Power BI Training

1 Introduction to Business Intelligence (BI)

2 Stages of business intelligence (BI)

3 Use cases of BI

4 Various BI tools

5 Overview of Data warehouse & concepts

6 Introduction to Power BI

7 Why Power BI

8 Power BI Components

9 Power BI pricing structure

10 Building blocks of Power BI

11 Architecture of Power BI

12 Power BI vs Tableau vs QlikView

13 Introduction of Power BI Desktop

14 Installation of Power BI Desktop

15 The key features of Power BI workflow

16 Process of creating reports in Power BI

1 Overview of Power BI desktop

2 Data sources in Power BI

3 Using files (excel, pdf, csv, etc.) as a data source

4 Using SaaS connectors

5 Extracting data from folders, and databases

6 Working with Azure SQL database and database sources

7 Connecting to Analysis Services

8 Other data sources (OData, web, SharePoint etc.)

9 Python & R script in Power BI

10 Introduction of power query editor

11 Advance editor

12 Query dependency editor

1 Deep dive into Power BI data visualization

2 Understanding Power View and Power Map

3 Data visualization techniques

4 Page layout & Formatting

5 Power BI Desktop visualization

6 Formatting and customizing visuals

7 Visualization interaction

8 Custom visualization in Power BI

9 Top-down and bottom-up analytics

10 Drill down

11 Drill through

12 Page navigations

13 Bookmarks

14 Selection pane to show/hide visuals

15 Comparing volume and value-based analytics

16 Combinations charts (dual axis charts)

17 Filter pane

18 Slicers

19 Use of Hierarchies in drill down analysis

20 Theme for corporate standards

21 Power BI template for design reusability

22 Mastering the best practices

23 Performance analyzer in Power BI for monitoring performance of report

24 Power BI Q&A (Natural Language Query visual)

25 Sync slicers

26 Tooltips & custom tooltips

27 Tables & matrix

28 Conditional formatting on visuals

29 Waterfall chart, KPI, Donut chart, Scatter chart

30 Geographical data visualization using Maps

1 Shaping data using Power Query Editor

2 Formatting data

3 Transformation of data

4 Understanding of Data types

5 Data profiling for data quality check

6 Naming conventions & best practices to consider

7 Working with Parameters

8 Merge Query

9 Append Query

10 Group by of data (aggregation of data)

11 Applied steps (query settings)

12 Duplicate & Reference tables

13 Transpose of data

14 Fill

15 Pivot & Un-pivot of data

16 Custom columns

17 Conditional columns

18 Replace data from the tables

19 Split columns values

20 Move columns & sorting of data

21 Detect data type, count rows & reverse rows

22 Promote rows as column headers

23 Hierarchies in Power BI

24 M query

1 Introduction to Power BI Service

2 Introduction of workspaces

3 Dashboard

4 Creating & Configuring Dashboards

5 Dashboard theme

6 Reports vs Dashboards

7 Building workspace Apps

8 Sharing reports & dashboards

9 Introduction to Power Q & A

10 Ask questions about your data using Natural Query Language

11 Getting answers in the form of charts, graphs, and data discovery methodologies

12 Configure custom questions for Q&A like FAQ

13 Ad-hoc analytics building

14 Power Q&A best practices

15 Quick Insights

16 Subscribe, Alerts, Usage statics, Related content

17 Design reports on Power BI Service

18 Collaboration using Power BI Service

19 Row Level Security (RLS)

20 Introduction of Paginated Reports

21 Introduction of Power BI Report Server

1 Getting to understand Power BI Desktop settings

2 Aggregating data from multiple data sources

3 Power BI Service settings

4 Power BI Admin Portal

5 Administration activities

6 Power BI usage analysis

7 Introduction of Office 365 admin activities

8 Introduction of Data Gateway

9 Installation & Configuration of data gateways

10 Scheduling auto data refresh

11 Managing groups, row-level security, datasets, reports, and dashboards

12 Real time data analysis using Direct Connectivity

13 Direct Query vs Import Mode

1 Introduction to embedded Power BI

2 Create embedded code

3 Manage embedded code

4 Integration of Power BI in SharePoint

5 Introduction of Power BI API

6 Power BI Embedded playground

7 Introduction to Power BI Mobile

8 Creating mobile based reports & dashboards

9 Optimizing report for Power BI mobile app

10 Features of Power BI mobile app

11 Introduction of integrating Power BI & Excel

12 Power BI Analyze in Excel

1 Introduction of Power BI Premium

2 Power BI Premium per user

3 Power BI Premium features

4 Introduction to Data Flow

5 Create Data Flow

6 Advantages of Data Flow

7 Create reports using Data Flow

8 Introduction to Power BI Deployment Pipelines

9 Create Deployment Pipelines

10 Benefits of Deployment Pipelines

11 Introduction of Sensitivity Labels

12 Introduction of Power BI Goals feature

13 Incremental data load in Power BI

14 Power BI best practice rules to improve performance

1 Introduction of relationships

2 Creating relationships

3 Cardinality

4 Cross filter direction

5 Use of inactive relationships

6 Introduction of DAX

7 Why DAX is used

8 DAX syntax

9 DAX functions

10 Context in DAX

11 Calculated columns using DAX

12 Measures using DAX

13 Calculated tables using DAX

14 Learning about table, information, logical, text, iterator,

15 Time intelligence functions (YTD, QTD, MTD)

16 Cumulative values, calculated tables, and ranking and rank over groups

17 Date and time functions

18 DAX advanced features