My SQL, Excel Pivots & Charts, Tableau (4 in 1)
What you'll learn
- MY SQL Workbench & commands
- MY SQL Queries
- MY SQL functions
- SQL Join queries across tables
- Excel Charts & Pivots
- Create reports from pivots
- Install Tableau Desktop 2022
- Tableau Interface & Charts
- Tableau Filters
- Tableau Visualization Activities
- Work with Parameters
- Create Treemaps
- Create Data Hierarchies
- Adding Filters and Quick Filters
- Create Dual Axis Charts
- Create Area Charts
- Create Scatterplots
- Create Piecharts
- Create Barcharts
- Dashboard Creation in Tableau
- Adding Actions to Dashboards (filters )
- No MySQL, Tableau experience needed! Complete beginners to MySQL are welcome.
- Software Installed : MS Excel 2007 to 2021
- Software Installed : Tableau 2022
- Software Installed : My SQL community 8.0.30 (My SQL Server +Benchmark)
- All you need is a working computer for this course like Laptop or PC , Mac
- Stable Internet connection
Welcome to the MySQL, Tableau , Excel Pivots & Charts course! This comprehensive course is designed to provide you with a solid foundation in MySQL and Tableau, focusing on SQL queries, basic Tableau functionality, filters, and charts. Whether you're a beginner or have some experience with these tools, this course will help you develop the skills necessary to manipulate and visualize data effectively.
In the MySQL section of the course, you will learn the fundamentals of SQL queries. SQL (Structured Query Language) is a powerful tool used for managing and analyzing data stored in relational databases. You will explore the basics of creating databases, designing tables, and manipulating data using SQL queries. By the end of this section, you will have a strong understanding of SQL and the ability to retrieve, filter, and aggregate data efficiently.
Moving on to Tableau, you will be introduced to the basics of this popular data visualization tool. You will learn how to connect Tableau to data source, navigate the Tableau interface, and create simple visualizations. With a focus on filters, you will discover how to apply filters to your data to drill down and explore specific subsets of information. You will also learn how to create basic charts, such as bar charts, line charts, and pie charts, to effectively communicate your data.
Throughout this course, you will have the skills and confidence to work proficiently with MySQL, Tableau, Excel Pivots, and Charts, and leverage their combined power to uncover valuable insights, make informed decisions, and present data in a compelling and impactful way.
By the end of this course, you will have a strong foundation in SQL queries, a basic understanding of Tableau's features, and the ability to apply filters and create charts in Tableau. These skills will empower you to work with databases, perform data analysis, and visualize data in a more meaningful and impactful way.
Whether you're a student, a business professional, or someone interested in expanding their data analysis skills, this course will equip you with the knowledge and confidence to tackle data-related tasks using MySQL and Tableau. Join us now to unlock the potential of these powerful tools and take your data analysis and visualization skills to the next level.
Section 1:Bundle1 : MYSQL PART (A)
Section 2:MY SQL PART (B)
Section 3:MY SQL PART (C)
Section 4:MY SQL PART (D)
Section 5:MY SQL PART (E)
Section 6:MY SQL PART (F) Activities
Quiz 1:MY SQL QUIZ 1
Quiz 2:MY SQL QUIZ 2
Section 6:Bundle2 : Excel Pivots PART (A)
Section 7:Bundle2 : Excel Pivot PART (B)
Section 8:Bundle3 : Excel Charts PART (A)
Section 9:Bundle3 : Excel Charts PART (B)
Section 10:Bundle4 : Tableau PART (A)
Section 11:Tableau PART (B)
Section 12:Tableau PART (C)
Section 13:Tableau PART (C)
Section 14:Tableau PART (D)
Section 15:Tableau PART (E)
Section 16:Tableau Activities
Lecture 119:Download Data Set
Who this course is for:
- Absolute beginners & Intermediates are also welcome
- Working professionals, business analytics & managers
- Anyone interested in learning SQL to help with their current job or to find a new role
- Anyone looking to answer complex business problems and generate reports using data
I have worked as a data analyst from last 10 years. My task is to clean the data, validate the reports , create Visuals using Tableau & Excel as per business requirements or as per various departments in an organization. I have designed this course for the freshers & working professionals. Please leave a feedback after completion of the course.