Portfolio - Rohit Deshmukh | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

Rohit Deshmukh

Data Analyst

Resume

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

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.

Business Insights 360

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.

Consumer Goods Insights

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.

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

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals

Contact Me

Email

[email protected]

Github

https://github.com/Rohit-Deshmukh6

Linkedin

https://www.linkedin.com/in/rohit-deshmukh-rd/

Call

+91 7083352725

Rohit Deshmukh

Data Analyst

Download Resume

Resume

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

Sales and Finance Analytics

Customer wise Net Sales Performance

Sales and Finance Analytics

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

Business Insights 360

Cover Page

Business Insights 360

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

Consumer Goods Insights

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

Consumer Goods Insights

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.