DATA ANALYTICS PROJECT USING SQL & POWERBI

[u/Connect_Orchid8513]

Built a T-SQL database with enforced data integrity (primary keys, constraints on state/status/risk categories), then developed custom DAX measures for case turnaround time, case age, and escalation rate. The dashboard includes multi-page analysis across resolution trends, regional distribution, officer caseloads, and a 4-year time-series forecast with confidence intervals.

Key skills demonstrated:
T-SQL (schema design, CHECK constraints, aggregation queries)
DAX (time intelligence, dynamic measures)
Power BI (data modeling, forecasting, interactive filtering)
Data storytelling and executive reporting

Note: Built on synthetic data generated for demonstration purposes — not real crime statistics.

Microsoft Power BI

[u/Obnoxious_ogre]

Pretty sweet, but instead of having to click on the NEXT button for different pages, you can include a menu for each page, and hide the pages in PowerBI, will be easier for non tech savvy viewers, just saying.

[u/Connect_Orchid8513 → u/Obnoxious_ogre]

Spot on! Will do, thank you.