AMAADOR ACADEMYCertificatesVerify a certificate

DVDASH

Final check — Data Visualisation and Dashboards with Power BI and Tableau

Answer the 41 questions. You need 80% or more to pass. You can retry as many times as you like.

Study the course →

Question 1Besides the number itself, what makes a KPI useful?
Question 2You are asked for a dashboard, but nobody can say who will use it. What do you do first?
Question 3Sales and Marketing report different numbers of "active customers". What is the best fix?
Question 4A card shows only "87%". Which addition makes it a real KPI?
Question 5Which of these is a leading KPI?
Question 6A manager wants to know why returns spiked in March, once. What is the best deliverable?
Question 7Which chart best compares sales across 8 regions?
Question 8A bar chart axis starts at 90 to show 92 against 95. What is wrong?
Question 9You must show monthly orders for three years so readers see seasonality. Which chart?
Question 10Does advertising spend relate to sales across 40 stores? Which visual answers it?
Question 11What is the main risk of a dual-axis chart?
Question 12A map of case counts per city shows the biggest cities darkest. What improves it?
Question 13In a star schema, which table holds the numeric measures and keys?
Question 14Which relationship is normal between a dimension and a fact table?
Question 15The source has 120,000 rows but your model loaded 65,000 with no error. What now?
Question 16Country values appear as "Maroc", "Morocco" and "MA". What do you do?
Question 17What does the "grain" of a fact table mean?
Question 18Your data passes through an old Excel file and the dashboard total drops with no error. Best control?
Question 19What is the difference between a DAX measure and a calculated column?
Question 20Which DAX pattern avoids an error when the denominator is zero?
Question 21In Tableau you need each customer’s first order date whatever the view shows. Which expression?
Question 22In Tableau’s order of operations, which filter is applied before a FIXED LOD?
Question 23You need a year-to-date sales line in Power BI. Which approach is right?
Question 24A user adds a Region filter, but your FIXED LOD result does not change. Why?
Question 25An Import-mode model on an on-premises SQL Server must refresh daily. What is needed?
Question 26What does publishing from Power BI Desktop create in the service?
Question 27You defined RLS roles. How do you check that a manager sees only their region?
Question 28What is the best way to give many business users access to a set of reports?
Question 29Scheduled refresh fails after the owner changed their password. What is the right fix?
Question 30What is a Tableau extract?
Question 31Phone users must scroll sideways through your dashboard. What do you do?
Question 32Clicking a bar should filter a map on the same dashboard. What do you add?
Question 33You must share a salary-by-employee dashboard with HR only. Where do you publish it?
Question 34What is Tableau Bridge used for?
Question 35Three workbooks each hold their own extract of the same data and refreshes collide. What is better?
Question 36What minimum contrast ratio does WCAG 2.2 set for normal body text?
Question 37Which title is best for a chart showing returns by month?
Question 38In a 5-second test, viewers cannot say what your dashboard shows. What do you do?
Question 39Which page order is recommended for a dashboard?
Question 40Screen-reader users say your report is unusable. What is the best action?
Question 41A day before launch, your totals differ from finance by 3%. What do you do?