graphicsbyprathamesh@gmail.

com
G0URX4M3KS

Data Visualization
With Power BI
Vishal Padghan (Great Learning)

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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
graphicsbyprathamesh@[Link] What is Power BI? 06 Power BI DAX
G0URX4M3KS

03 Power BI Components 07 Visual Analytics

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

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Business Intelligence?
graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Business Intelligence?

graphicsbyprathamesh@[Link]
G0URX4M3KS

Raw Data Business Intelligence Business Insights

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Business Intelligence Features
Better Business
Understanding

graphicsbyprathamesh@[Link]
G0URX4M3KS Decision Making Quick navigation

Instant Answers

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Phases Of Business Intelligence
graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Phases Of Business Intelligence

IT Dependent

graphicsbyprathamesh@[Link]
Analyst
G0URX4M3KS

End User

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Data Visualization?
graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 What Is Data Visualization?

Design Information Science

graphicsbyprathamesh@[Link]
G0URX4M3KS
Data
Visualization

William Playfair
(Geometric Charts 1781)

Explored exports from seventeen

countries to Scotland

Communication

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
Data Visualization Tools

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Data Visualization Tools

graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
What Is PowerBI?

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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

graphicsbyprathamesh@[Link]
G0URX4M3KS
Apt Visualizations Depth

Automatic Function Connection To Data

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI Architecture

Data Sources Connect

graphicsbyprathamesh@[Link]
G0URX4M3KS PowerBI
Reports
Services
Publish
PowerBI Desktop

Gateway Data Integration,

Processing and
Presentation

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Components Of PowerBI
graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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

graphicsbyprathamesh@[Link]
G0URX4M3KS

Power Pivot Power Map

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Building Blocks Of PowerBI
graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Building Blocks Of PowerBI

Visualizations

Dashboards
graphicsbyprathamesh@[Link]
G0URX4M3KS

Datasets

Tiles

Reports

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
PowerBI Reports

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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.

graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
PowerBI Dashboards

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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.

graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Demo: PowerBI Installation and
graphicsbyprathamesh@[Link]

Interface
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
Power BI Data Types

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI Data Types

graphicsbyprathamesh@[Link]
G0URX4M3KS

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
PowerBI DAX

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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

graphicsbyprathamesh@[Link]
G0URX4M3KS
Functional Query Deals with
Language relational data

Performs
Aggregations

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 PowerBI DAX

Syntax Context
graphicsbyprathamesh@[Link]
G0URX4M3KS

Function

Measure = Function(TableName(ColumnName))
Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
Visual Analytics

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
 Popular Cloud Service Providers

graphicsbyprathamesh@[Link]
G0URX4M3KS

Question and Answer Time

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[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
graphicsbyprathamesh@[Link] What is Power BI? 06 Power BI DAX
G0URX4M3KS

03 Power BI Components 07 Visual Analytics

04 Building Blocks Of Power BI 08 Power BI Visuals Charts

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.
graphicsbyprathamesh@[Link]
G0URX4M3KS
Thank You

Proprietary
This file iscontent.
meant © Great Learning. All
for personal useRights
by Reserved. Unauthorized use or distribution prohibited.
graphicsbyprathamesh@[Link] only.
Sharing or publishing the contents in part or full is liable for legal action.