Excel Visualizations & Web Development
Budget: ₹600 – ₹1,500 INR
My project combines two main threads:
1) Data analysis – I’ll hand over raw tables that need cleaning, statistical exploration and, most importantly, clear visual stories built directly in Excel (think pivot-charts, slicers, interactive dashboards). The outcome I expect is a workbook that a non-technical manager can open and instantly grasp the insights, with the statistical work documented in a separate sheet.
2) Web development – the same dataset will power a small, responsive web page. Using HTML, JavaScript and a Python back-end that pulls from an SQL database, I want users to query key metrics online and see results in real time. A simple REST API is fine; no heavy framework necessary.
Deliverables (acceptance criteria)
• Cleaned .csv or SQL tables plus the transformation script/notebook
• Excel file containing:
– dynamic charts & slicers matching the KPIs we agree on
– a sheet that shows the statistical tests/run-rate calculations behind each visual
• Source code for the web front end (HTML/JS/CSS) and Python API
• README with setup steps so I can reproduce everything locally
If the workflow you propose keeps Excel as the main visualization layer while still letting the site call the same calculations, we’re in sync. Flexibility to swap in Power BI or matplotlib later is a bonus, but Excel visuals are the priority for this milestone.
1) Data analysis – I’ll hand over raw tables that need cleaning, statistical exploration and, most importantly, clear visual stories built directly in Excel (think pivot-charts, slicers, interactive dashboards). The outcome I expect is a workbook that a non-technical manager can open and instantly grasp the insights, with the statistical work documented in a separate sheet.
2) Web development – the same dataset will power a small, responsive web page. Using HTML, JavaScript and a Python back-end that pulls from an SQL database, I want users to query key metrics online and see results in real time. A simple REST API is fine; no heavy framework necessary.
Deliverables (acceptance criteria)
• Cleaned .csv or SQL tables plus the transformation script/notebook
• Excel file containing:
– dynamic charts & slicers matching the KPIs we agree on
– a sheet that shows the statistical tests/run-rate calculations behind each visual
• Source code for the web front end (HTML/JS/CSS) and Python API
• README with setup steps so I can reproduce everything locally
If the workflow you propose keeps Excel as the main visualization layer while still letting the site call the same calculations, we’re in sync. Flexibility to swap in Power BI or matplotlib later is a bonus, but Excel visuals are the priority for this milestone.