Power BI roadmap

Choosing data sources means identifying where your business information lives, such as spreadsheets, cloud servers, or local databases, and connecting to them securely. You need to know how to point Power BI to these locations so it can fetch the latest updates.

Imagine a retail shop that stores daily sales in a cloud database and customer lists in spreadsheets. Connecting to both sources lets you pull everything into one central workspace.

This matters because you cannot build reports without first gathering your raw numbers from across the business.

• Identify where your business information is stored
• Use built-in connectors for secure access
• Test connections before building large reports

Importing Excel files lets you bring your existing spreadsheets directly into the platform to start building interactive reports. It reads your sheets, tables, and named ranges so you do not have to manually retype any numbers.

Think of a small cafe tracking monthly expenses in Excel. Importing that file into Power BI lets you turn those static sheets into dynamic charts within minutes.

This matters because many businesses already rely on spreadsheets, and bridging them into a reporting tool saves countless hours of manual work.

• Select specific worksheets or tables to bring in
• Keep original Excel headers clean for easy reading
• Refresh data when your spreadsheets get updated

Connecting to web sources allows you to pull live tables and figures straight from public websites directly into your project. It scans web pages for HTML tables and lets you extract them with just a few clicks.

Picture a logistics worker needing daily fuel prices published on a government website. Instead of copying numbers daily, a web connection pulls the latest figures automatically.

This matters because it keeps your reports up to date with external market information without requiring tedious manual data entry.

• Paste public web URLs into the data connector
• Select specific HTML tables from the preview window
• Set up scheduled refreshes for live web figures

Using Power Query Editor opens a dedicated workspace where you clean, shape, and prepare your information before it enters your main reports. Every cleaning step you take is recorded as a applied step so it repeats automatically.

Imagine receiving a messy customer list with mixed-up name formats. You open the editor to split columns and change text sizes safely.

This matters because clean data prevents errors in your calculations and ensures your final dashboards look professional and trustworthy.

• Access a separate window for data preparation
• View every transformation step in a side panel
• Make changes safely without altering source files

Removing errors and blanks involves cleaning up missing values, corrupted cells, and obvious typos so your reports stay accurate. Leftover blank rows can skew your totals and break your visual charts.

Think of a sales sheet where some employee names are accidentally left blank. Filtering out those empty rows keeps your performance averages correct.

This matters because bad data leads to misleading insights, which can cause poor business decisions based on flawed reports.

• Spot missing values highlighted in your columns
• Filter out blank rows or replace them with defaults
• Fix data type errors caused by unexpected text

Merging and appending tables lets you combine multiple datasets together by matching common columns or stacking rows vertically. Merging joins extra columns from a lookup table, while appending adds new rows from similar tables.

Picture having a list of staff in one table and department names in another. You merge them using a shared staff ID column to create one complete view.

This matters because business information is often split across different sheets, and combining them provides the full picture needed for analysis.

• Use merge to join tables using a shared key
• Use append to stack tables with identical columns
• Check relationship matches after combining your data

Creating table relationships links your lookup tables to your main transaction tables using common keys like customer IDs or product codes. This allows different tables to filter each other correctly in reports.

Imagine a sales transaction table connected to a product details table. When you click a product category, the sales figures update automatically.

This matters because relationships remove the need to stuff all your information into one giant, messy spreadsheet.

• Link tables by dragging matching columns together
• Use one-to-many connections for standard lookups
• Check filter directions to ensure proper reporting

Understanding star schemas helps you organise your information into central fact tables surrounded by dimension tables for faster reporting. Fact tables hold measurable events like sales numbers, while dimension tables hold descriptive details like dates and locations.

Think of a central sales ledger surrounded by lookup tables for stores, staff items, and calendar dates arranged like a star.

This matters because Power BI is designed to run fastest and clearest when using this exact schema layout.

• Place numbers and metrics in central fact tables
• Place descriptions and categories in dimension tables
• Improve report performance with clean structures

Adding calculated columns creates brand new values for every single row in your table using simple formulas. It computes a result for each row and stores it permanently in your model.

Picture a table of product orders containing unit prices and quantities. You add a calculated column to multiply them for a total price per row.

This matters because it lets you categorise or evaluate individual rows before you aggregate them into summary charts.

• Write row-by-row formulas using basic math
• Store results directly inside the data model
• Use calculated columns for filtering and grouping

Introduction to DAX teaches you the formula language used to calculate custom metrics on the fly. Unlike Excel formulas, DAX formulas calculate results dynamically based on the filters applied in your reports.

Imagine writing a formula that calculates profit margins which automatically adjust when a user selects a specific country.

This matters because DAX is the engine behind all advanced calculations, giving your dashboards true interactive power.

• Learn the basic syntax of Data Analysis Expressions
• Understand measures versus calculated columns
• Write dynamic formulas that respond to filters

Using Sum and Average allows you to calculate basic totals and averages for your financial and sales figures. These aggregation functions condense thousands of rows into clear, useful top-level numbers.

Think of calculating total monthly revenue or finding the average ticket price for customer purchases.

This matters because these core metrics form the foundation of almost every business dashboard you will ever build.

• Use SUM to add up numeric columns completely
• Use AVERAGE to find typical values across rows
• Combine functions with filters for specific insights

Using the Calculate function lets you change filter rules on the fly to compare specific groups of data within your reports. It is the most powerful function in the language because it overrides existing filters.

Imagine calculating total sales, but using this function specifically for online orders while ignoring offline store sales.

This matters because it allows you to answer complex business questions like comparing this year's sales to last year's sales side by side.

• Modify or override existing filters in measures
• Compare specific segments against overall totals
• Build advanced conditional metrics with ease

Bar and column charts let you compare categories easily using simple vertical and horizontal bars. They show at a glance which items are performing best and which are lagging behind.

Picture comparing total sales across different product categories like shoes, jackets, and hats using a horizontal bar chart.

This matters because visual comparisons are much faster for human brains to process than scanning through long tables of numbers.

• Use column charts for time-based comparisons
• Use bar charts for category name comparisons
• Sort values neatly from highest to lowest

Cards and key metrics highlight single important numbers like total revenue, customer count, or average satisfaction score. They put your headline figure front and centre on the page.

Think of a large bold number at the top of a sales report showing total profit for the current quarter.

This matters because busy managers want to see top-level performance indicators immediately without hunting through crowded charts.

• Display single high-level summary figures clearly
• Use bold card visuals for headline metrics
• Format numbers cleanly with currency or percentage signs

Adding slicers and filters lets users click buttons to filter entire report pages by date, region, or category. It turns a static page into an interactive exploration tool.

Imagine a regional manager clicking on their specific store location in a slicer to instantly filter every chart on the page.

This matters because it empowers different team members to find their own answers from the same shared report.

• Place interactive slicer boxes on report canvases
• Link slicers to filter all visuals on the page
• Use dropdown or list styles to save space

Publishing to service uploads your desktop reports to the cloud so others can view them securely via a web browser. It bridges your offline workspace with online collaboration.

Think of finishing a monthly report on your laptop and publishing it online so your team lead can open it on their phone.

This matters because reports need to be accessible to colleagues rather than trapped on a single computer.

• Upload local desktop files to the cloud workspace
• Share web links with authorised team members
• Set up scheduled data refreshes in the cloud

Building live dashboards lets you pin your best visuals from different reports onto a single summary page. It provides a high-level overview combining metrics from multiple sources.

Imagine pinning the sales total card from one report and the regional map from another onto a single executive summary view.

This matters because busy leaders can monitor key indicators from across the entire business in one consolidated place.

• Pin key visual tiles onto a shared dashboard
• Combine charts from multiple different reports
• Monitor live updates across all pinned items

Row-level security restricts what different users can see based on their department or region using filter rules. It ensures staff only view information relevant to their role.

Picture a retail chain where regional managers can only see sales figures for their own specific store locations.

This matters because it protects sensitive company information while still allowing broad report distribution.

• Define security roles based on user attributes
• Filter table rows dynamically using email or username
• Test roles before sharing reports with your team