Finance — Data Engineering & Analytics

A focused collection of Excel-based work: KPI analysis, modeling, and accounting statements. Download the sample workbooks or preview via web viewers.

Featured Excel Projects

ExcelKPIPivot

Sales Performance & KPI Dashboard (Excel)

Workbook: sales_kpi.xlsx · Skills: PivotTables, Slicers, Power Query, XLOOKUP

Built a refreshable KPI dashboard from raw transactions (Power Query → model), with region/product pivots, MoM growth, top-N analysis, and dynamic slicers. Includes clean data model, measures, and an executive summary sheet.

⬇️ Download 👁️ Preview

ExcelAccountingModel

Accounting Model — P&L, Balance Sheet & Cash Flow (Excel)

Workbook: accounting_model.xlsx · Skills: Structured refs, Named ranges, Data Validation

Clean small-business model with inputs (revenue drivers, COGS, OpEx) feeding linked statements (P&L, BS, CF) and a 12-month cash runway view. Built-in checks and scenario toggles for sensitivity.

⬇️ Download 👁️ Preview

What this demonstrates

End-to-end Excel workflow: data cleaning (Power Query), modeling, and executive dashboards
Accounting structure linking P&L → Balance Sheet → Cash Flow with QA checks
Reusable templates with named ranges, validation, and documentation sheet