Portfolio
Representative projects that show dashboards, models, and analysis. Each case study includes the problem, the solution, tools used, and the impact.
Power BI Dashboards
FP&A Finance Dashboard
Interactive Power BI dashboard combining financial and operational metrics. Features executive KPIs, variance trends, and P&L insights.
Sales Performance Dashboard
Interactive Power BI dashboard tracking company-wide sales metrics, profitability trends, and customer insights across regions and product lines. Includes forecasting, margin analysis, and drill-through order details.
HR Analytics Dashboard
Power BI dashboard visualizing workforce composition, hiring activity, and retention trends. Includes interactive breakdowns by department, gender, and tenure to help HR teams optimize staffing and engagement strategies.
Excel Analytics Portfolio
These Excel-based analytics models demonstrate how structured data modeling and Power Query automation can turn raw business data into executive-ready insights. Each model — eCommerce ETL & Reporting, Marketing ROI Tracker, and SaaS Sales Performance Dashboard — follows a repeatable framework: Raw Data → Clean Data → Analysis → Dashboard. Together, they showcase advanced ETL workflows, automated KPI calculations, and professional dashboard design tailored to finance, marketing, and subscription-based businesses.
eCommerce ETL & Reporting
Excel model automating data cleaning and reporting for online retail performance. Built with Power Query, it consolidates order data to deliver accurate revenue, margin, and customer insights in a refreshable dashboard.
Marketing ROI Tracker
Excel dashboard designed to unify ad campaign data from multiple platforms into one clear ROI view. Calculates ROAS, CPA, and CTR automatically to identify top-performing campaigns and optimize spend.
SaaS Sales Performance Dashboard
Excel-based revenue dashboard built for subscription businesses. Tracks MRR, churn, and cohort retention with automated Power Query updates and executive-level visuals for quick growth analysis.
Ready to turn data into decisions?
If what you’ve seen aligns with your goals, let’s connect. Share a bit about your project and timelines, and I’ll follow up with a clear next step.