Powered by
Codebasics DA Bootcamp

Yatin Lokhande

Pricing Analyst at Ascendion

[email protected]

Hello, I am

Yatin Lokhande.

1

Excel Project

2

PowerBI Projects

2

SQL Projects

About Me

I focus on using data to improve business processes and deliver clear, actionable insights. With experience in data analysis, pricing strategies, and financial modeling, I simplify complex problems to drive practical solutions. I enjoy collaborating with teams to achieve impactful results and continuously work to enhance my skills and expertise.

Key Skills

Power BI & Data Visualization

Financial Modeling & Pricing Strategies

Data Analysis & Automation

Ad-hoc Analysis

SQL & Advanced Querying

My Projects

My Experience

Pricing Data Analyst with experience in optimizing financial models and analyzing complex datasets to drive strategic decisions. At Ascendion Engineering, I developed pricing strategies for RFPs and RFQs, collaborating with cross-functional teams to enhance profitability and streamline processes. At Epiq Global, I automated data tasks, improving efficiency and accuracy in eDiscovery analysis. My role at Web Crypt Technology involved enhancing data analysis workflows and presenting insights through Power BI dashboards. With an MBA in Finance and a BCA, I apply analytical and business acumen to deliver impactful results across multiple sectors.

Let's Connect

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 protected]

https://www.linkedin.com/in/yatinlokhande/

https://github.com/YatinLokhande

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Executive Dashboard Offers market share against competitors, trend analyses, revenue breakdowns, and highlights the top 5 customers

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

This home page features a display of all dashboards, including the refresh date and project details.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Excel Project

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics(FMCG)

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

AtliQ Hospitality

The problem statement was AtliQ grands is a chain of Luxury hotels and they are losing market share we need to build a dashboard that will help the stakeholders to find the cause of downfall and to help them take decisions to regain market share.

View Project
on GitHUB

AtliQ Hospitality

AtliQ Grands aims to reverse declining market share with a Power BI dashboard for data-driven decisions.

AtliQ Hospitality

This calculates revenue contribution by various metrics.

Project Details

🏨 Title: AtliQ Hospitality Revival Analysis 📊🔑

🔍 Project Overview:
AtliQ Grand, a prominent 5-star hotel chain in India, is facing revenue challenges due to ineffective decision-making and fierce competition. They're seeking to leverage "Business and Data Intelligence" for informed decisions.

📋 Objectives:
This data analysis initiative aims to empower AtliQ Grand's Revenue Team with actionable insights from historical data. As a data analyst, my mission is to deliver key findings, establish metrics, construct an insightful dashboard, and provide actionable recommendations to enhance decision-making.

💡 My Achievements:
✅ I've fostered connections between various datasets.
✅ I've grasped essential metrics and terminology in the hospitality domain
✅ I've devised measures and KPIs to monitor revenue across different segments, including room types, booking platforms, and occupancy rates, enabling a detailed analysis of revenue performance.

Live Interactive Dashboard

SQL Project

Consumer Good AD_HOC Analysis

AtliQ Hardwares Consumer Goods Analytics: Leveraging SQL queries, exploring sales data to uncover insights. Key findings: product trends, retailer performance, and sales channel analysis.

View Project
Engagement

View Project
on GitHUB

Consumer Good AD_HOC Analysis

Stored procedure output: monthly gross sales report for customer 90002002

Consumer Good AD_HOC Analysis

SQL query finds top customers by average discount pct for FY 2021 in India

Project Details

In the 'Consumer Goods Domain' project, I worked on the database of Atliq Hardwares. Faced with the challenge of making data-informed decisions, I addressed ten ad-hoc requests to extract actionable insights. The findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Insights into sales seasonality and the pivotal role of the 'Retailer' channel were uncovered. Key learnings included the transformative potential of data analytics for informed decisions, the dynamic nature of the consumer goods market, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes. The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst."

SQL Project

Finance and Supply Chain Analytics

In this project, we delve into a dataset related to Finance & Supply Chain within the domain of AtliQ Hardwares. AtliQ Hardwares is a renowned hardware company specializing in PCs, printers, mice, and computers, boasting a global presence.

View Project
Engagement

View Project
on GitHUB

Finance and Supply Chain Analytics

Project Data Set

Finance and Supply Chain Analytics

Croma India product wise sales report for fiscal year - 2021

Project Details

AtliQ Hardwares Finance & Supply Chain Analytics SQL Project

Welcome to the AtliQ Hardwares Finance & Supply Chain Analytics Project repository. Here, we analyze a dataset concerning Finance & Supply Chain within AtliQ Hardwares, a global leader in PC, printer, mouse, and computer manufacturing.

Objective:
This project aims to extract insights from the database, addressing sales reports, market analysis, customer behavior, and supply chain forecasting. With the expanding Excel file sizes causing performance issues, leveraging MySQL as the database management system offers a solution.

Key Insights:
- Amazon leads in net sales with $109.03M in fiscal year 2021, followed by AlliQ Exclusive with $79.92M.
- The Indian market generates the highest net sales at $210.67M in fiscal year 2021, with the USA following at $132.05M.
- Amazon contributes 13.23% of total net sales, and in the APAC region, it leads with a net sales contribution of 12.99%.