Skip to content

My project using Power BI and Python to analyze the performance of a retail company

Notifications You must be signed in to change notification settings

baotram237/Retail-analysis

Repository files navigation

Retail-analysis

Market basket analysis, RFM analysis, Return analysis, Sale performance, Customer Lifetime value analysis My project uses Power BI and Python to analyze the performance of a retail company

Link Dataset: Ecommerce Dataset (Source Kaggle)

Our Objective: Create Dashboard to track Sale performance, Customer analysis and purchase behaviour

  • Explore some metrics related to customers in different groups based on demographic features and purchasing behavior
  • Calculate customer lifetime value, RFM analysis to segment customer, suggest strategic plan for each group
  • Explore churn customer, and returned orders and identify patterns to reduce them
  • Execute market basket analysis to enhance cross-sell strategy
  • Track sale performance over time and in different categories and customer group Short Summary EDA

Tasks: Using Python and Power BI

  • Data preprocessing
  • Data modeling
  • Exploratory data analysis
  • Identify buying patterns and track performance
  • Create actionable dashboards

Data Model in Power BI

image

Some Metrics in the Project

image

Sale Dashboard sample

image image image

About

My project using Power BI and Python to analyze the performance of a retail company

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published