Business Intelligence & Reporting — Quiz

Answer all 12 questions, then submit. You need 70% to pass. Log in to save progress.

Question 1
What distinguishes a KPI from an ordinary metric?
A It is bigger
B It is tied to a specific goal/target
C It uses more decimals
D It is always revenue
Question 2
Trial sign-ups that predict future revenue are a…
A lagging indicator
B leading indicator
C vanity metric
D dimension
Question 3
In a star schema, the central table is the…
A dimension table
B fact table
C lookup table
D index
Question 4
In Power BI, a DAX MEASURE is…
A computed once and stored per row
B calculated on the fly as users filter the report
C a type of chart
D the same as a column
Question 5
Which is TRUE about Power BI vs Tableau?
A Only one can make dashboards
B They share the same core concepts; learn the ideas and switch freely
C Tableau cannot connect to databases
D Power BI cannot do KPIs
Question 6
Which Python tool writes formatted, multi-sheet Excel files?
A matplotlib
B pd.ExcelWriter with xlsxwriter/openpyxl
C requests
D scipy
Question 7
Which library can both READ and EDIT existing Excel workbooks?
A xlsxwriter
B openpyxl
C seaborn
D plotly
Question 8
Which tool schedules a report script to run weekly on Windows?
A cron
B Task Scheduler
C GitHub
D Jupyter
Question 9
Why add failure alerts to a scheduled report?
A To slow it down
B So a silently broken job does not serve stale numbers
C It is legally required
D To use more memory
Question 10
The pyramid principle for communicating results means…
A save the conclusion for the end
B state the recommendation first, then reasons, then detail
C use as many slides as possible
D show only raw tables
Question 11
Before sharing a dashboard, personal identifiers (PII) should be…
A highlighted
B removed or anonymised/aggregated
C sorted
D duplicated
Question 12
GDPR / DPDP 'data minimisation' means…
A use the smallest font
B collect and keep only the data you actually need
C minimise the number of charts
D delete all data monthly