Google Sheets KPI Dashboard Build

Заказчик: AI | Опубликовано: 15.01.2026

I need an advanced Google Sheets file that pulls fresh data from periodic CSV uploads, recalculates everything automatically, and presents the key numbers in an intuitive way. Scope of work • Structure a single workbook (or logically linked set) so raw CSV data can be dropped in, recognised, and fed through to every dependent sheet without manual copy-paste. • Build interactive bar-chart visuals and a one-page KPI dashboard highlighting sales performance at a glance. • Add fully integrated budgeting, forecasting, financial-reporting, and basic investment-analysis tabs—all updating the moment new data is ingested. • Provide a short recorded walkthrough or live call plus concise documentation so I can understand the layout, formulas, and any Apps Script used, and confidently adjust things later. Acceptance criteria • Drop-in CSV upload triggers end-to-end refresh with no broken references. • Dashboard renders inside 5 seconds on current-year data set (~20 k rows). • All calculations remain within Google Sheets (Apps Script is fine; no third-party add-ons). • File is share-ready: no hard-coded personal paths or credentials. If this sounds straightforward to you, let’s get started.