This course is designed to equip students with the knowledge and skills needed to generate insightful data visualizations using SQL, Tableau, and Power BI. By the end of the course, participants will be proficient in data extraction, transformation, and visualization techniques, using these three primary tools.
»Course Duration – 12 Weeks
»36 Hours (3 hours per week)
Modules
Module 1: Introduction to Data Visualization (Week 1)
• Introduction to Data Visualization and its Importance
• Overview of SQL, Tableau, and Power BI
Module 2: SQL for Data Visualization (Weeks 2-3)
SQL Basics
• SELECT Statements
• WHERE Clauses
• Aggregation Functions
Advanced SQL
• JOIN Operations
• Subqueries
• Stored Procedures
Module 3: Introduction to Tableau (Weeks 4-5)
• Tableau Basics
• Installation and Configuration
• Tableau Interface
• Importing Data
• Data Manipulation in Tableau
• Sorting
• Filtering
• Creating Calculated Fields
Module 4: Advanced Tableau Techniques (Weeks 6-7)
• Data Aggregation and Grouping
• Creating Dashboards and Stories
• Tableau Server and Online
• Integration of Tableau with SQL
Module 5: Introduction to Power BI (Weeks 8-9)
• Power BI Basics
• Installation and Configuration
• Power BI Interface
• Importing Data
• Data Manipulation in Power BI
• Query Editor
• Data Modeling
Module 6: Advanced Power BI Techniques (Weeks 10-12)
• Data Visualization Components
• DAX Functions
• Creating Interactive Dashboards
• Integration of Power BI with SQL
Dr. S. Shahul Hameed
MBA (H.R), MBA (Business Analytics), Msc (Psy), Ph.D
