Khushi Jain

Data Analyst

[email protected] +91 6375206808

Hello, I am

Khushi Jain.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

A data analyst with a blend of business acumen and technical expertise. My journey began in retail, where I optimized KPIs, sales metrics, and inventory strategies while leading a team of 10. Witnessing the power of data in decision-making, I transitioned into analytics, leveraging my MBA in Marketing with Excel, Power BI, and SQL to uncover insights that drive business growth.

I specialize in data storytelling, interactive dashboards, and process optimization, transforming complex datasets into clear, actionable intelligence that fuels strategic success.

A lifelong learner, I work on real-world projects to refine my skills. Beyond data, I explore new technologies, take on innovative projects, and stay curious.

🔹 Let’s connect and explore data-driven possibilities!

Key Skills

SQL & Data Analysis

Power BI & Dashboarding

Data Cleaning

Business Intelligence & Metrics

Stakeholder Communication

My Projects

Myntra's Data Analysis Using Python

Domain/Function: E-Commerce

Codex Marketing Insight

Domain/Function: Food and Beverage Industry

Consumer Goods Ad- Hoc Insights

Domain/Function: Consumer Goods Domain

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

Domain/Function: Consumer Electronics Industry

Sales And Finance Analytics

Domain/Function: Consumer Electronics Industry

My Experience

Trainee Assistant Store Manager | Aditya Birla Fashion and Retail Limited | Mumbai, Maharashtra (July 2023 - April 2024)

Led a team of 10, optimizing staffing schedules based on peak sales hours, tracking store and individual KPIs, and enhancing operational efficiency by 10%.
Conducted deep-dive sales analysis, ensuring data quality, and identified sales trends and peak shopping hours and high-demand products. This led to optimized inventory planning, improved metrics tracking, and a 15% reduction in overstock, resulting in enhanced data visualization for improved decision-making.
Utilized stock-on-hand (SOH) reports to detect underperforming categories, implementing data-driven merchandising adjustments that doubled the men's department’s contribution to total sales in two months.
Developed and automated dynamic sales performance reports (daily, weekly, and monthly) using advanced Excel formulas and visualization tools, streamlining reporting and accelerating decision-making for senior management.

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

Tableau Mini

Myntra's Data Analysis Using Python

The Art Of User Centric Power BI Dashboards

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/khushijain0126/

Call Me

+91 6375206808

GitHub

https://github.com/Khushi-Jain0126

Python Project

Myntra's Data Analysis Using Python

Domain/Function: E-Commerce

This project analyzes Myntra's e-commerce data to uncover customer behavior trends, product performance, and revenue drivers. Using Python, it delivers actionable insights—optimizing discount strategies, identifying high-value customers, and refining regional sales approaches to maximize profits.

View Project
Engagement

View Project
on GitHUB

The image shows a Jupyter Notebook analyzing sales ,customer behavior, exploring brand revenue, discounts, AOV, and customer segmentation using Python

The image shows an Excel workbook containing data from dim_products, dim_customers, and fact_orders sheets.

Project Details

Approach & Tech Stack:
Used Python (Pandas, NumPy) to analyze Myntra’s e-commerce sales. Leveraged Matplotlib & Seaborn to visualize top brands, discount efficiency, and regional sales. Segmented customers to assess revenue patterns across weekdays vs. weekends.

Key Insights & Business Impact:
✔ Top Brands Drive Revenue – Puma, H&M, Roadster, Adidas, and Here&Now dominate. Action: Prioritize inventory & marketing.
✔ Customer Retention Boosts Profits – Top 10% contribute 12.57% of revenue. Action: Implement loyalty programs.
✔ Optimal Discounts Maximize Sales – 30-40% range generates ₹918K+. Action: Fine-tune pricing for profitability.
✔ Sales Timing Insights – Weekday revenue (₹1.31M) is 2.3x weekends. Action: Optimize ad spend & promotions.
✔ Regional Focus – Bengaluru, Ahmedabad, Vadodara, Prayagraj, and Patiala lead sales. Action: Improve location-based strategies.

Outcome:
Improved profitability, retention, and smarter data-driven decisions.

PowerBI Project

Codex Marketing Insight

Domain/Function: Food and Beverage Industry

CodeX aimed to grow in India by understanding consumer preferences and market trends. Analyzed 10,000 survey responses in Power BI to uncover insights on demographics, consumer behavior, competitor gaps, and marketing channels for effective strategy and targeted growth opportunities.

View Project
Engagement

Overview of demographics, consumer behavior, competitor analysis, channel performance, and strategic insights

Explore target audience, brand perception, marketing channels, consumer engagement, purchase behavior, and key improvement opportunities.

Project Details

Project Overview:
Developed a Power BI dashboard for CodeX to analyze 10,000 survey responses, delivering actionable insights across marketing and product strategy. Focused on data transformation, interactive visualization, and strategic reporting to drive decision-making.

Key Focus Areas:

Data Transformation: Cleaned and processed large datasets, ensuring accuracy.
Interactive Visualization: Designed dashboards to showcase demographics, behavior, and brand perception.
Strategic Reporting: Generated insights to optimize growth and packaging strategies.
Key Learnings:

Mastered data transformation and cleaning in Power BI.
Learned effective dashboard design for visual storytelling.
Proficient in filtering, slicing, and using cards.
Leveraged interactive visuals to boost engagement.
Communicated complex insights in an actionable format.
Outcome:
Optimized marketing efforts, strengthened brand positioning, and identified growth opportunities in key markets.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad- Hoc Insights

Domain/Function: Consumer Goods Domain

AtliQ Hardware, a leading computer hardware producer in India, struggled with making quick, informed decisions due to a lack of insightful data. This prompted my analysis of over 1 million sales records to uncover actionable insights and drive strategic decisions

View Project
Engagement

View Project
on Canva

Other Tools

Power BI

Canva

User-Centric Presentation: Crafted engaging PPTs using SQL, Power BI, and Canva, making complex insights easy to understand.

Showcased the top 3 products by division using a ribbon chart, along with insights to enhance storytelling and drive impact.

Project Details

Developed a SQL analysis for AtliQ Hardware, a leading computer hardware producer in India, utilizing advanced SQL skills to analyze extensive sales data.

Focus Areas:
1.Advanced Querying: Leveraged complex SQL techniques, including JOINs, subqueries, CTEs, and window functions, on over 1 million records.
2.User-Centric Reporting: Created engaging PowerPoint presentations and interactive dashboards using Power BI and Canva.

Key Learnings:
1. Mastered SQL basics (SELECT, WHERE, BETWEEN, GROUP BY, ORDER BY).
2. Applied various join types (LEFT, RIGHT, INNER, FULL, CROSS) for data integration.
3. Utilized subqueries, CTEs, views, and temporary tables for data manipulation.
4.Gained foundational knowledge of ETL processes and data warehousing concepts.
5. Developed user-defined functions and stored procedures.
6. Employed window functions for advanced analysis.

Outcome: Delivered actionable insights that enhanced decision-making speed, driving strategic initiatives.

PowerBI Project

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

Domain/Function: Consumer Electronics Industry

AtliQ Hardware growing quickly in the competitive electronics market, struggled with outdated Excel reporting. My task was to implement a Power BI solution to modernize their data analytics and provide actionable insights for better decision-making.

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design.

Data modelling involving 10+ tables using snowflake schema

Project Details

Project Overview: Developed a Power BI dashboard for AtliQ Technologies to integrate and analyze data for Sales, Marketing, Finance, and Executive teams. Focused on robust data modeling, user-centric design, and drillable insights.

Key Focus Areas:
1.Robust Data Modeling: Used a snowflake schema with 10+ tables.
2.User-Empathetic Design: Created intuitive, interactive reports.
3.Drillable Insights: Enabled detailed data exploration.

Key Learnings:
1.Advanced Power Query operations.
2.Basic and complex DAX formulas.
3.Data modeling involving 10+ tables.
4.Selecting and formatting visuals.
5.Applying dashboard design principles.
6.Utilizing bookmarks for navigation.
7.Deploying reports to Power BI Service.
8.Implementing stakeholder feedback.
9.Analyzing Sales, Marketing, Finance & Supply Chain metrics.

Outcome: Unified insights enhanced decision-making and operational efficiency.

Live Interactive Dashboard

Excel Project

Sales And Finance Analytics

Domain/Function: Consumer Electronics Industry

Created two comprehensive reports for the sales team, designed to evaluate customer performance and provide insights into market performance in comparison to their targets.

View Project
on Adobe Acrobat

Other Tools

Adobe Acrobat

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

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 designed a sales report using Excel pivot tables to help businesses determine optimal customer discounts, support consumer negotiations, and identify potential opportunities for expansion in high-potential countries. These reports will offer actionable insights and recommendations, empowering businesses to refine their sales strategies, improve customer satisfaction, and boost revenue growth.

Throughout this project, I have gained proficiency in the following key areas:
1. Pivot Tables
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics
The project is designed to equip businesses with the essential tools and insights needed to effectively monitor, evaluate, and improve their sales activities. By leveraging data-driven sales analysis, businesses can uncover new opportunities, drive growth, and maintain a competitive edge in an ever-evolving market.