About

Power BI

What is meant by Power BI?

What is the use of Power BI?

What contribution of Power BI in analysis?

Introduction to Power BI

Business Intelligence

Self Service Business Intelligence

SSBI Tools

What is Power BI

Why Power BI

Key Benefits of Power BI

Flow of Power BI

Components of Power BI

Architecture of Power BI

Building blocks of Power BI

Power BI Desktop

Power BI Desktop

Overview of Power BI Desktop

Data Sources in Power BI Desktop

Connecting to a Data Sources

Query Editor in Power BI

Clean and Transform data with Query Editor

Combining Data – Merging and Appending

Difference between Merging and Appending data

Cleaning irregularly formatted data

View in Power BI Desktop

Modelling Data

Manage Data Relationship

Cross Filter Directions

Create calculated table and measures

Difference between columns and measures

Optimizing Data Models

Data Analysis Expressions (DAX)

Essential concepts in DAX

Why is DAX important

DAX Syntax

Data types in DAX

Calculation types

DAX Functions

Measures in DAX

DAX operators

DAX tables and filtering

DAX Queries

DAX Parameter Naming

Data Visualization

Introduction to visuals in Power BI

Charts in Power BI

Matrices and tables

Slicers

Map Visualizations

Guages and single Number Cards

Modifying colors in charts and visuals

Shapes, text boxes and images

What are Custom Visuals?

Page layout and formatting

KPI Visuals

Manage Data Relationship

Cross filter Direction

Create calculated tables and measures

Optimizing Data Models

BI Q/A & Data Insights

Introduction to Power BI Service

Dashboard Creations

Quick Insights in Power BI

Configuring Dashboard

Power BI embedded

Power BI Report

Servers

Report server basics

Web portal

Paginated Reports

Row level security

Data Gateways

Scheduled refresh

Resources (Rest API/Soap API’s/ URL Access)