Portfolio - Siddharth Patil

PowerBI Project

FMCG supply chain market Solution

Domain/Function: Supply Chain

AtliQ Mart, a leading FMCG manufacturer in Gujarat, operates in Surat, Ahmedabad, and Vadodara. This dashboard enhances supply chain efficiency by tracking key metrics like order fulfillment and delivery performance , aiding their expansion into metro and Tier 1 cities.

View Project
Engagement

This page explains the key metrics and all the important information about customer's of Atliq mart.

This page explains all the important insights about the products

Project Details

Welcome to AtliQ Mart's Supply Chain Performance Dashboard. This project focuses on providing insightful analytics to enhance the operational efficiency of AtliQ Mart, a prominent Fast-Moving Consumer Goods (FMCG) manufacturer based in Gujarat, India. AtliQ Mart operates in three major cities: Surat, Ahmedabad, and Vadodara, and is known for delivering high-quality essential products efficiently and reliably. As AtliQ Mart aims to expand into additional metro and Tier 1 cities over the next two years, maintaining and enhancing service standards is crucial.

The FMCG sector, characterized by products with rapid turnover and relatively low cost, necessitates exceptional supply chain management to meet high demand and ensure timely, complete deliveries. The Supply Chain Performance Dashboard provides real-time analytics on key performance indicators (KPIs) such as order fulfillment rates, delivery performance, and inventory management. By leveraging this dashboard

Live Interactive Dashboard

PowerBI Project

Electric Vehicle Market Insights

Domain/Function: EV Market Analysis

Created an interactive Electric Vehicle Analysis Dashboard , providing insights into EV market trends, brand performance, and state-wise adoption in India. This project highlights growth opportunities and market expansion potential by 2030.

View Project
Engagement

Other Tools

Excel

An interactive dashboard for electric vehicles (EVs) in India presents key metrics such as the total number of vehicles, EV penetration rate, CAGR.

An interactive dashboard for electric vehicles (EVs) in India presents key metrics, including total CAGR, EV CAGR, projected sales, and total revenue.

Project Details

Developed an interactive Electric Vehicle (EV) Analysis Dashboard . The dashboard provides comprehensive insights into the Indian EV market by analyzing trends from both manufacturer and state perspectives. Key features include:

1.Maker Analysis: Evaluates the performance of various EV brands, highlighting market leaders like Tata Motors with a remarkable CAGR of 94.7%.
2.State Analysis: Identifies states such as Karnataka, Meghalaya, and Goa as leaders in EV adoption, revealing regional growth patterns and potential.
3.Growth Metrics: Showcases a 93.91% CAGR in EV adoption, forecasting significant market expansion by 2030.

This project enhanced my data visualization and analytical skills, utilizing Power BI and DAX to deliver actionable insights for the growing EV sector in India. Special thanks to the Codebasics team for this invaluable learning opportunity!

Project video

Live Interactive Dashboard

PowerBI Project

Comprehensive Analysis of Customer Spending Behavior: Insights into Income Utilization and Spending Patterns

Domain/Function: Banking

Analyzed customer data to understand spending behavior and income utilization. Integrated datasets to develop key metrics, such as Total Income, Total Spend, and Income Utilization. Utilized Power BI and DAX for interactive visualizations and insightful segmentation.

View Project
Engagement

Comprehensive Analysis of Customer Spending Behavior: Insights into Income Utilization and Spending Patterns

The interactive dashboard for customer analysis presents key metrics, including total customers and their distribution by age, gender, marital status.

The interactive dashboard for customer spending analysis presents key metrics, such as total income, total spend, and average income.

Project Details

This project aimed to analyze customer spending behavior and income utilization by integrating data from dim_customers and fact_spends datasets. Key metrics, including Total Income, Total Spend, and Income Utilization, were developed to provide insights into customer spending efficiency.

The analysis featured detailed customer segmentation based on age, gender, marital status, and occupation, as well as spending trends across various categories and payment types.

The project utilized Power BI for creating interactive and intuitive visualizations that facilitated stakeholder engagement. Complex measures and calculations were implemented using DAX to uncover deeper insights, enabling data-driven decision-making and a comprehensive understanding of customer financial behavior.

Live Interactive Dashboard

Excel Project

P&L Report

Domain/Function: Financial Analysis

Developed a comprehensive P&L report for AtliQ Hardware FY 2022 using advanced Excel features like Pivot Tables and DAX. Automated data cleaning with Power Query, reducing manual work by 4 hours, and improved report accuracy by 30% with DAX-based calculation models.

View Project
Engagement

This report's first page highlights the top 10 products, showing sales for 2020 and 2021, and sales growth from 2020 to 2021.

The second page displays overall sales data, including a detailed comparison of sales performance between 2020 and 2021.

Project Details

- Developed a comprehensive Profit and Loss (P&L) report for AtliQ Hardware for FY 2022 using advanced Excel features.

- Utilized Pivot Tables to provide granular insights into revenue streams and expense categories.

- Analyzed product performance with a focus on:
- Top 10 and bottom 10 products by sales.
- Year-over-year sales comparison for 2019, 2020, and 2021.
- Automated data cleaning using Power Query, reducing manual work by approximately 4 hours.

- Deployed DAX-based calculation models to increase report accuracy by 30%, offering more nuanced and flexible data insights.

- Enabled AtliQ Hardware to better understand their financial performance, supporting more informed strategic decisions.

SQL Project

Ad-hoc request challenge

Domain/Function: Consumer Goods

Atliq Hardwares, a leading computer hardware producer, needed actionable insights to enhance decision-making. To solve this, I tackled 10 ad-hoc business queries using SQL for data analysis and Power BI for visualizations. This challenge, led by Tony Sharma, the data analytics director, tested both

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Microsoft power Point

A donut chart visualizing sales contributions by channel for Atliq Hardwares. It highlights that Retailers contributed the highest at 73.22%.

A dual-line chart comparing FY 2020 and FY 2021 monthly gross sales for Atliq Hardwares. The chart highlights key trends, showing a spike in November.

Project Details

Atliq Hardwares, a prominent computer hardware manufacturer, faced challenges in deriving actionable insights for quick, data-driven decisions. To address this, their data analytics director, Tony Sharma, launched a SQL challenge to assess potential junior analysts. The task involved solving 10 ad-hoc business queries using SQL to extract insights on product performance, customer behavior, and sales channels. I utilized SQL for data analysis and created visualizations in Power BI to present the findings effectively. This project tested both my technical skills in data querying and analysis, as well as my ability to present insights clearly. The solution provided valuable insights, helping Atliq's management make informed decisions across multiple business functions. The complete solution is available on GitHub, and a video/audio presentation is in progress to explain the approach and findings in detail.

PowerBI Project

Shield Insurance Dashboard

Domain/Function: Insurance

Developed a Shield Insurance Dashboard with KPIs like Total Customers, Revenue, DRG, and DCG. Included Sales Mode and Age Mode analysis for insights into sales channels and customer segmentation. Focused on data storytelling and actionable insights.

View Project
Engagement

Other Tools

Excel

General view representing customer & revenue trends by month and important KPI's like total customer,revenue , DCG & DRG

Sales view representing total revenu by channels

Project Details

Developed a Shield Insurance Dashboard to visualize and analyze key metrics, including Total Customers, Revenue, DRG, and DCG. The project features Sales Mode Analysis to evaluate revenue across channels and Age Mode Analysis for customer segmentation by age and policy preferences. It highlights the importance of data storytelling, actionable insights, and supporting strategic decisions in the insurance domain

Hello, I am

Siddharth Patil

1

4

1

About

Key

My

FMCG supply chain market Solution

Electric Vehicle Market Insights

Comprehensive Analysis of Customer Spending Behavior: Insights into Income Utilization and Spending Patterns

P&L Report

Ad-hoc request challenge

Shield Insurance Dashboard

Awards

Contact Me

Email

Github

Linkedin

Call

Siddharth Patil

Download Resume