This course will not only train on POWER BI but also make you aware of data modeling, data mashing, data analytics concepts. Will cover from data connection to report publishing as well as key security concepts.
1. Introduction to Power Bi/Architecture- Use of power Bi and the Architecture of power Bi system
2. Connection to various sources like excel, csv, SQL DB, SharePoint, OneDrive and other sources- importing data from various available sources
3. Power Query Data modeling - How to transform data in power query and write M function
4. Table relationships - linking tables using star schema
5. Power Bi report - How reports can ve created in power Bi and ideal approach to data visualization
6. Measures and Calc Column - Using dax writing basic and advance level calculations
7. Sharing and publishing report - How to share report with end users
8. Row level security - to ensure only relevant people has access to their data.
9. External tools - Dax editors and other tools
10. Project - Real life Project to be prepared