A very important thing we do in ELSA is following user trends and patterns, so that we can quickly adapt our product to changes and new arising opportunities.
Create a dashboard with meaningful insights for the given data, followed by an explanatory report.
-
Download the data csv from here
-
Clean and prepare the data in Python (can be a simple script or notebook)
-
Choose the most relevant metrics and insights
-
Create the dashboard, in a technology of your choice (Tableau, Google Data Studio, etc), presenting the chosen metrics
-
Write a small report detailing any findings you deem important
The data is provided in a csv file and contains the population count for different countries and cities over some years. Data columns are self explanatory.
- The cleaning and preparation Python code/script
- Dashboard link/access
- Simple report of the challenge solution and results obtained
- Any other relevant information you deem important
Python cleaning script is available in the notebook: Exploratory Data Analysis and Cleaning.ipynb Populations_data_exploratory_profile.html is a on exploratory profile of the whole dataset before cleaning. Interactive report is available here.