About course
This course teaches you how to get data from different sources, clean it, and shape it so you can analyze it quickly. You will learn Power Query for importing and transforming data (remove errors, split columns, unpivot, merge tables) and Power Pivot for creating data models, relationships, and DAX basics for calculations. The course focuses on simple, repeatable workflows so your reports stay accurate even as data changes.
Course format: Self-paced recorded sessions
Language: English & Hindi
Projects included: 2 hands-on projects — Sales data cleanup and a combined reporting model
Duration: ~20 hours of video + practice files
Level: Beginner to Intermediate
Key Skills
- Importing data from Excel, CSV, web and databases
- Cleaning and transforming data in Power Query (filters, split, merge, unpivot)
- Combining multiple tables and refreshable workflows
- Creating data models with Power Pivot and relationships
- Basic DAX for calculated columns and measures (SUM, CALCULATE, FILTER)
- Optimizing models for performance and scalability
- Building refreshable reports and preparing data for Power BI or PivotTables
- Best practices for data lineage and repeatable ETL in Excel
