DataAnalyst_PortfolioProjects

Project-1: SQL Data Exploration

Obtain Covid-19 dataset. Original data source is here.
Prepare dataset using Excel.
Import dataset into SQLServer.
Create queries to explore dataset. Link to Queries!

Project-2: Tableau Visualization

Getting processed Covid-19 data back from SQLServer. Link to Queries!
Importing data into Tableau Public.
Building our Visualizations.
Building our Dashboard.
Link to Dashboard!

Project-3: Data Cleaning in SQL

Obtain Nashville Housing dataset.
Import dataset into SQLServer.
Converting to Date format, populating NULL values, splitting data, modifying data, removing duplicates and deleting unused columns.
Link to Queries!

Project-4: Analyzing Correlations in Movie Dataset using Python Pandas Library

Obtain movie datset from Kaggle. Data source is from here.
Read data as dataframe using Python Pandas.
Prepare and clean data by: looking for missing data, converting data types, sorting and by dropping duplicates if necessary.
Formulate hypotheses on correlations between variables.
Analyze data by creating plots and correlation matrices using matplotlib and seaborn.
Link to Python script!