April, 2023
The Case
You’ve been tasked with creating a business intelligence visualization to help the Minnesota Department of Transportation improve highway infrastructure. You had a video call with your stakeholder and received an email with details of their needs.
The most important charts you need to make should represent the following needs:
Traffic volume throughout the year; ideally organized by year, month, week, day, and hour
Traffic volume in various weather conditions
Traffic volume on different holidays
Tools used:
MS Excel
Tableau
Google Spreadsheets
January, 2021 (refurbished - February, 2023)
BCP Clearance Stats for a roughly 4-years period of live monitoring of trucks movement at Border Crossing Point X between country Y and country Z. The data had been collected and entered manually on a daily basis. The geographical names are skipped intentionally and in terms of non-disclosure of source providers.
This is a personal monitoring experiment from the very first scratch that allowed years of data not only become available, but also showing services daily work and the load they faced within their work complex. The process of collection manually and going through service recorders revealed a lot of mistakes due to simple human nature errors caused by tiredness, lack of technical skills, motivation among other factors. And this is a lesson learnt, not a criticism or blame.
Tools used:
MS Excel
Tableau
Tools used:
MS Excel (row data collection)
Tableau (visualization combos)
Google Slides (outcomes presentation)
The visualization report is located here (Tableau Public platform).
February, 2023
One day, I decided to put on my wish-list running a 1000 km without clear finish date. I love running. And I used to run before that moment actually, maybe even around a 1000 km in total, maybe more... But that was a distinct goal set back in 2020. So, little by little I was collecting kilometers and runs...
Initially, I made a Spreadsheets file and linked it to direct set of dashboards in Tableau.
This is another personal monitoring experiment aimed at creation of interactive visualisations and updated automatically as the source files gets populated with the latest running records. The set demonstrates yearly achievements by distance, runs, countries, and sneakers I've enjoyed during the experiment. So far, closer to the endpoint of the multi-year effort I'd say I've learnt I'm getting older by the indicators comparison inside the file...:) Another lesson learnt - efforts require discipline in both - running and monitoring activities.
Still in love with running and data analysis, especially in the part of visualisation.
In Tableau, I plan to create another type of dashboards depicting activities calendar-wise, like what's the best day, what's the best month, playing with various ingredients' combinations.
Tools used:
Samsung Health (personal measurements of running activities)
Google Spreadsheets
Google Looker
Tools used:
Power of Will
Samsung Health (personal measurements of running activities)
Google Spreadsheets
Google Looker
Here is a screenshot of a dashboard, so to get the understanding of what it does
April, 2021 - February, 2023
One day, I decided to put on my wish-list running a 1000 km without clear finish date. I love running. And I used to run before that moment actually, maybe even around a 1000 km in total, maybe more... But that was a distinct goal set back in 2020. So, little by little I was collecting kilometers and runs...
Initially, I made a Spreadsheets file and linked it to direct set of dashboards in Tableau.
This is another personal monitoring experiment aimed at creation of interactive visualisations and updated automatically as the source files gets populated with the latest running records. The set demonstrates historic achievements and patterns by distance, runs, countries, and sneakers I've enjoyed during the experiment. So far, closer to the endpoint of the multi-year effort I'd say I've learnt I'm getting older by the indicators comparison inside the file...:) Another lesson learnt - efforts require discipline in both - running and monitoring activities.
Still in love with running and data analysis, especially in the part of visualisation.
In Tableau, it was planned to create another type of dashboards depicting activities calendar-wise, like what's the best day, what's the best month, playing with various ingredients' combinations. No complex calculations, but a data story made.
Tools used:
Samsung Health (personal measurements of running activities)
Google Spreadsheets
Google Tableau