Sales Performance Dashboard + Customer Segmentation using RFM Analysis
Key Elements:
-
Thorough customer analysis using the RFM model to segmentize customers based on past purchasing behaviors.
-
KPI cards tracking Year-on-Year percentage growth for total revenue, customer, and orders received.
-
Line charts displaying the Month-on-Month changes in sales, customer orders, and customer growth.
-
Identified top product categories, most demanded products, and the business' market reach in the United States of America using various visuals.
​
Tools used: Python (Pandas, Numpy), Power BI, DAX, and PowerPoint.
Click to view the python code...
Sales Dashboard + Regression Analysis for Causality Relationship between Sales and Email Engagement.
Key Elements:
-
An in-depth analysis of the relationship between email engagements and sales was performed using a linear regression method.
-
KPI cards were used to display the Month-on-Month percentage change in sales and customer growth.
-
A line chart was used to display the Month-on-Month changes in sales.
-
Top 10 customers vs others and their contributions to total sales were visualized using Matrix Table.
-
A matrix table was used to display the product performance for each of the products sold.
-
A scatter chart was used to visualize the relationship between email engagements and sales.
​
Tools used: Power BI, DAX, PowerPoint, and Microsoft Excel for Regression Analysis.
