One home for data on Databricks
Data was scattered across SQL Server and Google Sheets, and every chart and dashboard lived in a spreadsheet. I brought in Databricks, scheduled pipelines from SQL Server, Google Sheets and Shopify, and rebuilt the reports there. I checked the numbers against the old sheets before retiring them, so people could trust what they saw.
How it works
Tap a step for the details.
Data in SQL Server and Google Sheets, with charts and dashboards living in Sheets.
Pipelines pull from SQL Server, Google Sheets and Shopify on a schedule.
Reports and dashboards rebuilt in Databricks.
New numbers checked against the old sheets before switching.
Old charts, dashboards and tables switched off once everything matched.