Module 04 · Master data & calendar

Check all five queries

Match the row counts of all five queries in the Queries & Connections pane before moving on to the Data Model.

Step by step4 minLesson 17 of 37 Members

Before connecting tables in the Data Model, make sure all five queries are loaded the right way and their row counts match. A wrong number here carries into every chart later, so this quick check saves a lot of time. You will also learn to fix a query that was loaded as a table by mistake.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

4 steps with a numbered picture
All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
A new Excel & dashboard template every day, with resell rights
Take paid client projects on the Project Board

Become a member & unlock all Already a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons