How m03jam14/visualizethisdata works
Project type and purpose
• This is a data‐analytics / BI dashboard project built on the Power BI Desktop/Service platform.
• Purpose: Visually analyze, compare, and forecast robbery incidents across three Canadian provinces (Alberta, Manitoba, Ontario) using multi-source crime data and advanced time-series/statistical models.
File structure
• Top-level files:
• README.md – full project description, features, architecture
• Canadian Provincial Robbery Patterns.pdf – supplemental documentation
• Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix – the Power BI report file containing data model, queries, visuals
• No explicit “src” or “backend” code folders—logic is inside the .pbix (Power Query queries, DAX measures).
README for additional insights
• ETL pipelines (Power Query) ingest multi‐source provincial and municipal crime data.
• Data model uses DAX measures for forecasting and trend analysis.
• Deployment: published to Power BI Service with scheduled refresh.
• Key external data sources: Alberta Justice DB, Manitoba Justice DB, Ontario Police Records, Statistics Canada.
Main components & relationships
a. Data Sources Layer (External Services)
• Alberta Crime DB
• Manitoba Crime DB
• Ontario Crime Systems
• Municipal Police Dept. Records
• Statistics Canada API/Files
b. Ingestion & ETL Layer (Power Query)
• Extract scripts (Power Query queries in .pbix)
• Transform/normalize data (standard schemas for cross-province)
• Load into Power BI Data Model
c. Data Model Layer
• Fact tables: robbery incidents, crime rates, forecasting outputs
• Dimension tables: Date, Province, City, Crime Severity Index
• Relationships (star schema pattern)
d. Analytics Layer
• DAX Measures: time-series forecasts, trend calculations, city rankings
• Calculated columns for crime rates per 100k population
e. Visualization Layer (Power BI Report)
• Temporal trend charts (2014–2022)
• Provincial comparison visuals (maps, bar charts)
• City-level top-5 rankings
• Forecasting plot with confidence intervals
• Interactive filters and drill-downs
f. Deployment & Access
• Power BI Service workspace
• Scheduled data refresh (weekly)
• End users: Law enforcement dashboards, policy analysts
Architectural patterns & design principles
• Star Schema for high-performance querying in Power BI
• ETL separation: data ingestion vs. modeling vs. visualization
• Modular DAX design: reusable measures for forecasting & metrics
• Responsive dashboard design for drill-through and cross-filtering
Detail level
• You capture each provincial data source as a separate node
• Power BI Desktop (.pbix) as the container for ETL queries, Data Model, and Visuals
• Power BI Service for published reports and scheduled refresh