POWER BI (POWER BUSINESS INTELLIGENCE)

Introduction

What is Business Intelligence?

Different BI Softwares

About Power BI

History of Power BI

Why Power BI Used?

Advantages of Power BI

Disadvantages of Power BI

Power BI Products

Power BI Desktop

Power BI Pro

Power BI Premium

Power BI Mobile

Power BI Embedded

Power BI Report Server

Power BI Fundamentals

Screen Layout

Menus

Data Terminologies

Views

File Types

Get Data

All

File

Database

Power BI

Azure

Online Services

Other

Load Data from Multiple Data Sources

Insert

New Page

New Visual

Buttons

Text Box

Image

Shapes

Edit Queries

Edit Queries

Enter Data

Data Source Settings

Shape and Combine Data

Manage Queries

Manage Parameters

Transform Column & Add Column

Data Types

Number types

Date/Time types

Text type

Boolean

Blanks/Nulls type

Data Modelling

Manage Relationships

Sort by Columns

Change Datatype

Change Format

Copy Table

Refresh Table

Data Category

Data Summarization

Format

Edit Interactions

Drilling filters other visuals

Bring Forward

Send Forward

Align

Distribute

Data Drill

Show Next Level

Expand Next Level

Drill Up

Drill Down

Drill through

See Records

View

Phone layout

Page View

Show Gridlines

Snap Objects to Grid

Lock Objects

Bookmarks Pane

Selection Pane

Sync Slicers

Field Properties

Bookmarks

Add

Update

Rename

View

Delete

Grouping

Groups

Hierarchies

Group Columns

Clusters

Query Groups

Joins

Inner Join

Full Outer Join

Left Outer Join

Right Outer Join

Charts

Basic Charts

Dual Axis Chart

Funnel Chart

KPI Visuals

Heat Map

Radial Gauge Chart

Time Series Chart

Table & Matrix

Card & Multi-Row Card

Scatter Chart

Tree Map

Waterfall Chart

Gnatt Chart

Map & Filled Map

Box-and-Whisker Plots

Bullet Chart

Aster Chart

Histogram Chart

Analytics Pane

Constant Line

Average Line

Min Line

Max Line

Median Line

Filters

Slicer

Basic Filters

Advanced Filters

Top N Filters

Filters on Measures

Visual-level Filters

Page Level Filters

Report Level Filters

Drill through Filters

Parameters

o What if Parameters

o Query Parameters

DAX (Data Analysis Expressions)

What Is DAX

What Is a Data Model

Components of a DAX Data Model

Datatypes

Operators

Calculations

DAX Functions

Variables

Debugging and Optimizing

Publish

Register to Pro Service

Dashboard Introduction

Connect Desktop with BI Service or Pro

Publish Desktop Reports

Create a Workspace

Create a Dashboard

Favourites

Reports and Datasets

reating a Report

Creating a Report using Excel Data

Upload Excel Files to Dashboard

Upload Workbook

Pin Workbook to Dashboard

Rename a Dataset

Rename a Report

Get Insights of a Dataset

Get Insights of a Report

Power BI Dashboards

Dashboard Actions

Add Reports to a Dashboard

Add Title to Dashboard

How to Add Image to Dashboard

Add Video to Dashboard

Add Web Content to Dashboard

Dashboard Settings

Delete a Dashboard

Pin Report to a Dashboard

Sharing Power BI Work

Share a Dashboard

Share a Report

Sharing Workspace

Publish App

View Published App

Edit App