March 2020 Summaries

In the wake of the COVID-19 pandemic, a data-driven individual decided to create a personal dashboard using the Johns Hopkins CSSE data repository to track the virus's spread. Utilizing the Vertica Analytics Database for its advanced analytics and time series capabilities, the process involved setting up a table to load data, cloning the GitHub repository for updates, and creating views to process the data for daily reports and geo-spatial information. The dashboard, accessible through Apache Superset, features various visualizations such as trendlines, heatmaps, horizon charts, and scatterplot maps, which help in assessing the safety of travel destinations by monitoring COVID-19 cases globally. The system maintains current data through a simple cron job, enabling informed decision-making during the pandemic.