Essential session storage is required to sign in. Optional analytics remain off unless you allow them.
Pick a real dataset (a public dataset or a business-scenario CSV) and build a dashboard in a BI tool (Power BI, Tableau, or a free option like Metabase / Looker Studio). Requirements: model the data as a small STAR SCHEMA (a fact table + at least one dimension) with correct relationships; define at least TWO measures in the tool's language (e.g. total revenue and a ratio); build a dashboard that answers 2-3 clear business questions using appropriate CHART TYPES (trend -> line, comparison -> sorted bar) and add a filter/slicer; and VALIDATE one number by reconciling it to a SQL query or the source. State who the audience is and what decision the dashboard supports.
A small star-schema model (fact + dimension) with correct relationships; two or more well-defined measures.
Answers 2-3 clear questions with appropriate chart types + a filter; the audience and decision are stated.
One number reconciled to a SQL query or the source; chart choices are honest (no truncated/misleading axes).
Use this README structure to make the work reviewable.
DevPath fetches a read-only, size-capped snapshot. Submitted code is never executed.
# A dashboard from a real dataset ## Goal Pick a real dataset (a public dataset or a business-scenario CSV) and build a dashboard in a BI tool (Power BI, Tableau, or a free option like Metabase / Looker Studio). Requirements: model the data as a small STAR SCHEMA (a fact table + at least one dimension) with correct relationships; define at least TWO measures in the tool's language (e.g. total revenue and a ratio); build a dashboard that answers 2-3 clear business questions using appropriate CHART TYPES (trend -> line, comparison -> sorted bar) and add a filter/slicer; and VALIDATE one number by reconciling it to a SQL query or the source. State who the audience is and what decision the dashboard supports. ## Acceptance criteria - [ ] Model & measures: A small star-schema model (fact + dimension) with correct relationships; two or more well-defined measures. - [ ] Dashboard: Answers 2-3 clear questions with appropriate chart types + a filter; the audience and decision are stated. - [ ] Validation: One number reconciled to a SQL query or the source; chart choices are honest (no truncated/misleading axes). ## Verification - [ ] Document installation and run commands. - [ ] Record automated checks and their exact commands. - [ ] Add representative output, screenshots, or a short demo where useful. - [ ] Confirm failure paths and known constraints. ## Decision log ### Decision title - Context: - Choice: - Alternatives considered: - Tradeoffs: ## Evidence - Link each rubric criterion to the file, test, or artifact that demonstrates it. ## Known limitations - List what is intentionally out of scope and what should be improved next.