Portfolio

Projects

Selected work spanning BI reporting, retail analytics, people analytics, and large-scale text analytics.

WellTrack Analytics

Power BIDAXSQL

A three-page Power BI dashboard analyzing employee wellness program enrollment, completion rates, and ROI. Built with custom DAX measures and SQL-driven data preparation.

• 24 custom DAX measures across a 3-page dashboard
• Program performance and ROI views for leadership decision-making
• Clean, interactive design built for non-technical stakeholders

GitHub Live Dashboard

Climate Tweet Analysis

Power BISQLData Analysis

Analyzed 15.7M+ tweets to understand sentiment evolution and political aggression in climate discourse, with SQL-driven data preparation powering a three-page Power BI dashboard.

• 15.7M+ tweets cleaned and explored for sentiment patterns
• 3-page Power BI dashboard tracking belief, aggressiveness, and topic trends
• 71.5% of climate-related tweets classified as "Believer" sentiment

GitHub Live Dashboard

Northwind Trader Executive Dashboard

Power BISQL

A centralized reporting system to monitor global sales performance, shipping efficiency, and salesforce productivity.

• Revenue growth: $0.21M to $0.62M in one year
• USA and Germany identified as highest revenue generators

GitHub Live Dashboard

Walmart Retail Analysis

ExcelPower BIDAX

A two-page retail analytics dashboard built in Excel analyzing Walmart sales, profit margins, customer segments, and shipping operations to surface revenue drivers and loss-making products.

• $14.9M revenue and $1.5M profit analyzed across 8,399 orders
• Identified 553 loss-selling products and quantified discount impact on profit
• Top customer spend, regional performance, and ship-mode profitability broken out

Live Dashboard

HR Employee Attrition Analysis

ExcelData Cleaning

Identified drivers of employee turnover and built retention strategy recommendations to reduce organizational cost.

• 16% overall attrition rate uncovered
• High correlation found between overtime and attrition
• Recommended hybrid/remote options to address work-life balance drivers

Live Dashboard