In this work, a detailed analysis of vacation spending was conducted, with calculations of correlation, deviations from the plan, and other statistical parameters.
The tools used were: Google Sheets, Collaboratory, Python, Pandas. A dashboard was created in Google Data Studio.
Initially, the data were entered into tables through an interactive Google form, and then all the required formulas were calculated on them, and then all this data was sent to the GDS dashboard.
An interactive dashboard with all key metrics and sorts has been developed within the GDS environment. Then statistical dependencies were analyzed. Then several graphs and charts were built, including a distribution chart of the deviation of actual costs from the plan. Finally, the remaining calculations and combinations were done in Python.
Links
- Google Forms: https://forms.gle/
- Google Sheets: https://docs.google.com/spreadsheets/
- Data Studio: https://datastudio.google.com/
- Collaboratory: https://colab.research.google.com/
