-As the current pandemic is the center of focus worldwide, it seemed like a good opportunity to assess the economic impact of COVID-19. As both of us are different majors, Accounting/Business Information Systems, and Computer Science, we wanted to implement an idea that was a combination of both majors by utilizing aspects from CS to elaborate on financial standpoints for countries through the pandemic.
What it does
-Our Tableau dashboard provides a visualization of the economic impact of COVID-19 globally. We found it important to display another aspect of how the pandemic has significantly affected the globe in terms of the reduction in GDP as the number of cases and deaths had risen, in combination with the Human Development and Stringency Index. Tableau allowed to better visualize our chosen dataset by analyzing relationships between attributes into an understandable interactive graph that spanned over a period of 10 months in 2020.
How we built it
-Our dashboard was developed primarily using Tableau. First, we picked a data set from Kaggle which embodied one of our main inspirations, a combination of our majors. Upon picking the data set, we explored relationships between attributes and the best way to display them on a dashboard. The map was created first which included all the attributes that were intended such as the GDP, population, total cases, total deaths, as well as a correspondence to the month associated with those numbers and the location. Another important variable we added was the Stringency Index grouping. This grouping was done by creating a calculated field. In this calculated field we compiled an if, elseif, else statement where if the stringency index <30 then there were slight to no restrictions, <60 meant medium level restrictions, and more than that but <100 was high stringency which meant a lot of restrictions that were implemented by the country during that month period for lockdown. This was associated with the progression of months and rise in cases and deaths. Another calculated field was done for the double line graph for the Human Development Index where <0.5 was low human development, <0.8 was medium human development and more than that but less than 1 was high human development. Based off of the month progression, population, and total deaths, the line chart showed a trend change based off of the globe’s combination overall for high, medium, and low human development in regard to the pandemic. The GDP was a straightforward calculation by associating with the location and month progression. The progression of months was by using the Tableau feature of pages which allowed to see a trend across the months into a steady decline as the pandemic progressed and this was applied to all visualizations simultaneously.
Challenges we ran into
-"Challenges we ran into was trying to implement one feature was an action filter. We were trying to develop the dashboard where if we selected a country it would filter the other two visuals. We decided to avoid this as it would not work with the month progression with the pages feature.
Accomplishments that we're proud of
-We are proud of how our dashboard turned out overall. We were able to combine skills from both of our majors and it developed a dashboard that is valuable and useful to the public.
What we learned
-We learned more techniques involved with Tableau and how to better implement our dashboard.
What's next for Pednekar_Jagadesh Hackabull
-For the future, we intend to learn how to implement the action filter as a bonus. Along with this we may try to learn how to use Custom SQL through Tableau to develop queries in selecting the specified tuples in our data.