Promotion Performance Analysis

The main goal of the analysis was to identify the promotions that performed well and those that did not, enabling informed decision-making for future promotional periods. This analysis was crucial for Atliq Mart to maximize revenue and customer engagement during key festive seasons.

• Utilized SQL for querying and analyzing data, enabling in-depth insights into business questions.

• Leveraged Power BI for Store Performance Analysis, Promotion Type Analysis, and Product & Category Analysis, creating interactive visualizations for effective communication of findings.

• Managed complex SQL queries to extract relevant data for Business Insights questions, ensuring accurate and meaningful analysis.

• Integrated multiple data sources into Power BI for comprehensive Store Analysis, Promotion Analysis, and Product & Category Analysis, overcoming data integration challenges.

• Ensured data consistency and accuracy across different platforms, mitigating potential discrepancies and ensuring reliable insights for decision-making.

1. Store Performance Analysis:

•   Bengaluru and Chennai emerged as the top-performing cities with the highest Incremental Sold Units and Revenue.

•  Other cities showed varying levels of performance, with Hyderabad, Coimbatore, and Mysuru following closely.

2. Promotion Type Analysis:

•    The top two promotion types, 500 cashback and BOGOF, proved to be the most effective in generating Incremental Revenue.

•    BOGOF and 500 cashback promotions significantly outperformed discount-based promotions, indicating their effectiveness in driving sales.

3. Product & Category Analysis:

•    Grocery & Staples, Home Appliances, and Home care categories saw the most significant lift in sales from promotions.

•    Certain products, such as Atliq_waterproof_immersion_red and Atliq_High_Glo_15W_LED_Bulb, responded exceptionally well to promotions.

4. Business Insights:

•    Identified high-value products with a base price greater than 500 and featured in BOGOF promotions, providing insights for pricing and promotion strategies.

•    Provided an overview of the number of stores in each city, aiding in optimizing retail operations.

5. Key Performance Indicators (KPIs):

•    Achieved a significant increase of 211.3% in Incremental Sold Units and 110% in Incremental Revenue.

•    Atliq Mart operates a total of 50 stores.

• Tailor promotions to specific cities to maximize impact and reach.

• Focus on promoting products that exhibit high responsiveness to promotions, mirroring the success of top-performing products.

• Consider prioritizing BOGOF and 500 cashback promotions over discount-based promotions for optimal results.

• Enhance promotion strategies in cities beyond Bengaluru and Chennai to increase market penetration.

• Continuously identify and promote products with high responsiveness to promotions to drive overall sales growth.

The analysis provided actionable insights to enhance Atliq Mart's promotional effectiveness and drive sales growth.

By implementing the recommendations, Atliq Mart can further strengthen its position in the market and achieve sustainable growth.