My Projects

Marketing Performance Dashboard (Power BI) [View Project]

This dashboard provides a comprehensive view of marketing performance across channels, campaigns, audiences, and locations. It was designed to help stakeholders quickly understand what’s driving engagement, conversions, and return on investment (ROI).

The analysis covers key KPIs such as Impressions, Clicks, ROI, Conversion Rate, CTR, and Acquisition Cost, with month-on-month (MoM) comparisons to track performance trends over time. A dedicated ROI trend visual highlights how returns evolve across months, enabling easy identification of peaks and dips.

To support deeper insights, the dashboard breaks down performance by:

• Channel used (Email, Search, Social Media, Ads, Website, etc.)
  
  

• Campaign type (Search, Influencer, Display, Email)
  
  

• Target audience segments by age and gender
  
  

• Geographic locations, comparing ROI against conversion rates
  
  

The layout was intentionally wireframed to prioritize clarity, reduce clutter, and guide users through insights logically from high-level KPIs to detailed breakdowns. Interactive visuals allow users to explore performance drivers and make data-backed marketing decisions with confidence.

Tools & Skills Used:
Power BI, Power query (data cleaning), Data modeling & relationships, DAX measures, KPI design, Dashboard wireframing, Data visualization & storytelling.

Medical CRM Performance [View Project]

I developed an interactive dashboard in Power BI to help healthcare administrators track revenue, patient trends, and doctor performance. Using Power Query for data cleaning and transformation, and DAX measures for KPIs, the dashboard provides a clear view of operational and patient metrics.

Some Key Highlights:

• Revenue: +7.7% month-over-month

• Patient Trends: New patients up 5%, seasonal fluctuations observed

• Doctor Performance: Top performers identified; support opportunities for low performers
  
  

Recommendations: Reduce no-shows, improve follow-ups, enhance patient satisfaction, support low-performing doctors, optimize marketing for underutilized services, and investigate mid-year performance dips.

Tools & Skills Used:
Power BI, Power query (data cleaning), Data modeling & relationships, DAX measures, KPI design, Dashboard wireframing, Data visualization & storytelling.

Coca Cola 2022 Business Performance Report [View Project]

This analysis explores Coca-Cola’s $8.2 million in total sales and $3.04 million in earnings for 2022, focusing on brand performance, regional profitability, and retailer impact. Top-performing beverage brands, including Coca-Cola, Dasani, and Diet Coke, contributed over 60% of total units sold. Retailers like Walmart and CVS accounted for more than 75% of overall sales, while regional insights revealed the West as the most profitable market with $790K in profit. Monthly trends identified December as the peak sales period, guiding seasonal strategy and distribution planning.

Some Recommendations

1. Optimize Delivery Times

• Average delivery time of 37 days is too high evaluate logistics and shipping partners for efficiency improvements.

2. Leverage High-Performing Retailers

• Expand partnerships with Walmart and CVS to push more volume and promotions.

• Reassess strategies for Target, which shows low contribution ($404K).

3. Focus on High-Margin Products

• Promote Coca-Cola, Dasani, and Smart Water, which combine strong sales with high margins.

• Consider phasing out or repositioning underperforming brands.

Tools & Skills:

Microsoft excel, Pivot tables, Advanced excel formulas, Data cleaning, KPI analysis, Interactive dashboards, Data visualization & business reporting. 

Project & Task Management Dashboard [View Project]

This is an Excel-based, two-page interactive dashboard built with Pivot Tables and advanced visualizations to monitor performance across 300 projects and 300 tasks. The dashboard enables managers to track key KPIs, budgets, timelines, and task progress with staff-level filtering.

Key insights show $1.7M allocated with 31% utilized, 78 projects completed, 87 behind schedule, and 29% task completion, highlighting budget underutilization and execution delays. The dashboard provides a clear view of project health, resource usage, and areas requiring optimization to support better decision-making.

Tools & Skills:

Microsoft excel, Pivot tables, Advanced excel formulas, Data cleaning, KPI analysis, Interactive dashboards, Data visualization & business reporting.