WIZE Academy Franchise Data Storage and Visualization

Built for a client collecting ongoing franchise survey data in Google Sheets, this project automates the path from raw spreadsheet to live dashboard. A Google Apps Script, scheduled to run daily, pulls the current sheet as a CSV and loads it into BigQuery; from there, a cleaning query standardizes data types into a second table, and a final aggregated view is built on top for reporting. That view feeds a Looker Studio dashboard that updates automatically as new data comes in.

Beyond the working pipeline, I documented a maintenance procedure for the client’s team to handle schema changes without breaking the pipeline.

Timeline: Requirements & tool research (3 days) → design of the storage/processing pipeline (2 days) → implementation, testing, and dashboard build-out (2 weeks).

Stack: Google Apps Script, BigQuery, SQL, Looker Studio