Course Content
Getting started with Power BI
- Installing power BI
- Different types of data modes
- Query Editor
- Connecting to Data
- Workflow in PowerBI
Importing data
- Excel files
- csv files
- SQL server
- Real time streaming data
- Folder
Programming with Power BI
- Timeseries
- Aggregation and granularity
- Filters and slicers
- Segmentation dashboard
Power Queries
- Remove Duplicates
- Merge
- Unpivot and split
- Replace and Rearrange
- Add//remove rows and columns
- KPI
- Gauge card
- Matrix
- Shapes and texts
Visuals
- Pie chart
- Bar chart
- Line chart
- Stacked bar chart
- Clustered column chart
- Combo chart
- Tree map
- Funnel chart
- Scatter chart
Modelling
- star schema
- snowflake schema
- modelling and relationship
- report creation
DAX
- what is Dax
- Types of DAX
- Dax operators and syntax
- Dax Functions
- Measures