Power BI DAX Practice Test and Solutions
Description
Legend says if you can't write DAX then you don't know Power BI.
Microsoft Power BI uses the scripting language Data Analysis Expressions DAX to build custom tables, calculated columns, and measurements.
It is a set of operators, constants, and functions that can be included in a formula or expression to compute and output one or more values.
In this Practice Test, you will be using the Adventure Works Database.
The AdventureWorks Database is the source of information for Adventure Works Cycles, a made-up international manufacturing firm.
Before taking this test, ensure you know:
How to connect to a Data Source
Model a Data Relationship
Familiar with DAX Functions and Expressions
The Practice Test is going to cover :
Aggregation Functions
Iterator Functions
Filter Functions
Conditional Functions
Logical Functions
Date and Time Functions
Statistical Functions
Time Intelligence Functions
Instructions
The link to the database will be given on the test page. If you encounter any problem downloading the database from the link, please feel free to drop me a message.
You are going to load five tables, from the database:
Calendar Table
Customers Table
Products Table
Territories Table
Sales Table
Ensure your Data Modelling is right by defining the right relationships.
Join the Calendar, Customers, Products and Territories Lookup Tables to the Sales Data Table.
Join Products Table to Sales Table using the ProductKey Column in both Tables.
Join Customers Table to Sales Table using the CustomerKey Column in both Tables.
Join Territories Table using the TerritoryKey Column to Sales Table using the SalesTerritoryKey
Join the Calendar Table using the Date column to the Sales Table using the OrderDate column
Please take your time to study the database, the columns in the database are self-explanatory.
Some questions might have different ways of solving, provided your answer is correct don't worry. You can still compare with my solution.
If you can't solve a question skip it and come back to it later.
Who this course is for:
- Data Analysts who want to sharpen their DAX skills.
Instructor
- 4.2 Instructor Rating
- 38 Reviews
- 2,902 Students
- 6 Courses
In an era where there is a huge and vast amount of data, the need for professionals who can manage and make sense of this data is needed, either by describing, modelling or identifying patterns in data.
As someone who has worked as a freelance Data Scientist for over 5 years in the data industry, I aim to train and educate you on how you can become one of the best data professionals out there either as a Data Analyst, Data Scientist or Machine Learning Engineer.
I graduated with a BSc in Statistics and currently working as a Biostatistician at a public hospital assisting medical researchers in analysing health data. As a technical writer, I have written various articles and have thousands of reads on medium.
I am proficient in Mathematics, Statistics and Programming (R and Python) and have a strong domain knowledge of the health sector.
As a data scientist, my day-to-day activities range from performing exploratory data analysis to building machine learning or deep learning models.
My biggest happiness comes when students benefit from my courses and I hope as you are reading this, you have either enrolled or are about to enroll in one of my courses.
I wish you all the best in your path to becoming a world-class data professional!