1500 Questions | Data Practitioner Certification 2026

Data Preparation and Manipulation (27%): Connecting to diverse data sources, performing advanced filtering, sorting, and effectively grouping or summarizing data.

Data Storytelling and Insights (23%): Translating raw numbers into compelling visual narratives and providing actionable data-driven recommendations.

Data Analysis and Modelling (19%): Mastering essential DAX calculations, data analysis functions, and industry-standard modelling best practices.

B. One-to-one (1:1), Both directions

C. One-to-many (1:*), Single direction (Sales filters Product)

D. Many-to-many (:), Both directions

E. Many-to-one (*:1), Both directions

F. No relationship is required if the names match.

Correct Answer: A

Explanation:

B (Incorrect): 1:1 relationships are rare and usually indicate that the tables should be merged.

C (Incorrect): This reverses the logical flow; the fact table does not typically filter the dimension table.

D (Incorrect): Many-to-many relationships introduce complexity and potential data inaccuracies if not handled with a bridge table.

E (Incorrect): While technically possible, bi-directional filtering can cause performance issues and ambiguity in complex models.

F (Incorrect): Power BI requires established relationships to aggregate data across tables correctly.

Question 2: Which DAX function would I use to calculate the total sales for the previous year, regardless of the current month filter applied in the report?

B. CALCULATE(SUM(Sales[Amount]), PREVIOUSYEAR('Date'[Date]))

C. COUNTROWS(Sales)

D. FILTER(Sales, Sales[Year] = "Last Year")

E. LOOKUPVALUE(Sales[Amount], Sales[Year], 2025)

F. AVERAGE(Sales[Amount])

Correct Answer: B

Explanation:

A (Incorrect): This only provides a simple sum based on the current filter context.

C (Incorrect): This counts the number of transactions rather than summing the value.

D (Incorrect): "Last Year" is a string, not a dynamic date function; this would likely return an error or empty set.

E (Incorrect): LOOKUPVALUE is used to find a single value, not to aggregate data over a time period.

F (Incorrect): This calculates the mean value per transaction, not the total yearly sum.

Question 3: When designing a report for executive stakeholders, which visualisation is most effective for showing a breakdown of a single total value into its contributing categories?

B. A Treemap or Donut Chart.

C. A simple Card visual.

D. A Python script visual.

E. A blank text box with manual numbers.

F. A high-density Map visual.

Correct Answer: B

Explanation:

A (Incorrect): Scatter charts are best for showing correlations between two numerical variables.

C (Incorrect): A Card visual shows a single aggregate number but cannot show a breakdown of categories.

D (Incorrect): While powerful, it is over-engineered for a simple categorical breakdown and may not be supported in all environments.

E (Incorrect): This is static and defeats the purpose of an interactive data practitioner certification.

F (Incorrect): Maps show geographic distribution, not a general categorical breakdown of a total.

You can retake the exams as many times as you want

This is a huge original question bank

You get support from instructors if you have questions

Each question has a detailed explanation

Mobile-compatible with the Udemy app

30-days money-back guarantee if you're not satisfied