Back to home
All projects

Finance and analytics case studies

Five detailed case studies covering FP&A dashboards, CMA models, GST compliance analytics, startup MIS, and accounts receivable analysis.

Featured

FP&A and Business Performance Dashboard

Revenue, profitability, product, customer, regional, budget vs. actual, and cash flow analysis in a single Power BI solution. 25,000+ sales records, 24-month coverage.

Power BIDAXPower Query
Completed Open
Funding model

CMA Projection Model

Three-statement Excel model — projected Income Statement, Balance Sheet, and Cash Flow — with scenario testing for conservative vs. aggressive business assumptions. Supports lender credit review.

ExcelForecasting3-statement model
Planned Open
Compliance analytics

GST Analytics Dashboard

GST liability tracking, GSTR-1/3B/9 reconciliation, ITC utilization, and filing trend review. Mismatch detection across CGST, SGST, and IGST with exception alerts.

Power BIGST returnsReconciliation
In progress Open
Management reporting

Startup Finance MIS

B2B SaaS startup finance reporting system: revenue trends, customer concentration, AR aging, budget vs. actuals, working capital tracking, and cash runway analysis.

ExcelPivot tablesRisk indicators
Completed Open
Receivables analysis

Accounts Receivable Aging

Debtor ledger aging model grouping customer balances into 0–30, 31–60, 61–90, and 90+ day overdue buckets. DSO tracking, credit limit review, and collection risk concentration.

ExcelAging bucketsDSO
In progress Open