This repository showcases my Tableau dashboard for DMV AKTE exam analysis.
All assets are anonymized: table names are generic, identifiers are hashed, and screenshots mask PII.
sql/demo_query.sql— the query powering the dashboard (scrubbed, documented)- (See Below) — static screenshots of the dashboard
Main dashboard view showing exam types, durations, and state averages.
Available filters: date range, office, exam type, language, CDL flag, and result.
- Fully filterable by Start/End Date, Exam Name, Office, Language, CDL flag, and Result.
- Click any chart segment (e.g., exam type, office bar) to drill down into the detailed exam-level table.
- Tooltips provide additional context on hover (e.g., state averages, record counts).
- Average exam duration by exam type with state-average reference lines
- Filters/ Parameters for Start/End date, Office, Exam Name, Language, CDL flag, and Result
- Record-level detail for QA (counts of questions, score, completion reason)
- Secondary verification linkage (fingerprint audit → session → exam) within a configurable time window
- No raw DL numbers or IP addresses are exposed; both are hashed.
- Names, DOB, and street addresses are omitted.
- Some test types are excluded per policy/business rules (see CTE
exclude_test_ids).
- Scope sessions and exams to the selected date window.
- Exclude certain test types (admin/instructor exams).
- Link fingerprint-audit failures to sessions within X seconds (parameterized).
- Join exams to sessions and a vault lookup (hashed driver IDs).
- Produce clean facts + dimensions for Tableau, including pass/fail counters and durations.
- (Optional) Enrich with non-PII DL attributes via a LEFT JOIN.
- SQL (Snowflake-like dialect),
- Tableau for visualization.
- Built a parameter-driven Tableau dashboard for DMV exam analysis.
- Designed SQL query with CTEs for clean modular logic (sessions, exams, audits).
- Applied anonymization: hashed driver IDs, masked IP addresses, removed PII.
- Delivered interactive visualizations with state-average KPIs and detailed record tables.
This version of the dashboard focuses on office-level exam distribution and outcomes.
- Exam distribution by exam type (donut chart)
- Pass/Fail outcomes by exam type (stacked bar)
- Office-level completion metrics with pass/fail breakdowns
- Record-level detail including exam duration, % correct, and outcomes
- Fully filterable by date range, exam type, office, result, and workstation IP.
- Click-to-drilldown: selecting a bar or chart segment filters the detailed table automatically.
- Row-level table is dynamically tied to filters, showing exam-by-exam breakdowns.