Description
Workshop Overview & Details
+
Time: 9:00 AM – 5:00 PM
(Price Includes SST)
- FREE Workbook
- FREE Certificate
- FREE Digital Notes
Morning Session
+
1) Power BI interface & basics
2) Supported data sources
3) Importing data (Excel, CSV, Databases)
4) DirectQuery vs Import Mode
5) Hands-on: connect to dataset
6) Power Query Editor
7) Data cleaning techniques
8) Transforming data
9) Hands-on: prepare dataset
10) Data modelling & relationships
11) Primary & foreign keys
12) Introduction to DAX
13) Hands-on: build data model
Afternoon Session
+
14) Visualisation types:
- Bar, line, pie charts, maps, tables & matrices
- Formatting visuals, filters & slicers
- Hands-on: build a dashboard
15) Publishing to Power BI Service:
- Sharing dashboards
- Automatic data refresh
- Hands-on: publish & share
16) Mini project:
- Clean data
- Create data model
- Develop visuals
- Publish & share report
