This repo contains the files that we made in Data fiesta 2021 conducted by Polestar Solutions.
We were one of the campus winners and one of the top 24 teams all over India.
- Modified Excel folder contains the files that we modified in order to get rid of redundant,null data.It contains 3 excel files.
Queries.sql contains the information about the files we merged and the corresponding SQL code that we wrote to merge.
- Python notebooks folder contains the work that we did initially to visualize the data using pandas and matplotlib modules in Python.
Links for the Python notebooks used :-
https://colab.research.google.com/drive/18LMhpR7s8LI368X9IeK9kH8McR_PC_w5?usp=sharing
https://colab.research.google.com/drive/18LMhpR7s8LI368X9IeK9kH8McR_PC_w5?usp=sharing
3.Tableau Dashboards folder contains all the dashboards that we made in Tableau in .pptx and Tableau workbook format
Link for the Tableau workbook used:- https://public.tableau.com/views/DataFiesta/Dashboard2?:language=en-US&:display_count=n&:origin=viz_share_link