Data Visualization

In Power BI

PUNEET KAPOOR
1
AGENDA

 Powerbi Introduction, components and architecture – Learn from basics

 Powerbi Desktop – Lets learn together

 Powerbi hands on exercise – Learn by doing

 Advance Powerbi Visualization - Learn from already developed

 Capstone Project – Learn from Experience

 Reference – Learn by your own

2
 POWER BI - INTRODUCTION

Experience your data. Any data, any way, anywhere

Power BI is a cloud-based business analytics service that Connect to and visualize any data using the unified, scalable platform for
self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight

Data and Information is the most strategic business asset

 Fast and easy access to your data
 360º Live view of your business
 Data discovery and exploration
 Insights from any device
 Collaboration across your organization
 Anyone to visualize and analyze data

History : Microsoft Project Crescent (2010) -> Powerbi for office 365 (2013) -> Public Release (2015)

3
 POWER BI OVERVIEW

Data sources Power BI service

SaaS solutions
e.g. Salesforce, GitHub, Google
Power Apps Natural language query Sharing & collaboration
On-premises data
e.g. Analysis Services
Live dashboards
Organizational content packs
Corporate data sources or external data
services
Visualizations
Azure services
Azure SQL, Stream Analytics…
Reports
Excel files
Workbook data / data models
01001
Power BI Desktop files 10101
Datasets
Data from files, databases, Azure, and
other sources
Data refresh

4
 WHY POWER BI

Top reasons organizations choose Power BI to meet their self-service and enterprise business intelligence (BI) needs.

Trust a recognized leader

• Rely on one of the largest and fastest-growing business intelligence clouds

• Trust a recognized leader
• Build your business on secure data analytics
• Put BI in everyone’s hands—economically
• Get rapid, user-driven innovation
• Unify self-service and enterprise analytics
• Create deeper, more helpful insights
• Find answers fast with industry-leading AI
• Improve publishing efficiency and accuracy of BI content
• Turn insights into action
• Stream analytics in real time
• Create data dashboards and visualizations in minutes

5
 POWER PRODUCT FAMILY

Powerbi Desktop Power BI Visuals Marketplace Power BI Service Power BI Dataflow

Power BI Embedded Power BI Mobile Apps Power BI Dataset Power BI Report Server

Power Apps Power Automate Power BI Pro Power BI Premium

6
POWER BI ARCHITECTURE

The Power BI service is built on Azure

7
 POWER BI ARCHITECTURE
Web Front End (WFE) cluster Back-End cluster.

• Managed the connection and Authentication • Manages visualizations, user dashboards, datasets, reports, data storage, data
• Azure Active Directory (AAD) to store and manage user identities connections, data refresh
• Azure Traffic Manager (ATM) to direct user traffic to the nearest • The Gateway Role acts as a gateway between user requests and the Power BI
datacenter service
• Azure BLOB (users) and Azure SQL Database(metadata) manages the storage
• Azure Content Delivery Network (CDN) to efficiently distribute the
of data and metadata
necessary static content and files to users based on geographical locale.
• Presentation Role to retrieve the data needed by the browser to render the
dashboard.

8
 POWER BI VISUALIZATION 200 + Visual
ADVANCE
BASIC

9
 POWER BI VISUALIZATION 200 + Visual and Plugins

Draw your Own

 R Charts
 Python Charts
 D3 Charts
 Custom Viz Creation

10
POWER BI GET DATA

11
POWER BI CONNECT LIVE

12
POWER BI DATA MODEL

13
 POWER BI LANGUAGE

• DAX DAX - Data Analysis Expressions

• M-LANGUAGE • The first language you will likely consciously encounter
• MDX • DAX is a library of functions and operators that can be combined to build formulas and expressions
• When - DAX is used after your data has been imported into your data model.
• R
• PYTHON
M - Power Query Formula Language
• SQL • is a powerful mashup query language optimized for building queries that mashup data
• It is a functional, case sensitive language similar to F#
• Query Editor provides a powerful graphical interface that allows users to perform complex data mashups
• When - Use M to transform and cleanup your data as well as create custom columns during data import.

MDX - Multi-Dimensional Expressions

• The standard language defined by Microsoft to query multidimensional cubes
• When - MDX is used before your data import.

R Language
• R is a language and environment for statistical computing and graphics.

PYTHON
• Python is a general-purpose language
SQL
• Structured Query Language
14
POWER BI PERFORMAMANCE ANALYZER

15
POWER BI REAL TIME DASHBOARDS

16
POWER BI AI INSIGHTS

17
POWER BI APP

18
POWER BI DATA LINEAGE

19
POWER BI USAGE MONITORING

20
POWER BI LICENSING

Powerbi Pricing and Plans

21
POWER BI REFERENCE

POWERBI ENTERPRISE

Powerbi Pricing and Plans

POWERBI PREMIUM

Powerbi DAX

22
POWER BI DATA MODEL

23
POWER BI ACCESS

24