US REAL ESTATE SALES RATIO ANALYSIS DASHBOARD

This dashboard reveals that the  market is largely driven by single-family homes, making them both the core growth engine and the main source of risk. Sales activity follows strong seasonal patterns, peaking in late summer and early fall. Undervaluation in property assessments, particularly for three-family homes, points to potential reassessment opportunities, while high-priced four-family properties represent a niche investment segment despite low sales volume. Regional differences remain pronounced, with premium towns like New Fairfield contrasting sharply against more affordable markets such as Hartford, creating room for targeted investment strategies. 

EXCELPRO CONSULT TRAINING PERFORMANCE DASHBOARD

The  dashboard reveals that the training program engaged 160 trainees and generating $1.95M in revenue. The IT department and the East region lead in training investments, reflecting strategic focus areas. Notably, 69% of participants benefited from discounts, driving higher enrollment. While overall satisfaction stands at 3.0/5, this presents an opportunity for continuous quality improvement. Participation spans across all education levels, underscoring the program’s inclusive reach and relevance across the workforce. 

Employee Demographic Analysis Summary

Developed a dynamic HR dashboard to visualize workforce composition, hiring trends, diversity metrics, and attrition patterns. Key insights include a mid-career-dominant workforce (avg. age 41), peak exits in 2021, balanced gender distribution, and engineering as the largest department.

Recommendations: Focus on succession planning for aging employees, strengthen retention programs, enhance diversity hiring, invest in early-career talent, and use data to predict attrition and guide workforce planning.

🚗 METROSAFE ACCIDENT ANALYSIS
Analyzed 144K+ accidents, 195K+ casualties, and 265K+ vehicles involved. Fridays emerge as the riskiest day, with single carriageways (120K+ cases) posing the highest danger. 65% of crashes occur in urban areas, while Sept–Oct peaks reflect festive travel and weather changes. Strikingly, 1 in 7 accidents is serious or fatal—underlining the urgent need for safer road designs, driver awareness, and faster emergency response.

FRAUD MONITORING ANALYSIS

⚠️ Imagine this: every 5th transaction is fraudulent. The Fraud Monitoring Dashboard (Tableau) revealed a 21.3% fraud rate worth $489K, with hotspots across POS, bank transfers, and ATMs. Fraudsters systematically target clothing, luxury, and travel merchants, while risk varies by customer group — from students on mobile to retirees in crypto. The insight is clear: fraud follows patterns, and detecting them early protects both money and trust. 

EXECUTIVE SALES ANALYSIS

💡 The Executive Sales Dashboard reveals more than just numbers — it shows where profit truly comes from. In-Store leads with $30.1M revenue, but Wholesale delivers the highest margin (30.3%) despite being the smallest channel. Seasonal surges drive in-store & online growth, while everyday products like platters and glassware outperform niche items. 👉 Revenue tells the story, but profit writes the ending.