Welcome to my Data Analysis Projects Portfolio! This repository showcases three comprehensive data analysis projects that demonstrate my skills and expertise in SQL, Python, and Power BI. Each project includes detailed documentation, code, and visualizations to provide clear insights and useful recommendations.
| Projects | Data Link | Situation | Actions | Insights and Recommendations |
|---|---|---|---|---|
| SQL | Online Retail | This project was undertaken to analyze user behavior over time by grouping them into cohorts based on their signup dates. Cohort Analysis helps identify trends, evaluate the effectiveness of marketing campaigns, and develop strategies to improve user experience and retention. | 1. Analyzed user groups based on their signup dates 2. Evaluated user retention rates over different time periods. 3. Identified factors affecting user retention. |
Results |
| Python | Global Superstore | This project aims to analyze customer behavior using the RFM (Recency, Frequency, Monetary) model to segment customers and understand their purchasing patterns | 1. Segmented customers based on their recency, frequency, and monetary value. 2. Identifed the most valuable customer segments. 3. Identified strategies for targeted marketing and customer retention. |
Results |
| PowerBI | Global Superstore | This project involves creating a detailed sales performance dashboard to monitor the business performance to develop market expansion strategies and make informed decisions about strategic product choices | 1. Visualized critical sales performance metrics 2. Visualized sales data by various dimensions including time, customer segment, product category. 3. Identifed high-potential markets for expansion and key products for strategic focus. |
Results |