Excel KPI Reporting & Dashboards
Publicada el 2026-07-30
Descripción de la oferta
I need a detail-oriented analyst who can own the entire reporting cycle in Excel. On a daily basis you will compile the Discount Report and Discharge TAT figures; each month you will close out revenue numbers and roll them up into both monthly and annual views, then translate those results into clear KPI tables tracking Sales growth and Net profit margin. Beyond the raw numbers, I also want polished outputs: dynamic dashboards that refresh automatically and a management slide deck that combines charts and graphs, a concise summary of findings, and actionable recommendations we can take to the leadership team. Key deliverables • Automated daily Discount & TAT worksheets • Consolidated monthly and annual revenue workbooks • KPI dashboard in Excel (pivot tables, slicers, charts) covering Sales growth, Customer retention rate, Net profit margin • PowerPoint (or Excel-embedded) presentation with visuals, insights, and next-step suggestions Everything must be built in Excel using best-practice formulas, PivotTables, and, where useful, Power Query or light VBA for refresh automation. Clean structure, clear labelling, and error-free calculations are critical; I will test by reconciling figures against our raw data and reviewing that each chart updates correctly when source data changes.
Skills
Fuente original: freelancer