Yash Khobragade

Data Aspirant

[email protected] +91 8007696271

Resume

Hello, I am

Yash Khobragade.

1

Excel
Project

2

PowerBI
Projects

About Me

Hello and welcome to my portfolio!
I'm Yash, a passionate and curious Data Analyst in the making. I’ve learned to work with tools like Excel, Power BI, SQL, and Python to explore data and uncover useful insights.

I have a Bachelor's degree in Computer Science and Engineering. While I haven't worked in a company yet, I’ve taken the initiative to work on several real-world business projects — all of which are showcased below. These projects reflect my practical skills and the effort I’ve put into learning by doing.

I’m always eager to learn, grow, and solve problems using data. If you’re looking for someone who’s motivated and ready to contribute from day one — I’d love to connect!

Key Skills

SQL

Power BI

Excel

Python

Tableau

My Projects

Business Insights 360

Domain/Function: B2B2C Consumer Electronics Distribution

AtliQ Hardware Sales & Finance Analytics

Domain/Function: B2B2C Consumer Electronics Distribution

Shopeasy Marketing Analytics

Domain/Function: E-Commerce

My Experience

Art Shoppy | Business Analyst Intern | Oct 2024 - Nov 2024

Analyzed sales and product trends across 50+ SKUs using Excel and Power BI, identifying top-selling art supplies and seasonal demand spikes.
Built 2 interactive dashboards to track inventory levels and customer purchase patterns, supporting 20% faster restocking decisions.
Cleaned and modeled 5,000+ rows of raw sales data, delivering insights that improved marketing targeting for high-margin product categories.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Accenture North America - Data Analytics and Visualization Job Simulation

HackerRank - SQL Intermediate Certificate

HackerRank - SQL Basic Certificate

Deloitte Australia - Data Analytics Job Simulation

Tata Data Visualisation: Empowering Business with Effective Insights Job Simulation

Microsoft Power BI: A Complete Guide

Microsoft Excel Zero to Advance w/ Data Analysis Masterclass

Business Analyst Course

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.

Mail Me

[email protected]

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

Call Me

+91 8007696271

GitHub

https://github.com/yash-khobragade

PowerBI Project

Business Insights 360

Domain/Function: B2B2C Consumer Electronics Distribution

AtliQ Hardware, a fast-growing B2B electronics distributor, was facing challenges with siloed Excel reports, low forecast accuracy, and limited profitability tracking. This project delivers a comprehensive BI solution to shift from gut-based decisions to data-driven strategies.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

Snowflake schema data model connecting fact and dimension tables for unified reporting across business functions.

Interactive Power BI landing page linking to 6 dashboards—Sales, Finance, Marketing, Supply Chain, Executive, Discount Trend.

Project Details

📑 Project Overview
AtliQ Hardware is a growing B2B electronics company that distributes PCs, peripherals, and networking products to major retailers like Amazon, Flipkart, and Croma.
This project replaces fragmented Excel-based reporting with an end-to-end Power BI solution that brings transparency and actionable insights across core business functions—Finance, Sales, Marketing, and Supply Chain.

🛠️ Tools Used:
SQL | Power BI | Power Query | DAX | DAX Studio | Excel | PowerPoint | OBS Studio

🔍 Project Highlights
✅ Built a Star Schema data model integrating SQL + Excel
✅ Developed 6 interactive dashboards covering Net Sales, GM %, Net Profit %, Forecast Accuracy, Discount Impact, and Unit Economics
✅ Used Power Query for transformation, DAX for KPIs, and DAX Studio for optimization
✅ Published to Power BI Service with auto-refresh via On-Prem Gateway
✅ Presented findings through a professional slide deck and walkthrough video

Project video

Live Interactive Dashboard

Excel Project

AtliQ Hardware Sales & Finance Analytics

Domain/Function: B2B2C Consumer Electronics Distribution

This project combines Sales and Finance Analytics to provide a 360° view of business performance from 2019–2021 for AtliQ Hardwares. Created using Microsoft Excel with Power Query, Power Pivot, DAX, and Pivot Tables.

View Project
Engagement

View Project
on GitHUB

Displays Net Sales trends for 40+ customers from 2019 to 2021. Identifies high-growth accounts like Amazon (+118.87%) and AtliQ Exclusive

Tracks Net Sales, COGS, Gross Margin, and GM% across countries. Year-over-year comparison reveals key financial trends and operational efficiency.

Project Details

AtliQ Hardware Sales & Finance Analytics 📊💼
A complete Excel-powered project presenting Sales and Finance Analytics Reports for AtliQ Hardwares, created using Power Query, Power Pivot, Pivot Tables, and DAX. This report provides stakeholders with actionable insights into revenue trends, profitability, and market performance across time, region, and products.

🚀 Project Overview
This merged report brings together:
📈 Sales Analytics: Uncovers growth, top products, market targets, and customer performance.
💰 Finance Analytics: Offers deep financial insights including Net Sales, COGS, Gross Margin, and GM%.
Built using Excel’s advanced features such as Power Query for ETL, Power Pivot for data modeling, and DAX for creating key measures.

🧰 Tools & Technologies Used
Excel Power Query
Power Pivot
Pivot Tables & Charts
Filters & Slicers

PowerBI Project

Shopeasy Marketing Analytics

Domain/Function: E-Commerce

A data-driven Marketing Analytics project for ShopEasy, using SQL, Python, and Power BI to optimize conversion rates, boost customer engagement, and improve feedback insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Python

Power BI dashboard showing conversion, engagement trends, and customer ratings at a glance.

Star schema data model linking customers, products, reviews, and engagement for clear analysis.

Project Details

Marketing Analytics Project ShopEasy

🚀 Project Overview
ShopEasy, an online retail business, was facing declining customer engagement and conversion rates despite multiple marketing campaigns. This Marketing Analytics project was developed to identify performance gaps and deliver actionable recommendations using data.

🎯 Business Challenges
Reduced engagement: Fewer interactions with content and site
Falling conversion rates: Fewer visitors turning into customers
High marketing costs with poor ROI
Lack of clarity on customer feedback trends

🛠️ Tools Used
SQL for data extraction and transformation
Python for data analysis and sentiment breakdown
Power BI for interactive dashboards

📌 Conclusion
This data-driven solution helped pinpoint key marketing weaknesses and recommended optimizations that could significantly improve ShopEasy’s customer experience, engagement, and revenue performance.