arif.chapla@gmail.
com
A3C0Z5T94E
Data Visualization
With Power BI
Vishal Padghan (Great Learning)
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
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
[email protected] What is Power BI? 06 Power BI DAX
A3C0Z5T94E
03 Power BI Components 07 Visual Analytics
04 Building Blocks Of Power BI 08 Power BI Visuals/Charts
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
What Is Business Intelligence?
[email protected]
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
What Is Business Intelligence?
[email protected]
A3C0Z5T94E
Raw Data Business Intelligence Business Insights
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Business Intelligence Features
Better Business
Understanding
[email protected]
A3C0Z5T94E Decision Making Quick navigation
Instant Answers
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Phases Of Business Intelligence
[email protected]
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Phases Of Business Intelligence
IT Dependent
[email protected]
Analyst
A3C0Z5T94E
End User
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
What Is Data Visualization?
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
What Is Data Visualization?
Design Information Science
[email protected]
A3C0Z5T94E
Data
Visualization
William Playfair
(Geometric Charts 1781)
Explored exports from seventeen
countries to Scotland
Communication
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
Data Visualization Tools
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Data Visualization Tools
[email protected]
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
What Is PowerBI?
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
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
[email protected]
A3C0Z5T94E
Apt Visualizations Depth
Automatic Function Connection To Data
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
PowerBI Architecture
Data Sources Connect
[email protected]
A3C0Z5T94E PowerBI
Reports
Services
Publish
PowerBI Desktop
Gateway Data Integration,
Processing and
Presentation
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
Components Of PowerBI
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Components Of PowerBI
Power Query Power View PowerBI QNA
[email protected]A3C0Z5T94E
Power Pivot Power Map
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
Building Blocks Of PowerBI
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Building Blocks Of PowerBI
Visualizations
Dashboards
[email protected]
A3C0Z5T94E
Datasets
Tiles
Reports
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
PowerBI Reports
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
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.
[email protected]
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
PowerBI Dashboards
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
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.
[email protected]
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Demo: PowerBI Installation and
[email protected]
Interface
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
Power BI Data Types
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
PowerBI Data Types
[email protected]
A3C0Z5T94E
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
PowerBI DAX
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
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
[email protected]
A3C0Z5T94E
Functional Query Deals with
Language relational data
Performs
Aggregations
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
PowerBI DAX
Syntax Context
[email protected]
A3C0Z5T94E
Function
Measure = Function(TableName(ColumnName))
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
Visual Analytics
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
Popular Cloud Service Providers
[email protected]
A3C0Z5T94E
Question and Answer Time
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by
[email protected] prohibited.
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
[email protected] What is Power BI? 06 Power BI DAX
A3C0Z5T94E
03 Power BI Components 07 Visual Analytics
04 Building Blocks Of Power BI 08 Power BI Visuals Charts
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
[email protected]
A3C0Z5T94E
Thank You
Proprietary
Thiscontent.
file is©meant
Great Learning. All Rightsuse
for personal Reserved. Unauthorized use or distribution
by [email protected] prohibited.
only.
Sharing or publishing the contents in part or full is liable for legal action.
