Rohit Deshmukh

Data Analyst

[email protected] +91 7083352725

Resume

Hello, I am

Rohit Deshmukh.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

Hello, I am Rohit , Data Analyst with hands-on experience in SQL, Power BI, and Advanced Excel. Passionate about turning raw data into actionable insights to drive decision-making and solve business challenges. Eager to leverage my skills in data analysis, visualization, and reporting to contribute to impactful projects and grow in the analytics field.

Key Skills

Power Bi

SQL

Advanced Excel

Communication Skills

Problem Solving Skill

My Projects

Sales and Finance Analytics

Domain/Function: Sales and Finance

Business Insights 360

Domain/Function: FMCG

Consumer Goods Insights

Domain/Function: FMCG

My Experience

Worked as a Data Coordinator in Exactus Energy, where I developed visual reports in Excel to provide detailed summaries of Key Performance Indicators (KPIs).

Ensured data accuracy and integrity through data cleaning, error checking, and validation processes.

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

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/rohit-deshmukh-rd/

Call Me

+91 7083352725

GitHub

https://github.com/Rohit-Deshmukh6

Excel Project

Sales and Finance Analytics

Domain/Function: Sales and Finance

Design an analytics system to track sales performance, perform data analysis, and generate detailed reports to optimize customer discounts and identify opportunities for business growth.

View Project
Engagement

View Project
on GitHUB

Customer wise Net Sales Performance

P & L Key Metrics by Quarters

Project Details

In this project, I developed a sales report using Excel pivot tables to help businesses identify effective customer discount strategies, improve consumer negotiations, and uncover potential opportunities for expanding into new markets. The reports generated offer actionable insights and recommendations for optimizing sales strategies, enhancing customer satisfaction, and maximizing revenue growth.

Through this project, I gained expertise in the following areas:

1. Pivot Tables
2. Power Query
3. Basics of DAX
4. Conditional Formatting
5. Report Enhancement and Presentation
6. Sales Domain Metrics Analysis

PowerBI Project

Business Insights 360

Domain/Function: FMCG

AtliQ Hardware aims to address the limitations of outdated data practices, such as relying solely on Excel. This project focuses on delivering an in-depth analysis of data across the Finance, Sales, Marketing, Supply Chain, and Executive sectors to drive smarter decision-making.

View Project
Engagement

View Project
on GitHUB

Cover Page

Marketing View

Project Details

AtliQ Hardware, a global company, is facing financial losses in its Latin American operations due to difficulties in making accurate, data-driven decisions. To closely monitor business operations, and strengthen its competitive position, AtliQ has implemented Power BI for advanced data analytics and more informed decision-making.

Tools/Methods:
● My SQL
● Power BI Desktop
● Power Query
● Snowflake Schema
● DAX
● DAX Studio
● Power BI Service

In addition to developing technical skills, this project provides a comprehensive understanding of key business concepts across various departments and expertise in stakeholder management. These skills are critical for ensuring smooth and productive processes, leading to effective and impactful outcomes.

Live Interactive Dashboard

SQL Project

Consumer Goods Insights

Domain/Function: FMCG

I worked on a project for AtliQ Hardware, a top computer hardware manufacturer in India with a global presence. My role involved handling 10 ad-hoc data requests using SQL to extract and analyze important business data.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

List of markets where a customer "AtliQ Exclusive" operates its business in Asia Pacific (APAC) region.

Monthly trend Gross Sales Amount of customer "AtliQ Exclusive".

Project Details

I used a three-step workflow to deliver ad-hoc insights for AtliQ Hardware in the consumer goods domain:

1. Ad-hoc Query Handling: Managed 10 real-time data requests using SQL techniques like WHERE, GROUP BY, ORDER BY, JOINS, CTEs, and WINDOW FUNCTIONS. Focused on ensuring data accuracy and optimizing query performance.

2. Power BI Visualization: Transformed query results into impactful visualizations in Power BI, utilizing various chart types—bar, pie, map, donut, and line—to present data effectively.

3. Insight Presentation: Shared findings through a video presentation, highlighting key observations and providing actionable recommendations. Ensured insights were clear, concise, and easy to understand for decision-making.

This experience reinforced the value of combining technical skills with effective storytelling to drive meaningful insights.