OUTLINE

DURATION:  3 DAYS (24 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

Explore AI-powered visuals

4.       Publishing to the Power BI Service

Publish from Power BI Desktop to Power BI Service

What are Reports, Database & Dashboards?

Sharing dashboards across

Pinning Excel elements to Power BI Service

Generating Quick Insights

Using the Q&A feature

Refreshing data, Personal Gateway, Enterprise Gateway & scheduled refresh

Building refreshable reports in Excel

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

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

7.       Using DAX in Power BI

Creating a calculated column

Using Measures

Using New Quick Measures

SUM, CALCULATED, &&, RELATED, FILTER

8.       Power BI Mobile

Downloading & setting up the Power BI Mobile

Viewing & annotating pages in Power BI Mobile

9.      Cross-app capabilities

Explore AI-powered cross-application features in PowerPoint