π Data Analytics & Business Intelligence Portfolio π
Welcome to my PortfolioProjects repository! This collection showcases my expertise in SQL, Python, and data visualization through hands-on projects that analyze real-world datasets. From data cleaning to exploratory data analysis (EDA) and business insights, these projects reflect practical applications of data-driven decision-making. π‘
- Tools: SQL, Excel, Tableau
- Goal: Analyze COVID-19 trends in cases, deaths, and vaccinations.
- Key Insights:
- Identified global trends in infection and vaccination rates.
- Analyzed country-wise impact using SQL queries and Tableau visualizations.
- Files:
Covid Portfolio Project.sql,CovidDeaths.xlsx,CovidVaccinations.xlsx
- Tools: SQL
- Goal: Prepare messy real estate data for analysis.
- Key Steps:
- Standardized date formats and address fields.
- Removed duplicates and handled missing data.
- File:
NashvilleHousingPP(Data Cleaning).sql
- Tools: Python (Pandas, Matplotlib, Seaborn)
- Goal: Examine wealth distribution and industry dominance.
- Key Insights:
- Tech industry dominates billionaire wealth.
- Identified top wealth-generating countries.
- File:
Billioners Dataset.xlsx
- Tools: Python (Pandas, Seaborn)
- Goal: Understand customer viewing habits and trends.
- Key Findings:
- Analyzed genre preferences and subscription patterns.
- Explored customer retention rates.
- File:
Netflix Customer Database Exploration.ipynb
- Tools: Excel (Pivot Tables, Charts)
- Goal: Build an interactive sales performance dashboard.
- Key Insights:
- Identified best-selling products and peak sales periods.
- Analyzed regional sales trends.
- File:
Excel Project Bike Store.xlsx
π PortfolioProjects
βββ π README.md # You're reading it! Repository overview.
βββ π Data Cleaning in Pandas.ipynb # Python-based data cleaning.
βββ π EDA in pandas.ipynb # Exploratory Data Analysis.
βββ π Groupby And Aggregate Functions.ipynb # Advanced Pandas functions.
βββ π Merge, Join, Concatenate.ipynb # Data merging techniques.
βββ π Visualizations in Pandas.ipynb # Data visualization techniques.
βββ π NashvilleHousingPP(Data Cleaning).sql # SQL-based data cleaning.
βββ π Covid Portfolio Project.sql # COVID-19 SQL analysis.
βββ ποΈ Dataset Files (Excel, JSON, CSV) # Source data for analysis.
πΉ SQL (PostgreSQL, MySQL, SQL Server)
πΉ Python (Pandas, NumPy, Matplotlib, Seaborn)
πΉ Data Visualization (Tableau, Power BI, Excel)
πΉ Data Cleaning & Processing
πΉ Business Intelligence & Decision-Making
Explore interactive visualizations on my Tableau Public Profile!
If you're passionate about data analytics, business intelligence, or data-driven decision-making, let's collaborate! Feel free to explore, fork, or contribute to this repository. π
π§ Email: tmhomenko@gmail.com
π LinkedIn: Connect with me
πΊπ¦ Glory to Ukraine! Π‘Π»Π°Π²Π° Π£ΠΊΡΠ°ΡΠ½Ρ! πΊπ¦