## BEI SAWA Supermarkets

Project Overview: BEI SAWA Supermarkets, located in Maua, Meru County, Kenya, sought to leverage its sales data to improve inventory management and marketing strategies. The project involved designing ETL pipelines and dashboards, with a special focus on creating a market basket analysis to uncover customer shopping trends and enhance bundling strategies.

### Project Goals

- Extract and analyze sales data to identify customer buying patterns.
- Design a market basket analysis to group commonly purchased items.
- Create actionable dashboards for inventory management and marketing.
- Improve operational efficiency and enable data-driven decision-making.

### Technologies Used

- SQL: Extracted and prepared sales data for analysis.
- Azure Workspace: Provided a scalable environment for data processing.
- Power BI: Developed interactive dashboards for sales trends and market basket insights.
- ETL Pipelines: Automated the data flow from source to staging and reporting environments.

### Achievements & Impact

The project delivered several key benefits:

- Developed a market basket analysis to identify frequently purchased product combinations.
- Enabled BEI SAWA to create product bundles, boosting marketing efficiency.
- Improved stock management by providing insights into reorder levels and seasonal trends.
- Enhanced decision-making through interactive Power BI dashboards.

### Challenges & Solutions

A major challenge was implementing the market basket analysis for identifying buying patterns:

- We employed SQL queries and data transformations to derive item associations from transactional data.
- Integrated the analysis results into Power BI to visualize customer shopping trends effectively.
- Optimized ETL processes to handle high volumes of daily sales data efficiently.

### Project Results

Through this project, BEI SAWA Supermarkets gained a deeper understanding of customer behavior, enabling them to craft more targeted marketing campaigns and optimize inventory management. The market basket analysis significantly improved their ability to bundle products and enhance sales strategies.