Krishn Kumar Rathore

Junior Data Analyst

[email protected] +91 9179908171

Resume

Hello, I am

Krishn Kumar Rathore.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About Me

👋 Hello and welcome to my portfolio!

I'm Krishn Kumar Rathore, a dedicated data analyst with a passion for transforming complex data into clear, actionable insights. With expertise in Excel, Power BI, SQL, and Python, I tackle data challenges and deliver impactful solutions.

Why Choose Me?

📊 Analytical Mindset: My background in mathematics enables me to approach problems with precision and clarity.

🛠️ Data Tools Expert: Proficient in the latest data analysis tools, I create compelling dashboards and extract valuable insights.

🌟 Continuous Learner: I'm always expanding my skills and staying updated with industry best practices.

Experience:

- Data Analyst Internship at AtliQ Technologies: Gained hands-on experience with real-world datasets, delivering dashboards that translate data into actionable insights.

I'm seeking opportunities to apply my skills and contribute to organizational growth. Let's connect and see how I can help you make data-driven decisions!

Key Skills

SQL

PYTHON

PRESENTATION

Tableau

My Projects

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

AtliQ- Business Insights--360

Domain/Function: Bussiness

Shield Insurance

Domain/Function: Sales

Consumer Goods Analytics

Domain/Function: Consumer Goods

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

Call Me

+91 9179908171

GitHub

https://github.com/Krishn9779

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
on GitHUB

The P & L Report displays the Profit and Loss values for each customer. by their fiscal years.

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

Domain/Function: Bussiness

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

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

POWER BI

EXCEL

DAX STUDIO

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

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

Live Interactive Dashboard

PowerBI Project

Shield Insurance

Domain/Function: Sales

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

Other Tools

POWER BI

SQL

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

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.

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

Domain/Function: Consumer Goods

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

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

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

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.