Which Power BI course is right for you?

Answer 10 quick questions and I will point you to the best course: An Introduction to Power BI, or Further Power BI. Pick the answer you think is right, and do not worry about guessing.

Looking for Excel instead? Take the Excel quiz.

Two monitors showing dashboards of charts, with a spreadsheet beside them

1. Which Power BI tool do you install on your computer to build reports? Microsoft Forms Power BI Desktop Power BI Mobile Power Automate

2. What is Power Query used for in Power BI? Cleaning and transforming data before it is loaded Choosing the colours and fonts of a report Sharing a report with colleagues Printing reports on to paper

3. What is a relationship between two tables in a Power BI data model? A colour theme shared by two reports A copy of one table stored inside the other A password that protects two tables A link between a column in one table and a column in another, so they can be used together in a report

4. In Power Query, what do the Applied Steps record? The visuals on your report page The version of Power BI you are using The list of changes you have made to the data, in order The people who have viewed your report

5. Which of these best describes DAX? A way of sharing a dashboard by email A formula language used to create measures and calculated columns A type of chart A file format for saving reports

6. What is the main difference between a measure and a calculated column? A measure is calculated when it is used in a visual and responds to filters; a calculated column is worked out row by row when the data is refreshed and stored in the model A measure can only contain text; a calculated column can only contain numbers There is no difference, they are two names for the same thing A calculated column is only available in the Power BI service

7. In Power Query, you have one column for each month. Which step turns these columns into rows with a Month column and a Value column? Merge queries Remove duplicates Transpose the whole report Unpivot columns

8. What is the difference between Merge queries and Append queries? Merge works only on text; Append works only on numbers There is no difference Merge joins two queries side by side using matching columns; Append stacks the rows of one query underneath another Merge deletes the first query; Append deletes the second

9. What does row-level security allow you to do? Stop a report being printed Control which rows of data different people can see by using roles Lock a report so nobody can edit the formatting Hide a column from the data model for everyone

10. In the Power BI service, what does a scheduled refresh do? Reloads the data from its sources automatically at set times Redraws the report page every few seconds Emails the report to everyone in the workspace Deletes old versions of the report

Not sure Power BI is for you yet?

If your team lives in Excel, start there. The Excel quiz points you to Foundation, Intermediate or Advanced.

Take the Excel quiz

Still not sure?

Talk to me. I will happily talk through what your team does with data and recommend the right course.

Get in touch with me

Think I can help? Contact me today

Tell me what your team needs and I will come back to you.