Portfolio - Sanket Kelkar

PowerBI Project

Business Insights 360

An imaginary company called AtliQ Hardware is a consumer goods electronics company having operations in various countries. Their business is growing rapidly and they still rely on excel files for data analytics. Excel files are hard to consume and not effective in generating insights from large amou

View Project
on GitHUB

Finance View: Focused on financial data, enabling decision-makers to gain insights into financial performance.

Supply Chain View: Offering insights into supply chain operations and efficiencies.

Project Details

AtliQ Hardware, a global consumer electronics company, faced unexpected losses in the Latin American market due to inadequate data analysis. Competitors with dedicated analytics teams outperformed AtliQ, prompting the need for an analytics upgrade.
Our project's objective was clear: enhance AtliQ's data analytics capabilities by transitioning from Excel to Power BI for better decision-making.

Data Preview: We examined two databases (gdb041 and gdb056) for historical transaction data and dimensions (e.g., customer, product, market).
Data Extraction: Data from a MySQL database was seamlessly imported into Power BI, ensuring data access.
Data Transformation: We eliminated biases through preprocessing (e.g., removing duplicates, adjusting data types) and structured data for clarity.
Data Modeling: We created a flexible data model, evolving from a star schema to a snowflake schema to accommodate complex relationships.
Dashboard Design: Interactive dashboards were develop

Live Interactive Dashboard

Excel Project

Excel Sales & Finance Analytics

In Sales Analytics, we compare sales data to optimize activities and track key performance indicators. Finance Analytics creates Profit and Loss (P&L) reports for evaluating financial performance and supporting decision-making. Essential skills include ETL, Power Query, Power Pivot, DAX, reports.

View Project
on GitHUB

This report gives the comparison between market share and the given targets.

This report gives insights about the customers performance.

Project Details

This project comprises two primary objectives: creating Sales reports and generating Profit and Loss (P&L) reports.
Sales Analytics:
Objective: Develop Sales reports for monitoring performance and optimizing strategies.
Importance: Identify sales patterns, track KPIs, and facilitate effective customer negotiations.
Finance Analytics:
Objective: Create detailed Profit and Loss (P&L) reports.
Importance: Evaluate financial performance, support decision-making, and enable effective stakeholder communication.
Skills Required:
A mix of technical and soft skills is essential:
Technical Skills:
ETL methodology proficiency.
Generating date tables using Power Query.
Deriving fiscal months and quarters.
Establishing data model relationships with Power Pivot.
Incorporating supplementary data into models.
Using DAX for calculated columns.
Soft Skills:
Understanding Sales & Finance Reports.
Designing impactful reports.
Optimizing report generation.
Systematic report building.

PowerBI Project

Axon Retail Car Analysis

A retailer selling classic cars, is facing issues in managing and analyzing their sales data. struggling to make sense of the data and they do not have a centralized system to manage and analyze the data. To address this issue, the company has decided to implement a Business Intelligence (BI) tool.

View Project
on GitHUB

The sales view gives the overview of the company's sales performance over the years and showcase the potential pitfalls to analyze.

The order view gives the order trends over the months and the shipping details from past years.

Project Details

Axon's sales team struggled with managing and making sense of their sales data due to a lack of a centralized system. The absence of accurate and up-to-date sales reports hindered effective decision-making.
To address these issues, I try to implement a robust Business Intelligence (BI) solution using Microsoft Power BI and SQL.

Live Interactive Dashboard

PowerBI Project

AtliQ Mart Supply Chain Analysis

AtliQ Mart, an FMCG manufacturer, is expanding to other cities, but key customers are reluctant to renew contracts due to service issues. To address this, the supply chain team will track on-time and in-full delivery service levels daily to identify and resolve issues swiftly.

View Project
Engagement

View Project
on GitHUB

This report gives the key matrices overview for customers and the targeted values of matrices like OTa%, OTIF%, IF% etc.

This report gives the representation of matrices related to products.

Project Details

I built a Power BI dashboard for AtliQ Mart to enhance service quality, retain customers, and prepare for expansion.
Features:
1. Data Integration: Visualized diverse data sources.
2. Product-Level Insights: Real-time analysis for Surat, Ahmedabad, Vadodara.
3. Metrics: OT %, IF %, OTIF %, LIFR%, VOFR% for each customer.
4. Drill-Down: Deep data exploration and issue resolution.
Outcomes:
• Improved Service Quality
• Informed Decision-Making
• Scalability
Impact:
AtliQ Mart is now positioned for success in new markets, recognized for its customer focus and data-driven approach.

Hello, I am

Sanket Kelkar

3

1

About

Key

My

Business Insights 360

Excel Sales & Finance Analytics

Axon Retail Car Analysis

AtliQ Mart Supply Chain Analysis

Contact Me

Email

Github

Linkedin

Call

Sanket Kelkar

Download Resume