Overview
The course “Data Analytics with Power BI” is designed to equip students with the skills to create interactive dashboards, analyze business data, and build visually appealing reports using Microsoft Power BI – one of the leading BI tools in the industry.
Our Trainers
Prof. Durvakshi Vyas
I hold an M.Tech in Data Science and have one year of experience as a Data Analyst Trainer, along with an additional year of teaching in a Data Science department. My background includes hands-on work with real-world data, model building, and delivering interactive, concept-driven sessions. I am passionate about simplifying complex topics and ensuring practical understanding.
Modules
Unit 1: Introduction to Business Intelligence and Power BI (2 hrs)
- What is Business Intelligence?
- Overview of Power BI ecosystem
- Power BI Desktop interface
Unit 2: Data Loading and Transformation (Power Query) (2 hrs)
- Connecting to Excel/CSV/SQL
- Power Query Editor basics
- Data types, cleaning, splitting, merging, appending
Unit 3: Data Modeling (2 hrs)
- Data relationships and cardinality
- Star vs snowflake schema
- Creating calculated columns and measures
Unit 4: DAX Fundamentals (2 hrs)
- Introduction to DAX
- Aggregation, filter, and time intelligence functions
- Measures vs calculated columns
Unit 5: Visualization & Report Building (2 hrs)
- Charts: bar, pie, line, combo
- Slicers, cards, tables, KPIs
- Formatting and themes
Unit 6: Advanced Visuals and Custom Charts (2 hrs)
- Tree maps, waterfall, maps
- Drill-throughs and bookmarks
- Tooltips and buttons
Unit 7: Power BI Service & Sharing (2 hrs)
- Publishing to Power BI Service
- Creating and sharing dashboards
Unit 8: Case Study – Mini BI Project (2 hrs)
- Sales/HR dataset
- Problem statement, dashboard design, presentation
Unit 9: Power BI + Excel & SQL Integration (2 hrs)
- Using Excel files in Power BI
- Connecting to SQL Server
- Refresh, schedule, gateway overview
Outcomes
- Participants will be able to use Power BI for data connection, transformation, and analysis.
- Learners will design and publish interactive dashboards and reports.
- They will be able to apply DAX formulas to add analytical value.
- Students will demonstrate practical BI project development and presentation skills.
Participants will be job-ready for analytics and BI roles.
