Power BI Tutorial
Learn Power BI step by step: 56 lessons in 9 chapters with examples, quizzes, diagrams and projects.
Start learning →
of lessons completed
Welcome to Power BI
- Self-Service BI and Business Intelligence Concepts Understand business intelligence and self-service BI: what BI is, its benefits and risks, the main tools, and how Power BI Desktop, Service, Mobile and Report Server fit.
- What Is Power BI? Learn what Power BI is, how Desktop, the online service and mobile apps fit together, and what semantic models, reports and dashboards are.
- A Tour of Power BI Desktop Find your way around Power BI Desktop: the ribbon, the Report, Table, Model and DAX query views, the main panes, and how .pbix and .pbip files work.
- Build Your First Report in 10 Minutes Load a small sales file, drag fields into a column chart and a card, add a title and save your first Power BI report, with pandas checking the numbers.
- Power BI and Excel Together Learn how Power BI and Excel work together: import workbooks, Analyze in Excel, connect a PivotTable to a semantic model, upload and refresh Excel files, and when to use which.
Getting Data
- Connecting to Data Sources Learn how Get Data works in Power BI: files, folders, databases, web and online services, the Navigator, and what a connector query looks like in M.
- Import, DirectQuery and Live Connection Understand Power BI storage modes: Import, DirectQuery, Dual and Live Connection, composite models, refresh versus live queries, and the trade-offs.
- Data Source Settings, Privacy Levels and Parameters Manage Power BI data source credentials, understand privacy levels and the Formula.Firewall error, and use parameters for file paths and servers.
Power Query
- The Power Query Editor Tour the Power Query Editor: the Queries pane, Applied Steps, the formula bar and the M code behind every click, with a pandas pipeline that mirrors it.
- Cleaning Data: Types, Nulls, Trim and Duplicates Fix the most common data problems in Power Query: data types, errors, nulls, stray spaces, duplicates and header rows, with M code and pandas equivalents.
- Shaping Columns and Rows Split and merge columns, extract text, add conditional and custom columns, and keep or remove rows in Power Query, with M code and pandas stand-ins.
- Unpivot, Pivot and Transpose Turn wide tables into tidy ones with Unpivot, summarize with Pivot, and flip with Transpose in Power Query, with M code and runnable pandas melt and pivot.
- Merge and Append Queries Combine data in Power Query: merge queries with join kinds and fuzzy matching, expand columns, append tables and combine a folder of files, with pandas stand-ins.
- Group By and Aggregations in Power Query Summarize tables with Group By in Power Query: sums and counts, the All Rows option, index and rank columns and running totals, with pandas stand-ins.
- M Language Basics Learn the Power Query M language: let and in, values, records, lists, tables, functions, each and underscore, types, and error handling with try.
- Custom Functions and Reusable Queries Write parameterised Power Query functions, invoke them on a column, choose between reference and duplicate, and organise staging queries.
- Query Folding, Incremental Refresh and Query Performance Understand query folding, native queries and step order in Power Query, set up incremental refresh, and keep refreshes fast with simple habits.
Data Modelling
- Star Schema: Facts and Dimensions Learn why Power BI models should be star schemas: fact and dimension tables, grain, snowflaking, and how a flat table compares with a star.
- Relationships, Cardinality and Filter Direction Learn Power BI relationships: one-to-many, many-to-many, active and inactive links, cross-filter direction, ambiguity and role-playing dimensions.
- Date Tables and Time Intelligence Setup Build a Power BI date table with CALENDAR or CALENDARAUTO, mark it as the date table, add hierarchies and a fiscal calendar, and sort month names.
- Model View, Hierarchies, Formatting and Display Folders Tidy a Power BI model for report authors: diagram layout, hidden fields, display folders, hierarchies, number formats, sort by column and summarization defaults.
DAX
- DAX Basics: Syntax, Columns and Measures Learn what DAX is, how its syntax works, and when to use a calculated column, a measure or a calculated table, with a pandas stand-in you can run.
- Aggregators and Iterators: SUM, SUMX, AVERAGEX Understand row context, the difference between SUM and SUMX, AVERAGEX, DIVIDE, COUNTROWS and DISTINCTCOUNT in DAX, with a pandas stand-in you can run.
- CALCULATE and Filter Context Learn filter context, how CALCULATE changes it, ALL, REMOVEFILTERS, KEEPFILTERS, context transition and variables, with a runnable Python stand-in for the engine.
- Time Intelligence: YTD, Prior Year and Moving Averages Write DAX time intelligence measures: TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, DATESINPERIOD, growth percent and rolling averages, with pandas stand-ins.
- Ranking, Top N and Percent of Total Rank products with RANKX, keep the top N with TOPN, compute percent of total with ALL and ALLSELECTED, and build Pareto and running totals, with pandas stand-ins.
- Common DAX Patterns: Segmentation, Cohorts and Dynamic Measures Learn reusable DAX patterns: a SWITCH measure selector with a disconnected table, ABC classification, new vs returning customers and field parameters, with pandas checks.
- Debugging and Optimizing DAX Find and fix DAX problems: write EVALUATE queries in DAX query view, record Performance Analyzer, use DAX Studio, split logic with variables and avoid common mistakes.
- DAX Text Functions: FORMAT, CONCATENATEX, SUBSTITUTE and More Learn the DAX text functions: LEFT, MID, TRIM, SUBSTITUTE, FIND, SEARCH, FORMAT and CONCATENATEX, with pandas stand-ins that show the exact results.
- DAX Date and Time Functions Learn DAX date and time functions: CALENDAR, DATEDIFF, EDATE, EOMONTH, WEEKDAY, WEEKNUM, NOW, UTCNOW and YEARFRAC, with runnable Python stand-ins.
- DAX Logical and Information Functions Master DAX logic: IF, SWITCH(TRUE()), AND/OR, COALESCE, IFERROR, ISBLANK, HASONEVALUE, ISFILTERED, ISINSCOPE and USERNAME, with runnable Python stand-ins.
- DAX Math and Statistical Functions Learn DAX math and statistics: ROUND, MROUND, CEILING, MOD, QUOTIENT, POWER, LOG, MEDIAN, STDEV.S, PERCENTILE and COMBIN, checked with Python stand-ins.
- DAX Trigonometric, Financial and Bitwise Functions Learn the specialist DAX functions: SIN, SINH, ACOT, DEGREES, SLN, SYD, DDB, DB, COUPDAYS and BITAND, with formulas and runnable Python stand-ins.
- DAX Table Functions: SUMMARIZE, GROUPBY, CROSSJOIN, UNION and LOOKUPVALUE Learn the DAX table functions: ADDCOLUMNS, SUMMARIZE, GROUPBY, CROSSJOIN, UNION, EXCEPT, TREATAS, LOOKUPVALUE and TOPN, with pandas stand-ins.
Visuals and Reports
- Choosing the Right Visual Match a business question to the right Power BI visual: bar, line, scatter, table, matrix, map, treemap and waterfall, with matplotlib and pandas stand-ins you can run.
- Maps, Gauges and the Visual Formatting Options Build and format Power BI maps, filled and shape maps, radial gauges, 100% stacked, area, donut, pie and ribbon charts, and learn the Format pane options they share.
- Formatting, Themes and Report Design Design clearer Power BI reports: page layout, alignment, colour, theme JSON files, accessibility, alt text, tab order and mobile layout, with a contrast checker.
- Filters, Slicers and Sync Learn the three filter levels, every slicer type, sync slicers across pages, relative date slicers and edit interactions in Power BI, with pandas stand-ins.
- Drill-through, Tooltips, Bookmarks and Buttons Make Power BI reports explorable: drill down and drill through, report-page tooltips, bookmarks, navigation buttons and what-if parameters, with Python stand-ins.
- Conditional Formatting, KPIs and Cards Use rules, gradients, icons and field-value formatting, the KPI visual, reference labels and small multiples to make Power BI numbers explain themselves.
- The Analytics Pane: Trend Lines, Reference Lines and Forecasts Use the Power BI Analytics pane: constant, average and percentile lines, trend lines, forecasts with confidence bands and anomaly detection, with Python stand-ins.
- AI Visuals: Key Influencers, Decomposition Tree and Smart Narrative Use Power BI's AI visuals: key influencers, decomposition tree, smart narrative and the Q&A visual. Learn how they work, what to feed them and when not to trust them.
- Custom Visuals, AppSource, and R/Python Scripts Extend Power BI beyond the built-in charts: AppSource and certified custom visuals, .pbiviz files, R and Python visuals, scripts in Power Query and the limits in the service.
Service, Sharing and Security
- Publishing to the Power BI Service Publish a report from Power BI Desktop to the service: workspaces, reports versus dashboards, pinning tiles, apps, Q&A, subscriptions and data alerts.
- Scheduled Refresh and Gateways Keep published Power BI data current: scheduled refresh, the on-premises data gateway (personal vs standard), credentials, refresh failures and dataflows.
- Row-Level Security Restrict which rows each person sees in Power BI: static and dynamic RLS roles, USERPRINCIPALNAME, testing as a role, and object-level security.
- Governance, Deployment Pipelines and Best Practices Run Power BI at scale: workspace roles, certification, sensitivity labels, deployment pipelines, naming, source control and performance guidelines.
Projects
- Project: Sales Performance Dashboard Build a complete Power BI sales dashboard: star schema, date table, DAX measures, two report pages, and a pandas check of every number you show.
- Project: Profit and Loss Report Build a profit and loss report in Power BI: an account hierarchy matrix, variance to budget, a waterfall bridge and DAX measures, checked with pandas.
- Project: HR and Headcount Dashboard Build an HR dashboard in Power BI: a monthly headcount snapshot table, hires, leavers and attrition measures, slicers and row-level security, checked in pandas.
- Project: Customer Churn Analysis Build a customer churn report in Power BI: churn rate and MRR churn measures, plan and tenure segments, cohort retention and key influencers, verified in pandas.
- Project: E-commerce Analytics Dashboard Build an e-commerce dashboard in Power BI: revenue, orders, average order value, repeat purchases, returns, a conversion funnel and product and channel analysis.
- Project: Risk and Fraud Monitoring Dashboard Build a fraud and risk monitoring dashboard in Power BI: rule-based flags, a risk score, adjustable thresholds, precision and recall, drill-through to transactions and alerts.
Practice
- Exercises with Solutions Twelve Power BI exercises across Power Query, data modelling and DAX, each with a worked answer in M or DAX and a pandas check you can run in the browser.
- Power BI Interview Questions 25 Power BI interview questions with clear answers on data modelling, DAX, Power Query and the Power BI Service, plus runnable stand-ins for the trickiest ideas.
- Power BI Cheat Sheet A one-page Power BI reference: DAX functions and patterns, Power Query M steps, modelling rules, shortcuts and a performance checklist, with runnable pandas stand-ins.