About Course
This course helps you use Power BI with confidence. You will start by connecting to different data sources and cleaning data with Power Query. Then you will learn how to build a proper data model with relationships and a star schema. Next, you will write DAX measures for totals, averages, and time-based trends. You will design clean dashboards with drill-down, tooltips, bookmarks, and page navigation. Finally, you will publish to the Power BI Service, set scheduled refresh, share safely, and apply Row-Level Security where needed.
Course format: Self-paced recorded sessions
Language: Hindi & English
Projects included: 3 hands-on projects — Sales Performance Dashboard, Finance KPI Report, Customer Retention Analytics
Duration: 30-35 hours of video + practice files
Level: Beginner to Advanced (focus on real work use-cases)
Key Skills
- BI Desktop basics and interface
- Power Query for cleaning and shaping data (merge, append, pivot/unpivot)
- Data modeling: star schema, relationships, data types, hierarchies
- DAX fundamentals: CALCULATE, SUMX, FILTER, RELATED, ALL
- Time intelligence: YTD, MTD, rolling periods, DATEADD
- Visual design: charts, cards, maps, drill-through, tooltips, bookmarks
- Report navigation and storytelling with data
- Row-Level Security (RLS) and role setup
- Performance basics: model size, columns vs measures, reduce cardinality
- Power BI Service: publish, workspaces, apps, sharing, scheduled refresh
- Connecting to Excel, CSV, databases, and cloud sources
