Powered by
Codebasics DA Bootcamp

Khushboo Rani

Data Analyst

[email protected]

Resume

Hello, I am

Khushboo Rani.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

👋 Hello! I'm Khushboo Rani
A passionate data enthusiast with a strong foundation in mathematics, actively developing expertise in Excel, Power BI, MySQL, and Python to transform data into actionable insights.

Why Choose Me?
📊 Analytical Mindset: Mathematics background enables precise problem-solving and clear analysis.
🛠️ Skilled in Data Tools: Proficient in the latest analytics tools and committed to staying ahead of industry trends.
🧮 Problem-Solver: Tackles real-world challenges with innovative, data-driven solutions.
🔍 Detail-Oriented: Ensures accurate interpretation and reporting for confident decision-making.
🌟 Passion for Growth: Driven by continuous learning and professional development.

Key Skills

SQL

Stakeholder Management

Effective Communication

Problem Solving

Power BI

Excel

My Projects

Awards & Certificate

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

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Tata - Data Visualisation: Empowering Business with Effective Insights Job Simulation

Tata - Data Visualisation: Empowering Business with Effective Insights Job Simulation

Accenture North America - Data Analytics and Visualization Job Simulation

Accenture North America - Data Analytics and Visualization Job Simulation

PwC Switzerland - Power BI Job Simulation

PwC Switzerland - Power BI Job Simulation

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]

http://www.linkedin.com/in/khushboo-rani-

https://github.com/kr914?tab=repositories

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The Customer Performance Report displays the yearly net sales performance for each customer.

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Project Details

In this project, I have created a sales report utilizing Excel pivot tables. This report serves as a valuable tool for businesses to determine optimal customer discounts, streamline negotiation processes, and identify opportunities for expanding into promising markets. The reports I've crafted offer actionable insights to assist businesses in enhancing their sales strategies, enhancing customer satisfaction, and increasing revenue.
Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into sales-related metrics
Overall, this project revolves around equipping businesses with the tools and knowledge necessary to enhance their sales efforts. By delving into sales data, businesses can uncover growth.

PowerBI Project

AtliQ- Business Insights--360

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, Excel, DAX Studio.

View Project
Engagement

View Project
on GitHUB

AtliQ- Business Insights--360

Data Modelling involving 10+ tables

AtliQ- Business Insights--360

Designing a landing page that connects with users, making it an essential part of our dashboard.

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
📣Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends,revenue by division and channel, top 5 customer

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ--Hospitality Analytics

This project serves as a prime example of how data can bring about a significant transformation in the hospitality sector. It accomplishes this by delving into essential metrics like Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, DSRN, and more.

View Project
Engagement

View Project
on GitHUB

AtliQ--Hospitality Analytics

Atliq Grands hotel chain classification

AtliQ--Hospitality Analytics

Designing a landing page that users connect with, making it a key part of our dashboard

Project Details

AtliQ Grands, renowned for its chain of five-star hotels across India, boasts a rich 20-year history in the hospitality sector. Nevertheless, they currently grapple with diminishing market share and revenue in the luxury and business hotel segment, attributed to competitive pressures and less effective management choices. In response to this challenge, the managing director of AtliQ Grands is embarking on a strategic initiative to integrate "Business and Data Intelligence" into their operations. The primary aim is to recapture market share and bolster revenue.
ACHIEVED OBJECTIVES
1. Formulated metrics in accordance with the provided metric list.
2. Designed a dashboard aligning with stakeholder-provided mock-up.
3. Generated valuable insights extending beyond the specified metric list and mock-up dashboard.
UTILIZED SKILLS
4. Leveraged Power BI
5. Employed SQL
6. Harnessed Excel
7. Utilized DAX Studio

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

Using SQL queries answered 10 ad-hoc requests, making data the compass for Atliq's journey to success. SQL, Excel, and PowerPoint tools are used.Key insights included a significant increase in unique products, a dominant 'Notebook' segment and seasonal sales trends

View Project
Engagement

View Project
on GitHUB

Consumer Goods Analytics

SQL query for the monthly sales amount report for the customer 'ATLIQ EXCLUSIVE'

Consumer Goods Analytics

Line chart for output of sql query of screenshort 1 for visualizing monthly sales trends

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. 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 consumer goods market's dynamic nature, 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.

Project video

Python Project

Hotel Domain Analysis Using Python

Atliq Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower Atliq Grands with insights for customer retention and revenue growth.

View Project
Engagement

View Project
on GitHUB

Hotel Domain Analysis Using Python

Crafted average rating per city and pie chart of revenue per booking platform.

Hotel Domain Analysis Using Python

Crafted a table of average occupancy rate per city.

Project Details

In this project , I performed the following operations to get insights.
1. Data Cleaning- Handling missing values and outliers.
2. Data Transformation - Added occupancy% columns.
3. Insights generation-key questions answered
#calculating average occupaancy rate by room type and city.
# Identifying occupancy rate on weekdays and weekends.
# Analyzing revenue generated per city.
# Analyzing monthly revenue trends.
# Assessing revenue by booking platforms.

Project video

PowerBI Project

Shield Insurance

Explored Shield Insurance customer behavior & sales trends using Power BI in a data analytics bootcamp by Codebasics. Completed an end-to-end project during my data analytics internship, analyzing provided CSV files.

View Project
Engagement

View Project
on GitHUB

Shield Insurance

This general view provides a snapshot of revenue and customer trends, enabling exploration of key insights.

Shield Insurance

Age Group Analysis view offers monthly customer trends, sales mode distribution, policy preferences, settlement percentages,& customer distribution.

Project Details

Employed Power BI for an in-depth analysis of Shield Insurance. Explored revenue, customer behavior, city trends, sales modes, and age group dynamics. Generated a comprehensive report leading to strategic decisions and actionable recommendations. Contributed to an 8-10% revenue growth projection and expanded market presence via data-driven insights.

Project video

Live Interactive Dashboard