Amit rai

Data Aspirant

[email protected] +91 7759821454

Resume

Hello, I am

Amit rai.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Hi, I’m an aspiring Data Analyst with a passion for turning data into meaningful insights. I have hands-on experience using Excel, Power BI, SQL, and Python to analyze data, find trends, and create clear reports that help in decision-making.

I have a B.Com degree and currently work as a Content Moderator at Concentrix. While my job has sharpened my attention to detail and problem-solving skills, I discovered my real interest lies in data analysis. Though I haven’t worked in an official data analyst role yet, I’ve completed several business projects that showcase my ability to collect, clean, visualize, and interpret data effectively.

I love solving problems with data and constantly improving my skills. My goal is to help businesses make smarter decisions with data-driven insights.

Check out my work and see how I turn data into stories!

Key Skills

Effective communicatino

Stakeholder Mangement

PowerBi

Ms Excel

Problem Solving

Mysql

My Projects

Sales Analytics(FMCG)

Domain/Function: FMCG

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

Domain/Function: Brick & Mortar and E-commerce

Consumer Goods: Ad-Hoc Insights

Domain/Function: Consumer Goods | Executive Management

AtliQ Grands Hospitality Analysis

Domain/Function: Hopitality

Atliq Grands Hospitality Analysis

Domain/Function: Hopitality

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

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/amit-rai-56303a235

Call Me

+91 7759821454

GitHub

https://github.com/rai28968

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

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

View Project
Engagement

View Project
on GitHUB

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 created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

PowerBI Project

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

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

User-empathetic landing page as a part of dashboard design

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. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

SQL Project

Consumer Goods: Ad-Hoc Insights

Domain/Function: Consumer Goods | Executive Management

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

list of markets in which customer "Atliq Exclusive" operates its business in the APAC region

percentage of unique product increase in 2021 vs. 2020

Project Details

Title: Ad-Hoc Insights

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task: As a hypothetical applicant, I:

Reviewed 'ad-hoc-requests.pdf' with 10 business queries.
Crafted and executed SQL queries.
Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Employed Power BI for impactful visualizations. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and soft skills.

PowerBI Project

AtliQ Grands Hospitality Analysis

Domain/Function: Hopitality

AtliQ Grands faces declining market share and revenue from competitive pressures and management decisions. This project aims to revitalize the business with hospitality analytics, providing vital metrics like ADR, RevPAR, Occupancy%, and more for informed decision-making.

View Project
Engagement

View Project
on GitHUB

This is the main dashboard showcasing key performance metrics and insights

This dashboard displays data exclusively for the month of May 2022.

Project Details

To address this issue, the management outsourced analytics services to extract actionable insights from their historical data. As a Data Analyst, I was tasked with designing a dashboard and providing business intelligence that could help the leadership team regain competitive advantage.

Project Goals
Analyze hotel performance and revenue metrics.

Develop a professional Power BI dashboard based on stakeholder requirements.

Create key business KPIs using DAX and Power Query.

Identify patterns and trends to support strategic decisions.

Key Metrics Implemented
ADR (Average Daily Rate)

RevPAR (Revenue Per Available Room)

Realisation % (Checkout Success Rate)

DBRN / DSRN / DURN (Room Night Metrics)

WoW Change % for all major KPIs

Live Interactive Dashboard

Python Project

Atliq Grands Hospitality Analysis

Domain/Function: Hopitality

This project is a detailed data analysis case study for Atliq Grands, a hospitality group facing challenges with market competition and declining revenue. Using Python, I performed a full-cycle data analysis to uncover insights that could support strategic decisions and enhance performance across ho

View Project
Engagement

View Project
on GitHUB

View Project
on

Other Tools

Python

Jupyter Notebook

Pandas

As shown on this page, the dataset used for analysis

This is the table information

Project Details

This project presents a comprehensive data analysis for Atliq Grands, a hospitality group facing revenue decline due to market competition. Using Python, I performed data cleaning, exploration, and visualization to uncover strategic insights. Key findings include: “Others” was the top booking source by volume and revenue, Atliq Exotica generated the highest hotel revenue, and Delhi had the highest occupancy rate in June (62.47%). Tools used include Pandas, Matplotlib, and Seaborn. The project showcases my ability to translate raw data into actionable insights for business growth.