Ankit Kumar

Data Analyst

[email protected] +91 8077104445

Resume

Hello, I am

Ankit Kumar.

1

SQL
Project

3

PowerBI
Projects

1

Excel
Project

About Me

Hello! I'm Ankit Kumar, a dedicated data analyst proficient in Excel, SQL, Power BI, and Python, I specialize in making complex data easy to understand. I love turning data into practical insights that empower organizations to make informed decisions.

With a keen eye for details, I ensure accuracy in every project, whether it's organizing data, conducting in-depth analysis, or creating dynamic dashboards. Beyond technical skills, I believe in clear communication and teamwork. I enjoy collaborating with diverse teams, making problem-solving a collective effort.

Committed to staying current in the data world, I bring a broad understanding of computing principles to my work. Excited to contribute my skills to new and exciting projects, I'm ready to help organizations harness the power of data to achieve their goals.

Let's embark on a data-driven journey together and turn challenges into opportunities!

Key Skills

SQL

Python

Power BI

Advance Excel

Pandas

My Projects

Consumer Goods Analytics

Shield Insurance

Business Insights 360

Sales & Finance Analytics

Hospitality Analysis

Awards & Certificate

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Accenture North America - Data Analytics and Visualization 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.

Mail Me

[email protected]

https://www.linkedin.com/in/ankit-kumar-yadav3027

Call Me

+91 8077104445

GitHub

https://github.com/Ankit-KY

SQL Project

Consumer Goods Analytics

AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. Hence, company decided to conduct a SQL challenge.

View Project
Engagement

View Project
on GitHUB

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

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

Project Details

Handled 10 Unexpected SQL Tasks:
Managed a range of immediate SQL requests to help the company make better decisions. Gained a deeper understanding of important SQL concepts like Common Table Expressions (CTE), different ways to join data, and using window functions. Used these skills to work with and analyzed the database information.
Skillfully applying these concepts, I successfully transformed raw data into actionable insights, contributing to a more informed and strategic approach for the company's future endeavors.

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

This general page comprises all aspects of revenue and customer data, including demographic information, sales mode, age group.

This page focuses on various analysis related to the age groups of policy holders. It includes the number of policy holders in each policy.

Project Details

In this project, we embark on a journey to gain a deeper understanding of our customer base and revenue generation at Shield Insurance. We prioritize tracking customer numbers and total revenue, while also closely monitoring daily growth rates for both. This real-time monitoring ensures we stay on course towards our goals.
I've tackled the following aspects:
Understand how many customers they have and how much money they make.
Keep an eye on how fast the money and customer numbers are growing every day.
Looked at how the insurance policies change from one month to another to spot trends and areas to improve.
Sorting the customers by age groups and see which cities and age groups make the most money and have the most customers.
Used filters like sales methods, age groups, cities, months, and policy IDs to analyze our data faster.
Separate page to study how different age groups impact the business - like what policies they prefer and how they settle claims.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

This project aims to streamline and optimize various aspects of AtliQ Hardwres business, including Finance, Sales, Supply Chain, Executive Management, and Marketing. The primary objectives and key achievements for each perspectives.

View Project
Engagement

View Project
on GitHUB

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

Data modelling involving 10+ tables.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team.

● Customized Dashboard: Developed a multi-functional Power BI dashboard to specifically meet AtliQ Hardware's needs, allowing them to gain insights into their various departments.

● Data Integration: Data was sourced from disparate locations, including Excel/CSV files and a MYSQL database, and seamlessly integrated into Power BI for comprehensive analysis.

● Data Model and Visualization: A robust data model was developed within Power BI, enabling the creation of visually appealing and interactive visualizations to represent key performance indicators (KPI's).
● Performance Optimization: The dashboard's performance was significantly improved using DAX studio, resulting in a 5% increase in report efficiency.
● Data-Driven Decisions: AtliQ Hardware can now analyze trends across different department, empowering them to make data-driven decisions.

Live Interactive Dashboard

Excel Project

Sales & Finance Analytics

This project is about sales & finance analysis for AtliQ Hardwares which is a leading company that supplies products such as computer hardware and peripherals to clients across the world. My focus was to create a sales analytics report to analyze company performance in the market for given years.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across 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 aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities.

PowerBI Project

Hospitality Analysis

AtliQ Grands has experienced declining market share and revenue due to competition and management decisions. The project focuses on revitalizing the business by leveraging hospitality analytics to make informed decisions. The dashboard helps the AtliQ Grands management to understand their customers.

View Project
Engagement

View Project
on GitHUB

Dashboard.

Data Modelling.

Project Details

AtliQ Grands, a distinguished chain of five-star hotels in India, proudly celebrates a 20-year legacy in the hospitality industry. However, facing declining market share and revenue in the luxury and business hotel segments due to intense competition and suboptimal management decisions, the managing director has launched a strategic initiative to embed "Business and Data Intelligence" into their operations. This move aims to reclaim market share and boost revenue.

ACHIEVED OBJECTIVES

1. Crafted precise metrics aligned with the provided metric list.
2. Designed an intuitive dashboard based on stakeholder mock-ups.
3. Uncovered actionable insights beyond the specified metrics and dashboard mock-ups.

UTILIZED SKILLS

1. Mastered Power BI for interactive visualizations.
2. Utilized SQL for robust data querying.
3. Harnessed Excel for detailed data analysis.
4. Leveraged DAX Studio for advanced data modeling.