Course 4 of 6 · The Data Analytics pathway

Power BI for Data Analytics

Power Query, DAX & Dashboards

Turn business questions into DAX measures and visuals, and then into decisions. Clean data with Power Query, build a data model and design a dashboard people actually use, answering requests from the fictional Kettle & Bean team.

View on Udemy ›Get all six in the Bootcamp
  • Course 4 of 6
  • Beginner to intermediate
  • Power BI Desktop
  • Self-paced
Power BI for Data Analytics course thumbnail

Free preview lesson

What you will learn

By the end of the course you can

  • Install free Power BI Desktop, load data and build your first report visuals.
  • Clean and combine data with Power Query: data types, split, fill, conditional columns, append and merge.
  • Build a star-schema data model with relationships, a date table and hierarchies.
  • Break any stakeholder question into its parts and choose the right visual, filters and slicers to answer it.
  • Write DAX measures with SUMX, DIVIDE, CALCULATE and ALL, and understand filter context.
  • Compare results with last year and with target using time intelligence.
  • Design a clear dashboard with themes, KPI cards, tooltips, drill-through and bookmarks.
  • Check your report, secure it with row-level security and present results as actionable recommendations.

Who it is for

This course suits you if

  • You use Excel and are ready to move to data models and dashboards.
  • You want to answer your own business questions with data.
  • You are planning the PL-300 exam and want a hands-on foundation first.
Laptop showing a Power BI for Data Analytics live lesson: a MAXX measure in Power BI Desktop answers a question from Marcus in Operations
You will need

A Windows PC. Power BI Desktop is free but runs on Windows only, so Mac users need a Windows PC or a Windows virtual machine. No paid licence is needed. No Power BI, DAX or Excel experience is needed.

What's included

Everything in this course

Video lessons

Each question broken into its parts, then the DAX or visual built live, with every part of the code explained.

Course handbook

A handbook for every section, so you can review the ideas and examples at your own pace.

Quizzes

Short checks at the end of each section to confirm you have understood the key ideas.

Challenges and solution walkthroughs

A challenge brief to work through on your own in each section, then a solution walkthrough to compare your work with.

The Kettle & Bean data

Three years of sales, customer, returns and target data from the fictional company, with start files for each lesson.

AI visuals, checked

A decomposition tree, key influencers, a forecast and Q&A, with each answer confirmed by a measure.

Two pages of the Power BI course handbook: the Section 5 DAX Measures cover and the Lesson 5.2 page on SUMX and RELATED

Inside the handbook

A handbook for every section

Each section has its own handbook with the notes, analogies, every worked example with its real result, and space for your answers. Type in the fillable PDF or print it.

Shown: the Section 5 cover and the Lesson 5.2 page on SUMX and RELATED.

Course content

Eight sections, one final project

  1. 1Section 1

    Welcome to Power BI and Kettle & Bean

    Load your first data, build your first visuals and learn to break down a question.

  2. 2Section 2

    Get and Clean Data with Power Query

    Clean and fix columns, add conditional and custom columns, and append and merge queries.

  3. 3Section 3

    Model Your Data

    Build a star schema with facts, dimensions, relationships, a date table and hierarchies.

  4. 4Section 4

    From Question to Visual

    Choose the visual from the question, place each field, filter and give it a clear title.

  5. 5Section 5

    DAX Measures: Say It, Then Write It

    Write measures in plain English first, then in DAX, with SUMX, CALCULATE and filter context.

  6. 6Section 6

    Time Intelligence

    Compare with last year and with target, with year to date and running totals.

  7. 7Section 7

    Design a Dashboard That Looks Good

    Plan the page, use themes and colour for meaning, add drill-through, bookmarks and AI visuals.

  8. 8Section 8Final project

    Share, Secure and Final Project

    Check your report, set up row-level security and complete the board dashboard.

Final project: the 2025 Board Dashboard

In Section 8 you build a complete report for Kettle & Bean: a cleaned, refreshable model, measures compared with last year and target, a drill-through page, row-level security and a check page. You finish with a one-page dashboard and three recommendations for the board.

Two pages of the Power BI final project brief: Amara's request for a 2025 Board Dashboard with ten questions, and the marking table

See inside the course

Real reports, real measures

Explore slides from the actual lessons, including the live demonstrations. Click or tap any image to see it full size.

Lesson slide: a Power BI board page with KPI cards and a revenue against target chart, with a request from Tom
Section 7: Build a board page with KPI cards, a target line and alt text.
Lesson slide: the Kettle & Bean star schema in Power BI model view
Section 3: The Kettle & Bean star schema.
Lesson slide: a DAX measure for the biggest sales line written live in Power BI Desktop
Section 5: Write DAX measures row by row.

Kettle & Bean Co. is a fictional company created for teaching.

Lesson slide from Section 5: Grace, Finance Manager, needs trustworthy measures for margin and returns

The learning scenario

Answer questions from the Kettle & Bean team

Each lesson starts with a realistic request from a colleague at a fictional UK coffee and tea retailer. You query the data, check the result and explain what it shows.

  • Amara
    Head of Insights
  • Priya
    Sales
  • Grace
    Finance
  • Marcus
    Operations
  • Tom
    Marketing
  • Ellie
    Customer Service
Watch the free preview ›
Sophie Lumpa

Created by Virtavis Learning

Sophie Lumpa

Data and Business Intelligence Specialist, founder of Virtavis Learning

Sophie Lumpa created this course and designed the Kettle & Bean learning scenario, bringing realistic business questions into the learning experience. The Virtavis teaching team provides additional training and learner support through the Bootcamp and live cohorts.

  • BCS Certified Data Analyst
  • BSc (Hons) Business Management and IT
  • Adult education teaching qualification
  • AgilePM
  • Certified Scrum Master

Questions

Questions about the course?

Something else?

If your question isn't answered here, send it to us and the Virtavis team will reply by email.

Contact us ›
Can I use a Mac?
Power BI Desktop runs on Windows only. Mac users need a Windows PC or a Windows virtual machine. Power BI Desktop itself is free and no paid licence is needed.
Do I need any Power BI or DAX experience?
No. The course starts with installing Power BI Desktop and loading your first data. Experience with spreadsheets helps but is not required.
Where do I buy this course?
On Udemy. The "View on Udemy" button opens the course page, where you can see the current price and terms.
Is it included in the Bootcamp?
Yes. The Virtavis Bootcamp brings all six courses together with the full practice dataset, additional templates and learning resources, and email support. A tutor-supported option is also available with four 30-minute one-to-one sessions, subject to the published package terms.
Does it prepare me for the PL-300 exam?
It covers the skill areas of Microsoft's PL-300 Power BI Data Analyst exam, but it is a practical course, not exam preparation.
Do I get a certificate?
Udemy provides its certificate of completion, subject to its terms. As part of our commitment to delivering high-quality professional learning, we are working towards obtaining CPD accreditation for our courses. We look forward to sharing further updates as we progress.

Start with the free preview.

See how the lessons work before you choose.

View on Udemy ›Explore the Bootcamp