Portfolio - Abhishek Medar | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Abhishek Medar

Supply chain Associate

EMAIL

[email protected]

PHONE

+91 8309823086

Download CV

About Me

I am a Supply Chain Associate specializing in Cloud Capacity Planning, currently supporting Microsoft through Accenture. My work focuses on analyzing infrastructure demand, planning capacity across data centers, and improving resource utilization to reduce reservation rejections. I work extensively with data-driven planning, including Week of Supply (WoS) analysis, buffer planning, and capacity readiness checks. I regularly use Excel, Power BI, Power Query, DAX, and SQL to build automated reports and dashboards that replace manual processes and enable faster, insight-driven decisions. Before moving into analytics, I worked in the frozen food manufacturing industry as a Dispatch Supervisor and later as a Junior Production Manager, handling production planning, logistics coordination, vendor management, and operational reporting. This experience gave me strong end-to-end supply chain exposure.

1

Excel Project

3

PowerBI Projects

Key Skills

power query

dax

sql

My Projects

My Experience

Optimized Production Processes: Utilized data analysis to streamline production processes, resulting in a 15% reduction in waste and a 10% increase in efficiency.

Data-Driven Decision Making: Analyzed production data to forecast demand, optimize resource allocation, and reduce costs, leading to a 12% reduction in operational expenses.

Quality Control and Compliance: Implemented data tracking systems for quality control, ensuring compliance with industry standards and regulations.

Cross-Functional Collaboration: Worked closely with supply chain, quality assurance, and R&D teams to analyze data and identify opportunities for process improvements.

Awards & Certificate

Excel: Mother of Business Intelligence

Scam Awareness Course

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Let's Work Together!

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

EMAIL

[email protected]

Call Me

+91 8309823086

LinkedIn

https://www.linkedin.com/in/abhishek-medar/

Excel Project

Excel-Based Financial and Performance Reporting for Atliq Hardware

Domain/Function: Finance

I created a detailed P&L statement by fiscal year and month, with metrics like Net Sales, COGS, Gross Margin, and GM%. Additionally, I generated customer performance and market performance vs. target reports using Excel pivot tables, showcasing my advanced data analysis skills.

View Project
Engagement

Excel-Based Financial and Performance Reporting for Atliq Hardware

This report show the Market Performance Vs Target of different Region and Division.

Excel-Based Financial and Performance Reporting for Atliq Hardware

Created P & L Metrics by the Year.

Project Details

In this project, I applied my advanced Excel skills to develop a comprehensive financial and performance reporting system for the company, Atliq Hardware. The focus was on creating a detailed Profit and Loss (P&L) statement, broken down by fiscal year and month. Key metrics included:

Net Sales: Tracking revenue generated from sales activities.
Cost of Goods Sold (COGS): Calculating the direct costs attributable to the production of goods sold.
Gross Margin: Determining the difference between Net Sales and COGS.
Gross Margin Percentage (GM%): Providing a percentage-based view of profitability.
These metrics offer a clear view of the company's financial health and performance over time, aiding in strategic decision-making.

Additionally, I developed two critical performance reports using Excel's pivot table functionality:

Customer Performance Report: This report provides insights into individual customer contributions to overall sales, highlighting top-performing customers

PowerBI Project

Business Insights

Domain/Function: Business Insights

Atliq Hardware, a rapidly expanding consumer electronics company, is currently facing challenges in leveraging data for competitive advantage due to reliance on traditional Excel-based reporting. My project aims to transform this scenario to advanced analytical solution using Power bi

Business Insights

Executive View: P&L Statement, Revenue by Division/Channel, Yearly Revenue Trends, Top Customers, Top Products, KPIs

Business Insights

Sales View : Customer Performance, Product Performance, P & L Values by description, Total Gross, Gross Margin.

Project Details

To enable data-driven decisions at AtliQ Hardware through an advanced Power BI dashboard.

Finance View: Revenue, Profit Margins, Cash Flow.
Supply Chain View: Inventory Levels, Order Fulfillment, Supplier Performance.
Market View: Market Share, Customer Segmentation, Competitor Analysis.
Sales View: Sales Growth, Product Performance, Sales Forecasting.
Executive View: Overall Company Performance, Strategic Goals, Risk Assessment.

This integrated dashboard provides real-time insights, enhancing decision-making and operational efficiency across all departments,
and helping AtliQ Hardware stay competitive and grow.

Live Interactive Dashboard

PowerBI Project

IPL Data Analysis

Domain/Function: Sports Analytics

"Sports Basics" is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

View Project
Engagement

IPL Data Analysis

Batting Analysis, where the bar charts shows highest batsman by runs, Average, Strike rate and Boundary %

IPL Data Analysis

Team Analysis is done where we have teams with winning percentage and highest number of wins acheieved by chasing

Project Details

In this project, I took on the role of Peter Pandey to analyze and visualize three years of IPL performance data for players and teams. Using Power BI, I designed an interactive dashboard that provides a comprehensive summary of key metrics, helping stakeholders understand trends, strengths, and areas for improvement. The analysis was based on the data provided in the 'primary_and_secondary_analysis.pdf' document and was supplemented with additional research to provide deeper insights.
Key Objectives:
Data Transformation
Performance Metrics
Visual Storytelling
Interactive Elements

Live Interactive Dashboard

PowerBI Project

Insights to the revenue team in the Hospitality Domain

Domain/Function: Hospitality

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. AtliQ Grands are losing its market share and revenue in the luxury/business hotels category. the managing director wanted to incorporate “Business and Data Intelligence”.

Insights to the revenue team in the Hospitality Domain

screenshots shows some KPI's, Matrix table, Bar chart and line and Staked column chart of some trending insights for the Hospitality Domain

Insights to the revenue team in the Hospitality Domain

screen shots shows the line and staked column chart which is tool tip showing Revenue Trend by week

Project Details

As a data analyst, I was tasked with revitalizing AtliQ Grands' market share and revenue in the luxury/business hotels sector. Leveraging historical data, I developed a comprehensive Business Intelligence dashboard to provide actionable insights to the management team. The project involved creating specific metrics and visualizations based on a provided mock-up, as well as identifying additional insights beyond the given specifications.

Key Objectives:

Metrics Development: I created key metrics such as Average Daily Rate (ADR), Revenue Per Available Room (RevPAR), and occupancy rates. These metrics were tailored to provide a clear view of the hotel's financial and operational performance.

Dashboard Creation: Following the stakeholder-provided mock-up, I designed a user-friendly dashboard that includes charts and visual elements to display the metrics effectively. The dashboard facilitates easy navigation and quick access to critical data.

Live Interactive Dashboard