Skip to content

A collection of data analysis and business intelligence projects using SQL, Python, and visualization tools to uncover insights from real-world datasets. πŸš€πŸ“Š

Notifications You must be signed in to change notification settings

scarblase/PortfolioProjects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

15 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸš€ 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. πŸ’‘


πŸ” Project Highlights

πŸ“ˆ COVID-19 Data Analysis

  • 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

🏑 Nashville Housing Market Data Cleaning

  • 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

πŸ’° Billionaires Dataset Analysis

  • 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

🎬 Netflix Customer Database Exploration

  • 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

πŸ›’ Bike Store Sales Performance (Excel Dashboard)

  • 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

πŸ“‚ Repository Structure

πŸ“ 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.

πŸ›  Tools & Technologies Used

πŸ”Ή SQL (PostgreSQL, MySQL, SQL Server)
πŸ”Ή Python (Pandas, NumPy, Matplotlib, Seaborn)
πŸ”Ή Data Visualization (Tableau, Power BI, Excel)
πŸ”Ή Data Cleaning & Processing
πŸ”Ή Business Intelligence & Decision-Making


πŸ“Š Tableau Public Dashboards

Explore interactive visualizations on my Tableau Public Profile!


🀝 Let's Connect!

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! Π‘Π»Π°Π²Π° Π£ΠΊΡ€Π°Ρ—Π½Ρ–! πŸ‡ΊπŸ‡¦

About

A collection of data analysis and business intelligence projects using SQL, Python, and visualization tools to uncover insights from real-world datasets. πŸš€πŸ“Š

Topics

Resources

Stars

Watchers

Forks