Analytics Repository

Portfolio Projects & Case Studies

Deep-dive case studies spanning Business Intelligence dashboards, statistical SQL queries, and financial models.

Portfolio Highlights Carousel

Spotlight on flagship business intelligence and analytics projects.

COVID-19 Global Tracker
Power BI Public Health

COVID-19 Global Pandemic Tracker

Real-time epidemiological monitoring dashboard detailing global infection trajectories, mortality rates, and vaccination rollouts across 190+ nations.

Superstore Sales Dashboard
Excel Retail

Superstore Sales & Profitability Analysis

Advanced Excel dashboard tracking regional profit margins, shipping mode efficiency, and category sales performance.

Patient Care & Hospital Operations
Power BI Healthcare

Patient Care & Hospital Operations

Clinical operations visualizer modeling ER wait times, bed occupancy velocity, and patient length of stay optimization.

Loan Portfolio Risk Analysis
Tableau Finance & Risk

Loan Portfolio Risk & Yield Analysis

Tableau financial risk model examining credit score brackets, default probabilities, and loan interest margins.

Fact Sales Inventory SQL Analysis
SQL Supply Chain

Fact Sales Inventory SQL Relational Model

Production SQL queries calculating inventory turnover ratios, safety stock levels, and automated reorder alerts.

0+
Total Projects
0+
Excel Models
0+
Power BI Dashboards
0+
SQL Repositories
0+
Tableau Models
0+
Total Dashboards

Analytical Tool Portals

Select a technology domain to explore dedicated project repositories.

Excel Projects

5 Interactive Models
Explore Portal →

Power BI Projects

7 Production Dashboards
Explore Portal →

SQL Solutions

3 Relational Queries
Explore Portal →

Tableau Analytics

1 Risk Visualization
Explore Portal →

Master Project Grid

Search or filter instantly by project title, technology, or industry domain.

Superstore Dashboard

Superstore Sales Dashboard

Excel dashboard tracking regional profitability, shipping mode performance, and product category trends.

Excel Retail
HR Dashboard

HR Analytics Dashboard

Comprehensive HR dashboard tracking employee metrics, attrition, and performance indicators.

Excel HR
Sales Performance

Sales Performance Tracker

Excel tool monitoring sales quota attainment, growth trajectories, and regional revenue opportunity.

Excel Retail
Agent Performance Analytics

Call Center Agent Analytics

Performance dashboard analyzing customer service calls, resolution rates, and agent efficiency metrics.

Excel Operations
Customer Demographics & Segmentation

Customer Segmentation & Insights

Excel dashboard showcasing customer cohort breakdown, retention metrics, and churn behavior.

Excel Retail
Covid 19 Dashboard

COVID-19 Global Tracker

Power BI dashboard providing real-time insights and visualizations of COVID-19 pandemic trends globally.

Power BI Public Health
Healthcare Analytics Suite

Healthcare Performance & Clinical Suite

Unified 3-view Power BI suite: View 1: Healthcare Performance, View 2: Clinical Outcome, and View 3: Executive Overview.

Power BI Healthcare 3 Views
Financial Analytics Suite

Finance Job Market & Recruitment Suite

Enterprise 3-view Power BI dashboard: View 1: Finance Job Market Analysis, View 2: Salary and Skills, and View 3: Recruitment Performance.

Power BI Finance 3 Views
US Consumer Shopping Trends

US Consumer Shopping Trends

Interactive dashboard analyzing consumer purchasing habits, spending patterns, and product preferences across US demographics.

Power BI Retail
Monkeypox Epidemiological Analysis

Monkeypox Epidemiological Analysis

Public health reporting tool visualizing outbreak spread, demographic impact, and regional incidence trends.

Power BI Public Health
Loan Portfolio Analysis

Loan Portfolio Risk Analysis

Tableau visualization analyzing loan distributions, default rates, and credit risk factors.

Tableau Finance & Risk

Fact Sales Inventory SQL Analysis

Complex SQL queries designed to analyze sales inventory patterns and optimize stock levels.

SQL Supply Chain

HR Employee Attrition SQL Analysis

SQL relational analysis focusing on HR dataset to determine key drivers for employee turnover.

SQL HR

University Academic Performance Analysis

SQL relational queries investigating student CGPA, department graduation rates, carry-overs, and risk factors.

SQL Education