Today is the last day of Dashboard week.  The last 4 days have been maniac. Today we were given the brief at 10.30 am and was asked to present it at 3 pm and the most important point was we were not allowed to use Alteryx for data prep. The data we were given is  Air Pollutant Data from specially for Covid.

The data had Air pollutant information for years from 2015 to 2020. But some years had only partial data. Therefore, I went ahead with 2019 and 2020 because those 2 were the years which had full year information.

Data Prep

There was not much to prep for this data, I had to use Tableau Prep since we were not able to use Alteryx. All what I had to was to remove nulls and union all the years.

Data Visualization

Today I decided to focus on Pollution in Australia. I was interested in finding the air pollution pattern pre and during Covid in Australia. I also wanted to check the hazard level and whether there is any relationship with temperature.


I would have like to enrich this data with bush fire and covid hot spot data to find meaningful insights, but due to time constraints I was  not able to achieve this.

Overall this week has been a very intense but a great week of challenges!

Harsha Kunchu
Author: Harsha Kunchu