CREATING A
POWER BI
REPORT
DEFINE THE REPORT REQUIREMENTS
➢Before starting
➢Identify the purpose of the report.
➢Understand the target audience and key
performance indicators (KPIs).
➢List the metrics and dimensions required for
analysis.
CONNECT TO DATA SOURCES
➢Open Power BI Desktop
➢Go to Home > Get Data and select your data
source (e.g. Excel, SQL Server, Web etc.).
➢Authenticate and load the dataset.
➢Preview the data in the Navigator window and
select the required tables.
TRANSFORM AND CLEAN THE DATA (USING
POWER QUERY EDITOR)
➢Go to Home > Transform Data to open the Power Query
Editor.
➢Perform data cleaning and transformation tasks such as:
➢Remove null or unnecessary columns/rows.
➢Rename columns for clarity.
➢Check data types (e.g. dates, numbers).
➢Handle missing or duplicate values.
➢Combine multiple data sources using Merge Queries or Append
Queries.
➢After transforming, click Close & Apply to load the cleaned
data into Power BI.
CREATE RELATIONSHIPS BETWEEN
TABLES
➢Go to the Model View and ensure tables are related using
primary and foreign keys.
➢Drag and drop fields to create relationships or use the
Manage Relationships option.
➢Choose the appropriate relationship type (one-to-many,
many-to-many) and ensure cardinality and cross-filter
direction are correct.
ADD CALCULATIONS (MEASURES AND
CALCULATED COLUMNS)
➢Use DAX (Data Analysis Expressions) to create
measures or calculated columns
➢Measures are for aggregated values (e.g. Total Sales =
SUM(Sales[Amount])).
➢Calculated columns are row-level calculations (e.g. Profit
= Sales[Amount] - Sales[Cost]).
DESIGN THE REPORT LAYOUT
➢Go to the Report View.
➢Drag visuals from the Visualizations Pane to the canvas such
as
➢Bar/Column Chart for comparisons.
➢Pie/Donut Chart for proportions.
➢Line Chart for trends.
➢Card for single KPIs.
➢Table/Matrix for detailed data views.
➢Arrange visuals logically and use consistent sizes.
APPLY FILTERS AND SLICERS
➢Use the Filters Pane to add page-level, report-level
or visual-level filters.
➢Add Slicers to allow users to filter data interactively
by categories (e.g. date, region).
FORMAT VISUALS AND REPORT
➢Use the Format Pane to customize visuals
➢Change colors, fonts and themes.
➢Add labels, tooltips and legends for clarity.
➢Use conditional formatting for highlighting key
data points.
➢Apply a consistent theme using View >
Themes.
ADD INTERACTIVITY
➢Enable cross-filtering and cross-highlighting
between visuals.
➢Use bookmarks to create dynamic views for
storytelling.
➢Configure drill-through pages to allow detailed
analysis of specific data points.
ADD TITLES, TEXT AND IMAGES
➢Use Text Boxes for headings and descriptions.
➢Add logos, banners or images to align with
branding.
➢Include KPIs or report explanations for better
context.
VALIDATE DATA AND PERFORMANCE
➢Cross-check data against the source to ensure
accuracy.
➢Optimize performance by
➢Reducing the number of visuals.
➢Aggregating data at the source.
➢Using optimized DAX formulas.
PUBLISH THE REPORT
➢Save the report file.
➢Click on Publish from the Home tab.
➢Choose your Power BI workspace and
upload the report to the Power BI Service.
SHARE THE REPORT
➢In Power BI Service
➢Share the report with stakeholders by email or direct link.
➢Set permissions to control who can view or edit the
report.
➢Embed the report in applications (e.g. SharePoint or
Teams).
MONITOR AND UPDATE THE REPORT
➢Schedule data refreshes in Power BI Service to
ensure up-to-date information.
➢Gather feedback from users and refine the report
based on their input.
➢Keep improving and expanding the report as
business needs evolve.