OUTLINE

DURATION:  2 DAYS (16 HOURS)

DIFFICULTY LEVEL: ADVANCED

1.   Overview on important aspects of Power BI

Understanding the multiple data sources under ‘Get Data’

Dashboards, reports & datasets in Workspace

The Report view, Data view & Relationship view on Power BI Desktop 

2.  Using the Query Editor in Power BI

Understanding ETL- Extract, Transform & Load

Getting data from data sources

Merging, Appending, Combining Files

Removing rows & columns

Replacing values in columns

Pivoting & unpivoting data

Formatting data in columns

Merging columns

Creating customized columns

Indexing columns

Inserting calculations in columns 

3.  Creating visualizations in Power BI

Adding visualizations to the Report Canvas

Using Data view to sort & format data

Designing your dashboard & creating column, bar, pie, line graphs, cards, treemaps, matrices, KPIs, tables, geographical maps, ArcGIS maps

Inserting slicers into the dashboard

Using inline hierarchies

Applying filters to dashboards

Creating desktop & mobile view layouts

Pinning tiles & live pages

Viewing & annotating pages in Power BI Mobile 

4.  Data Modelling in Power BI

Concept of relational files, data modelling & the Data Model in Power BI

Cardinality, cross-filter direction

Understanding & creating data relationships 

5.  Using DAX in Power BI

Creating a calculated column

Using Measures

Using New Quick Measures

SUM, CALCULATED, &&, RELATED, FILTER