Full-Stack Engineering Showcase

This platform was engineered by Karan to showcase advanced data visualization and full-stack engineering.

Anyone can log into Power BI and drag-and-drop a pre-made chart. I didn't just build these dashboards—I engineered the entire software engine that powers, filters, and renders them from scratch. Think of it less like creating a dashboard, and more like building the Power BI platform itself using pure code.

Workspace 01 Database

IT Help Desk Incident Database

This workspace displays operational metrics powered by a sample database of 1,200 simulated incident records. The dataset models a live production system, tracking details such as resolution time in hours, SLA targets, severity ratings, client departments, and satisfaction surveys (CSAT). Click the button below to download the dataset and inspect it locally.

Interactive Console Filters

Filter by Severity (Priority)
SLA Compliance Rate

39.7%

473 of 1190 closed cases met targets

Current Backlog

22 Active

Unresolved tickets in queue

Mean Time to Resolve

42.1 Hrs

Average resolution duration

User CSAT Rating

3.10 / 5.0

Customer satisfaction average

Inbound Ticket Traffic vs. Resolution Velocity

💡 Hover over the data points to view specific daily volume.

Loading charts...

This chart tracks inbound ticket traffic directly against resolution velocity to monitor the IT department's operational capacity and identify processing backlogs over time.

SLA Compliance Breaks by Department / Category

💡 Hover over the bars to see breach root causes.

Loading charts...

This chart ranks SLA breaches by category, helping identify specific services that require infrastructure and connectivity improvements.

Active Incident Caseload by Support Agent

💡 Hover over columns to inspect individual queue priorities.

Loading charts...

This chart visualizes the active workload distribution across support agents, classified by ticket priority to ensure balanced resource allocation.

Average Customer Satisfaction (CSAT) by Agent

💡 Hover over the bars to see rated ticket volumes.

Loading charts...

This progress chart displays customer satisfaction scores relative to a perfect rating (5.0 / 100%). Visualizing scores as a percentage of the whole allows easy comparison of support quality benchmarks.

End of Workspace 01 • Scroll for Workspace 02
Workspace 02 Database • Statistics Canada Source

National Labor Force Disruption Database

This workspace visualizes macroeconomic trends extracted dynamically from **Statistics Canada Table 14-10-0126-01** (reasons for not working/unemployment). The database covers a 5-year statistical period (2021-2025) and registers why Canadians sit outside the active labor force. Use the controls below to inspect structural barriers, layoffs, or voluntary departures.

Macro Policy Control Filters

Filter Snapshot Year (REF_DATE)
Filter Demographic Age Tier
Disruption Pool (2025)

13,540,700

Total unemployed & out of labor force (persons)

Never Worked (2025)

2,598,900

Highest structural barrier to career entry

Permanent Layoffs (2025)

1,075,800

Active corporate staff reductions

Entry Barrier Growth

+27.6%

Never worked growth since 2021 baseline

Specified Disruption Composition

Composition breakdown of specified barriers for 2025

Loading chart...
Total Specified5,967,100
Never Worked
2,598,900(43.6%)
Job Leavers
1,126,600(18.9%)
Permanent Layoff
1,075,800(18.0%)
Retired
302,300(5.1%)
Other Reasons
863,500(14.5%)
Insight 01 • Structural Barriers

Workforce Entry Barrier Surge

Workforce Entry Barrier Surge: The population of Canadians who have never worked has surged steadily every year, from 2,036,200 in 2021 to 2,598,900 in 2025 (a +27.6% increase). This highlights a growing structural bottleneck for youth, graduates, and newcomers trying to enter the market.

Loading charts...
Insight 02 • Layoff Trend

Economic Cooling & Layoff Rebound

Economic Cooling & Layoff Rebound: Permanent corporate layoffs bottomed out in 2022 at 826,600 during the post-pandemic hiring boom, but have since climbed sequentially every year to 1,075,800 in 2025, approaching pandemic-era highs and signaling a cooling labor market.

Loading charts...
Insight 03 • Employee Confidence

Resignation Cycle Decline

Resignation Cycle Decline: Voluntary departures ("Job leavers") peaked between 2022 and 2024 (above 1.15M) during "The Great Resignation." However, in 2025, voluntary departures cooled to 1,126,600, indicating that workers are prioritizing job security as layoffs rise.

Loading charts...
Insight 04 • Labor Market Dynamics

Voluntary Departures vs. Involuntary Job Loss

Voluntary Departures vs. Involuntary Job Loss: This tracks employee quits ("Job leavers") against employer layoffs/furloughs ("Jobs losers"). In 2022, voluntary departures peaked at 1,127,800 (outpacing job losses of 879,300) due to high worker confidence. By 2025, voluntary quits cooled to 1,126,600 while involuntary job losses climbed to 1,114,900, indicating narrowing market confidence.

Loading charts...
Insight 05 • Demographics

Aging Demographics Drain

Aging Demographics Drain: Retiring workers exiting the active labor force grew by +34.3% since 2021, reaching 302,300 in 2025. This permanent drain of senior talent necessitates faster workforce integration channels for newcomers and graduates.

Loading charts...