Power BI Analytics Portfolio
Daniel S. Demoz
Data Visualization & Business Intelligence Professional
📊 Transportation & Aviation
Dominion Airlines: Passenger Traffic Report
Interactive chord diagram mapping bidirectional passenger flows across five major Canadian hub airports. Supports route optimization, capacity planning, and aircraft deployment decisions.
Airports Tracked
5 Hubs
Visualization
Chord Diagram
Use Case
Route Optimization
Network AnalysisPower BIData Modeling
💰 Finance & Strategic Performance
ABC Financial: Balanced Scorecard (Overview)
Executive dashboard tracking 12 KPIs across four strategic perspectives: Financial, Customer, Internal Process, and Learning & Growth. Real-time status monitoring for six departments.
KPIs Tracked
12 Total
Status Distribution
Traffic Light
Perspectives
4 Strategic
KPI TrackingDAXStrategy Map
💰 Finance & Strategic Performance
ABC Financial: Balanced Scorecard (Strategy Map)
Hierarchical view of strategic objectives linked to underlying KPIs. Shows how financial, customer, internal process, and learning initiatives align to drive organizational performance.
Performance
25% Green
At Risk
58% Yellow
Intervention
17% Red
Hierarchical DrillComplex Modeling
💰 Finance & Strategic Performance
ABC Financial: Balanced Scorecard (Trend Analysis)
12-month trend analysis showing KPI performance over time. Identifies seasonal patterns, growth trajectories, and early warning signs of underperformance requiring intervention.
Historical View
12 Months
Tracking
Monthly Cadence
Departments
6 Units
Time SeriesTrend Analysis
💰 Finance & Strategic Performance
ABC Financial: Department Performance
Cross-departmental analysis showing which units are performing on target vs. needing intervention. Enables accountability and drives data-backed resource allocation decisions.
View Type
Heat Map
Accountability
By Department
Comparison
Peer Benchmarking
Heat MapsDrill-down
💰 Finance & Strategic Performance
ABC Financial: Strategic Initiatives Tracking
Executive view of six cross-functional strategic initiatives with status, timeline, and impact on KPIs. Supports portfolio management and prioritization of organizational change efforts.
Initiatives
6 Active
Status Types
In Progress
View
Timeline
Project ManagementPortfolio Mgmt
🏗️ Construction & Project Management
Atlas Builders: Project Overview
Three-page dashboard tracking 48 tasks across seven project phases with real-time visibility into schedule and cost performance. Enables proactive risk management and stakeholder communication.
Completion
68.75%
Schedule Variance
-22 Days
Cost Variance
-$246K
Project TrackingVariance Analysis
🏗️ Construction & Project Management
Atlas Builders: Gantt Timeline
Visual project timeline showing planned vs. actual dates for each phase and task. Quickly identifies schedule slips and enables proactive course correction to minimize project delays.
Phases
7 Major
Tasks Tracked
48 Total
View
Gantt Chart
Gantt ChartsSchedule Mgmt
🏗️ Construction & Project Management
Atlas Builders: Cost & Risk Analysis
Detailed cost tracking by phase showing actual vs. budget with identification of top cost drivers and savings opportunities. Supports budget management and resource optimization decisions.
Cost Status
Under Budget
Top Overruns
3 Items
Risk Items
15 Open
Cost AnalysisRisk Mgmt
🛒 Retail & E-Commerce
Electrohub Sales Report: E-Commerce Performance
Comprehensive sales dashboard tracking revenue, product mix, channel performance (online vs. in-store), and regional trends. Supports pricing, inventory, and marketing investment decisions.
Total Revenue
$19.97M
Profit Margin
25.08%
AOV
$907.60
Sales AnalyticsChannel CompareProduct Mix
🏥 Healthcare & Patient Flow
Greenview Hospital: Admissions Overview
Multi-page healthcare operations dashboard tracking patient admissions, discharge patterns, and bed utilization. Supports capacity planning, staffing, and patient flow optimization.
Admissions
5,000+
Avg LOS
3.68 Days
Emergency %
63.54%
Healthcare AnalyticsPatient Flow
🏥 Healthcare & Patient Flow
Greenview Hospital: Department Analysis
Department-level breakdown of admissions and length of stay. Identifies high-volume units (Emergency at 1,183 admissions) and enables resource allocation based on demand.
Departments
11 Units
Highest Volume
Emergency
Highest LOS
ICU (6.94d)
Department MetricsDrill-Down
🏥 Healthcare & Patient Flow
Greenview Hospital: Diagnosis Analysis
Clinical diagnosis patterns showing top admission categories and associated length of stay. Supports quality improvement initiatives for high-volume diagnoses.
Diagnoses Tracked
12+ Categories
Highest LOS
Sepsis (7.51d)
Cross-Tab View
Department x Diagnosis
Clinical AnalyticsCross-Tab Tables
🏥 Healthcare & Patient Flow
Greenview Hospital: Discharge Planning
Patient discharge destination breakdown showing home discharges (71.94%) vs. post-acute care placements. Critical for discharge planning and bed availability management.
Home
71.94%
Post-Acute Care
29.06%
Unique Patients
1,000+
Discharge PlanningCare Coordination
🏭 Manufacturing & Quality Control
Machine Tooling: Rod Diameter Variance Analysis
Quality control dashboard using box-whisker plots to monitor CNC machine performance. Identifies CNC_D requiring maintenance through statistical variance detection.
Machines Monitored
4 CNC Units
Mean Diameter
50.00mm
Std Dev
0.15mm
Statistical AnalysisQuality ControlSPC
🚌 Transportation & Public Services
Municipal Transit: Ridership Forecast
Time series forecasting for transit ridership with 7-year historical context and 12-month forward prediction. Supports budgeting, staffing, and capacity planning decisions.
Historical Data
2018-2025
Forecast Period
12 Months
Key Event
COVID Impact
Time SeriesForecastingSeasonal Analysis
💪 Wellness & Fitness
Pro Fit Gym: Member Engagement & Retention
Member engagement dashboard tracking retention rate, class attendance, check-in frequency, and demographic distribution. Supports retention campaigns and class scheduling optimization.
Active Members
695
Retention Rate
86.88%
Avg Check-ins
7.50 per member
Member AnalyticsRetentionEngagement
1 of 0