Created by Fitria Dwi Wulandari – March, 2024
All-U-Need Mart, a retail company specializing in daily necessities with three branches across three cities in Myanmar, is preparing for the new quarter. To formulate strategic initiatives, the company aims to gather crucial information from the previous period.
This project seeks to drive growth, optimize operations, and enhance customer satisfaction in the upcoming quarter by:
- Assessing key metrics, including the number of transactions, number of active consumers, total revenue, and total profit.
- Analyzing sales trends over time.
- Evaluating sales performance by branch store, product type, and payment method.
- Displaying a list of consumers with details on membership type, number of transactions, and total sales.
- Conducting customer segmentation analysis using RFM (Recency, Frequency, Monetary) analysis.
- Source: Data obtained from the Business Intelligence Bootcamp at dibimbing.id, containing mart transaction data from Quarter 1 of 2019.
- Actions: Cleaning and preparing the data for analysis, ensuring data quality and consistency.
- Purpose: Discover patterns, spot anomalies, and gain a deeper understanding of the data's characteristics.
- Techniques: Use of various visualization techniques to explore and understand the data.
- Purpose: Present data in a clear and approachable way, facilitating decision-making processes.
- Data Analysis and Visualization: Tableau for creating dashboards and visual representations of the data.
The analysis will provide the insights necessary to inform strategic decisions and ensure continued success for All-U-Need Mart. Key findings will include trends in sales performance, customer segmentation insights, and actionable recommendations for driving growth and enhancing customer satisfaction.
- Advanced Analysis: Explore advanced analytics techniques for deeper insights into customer behavior and market trends.
- Dashboard: Tableau dashboards visualizing the key insights and metrics.
