Learn to build professional Power BI reports and dashboards step by step: Power Query, star schema data models, DAX, time intelligence, interactive reports, publishing with row-level security, a P&L statement, ABC and RFM analysis, and PL-300 exam prep.
No sign-up needed: just start reading. Create a free account to save your progress and get your certificate.
Every lesson starts by telling you what you’ll be able to do.
Real-life cases from U.S. households and small businesses.
Check what you learned with immediate feedback.
Practice first, then compare with the solution.
4 levels · 16 lessons · 3h 26min of content
Power BI vs. Excel, Desktop vs. the Power BI service, installation, the main views and a first report in 15 minutes.
Connectors, the Power Query Editor, cleanup steps, data types, unpivot, append, merge, folders and data profiling.
Which chart to use, cards, bar and line charts, matrices, filter levels, slicers, visual interactions and formatting.
Planning with the user, page structure, layout, themes, navigation, mobile layout and a pre-launch checklist.
Fact and dimension tables, one-to-many relationships, filter direction, different grains and common model problems.
Measures vs. calculated columns, SUM, COUNTROWS, DISTINCTCOUNT, DIVIDE, SUMX, RELATED and filter context.
CALCULATE, KEEPFILTERS, ALL, REMOVEFILTERS, ALLSELECTED, FILTER and context transition.
A DAX calendar table, TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, moving averages and partial periods.
Hierarchies, drillthrough pages, report page tooltips, bookmarks, field and numeric parameters, dynamic titles.
Licenses, workspaces, scheduled refresh, gateways, apps, subscriptions and static and dynamic RLS.
VAR and RETURN, RANKX, TOPN, SWITCH(TRUE()), new and lost customers, USERELATIONSHIP and Performance analyzer.
Data, Power Query, model, 20+ measures, interactive pages, security, validation, publishing and your portfolio.
A layout table, an expenses table, a SWITCH measure, subtotals, percent of sales, break-even and financial formatting.
Connecting to SQL databases, storage modes, query folding, the on-premises data gateway, scheduled and incremental refresh.
Cumulative percentage in DAX, ABC classes as a measure and a column, a Pareto chart, and champion and at-risk customers with RFM.
What the PL-300 exam measures, a six-week study plan, a portfolio that gets interviews and common data analyst interview questions.
Learn Power BI, one of the most requested tools in U.S. job postings for data analysts, financial analysts, sales operations and business intelligence roles, from zero and with a real project. You'll build the sales dashboard of Summit Supply Co., a fictional U.S. food and beverage distributor, with verified numbers, interactive quizzes and a worked exercise in every lesson. If you already know Excel, this is the natural next step.
Across 16 lessons in four levels you'll go from your first report to the skills that separate a casual user from a professional: cleaning data with Power Query, building a star schema, writing DAX measures, mastering CALCULATE and filter context, time intelligence (YTD, prior year, moving averages), interactive reports with drillthrough and bookmarks, publishing to the Power BI service, row-level security and performance tuning. The Expert level covers an income statement (P&L) built with DAX, connecting to SQL databases with scheduled and incremental refresh, ABC (Pareto) and RFM analysis, and a study plan for the Microsoft PL-300 certification.
Includes a free downloadable dataset: the complete Summit Supply database in Excel (4,430 order lines, products, customers, sales reps and monthly targets in dollars) for every lesson and the final project.
Templates and practice data you’ll use throughout the course. Free, no sign-up.
More free courses that pair well with this one.
Learn Excel from scratch all the way to PivotTables, XLOOKUP, Power Query, macros, Power Pivot and financial functions, with worked exercises, interactive quizzes and a free certificate.
Learn to attract customers and sell online: buyer personas, content, social media, SEO, email marketing, Google Analytics 4, Google Ads, Meta and TikTok Ads, ecommerce, influencers and LinkedIn.
Learn to lead people with confidence: leadership styles, emotional intelligence, feedback, delegation, one-on-ones, OKRs, difficult conversations, coaching and leading change, with real scripts and a 90-day plan for new managers.
