Portfolio Project 1 - SQL Data Exploration:
- https://github.com/ericmeyer1/PortfolioProjects-SQL-Tableau-Python/blob/main/Portfolio%201%20-%20SQL%20Data%20Exploration.sql
- Using SQL queries to organize global COVID-19 data
- Using SQL queries to explore and analyze global COVID-19 data (death and case #s / rates as well as vaccination #s / rates)
- Creating views in order to later summarize global COVID-19 data with visualization dashboards in Tableau
Portfolio Project 2 - Data Visualization in Tableau:
- https://public.tableau.com/app/profile/eric.meyer7874/viz/Covid-19DashboardProject_16416741339100/Dashboard1
- Used data queried and organized in SQL in my first portfolio project to create multiple worksheets and a final interactive dashboard in Tableau on Covid-19 global statistics from February 2019 through February 2021
Portfolio Project 3 - Data Cleaning in SQL:
- https://github.com/ericmeyer1/PortfolioProjects-SQL-Tableau-Python/blob/main/Portfolio%202%20-%20Data%20Cleaning%20in%20SQL.sql
- Using various SQL queries / statements (CONVERT, ALTER TABLE, UPDATE, JOIN, SUBSTRING, PARSENAME, REPLACE, CASE, CTEs, etc.), I cleaned a Nashville Housing dataset to sharpen my overall data cleaning skills
Portfolio Project 4 - Airbnb Research / Dashboard in Tableau:
- https://public.tableau.com/app/profile/eric.meyer7874/viz/AirBnBFullProject_16416533584710/Dashboard1
- Utilized Airbnb listing data from 2016 in Seattle, Washington to give a theoretical customer insights on how and where to approach starting their first Airbnb listing
- Results showed what type (# bedrooms) of listing to start with, the best locations in Seattle to list at, correct pricing for the listing, and times of the year when revenue is the highest (must list times)
Portfolio Project 5 - Sales Summary Dashboard in Tableau:
- https://public.tableau.com/app/profile/eric.meyer7874/viz/SalesSummaryDashboard_16432256923300/Dashboard1
- While achieving my Tableau Essential Training certification on LinkedIn Learning, I took the opportunity to use the provided theoretical sales data to create a sales summary dashboard. Filter by job position capabilities included.
Portfolio Project 6 - HR KPI Dashboard in Tableau:
- https://public.tableau.com/app/profile/eric.meyer7874/viz/HRKPIDashboard_16433256682450/HRKPIDashboard
- Utilized Kaggle dataset, IBM HR Analytics Employee Attrition & Performance, to gain better understanding of how to harness HR data to create informative KPIs and an overall dashboard to summarize attrition metrics.
Portfolio Project 7 - Data Exploration in SQL & Visualization in Tableau:
- https://github.com/ericmeyer1/PortfolioProjects-SQL-Tableau-Python/blob/main/Portfolio%207%20-%20%20EDA%20in%20SQL.sql
- In Part 1 of this portfolio project, I used Microsoft SQL Server to quickly explore the Kaggle dataset, Global Superstore, and gain a better picture of what is contained in the dataset. The goal was to see how it can be used to create an overview of sales by category, market, and country as well as to analyze sales vs profit. This overview was then created in Tableau (currently still a work-in-progress). Dashboard is shown below.
- https://public.tableau.com/app/profile/eric.meyer7874/viz/GlobalSuperstoreSalesDashboardWIP/Dashboard1
Portfolio Project 7 - Amazon Web Scraping Using Python (Coming Soon)
Portfolio Project 8 - Correlation in Python (Coming Soon)