Portfolio - Rohit Deshmukh | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Rohit Deshmukh

Data Analyst

EMAIL

[email protected]

PHONE

+91 7083352725

Download CV

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.

1

Excel Project

1

PowerBI Project

1

SQL Project

Key Skills

Power Bi

SQL

Advanced Excel

Communication Skills

Problem Solving Skill

My Projects

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 Work Together!

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.

EMAIL

[email protected]

Call Me

+91 7083352725

LinkedIn

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

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

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.