Data Science Portfolio

under construction

As I move into data analytics and data science, I’ll update this page with projects that are developing my skills.

I’m currently following @AlextheAnalyst’s Data Analyst Bootcamp:

Project in Excel: What affects bike sales?
- Data Cleaning
- Formulas
- Pivot Tables and Charts
- Building a Dashboard

Projects in SQL:
- Data Exploration - Covid Dataset
  - Likelihood of death if covid is contracted
  - What percentage of the population has covid
  - Countries with highest infection rates
  - Breakdown across continents
  - Population v vaccinations
- Data Cleaning - Nashville Housing Dataset
  - Populating NULL with information already in the dataset
  - Splitting addresses into address, city and state (SUBSTRING and PARSENAME)
  - Changing strings to characters (CASE)
  - Removing duplicates (CTEs)
  - Deleting unused columns (DROP COLUMN)

Other Courses:

CareerFoundary’s Learn Tableau in under 45 mins! Find my dashboard from the session here.