Welcome to the BuildMart Business Analytics Dashboard project! This project was initially created as part of a course assessment for Data Analytics for International Business and has been refined for use in my professional portfolio. The project focuses on analyzing and visualizing key performance indicators (KPIs) for BuildMart, a leading provider of building materials, to address revenue decline and improve customer satisfaction.
- Introduction
- Project Objectives
- Data
- Methodology
- Dashboard
- Insights and Recommendations
- Technologies Used
BuildMart has faced a slow revenue decline and low customer satisfaction over the past year. This project aims to analyze BuildMart's sales data and customer reviews to identify the core issues and suggest actionable solutions. A comprehensive business intelligence (BI) dashboard has been developed to provide insights into the company's performance.
- Analyze BuildMart's sales and customer data.
- Identify key areas of concern impacting revenue and customer satisfaction.
- Develop a BI dashboard to visualize and interpret the data.
- Provide actionable recommendations to improve performance.
The dataset used in this project includes:
- Sales data
- Customer reviews
- Inventory data
- Competitor pricing
The project follows a structured approach:
- Data Collection: Gathering data from various sources including sales, customer feedback, and competitor analysis.
- Data Processing: Cleaning, transforming, and aggregating data to ensure quality and consistency.
- Data Analysis: Utilizing statistical analysis and pattern recognition to extract insights.
- Data Visualization: Creating interactive dashboards and visual reports to present the findings.
The BI dashboard includes several key visualizations:
- Revenue Generated
- Total Profit
- Average Delivery Days
- Total Orders
- New vs Returning Customers
- Average Customer Review
- Stock Level by Category Classification
- Average Sales by Month
- Average Unit Price vs Competitor
- Total Revenue by Customer Location
- Order Frequency
Here are a screenshot of the dashboard:
You can download the Power BI dashboard file [here](Builmart Dashboard report.pbix).
Key insights derived from the analysis:
- Identifying underperforming geographical regions.
- Understanding high-demand product categories.
- Analyzing customer satisfaction levels and their impact on sales.
- Competitive pricing strategies.
Recommendations include:
- Tailored marketing strategies for underperforming regions.
- Improved inventory management for high-demand products.
- Enhancing customer service to improve satisfaction and retention.
- Regular monitoring and adjustment of pricing strategies.
- Excel: For data storage, processing, and preliminary analysis.
- Power BI: For creating interactive dashboards and data visualization.