Introduction To PowerBI

Kamini Saxena

Copyright @ Bsquare Software Services Pvt. Ltd.

 Introduction to Power
BI
Power BI is a powerful business analytics tool developed
by Microsoft that transforms data into rich visuals and
interactive reports. It is designed to help organizations
make data-driven decisions by providing insights that are
both deep and intuitive. With Power BI, users can connect
to a wide variety of data sources, streamline data
preparation, and drive ad-hoc analysis.

Power BI comprises several components, including Power

BI Desktop, Power BI Service, Power BI Mobile, and Power
BI Embedded. These components work together to
provide a comprehensive suite of tools for data analysis
and reporting.

 Power BI Desktop: A robust application for data

preparation and report creation.
 Power BI Service: An online service for sharing and
collaborating on reports.
 Power BI Mobile: Apps for viewing and interacting
with reports on mobile devices.
 Power BI Embedded: A service for embedding
Power BI reports into custom applications.

Example

A retail company uses Power BI to analyse sales data from

various stores. By connecting to their sales database, they
create interactive dashboards that show sales
performance, inventory levels, and customer
demographics. These dashboards help the management
team make informed decisions on inventory management,
marketing strategies, and store operations.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Getting Started with
Power BI
To get started with Power BI, you first need to download
and install Power BI Desktop from the Microsoft website.
Once installed, you can start by importing data from
various sources like Excel, SQL Server, or cloud services.
Power BI Desktop's intuitive interface guides you through
the process of data import, transformation, and
visualization.

Here are the basic steps to get started

Download and install Power BI Desktop.
Connect to data sources: Import data from Excel, SQL
Server, web pages, and more.
Transform data: Clean and shape your data using Power
Query Editor.
Create visualizations: Use the drag-and-drop interface to
create charts, graphs, and tables.
Publish your report: Share your report with others via
Power BI Service
.

Example

A financial analyst begins by downloading Power BI Desktop.

She connects to her company's financial database and imports
data on monthly expenses and revenues. Using Power Query
Editor, she cleans the data by removing duplicates and
correcting errors. She then creates visualizations to show
trends in expenses and revenues over time, and finally, she
publishes the report to Power BI Service for her team to
access.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Power BI Desktop vs.
Power BI Service
Understanding the differences between Power BI
Desktop and Power BI Service is crucial for
effectively using Power BI. Power BI Desktop is a
standalone application used for data
manipulation, report creation, and visualization.
On the other hand, Power BI Service is an online
platform used for sharing reports, dashboards,
and collaborating with others.

Power BI Desktop
Used for data transformation and report creation.
Provides advanced modelling and visualization
capabilities.
Allows for offline work and storage.
Power BI Service:

Used for sharing and collaboration.

Enables real-time dashboard updates.
Offers cloud-based storage and access.

Example

A marketing team uses Power BI Desktop to create a

detailed report on campaign performance. Once the
report is ready, they publish it to Power BI Service,
where team members can access it, provide
feedback, and collaborate on refining the insights.
The service also allows them to set up real-time data
refreshes to keep the dashboard updated with the
latest campaign metrics.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Connecting to Data
Sources
Power BI can connect to a wide variety of data
sources, making it a versatile tool for data
analysis. You can connect to local files like Excel
or CSV, databases such as SQL Server or Oracle,
and cloud-based services like Azure or Google
Analytics. The process of connecting to data
sources is straightforward and involves selecting
the data source type and providing the necessary
credentials.

Here are some common data sources

you can connect to
Excel files: Import data from spread sheets.
SQL databases: Connect to on-premises or cloud-based
SQL databases.
Web data: Pull data from web pages or APIs.
Cloud services: Integrate with Azure, Sales force, Google
Analytics, etc.

Example

A sales manager connects Power BI to the

company's CRM system, which is hosted on Sales
force. By importing data on customer
interactions, sales activities, and pipeline status,
she creates a dashboard that provides a real-time
view of sales performance. This dashboard helps
the sales team identify trends, track targets, and
optimize their sales strategies.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Data Transformation
with Power Query
Power Query is a powerful data connection
technology that enables you to discover, connect,
combine, and refine data across a wide variety of
sources. With Power Query, you can perform a range
of data transformation tasks such as filtering,
merging, pivoting, and aggregating data to prepare
it for analysis.

Key data transformation tasks in Power

Query
Filtering rows: Remove unnecessary data.
Transforming columns: Change data types, split
columns, etc.
Merging tables: Combine data from different sources.
Aggregating data: Summarize data with functions like
sum, average, etc.

Example

A data analyst needs to prepare a dataset for a customer

satisfaction analysis. Using Power Query, he imports data
from multiple sources, including survey results, customer
support logs, and product usage data. He then cleans the
data by removing duplicate entries, fills missing values,
and merges the datasets into a single table. This prepared
dataset is now ready for detailed analysis in Power BI.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Creating Data Models
0Data modelling in Power BI involves defining
relationships between different data tables to create
a coherent and comprehensive data structure. This
step is crucial for accurate analysis and reporting as it
allows you to connect related data from different
sources and perform more complex calculations.

Steps to create data models

Import data tables: Bring in data from various
sources.
Define relationships: Link tables using keys (e.g.,
primary and foreign keys).
Create calculated columns: Add new columns with
custom calculations.
Set up measures: Define aggregate calculations for
analysis
.
Example

A business analyst is working on a sales analysis

report. She imports data tables for sales transactions,
products, and customers. By creating relationships
between these tables (e.g., linking customer IDs and
product IDs), she can analyse sales performance by
customer segment and product category. This data
model enables her to create detailed reports that
provide insights into sales trends and opportunities.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Building Interactive
Reports
One of Power BI's standout features is its ability to
create interactive reports. These reports allow users
to drill down into data, apply filters, and gain deeper
insights without needing to go back to the raw data.
Interactive reports make data exploration more
intuitive and engaging.

Features of interactive reports

Drill-down capabilities: Explore data at different
levels of granularity.
Slicers: Filter data dynamically within the report.
Cross-highlighting: Highlight related data points
across visuals.
Tooltips: Display additional information on hover.

Example

A project manager creates an interactive report to

monitor project progress. The report includes various
visuals like Gantt charts, pie charts, and bar graphs.
Users can drill down from overall project status to
individual task details, use slicers to filter by project
phase or team member, and hover over data points
to see detailed tooltips. This interactivity helps the
project team quickly identify bottlenecks and take
corrective actions.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Custom Visualizations
Power BI offers a range of standard visualizations, but
it also supports custom visuals. Custom visuals can
be created using tools like Power BI Visuals SDK or
downloaded from the Microsoft App Source
marketplace. These visuals can make your reports
more engaging and tailored to your specific needs.

Types of custom visuals

Custom charts: Unique visual representations not
available by default.
R and Python visuals: Integrate advanced analytics
and visualizations.
Info graphics: Visually appealing representations of
data.
Maps: Advanced mapping capabilities for geographic
data.

Example

A healthcare analyst needs to visualize patient data in

a unique way. She downloads a custom visualization
from the App Source marketplace that shows patient
flow through different departments in a hospital. This
visual helps the hospital administration understand
patient movement patterns and optimize resource
allocation for better patient care.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Using DAX for
Advanced Calculations
Data Analysis Expressions (DAX) is a formula
language used in Power BI for creating custom
calculations. DAX enables you to perform complex
calculations and data analysis that go beyond the
built-in aggregation functions. Mastering DAX can
significantly enhance your ability to analyse and
present data.

Common DAX functions

SUMX: Calculates the sum of an expression evaluated
over a table.
CALCULATE: Modifies the filter context of a
calculation.
RELATED: Fetches related values from another table.
TIME INTELLIGENCE: Functions like DATEADD,
SAMEPERIODLASTYEAR, etc.

Example

A financial analyst uses DAX to create a custom

measure that calculates the year-to-date sales
growth. By using the CALCULATE function combined
with DATEADD, she can compare the current year's
sales to the same period last year. This measure
provides insights into sales performance trends and
helps in strategic planning.

Copyright @ Bsquare Software Services Pvt. Ltd.

 Power BI and AI
Integration
Power BI integrates with various AI technologies to
provide advanced analytics features like machine
learning models, text analytics, and image
recognition. This integration helps in deriving more
intelligent insights from your data, enabling you to
make more informed decisions.

I features in Power BI

AI visuals: Use AI-driven insights in your reports.

Azure Machine Learning: Integrate machine learning
models

Copyright @ Bsquare Software Services Pvt. Ltd.

Copyright @ Bsquare Software Services Pvt. Ltd.
Copyright @ Bsquare Software Services Pvt. Ltd.