Ravi kushwaha

Data Analyst

[email protected] +91 7781996222

Resume

Hello, I am

Ravi kushwaha.

2

Excel
Projects

1

SQL
Project

1

PowerBI
Project

About Me

Hello! I'm Ravi Raims, a final year student of M. Sc. Data Science.
I'm actively honing my skills in data analysis tools in Excel, PowerBI, MY SQL, and Python to harness the power of data and drive informed decisions.
Why Choose Me?
📊 Analytical Mindset: My background in data science has equipped me with a sharp, analytical mindset, allowing me to approach complex problems with precision and clarity.
🛠️ Data Tools Enthusiast: I'm dedicated to mastering the latest data analysis tools, ensuring I stay at the forefront of industry trends and best practices.
🧮 Problem-Solver: I thrive on solving real-world challenges through data-driven solutions, consistently seeking innovative ways to optimize processes.
🔍 Detail-Oriented: My keen attention to detail ensures accurate data interpretation and reporting, enabling confident decision-making.
🌟 Passion for Growth: I'm driven by continuous learning.

Key Skills

SQL

PYTHON

My Projects

Sales Analytics(FMCG)

Consumer Goods Analytics

Adventure Works Sales Report

Atliq Store Report 2023

Awards & Certificate

SQL For Data Science

Data Visualisation: Empowering Business with Effective Insights

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/ravi-raims-21559422b/

Call Me

+91 7781996222

GitHub

https://github.com/raimsravi

Excel Project

Sales Analytics(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.

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.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

SQL Project

Consumer Goods Analytics

I used SQL to answer 10 quick data requests, helping Atliq steer towards success with data-driven decisions. Some key findings were an increase in unique products, the dominance of the 'Notebook' segment, and noticeable seasonal sales trends.

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

Project Details

In the "Consumer Goods Domain" project, I worked with the Atliq Hardwares database to help make data-driven decisions. I tackled ten quick data requests to find useful insights.

I discovered a significant increase in unique products, a strong performance in the 'Notebook' segment, and growth in the 'Accessories' category. I also found that sales vary by season and that the 'Retailer' channel is crucial for sales.

This project taught me how powerful data analytics can be for making informed decisions. I learned about the changing nature of the consumer goods market, the importance of having a variety of products, the impact of seasonal trends, and the key role of distribution channels in sales.

Working on this project improved my skills in data analysis, problem-solving, and communication, helping me grow as a data analyst.

PowerBI Project

Adventure Works Sales Report

I have shared the Adventure Works Cycles Report, created using Power BI to analyze detailed data on clients, products, sales, returns, and regions. This interactive dashboard monitors key metrics, visualizes regional performance, and forecasts trends, aiding data-driven decisions. Special tha

Exes Dashboard

Customer Detail

Project Details

I’m excited to present the Adventure Works Cycles Report, where I utilized Power BI to analyze data from the Adventure Works Cycles bicycle company. This dataset includes detailed information on clients, products, categories, subcategories, sales, returns, and geographical areas. The company needed to monitor crucial metrics like sales, revenue, profit, and returns. They also aimed to compare regional performance, analyze product-level trends and projections, and identify high-value clients.

To address these needs, I used Power BI’s powerful visualization and analysis features to create an interactive storytelling dashboard. This dashboard effectively tracks and compares key metrics, offering a dynamic way to visualize regional differences, forecast sales trends, and identify valuable customers. The insights provided by the dashboard support the company in making data-driven decisions and strategic planning.

Excel Project

Atliq Store Report 2023

ATLIQ SALES Final Report

Order vs Sales Report

Project Details

This project contains data analysis & sales presentation of the annual report of ATLIQ STORE for the year 20223
This project aims to gain insights into the company's financial performance and key metrics,
So that ATLIQ stores can understand their customer's behaviour and grow more sales in 2024.

Steps Followed:
✔ Understanding the data
✔ Data cleaning
✔ Data Processing
✔ Using PIVOT table for Analysis
✔ Creating Dashboard

💡Insights:
1)Women are more likely to buy compared to men( ⁓ 65%).
2)Maharashtra, Karnataka and Uttar Pradesh are the top 3 states (⁓ 35%). 3)Adult age group (30-49yrs) is max contributing
4)Amazon, Flipkart and Myntra channles are max contributing(⁓80%).

Final Conclusions:
Target women customers of age group (30-49 yrs) living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, Flipkart and Myntra.