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!