Chapter 1: Introducing Power BI

Introduction to Power BI
Getting started with Power BI
Power BI Installation
Introducing natural-language queries
Introducing Quick Insights
Introduction to Report and Report Design
Introducing Visual Interactions
Power BI Desktop & Power BI Services
Building blocks of Power BI
Understanding Desktop & Mobile Editions
Report Rendering Options and End User Access
Data Flow and Work Flow Architecture

Chapter 2: Creating Power BI Reports

Report Design using TXT, CSV, xlsx
Report Design using Databases & Queries
Repot Data Sources and Dataset Queries
Query Settings and Data Preloads
Dataset Properties and Report Fields
Navigation Options and Report Refresh
Computed Columns & Column Splits
Working with external data sources
Working with import and direct query
Creating custom table in the Power BI
Merge Queries and Append Queries
Remove columns and split columns
Choosing required columns in the data

Chapter 3: Report Customizations & Parameters

Working with Data Visualizations & Cards
Tables, Matrix, Charts, Bars, Sparkline, Pie, Maps
Creating and Working with Parameters
Dynamic and Dependant Parameters
Static and Dynamic Filters – Usage Options
Navigator Options and Parameter Mapping
Creating and Working with groups
Managing the null values and errors
Managing data types in Query editor
Column Delimiters and Relationships Management

Chapter 4: Report Dashboards & Data Refresh

Publishing Reports to PowerBI Account
Dashboards and Pinning Options
Dynamic Data Sources and Encryptions
Dashboards from multiple reports
Installing the Power BI Personal Gateway
Configuring automatic refresh
Working with MY WORK SPACE group
Workbooks and Alerts with PowerBI
Applied steps in query editor

Chapter 5: Using Power BI Desktop

Cube Reports with OLAP Databases
DAX Expressions with Power View
DAX Calculations and Measures
Improving the report by using measures
Integrating from multiple objects
Working with Power BI Views
Working with Data Hierarchies
In-built slicers and custom slicers
Working with reference lines
Working with Power pivot data model
Working with data modeling
Using DAX in data models
Working with DAX Functions
Calculated Measures & Parameters with DAX
Creating high-density reports
Working with Pivot & Unpivot columns
Different external data source

Chapter 6: Data from Services & Content Packs

Consuming a service content pack
Creating a custom data set from a service
Working with Pivot & Un Pivot columns
Creating index and custom columns
Group By functionality in Query Editor
Applied steps in query editor
Managing Gateways & Content Packs
Defining relationships between tables
Creating a custom table with range
Publishing a report to Power BI Services
Power BI as a Service
Creating high-density reports
Creating custom visualizations for Power BI
Pushing Real-time data to Power BI

Chapter 7: Improving Power BI Reports

Data from multiple Data Sources
Reports from various data sets
Dashboards from multiple reports
Working with MY WORK SPACE group
Creating Groups & Working
Managing Gateways & Content Packs
Adding tiles to the Dash Boards
Adding images to the dashboards
Working with all visualizations
Reading & Editing Power BI Views
Managing report in Power BI Services
Scheduling refresh to the Datasets

Chapter 8: Power BI Access & Cloud

Getting data from existing systems
Data refresh and live connections
Using relational databases on-premises
Using live connections to Analysis Services
Integrating Power BI with Office
Publish Excel data models in Power BI
Consume Power BI content from Excel
Using Power BI Tiles from Office Store
Managing security to access data
Using row-level security & User Access
Extending and customizing Power BI
Power BI embedded in applications


Data Science