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

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 

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

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