Skip to content

Pritam9952/Major_data_analysis_projects

Repository files navigation

📊 End-to-End Data Analysis Portfolio

Data Analytics Maintained

Welcome to my master repository. This collection showcases my ability to transform raw, complex data into actionable business insights using SQL, Power BI, Python, and Excel.


🛠️ Tech Stack & Tools

Category Tools
Languages Python (Pandas, NumPy, Scikit-learn), SQL (MySQL, PostgreSQL)
Visualization Power BI, Tableau, Matplotlib, Seaborn
Data Handling Excel (VLOOKUP, Pivot Tables, Power Query), ETL Processes
Soft Skills Statistical Modeling, Customer Segmentation, Business Strategy

🚀 Featured Projects

  • Goal: Analyze subscriber behavior to identify churn drivers.
  • Insight: Identified specific content genres that increased long-term retention by 15%.
  • Goal: Evaluate sales performance across regions and product categories.
  • Insight: Uncovered seasonal trends that allow for 10% more efficient inventory management.
  • Goal: Streamline patient flow and resource allocation.
  • Insight: Optimized staff scheduling based on peak admission hours.

📂 Repository Structure

Folder Domain Tools Used
Blinkit Quick Commerce Power BI, Excel
Uber Rides Analysis Transportation Python, Seaborn
Smartphone Sales E-commerce SQL, Python
HR Analytics Employee Performance Power BI
Revenue Segmentation Marketing Python (RFM Analysis)

📈 Dashboard Previews

Telecom Churn & Customer Insight Dashboard

A high-level view of customer demographics, contract types, and churn probability. Dashboard Screenshot


📫 Let's Connect

About

End-to-end Data Analysis Projects using SQL, Power BI, Python and Excel including Amazon Sales, HR Analytics, Road Accidents, and more.

Topics

Resources

Stars

1 star

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors