
Meet Power BI Desktop and the project brief, load the 23,377-row energy file with Get Data, and check the 2024 world solar share (6.93 %) by hand.
Use the Power Query editor to remove regional totals, keep 2000-2024, choose and type the 25 project columns, and check the United States by hand.
Unpivot nine generation columns into a tall table, merge a country-codes lookup, read the M code and replace the file path with a parameter.
Build fact and dimension tables, create relationships with the right cardinality and filter direction, and check China 2024 through the model.
Write your first DAX measures, convert TWh to PJ and kWh per person, compute shares of a total and organise measures in display folders.
Use CALCULATE and variables for growth since 2000 and year-over-year growth, then build carbon intensity and low-carbon share measures.
Build the United States page with cards, column, line and stacked area charts, a year slicer, edited interactions and clear formatting.
Duplicate pages with a synced slicer, build a matrix hierarchy, add conditional formatting and tooltips, and check Europe's carbon intensity.
Apply a theme, add the Rest of the World page, page and bookmark navigators, hidden check pages, alt text and the Performance analyzer.
Create what-if and field parameters, a calculation group, a decomposition tree, anomaly detection and a forecast, and check a scenario by hand.
Test measures in DAX query view, document them in TMDL view, learn what add-ins and Copilot need, and use an AI assistant to draft a measure.
Publish the report, understand sharing, apps, scheduled refresh and the gateway, and create and test a row-level security role.
Run a final quality check with a phone layout, document the report, export a template and present the five headline findings.
Find what drives carbon intensity with Key influencers, read Top segments and build a 3-year rolling average with a visual calculation.
Learn what Copilot does and needs, troubleshoot AI-written DAX (a loud error and a silent mistake) and build an AI design suggestion.
This course contains the use of artificial intelligence.
Learn Microsoft Power BI the way it is used at work: by building one complete, real report from a raw data file to a published, secured and documented dashboard.
Project TERAWATT is a Global Energy Transition Dashboard for an international energy consultancy. Using the open Our World in Data energy dataset (CC BY 4.0), you analyse electricity generation, the energy mix, carbon intensity and electricity per person for every country from 2000 to 2024.
What you will do, step by step
• Load a 23,377-row CSV file and clean it in Power Query: filter rows, choose and type columns, unpivot, merge a lookup and use a file-path parameter.
• Build a star-schema data model with fact and dimension tables and correct relationships.
• Write DAX measures for unit conversions, shares, growth since 2000, year-over-year growth and carbon intensity, using CALCULATE and variables.
• Design report pages for the United States, Europe, China and the rest of the world, with slicers, matrices, conditional formatting, tooltips, a theme, navigation, bookmarks, alt text and a phone layout.
• Use advanced analytics: what-if and field parameters, calculation groups, the decomposition tree, anomaly detection, forecasts, key influencers, top segments and rolling averages with visual calculations.
• Use AI properly: what Copilot can do and what it needs, and how to use ChatGPT and Claude to draft DAX, then catch their mistakes in DAX query view.
• Publish to the Power BI Service, understand sharing, refresh and the gateway, and secure the report with row-level security.
How you learn. Every lesson works one important number out by hand on a whiteboard first, then verifies it in Power BI, so you understand the result and not just the click. Each lesson starts from a checkpoint file and ends with a new one.
Included: 15 project-based video lessons (over 4 hours), starting data or checkpoint files and solution .pbix files, step-by-step checklists, notes with glossaries, practice exercises with worked solutions, six section quizzes, and captions in ten languages.
About the use of AI in this course: the narration uses an AI-generated voice, captions were translated with AI assistance, and AI tools are also a topic of Lessons 11, 14 and 15. All numbers were checked by hand and in Power BI.