rajdabholkar2005@gmail.

com
CJFTHNK3QX

Data Visualization
With Power BI
Vishal Padghan (Great Learning)

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Offerings Of This Course

01 BI and Data Visualization 05 Power BI Installation

02
rajdabholkar2005@[Link] What is Power BI? 06 Power BI DAX
CJFTHNK3QX

03 Power BI Components 07 Visual Analytics

04 Building Blocks Of Power BI 08 Power BI Visuals/Charts

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Business Intelligence?
rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Business Intelligence?

rajdabholkar2005@[Link]
CJFTHNK3QX

Raw Data Business Intelligence Business Insights

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Business Intelligence Features
Better Business
Understanding

rajdabholkar2005@[Link]
CJFTHNK3QX Decision Making Quick navigation

Instant Answers

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Phases Of Business Intelligence
rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Phases Of Business Intelligence

IT Dependent

rajdabholkar2005@[Link]
Analyst
CJFTHNK3QX

End User

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Data Visualization?
rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Data Visualization?

Design Information Science

rajdabholkar2005@[Link]
CJFTHNK3QX
Data
Visualization

William Playfair
(Geometric Charts 1781)

Explored exports from seventeen

countries to Scotland

Communication

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
Data Visualization Tools

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Data Visualization Tools

rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
What Is PowerBI?

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is PowerBI?
From connection to collaboration, PowerBI is the most powerful, secure and flexible end-to-end analytics
platform for your data

rajdabholkar2005@[Link]
CJFTHNK3QX
Apt Visualizations Depth

Automatic Function Connection To Data

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI Architecture

Data Sources Connect

rajdabholkar2005@[Link]
CJFTHNK3QX PowerBI
Reports
Services
Publish
PowerBI Desktop

Gateway Data Integration,

Processing and
Presentation

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
Components Of PowerBI

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Components Of PowerBI

Power Query Power View PowerBI QNA

rajdabholkar2005@[Link]
CJFTHNK3QX

Power Pivot Power Map

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Building Blocks Of PowerBI
rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Building Blocks Of PowerBI

Visualizations

Dashboards
rajdabholkar2005@[Link]
CJFTHNK3QX

Datasets

Tiles

Reports

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
PowerBI Reports

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI Reports
It is a multi-perspective view into a particular data set with visualizations that represent different findings
and insights from that a set. A report may be a single visualization or pages full of visualizations.

rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
PowerBI Dashboards

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI Dashboards
It is a single page, also known as a canvas, that uses visualizations to tell a particular story. It is limited to
one page, and a point note is that a good dashboard contains only the important elements of that story.

rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Demo: PowerBI Installation and
rajdabholkar2005@[Link]

Interface
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
Power BI Data Types

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI Data Types

rajdabholkar2005@[Link]
CJFTHNK3QX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
PowerBI DAX

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI DAX
DAX is a collection of functions, operators and constant used in formulas, to return one or more values. It is
a native formula and Query language by Microsoft

rajdabholkar2005@[Link]
CJFTHNK3QX
Functional Query Deals with
Language relational data

Performs
Aggregations

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI DAX

Syntax Context
rajdabholkar2005@[Link]
CJFTHNK3QX

Function

Measure = Function(TableName(ColumnName))
Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
Visual Analytics

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Popular Cloud Service Providers

rajdabholkar2005@[Link]
CJFTHNK3QX

Question and Answer Time

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Summary

01 BI and Data Visualization 05 Power BI Installation

02
rajdabholkar2005@[Link] What is Power BI? 06 Power BI DAX
CJFTHNK3QX

03 Power BI Components 07 Visual Analytics

04 Building Blocks Of Power BI 08 Power BI Visuals Charts

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
rajdabholkar2005@[Link]
CJFTHNK3QX
Thank You

Proprietary
This filecontent. © Great
is meant forLearning.
personal All Rights
use byReserved. Unauthorized use or distribution prohibited.
rajdabholkar2005@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.