Home

AtliQ Mart | supply insights

I worked on an exciting project analyzing AtliQ Mart, a fast-moving consumer goods (FMCG) manufacturer operating in three cities: Surat, Ahmedabad, and Vadodara.

Skills Utilized:

1. Utilized SQL to analyze and format table data effectively.

2. Leveraged Power BI for creating impactful visualizations.

Key Insights :

During the project, I focused on deriving valuable insights that provided a comprehensive understanding of the business.

Here are some of the key insights I uncovered :

1. Total Order Lines.
• Analyzed the daily order lines, categorizing them by cities and customers.
2. Line Fill Rate:
• Assessed the line fill rate to determine the percentage of completed order lines.
3. Volume Fill Rate:
• Evaluated the volume fill rate to measure the percentage of fulfilled order quantities.
4. On-Time Delivery Percentage:
• Calculated the on-time delivery percentage in relation to set targets, considering different cities and customers.
5. In Full Delivery Percentage:
• Examined the percentage of orders delivered completely as per the targets, categorized by cities and customers.
6. On-Time In Full Percentage:
• Determined the percentage of orders delivered on time and in full, with respect to the targets, considering different cities and customers.

In addition, I also provided valuable product insights to further enhance the understanding of the business.

Creating the Visualization:

During the creation of the dashboard, I followed a meticulous ideation process to ensure an impactful and user-friendly design.

Here are the steps I took:

My primary goal was to develop a 4-sheet dashboard that effectively conveyed the complete narrative of the data.

I created visually engaging charts and graphs to address key questions and highlight important findings.

To enhance user experience, I incorporated interactive features that allowed users to drill down into specific areas, months, products, and more.

I successfully accomplished these objectives and was pleased with the final results, creating a dashboard that effectively communicated the data story