/CovidAnalysis

Analyzing KPIs in Covid-19 cases using SQL, Python and Tableau

Primary LanguageJupyter Notebook

💊 Covid Data Analysis

The goal here is analyzing some KPIs in Covid-19 datasets using a variety of tools, this SQL code was compiled with MySQL client for vscode.

1. SQL

Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types

2. Pandas and Plotly

Cleaning datasets using pandas data frame and DB2 connection, Plots for quick analysis

3. TensorFlow

Model for time series exploration

4. Tableau

Visualization, please review the results un my tableau public

References

  1. The dataset used in this project can be found on Our World in Data

  2. Alex The Analyst Projects