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

Inserting calculations in columns

3.       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

4. Database Normalization

Overview of database normalization and its importance

Understanding structured data and tables

Understanding primary keys and foreign keys

Normalization methodology- 1NF, 2NF, 3NF

Hands-on exercise on normalizing a dataset

5.       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

Explore AI-powered visuals

6.       Using DAX in Power BI

Creating a calculated column

Using Measures

Using New Quick Measures

SUM, CALCULATED, &&, RELATED, FILTER