I took this Dataset from codebaiscs resume challenge, I have performed data analysis and designed a Report in Power BI
Live Report : Link
AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodara. They want to expand to other metros/Tier 1 cities in the next 2 years.
AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers daily basis so that they can respond swiftly to these issues.
The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘On-time delivery (OT) %’, ‘In-full delivery (IF) %’, and OnTime in full (OTIF) %’ of the customer orders daily basis against the target service level set for each customer.
Peter Pandey is the data analyst in the supply chain team who joined AtliQ Mart recently. He has been briefed about the the task in the stakeholder business review meeting. Now imagine yourself as Peter Pandey and play the role of the new data analyst who is excited to build this dashboard and perform the following task:
Create the metrics according to the metrics list. Create a dashboard according to the requirements provided by stakeholders in the business review meeting. You will be provided with the transcript of this business review meeting in comic form. Create relevant insights not provided in the metric list/stakeholder meeting.
Performance Gap with Targets: There is a Huge gap between the actual performance and the target metrics for On-time Delivery (OT%), In-full Delivery (IF%), and On Time In Full (OTIF%) metrics. This indicates a need for improvement in operational efficiency and order fulfillment processes.
Focus on Line Fill Rate (LIFR): The Line Fill Rate (LIFR) is at 66%, indicating room for improvement in product availability and inventory management. AtliqMart should focus on optimizing inventory levels and ensuring that products are adequately stocked to meet customer demand.
Improvements in OTIF%: The OTIF% metric shows a gap of nearly 30% from the target, indicating a need to improve order fulfillment and delivery processes. AtliqMart should streamline its logistics operations to ensure timely and complete deliveries to customers.
Addressing Late Deliveries: Approximately 40% of orders are delivered late, with an average delay of 2 days. AtliqMart should identify the root causes of late deliveries and take corrective actions to minimize delays, such as optimizing delivery routes and schedules or improving communication with suppliers.
Category-wise Analysis: Dairy products account for the majority of orders, suggesting strong demand in this category. AtliqMart could capitalize on this trend by expanding its product offerings or promotions in the dairy category to drive sales further.
Customer and Product Performance: Customers like Lotus Mart, Coolblue, and Acclaimed stores have the highest orders but also face challenges in delivering products on time. AtliqMart should work closely with these suppliers to improve their performance and explore alternative suppliers if necessary. Products like Butter, Milk, and Ghee are frequently delayed, indicating potential issues in the supply chain or inventory management for these items. AtliqMart should prioritize addressing these issues to enhance customer satisfaction.
Continuous Improvement: Despite the insights gained, there are no noticeable improvements in key metrics over the past few months. AtliqMart should establish a culture of continuous improvement, regularly reviewing performance metrics, identifying areas for enhancement, and implementing corrective actions to drive positive changes.
Overall, AtliqMart should focus on enhancing operational efficiency, optimizing inventory management, and strengthening partnerships with suppliers to improve order fulfillment and customer satisfaction. By addressing these areas, AtliqMart can drive better performance and achieve its business objectives.