After today's automated refresh, a retail sales dashboard suddenly shows a Gross Profit Margin of 215 %, yet a manual SQL check of the ERP system still returns the expected 20 % range. No ETL errors were logged and other visuals appear normal. Before involving the data-engineering team, which review technique should the analyst apply first to efficiently locate the problem inside the report?
Examine the report's measures and aggregation formulas to verify that the profit-margin calculation logic is correct.
Perform a detailed line-by-line code review of the overnight ETL and SQL extraction scripts that populate the model.
Ask a colleague to conduct a peer review focused on the dashboard's visual design and storytelling elements.
Configure an automated alert that emails the analyst whenever the profit-margin card exceeds a predefined threshold.
The most likely cause of an implausible 215 % margin is an error in the KPI's formula-such as dividing by the wrong column or applying an incorrect aggregate. A calculation review focuses on auditing the measures, expressions or DAX used in the report, enabling the analyst to confirm or correct the logic quickly. A peer review that concentrates on layout would not inspect the math, a code review of the entire ETL pipeline is time-consuming and unnecessary when other metrics look fine, and an alert only signals the symptom without revealing the root cause.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does KPI mean in this context?
Open an interactive chat with Bash
What is DAX and why is it relevant here?
Open an interactive chat with Bash
Why is the ETL process unlikely to be the issue here?
Open an interactive chat with Bash
CompTIA Data+ DA0-002 (V2)
Visualization and Reporting
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .