A brilliant database query means nothing if business stakeholders can't understand it. This course transforms you from a data extractor into a data storyteller.
Designed for flexible timings and 100% hands-on learning, you will learn how to connect raw data sources (including your SQL databases), build robust relational data models, write powerful analytical formulas, and design stunning, interactive corporate dashboards.
PowerBI Desktop Installation
Power BI Building Blocks
Connecting Power BI with Different Data sources.
Power Query for Data Transformation
| Query Editor Interface |
| Column Transformation vs Adding Columns. |
| Append vs Merge |
| Data Type. |
| Text Transformations. |
| Date and Time Calculations. |
| M built-in functions |
Data Modelling in Power BI.
| Introduction to Data Modelling and DAX |
| Calculated Columns |
| Measures/ New Quick Measures |
| Calculated Tables |
| Row Context vs Set context |
| Time Intelligence Functions |
| Advanced calculations using Calculate functions |
Create PowerBI Reports Viz
| Report editor Interface |
| Visualisation Types |
| Different Types of Filters |
| Slicers |
| ToolTips |
| Interactions & Bookmarks |
| Aggregates |
| Hierarchies |
| Creating a dashboard |
PowerBI service
| Add / edit tiles in dashboard |
| Row Level Security in Power BI. |
| Configure Data refresh |
Build a report & publish it as per project requirements
Accordion Content
Interview FAQ
Accordion Content