Sales Insights for Data-Driven Decision

Overview

This project implements a Business Intelligence (BI) system for analyzing sales data to improve profitability, optimize inventory management, and enhance marketing strategies in a fictional retail company.

Objectives

Improve profitability
Optimize inventory management
Enhance marketing strategies

Tools and Technologies

MySQL
Google Forms
Talend Open Studio
MS Power BI

Approach

Methodology

To complete this project, we implemented a methodology tailored to the lifecycle of a BI project. This methodology consisted of six steps:

Data collection
Indicator collection
ETL (Extract, Transform, Load)
Determination of Analysis Axes or Dimensions and Data Warehouse Design
Visualization
Multidimensional analysis

Project Management

Project management was crucial for the success of the BI project. We utilized the Work Breakdown Structure (WBS) and Gantt chart to plan and coordinate the various project tasks.

Data Warehouse Design

Star Schema:

Dashboards

Dashboard 1 : Total income and total profit 1
Dashboard 2 : Total income and total profit 2
Dashboard 3 : Best-selling products and loyal customers

Key Findings

Identified sales trends
Improved pricing strategies
Enhanced inventory management
Identified loyal customers

Conclusion

This BI project successfully addressed various challenges faced by the company, demonstrating the importance of BI in effective decision-making for modern businesses.

Contact

For inquiries or feedback, contact me at mo.eddahby@gmail.com.

Show Your Support

⭐️ Don't forget to Star this repo if you like on !

License

This project is licensed under the MIT License - see the LICENSE file for details.

MrMDrX/Sales-Insights-Talend-Power-BI