Generate Insights to Solve a Supply Chain Issue in the FMCG Domain

Project Details

Tools Used: Data Visualization: Power BI Database: MS Excel

Problem Statement: AtliQ Mart, a growing FMCG manufacturer in Gujarat, India, faces challenges in retaining key customers and aims to expand to other cities in the next two years. The company has identified service issues, leading to non-renewal of contracts by some key customers. To address this, the supply chain analytics team is tasked with tracking the 'On Time' and 'In Full' delivery service levels for all customers daily. The goal is to swiftly respond to issues and ensure customer satisfaction.

Task: As the data analyst in the supply chain team, I was tasked to build a dashboard that measures 'On-Time Delivery (OT) %,' 'In-Full Delivery (IF) %,' and 'On-Time In Full (OTIF) %' against the target service levels for each customer. The objective is to provide insights and solutions to improve customer service. I have created relevant metrics, and a dashboard, and uncovered additional insights not covered in the stakeholder meeting to address the supply chain issue effectively.




Live Interactive Dashboard

Comments

Post a Comment

Popular posts from this blog

Ad-hoc Insights (Consumer Goods Domain)

Projects Details   AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they did not get enough insights to make quick and smart data-informed decisions. Hence, the company decided to conduct an SQL challenge. As part of the SQL Project Challenge, I successfully completed a project with the following key highlights: 1.SQL: Utilized advanced SQL concepts such as Subqueries, Multiple Joins, Common Table Expressions (CTE), and Window Functions to query the database effectively. 2. Power BI: Employed Power BI to visualize the extracted data, creating visuals like Bar Charts, Line Charts, and Donut Charts. These visuals were instrumental in clearly communicating insights derived from the data. Using my skills, I efficiently handled and analyzed database information. Applying these concepts, I turned raw data into useful insights, playing a key role in shaping the company's strategic de...
Read more
Image
I am excited to share that I have successfully completed all three levels of SQL certification on HackerRank - Basic, Intermediate, and Advanced. Throughout this journey, I strengthened my understanding of: Basic SQL: SELECT statements, filtering, sorting, and aggregations Intermediate SQL: JOINs, subqueries, grouping, Advanced SQL: Window functions and complex query optimization These skills have helped me improve the way I analyze data, build logic, and solve real-world business problems. Looking forward to applying this knowledge in future data projects! hashtag # SQL hashtag # HackerRank hashtag # DataAnalyst Linkedin Post
Read more