Portfolio - Krishan Kumar

Hello, I am

Krishan Kumar

A Data Analyst

About Me.

Welcome to my portfolio🙋‍♂️ I’m a data analyst with a passion for finding insights that help businesses grow. Armed with a B.Sc. in Mathematics, I’ve explored the world of data analysis. Using tools like Excel, PowerBI, SQL, and Python, I uncover valuable insights that drive business success.

You'll often find me on LinkedIn, where I share my learnings with over 13k followers and learn from the best in the biz
Despite being new to the professional world, I've already completed several exciting business projects. You can explore them in my portfolio below. Each project shows my dedication to mastering data analysis and making a difference.

I'm eager to collaborate with others and use my data skills to make a real impact. Let's transform data into action together.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

Skills.

Presentation Skills

Advanced Excel

Power Bi

MySQL

Dashboard Designing

Python

Projects.

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

Python: Beginner to Advanced For Data Professionals

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

Microsoft Excel - Excel from Beginner to Advanced

Contact.

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

GitHub

https://github.com/KRISHANKUMARPRAJAPAT

PowerBI Project

Business Insights 360

Domain/Function: Retail & E-commerce

AtliQ Hardware, a rapidly growing consumer electronics company, is struggling to compete with others due to its relianc on Excel for reporting. My goal is to implement an advanced analytics solution using Power BI to provide the company with valuable insights and support data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

This is the homepage of business insights 360. this overview dashboard acts as the navigation Canter providing quick access to key insights.

The executive view is the most important and critical section of our dashboard designed for top level Executives including CEOs

Project Details

Problem Statement: The AtliQ recently lost money because they opened a store in America without enough info. Their Competitors have smart teams they use data for decisions. Now, AtliQ hardware wants to make its own team to use data for smater choices and survive in the industry.
Goals to achieve: The Company aims to look at data form different department, make important metrics and visuals, make an easy-to-use dashboard for AtliQ Hardware team. The goal is to use data to make smart choices, help the current products, so that they can open new stores in upcoming quarters.
💼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

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Domain/Function: Hospitality

This project exemplifies the impactful role of data in revolutionizing the hospitality sector. It explores key metrics such as Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, DSRN, and more, showcasing the sector's transformation through data-driven insights.

View Project
Engagement

View Project
on GitHUB

Executive View provides top-level executives with a concise overview of critical metrics such as revenue, occupancy %, and ADR, facilitating informed.

This booking insights Delve into booking trends, cancellation rates, and class room distributions. Uncover hidden patterns and optimize strategies for

Project Details

AtliQ Grands, a prominent player in India's five-star hotel industry with a distinguished 20-year legacy, faces challenges in market share and revenue in the luxury and business hotel segment. This decline is attributed to competitive pressures and management decisions. To address this, the managing director has initiated a strategic project to integrate "Business and Data Intelligence" into their operations, aiming to regain market share and boost revenue.

Key Achievements:
- Defined relevant metrics.
- Created a dashboard based on stakeholder requirements.
- Extracted valuable insights beyond the initial scope.

Key Skills:
- Proficiency in Power BI for data visualization.
- Expertise in SQL for data querying and manipulation.
- Advanced Excel skills.
- Utilization of DAX Studio for advanced data analysis.

Project video

Live Interactive Dashboard

Excel Project

Sales Analytics(FMCG)

Domain/Function: Retail & E-commerce

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

View Project
on GitHUB

This report give insights about Market Performance VS Target for the AtiQ Hardwares

This report is give insights about P&L by Financial Year by division wise.

Project Details

In this project, I developed a sales report using Excel pivot tables to help businesses determine effective customer discounts, support negotiations with consumers, and identify potential expansion opportunities in promising countries. The generated reports provide actionable insights and recommendations, enabling businesses to optimize their sales strategies, improve customer satisfaction, and maximize revenue.

Throughout the project, I gained proficiency in the following areas:

➡️Pivot Tables
➡️Power Query
➡️Basic DAX
➡️Conditional Formatting
➡️Report Beautification
➡️Sales Domain Metrics

Overall, this project aims to equip businesses with the essential tools and insights needed to monitor, assess, and improve their sales performance. By utilizing sales data analysis, companies can uncover new opportunities, drive growth, and maintain a competitive edge in the ever-evolving market.

SQL Project

Ad-Hoc Insights - Consumer Goods Domain

Domain/Function: Manufacturing

Executed ad hoc SQL queries on a consumer goods dataset with 1M+ records to uncover sales trends, customer preferences, and inventory insights. Utilized advanced SQL techniques like joins, CTEs, and window functions to deliver actionable insights, enabling data-driven decision-making for FMCG.

View Project
Engagement

View Project
on GitHUB

These are the Ad Hoc Requests that are given to solve

Ad-Hoc Requests along with Output & Visualization

Project Details

In the Consumer Goods Analytics project,our goal was to provide decision-makers with actionable insights to boost sales. Our main tasks included:

- Performing detailed data queries
- Supporting strategic decision-making
- Improving overall sales performance

Through this project, I gained the following skills:

1. SQL Data Querying: Executing complex queries to answer various business questions.
2. Data Interpretation and Strategic Support: Analyzing data to help make informed strategic decisions.
3. Effective Visualization Selection: Choosing the best visual tools to clearly present data.
4. SQL Solution Implementation: Applying SQL solutions effectively in a business environment.
5. Sales Metrics Analysis: Conducting thorough analyses of important sales metrics to guide decision-making.

Project video

Python Project

Hotel Data Analytics

Domain/Function: Hospitality

This Project is All about the Hotel Data Analysis we are using this imaginary company called AtliQ Grants for this project. Now this company is a hotel chain, which operates in various cities in India. They have hotels in four cities

View Project
on GitHUB

Starting the Project Hotel Data Analysis Of AtliQ Grant it is hotel chain Staring the importing required Libraries the started to explore the data

Analysing the data of AtliQ grant the hotel and here some graphs that shows some insights from the data

Project Details

They have hotels in four cities Dehli Mumbai Bangalore and Hyderabad and they have been in the industry for around 20 years. Now, they have
different types of hotels such as AtliQ season Exotica Bay & Palace. For example AtliQ Palace is a luxurious portal.

There are other Hotels such as Seasons which are in business category and they have different type of rooms, you know.

Hundred Allied premium presidential Etc. Now a person can book a hotel. Why are various medium? So number one is at

AtliQ grants own website. So you can go to their website and book a room there. You can also go to third party booking websites
such as make your trip and so on a booking happens through variety of mediums that data

will go into AtliQ grants booking database and from this database we want to now perform

data analysis because this company actually grants is facing a major Challenge from their competitors. They're losing their revenue their market

PowerBI Project

Shield Insurance

Domain/Function: Insurance

this is an Internship Project at Atliq Technologies: Here I delivered a dashboard addressing client queries, featuring General, Sales, and Customer views. Enhanced data visualization for better insights and decision-making within the organization.

View Project
Engagement

View Project
on GitHUB

This general view provides comprehensive insights into the business. here I added new card visuals with animation, line charts, bar chart, table.

This sales view gives insights about how shield insurance company's customers perform monthly.

Project Details

This internship project at Atliq Technologies involved creating a dashboard to provide insights and recommendations for a client. The client struggled with analyzing market trends, customer interactions, and feedback, and needed data to support branch expansion and strategic planning.

The dashboard includes three views:
-> General View: Provides an overview of business and customer growth.
-> Sales View: Highlights key KPIs essential for understanding policy sales and revenue.
-> Customer View: Offers insights into customer growth, age group performance, and areas for improvement.

Additionally, I provided four insights and four recommendations to guide the client in developing a strategic approach for market leadership.