Portfolio - Rishabh Mohan | Codebasics

Powered by
Codebasics DA Bootcamp

Rishabh Mohan

Data Analyst

EMAIL

[email protected]

PHONE

+91 6280096220

Download CV

About Me

Welcome to my portfolio! I'm Rishabh Mohan, an aspiring Data Analyst with a knack for turning data into compelling stories. With a Bachelor's degree in Computer Science and expertise in Excel, PowerBI, SQL, and Python, I am passionate about transforming raw data into actionable insights.
Though I haven't worked in a traditional organizational setting yet, my portfolio is packed with real-world business projects where I've applied my skills to deliver impactful results. Each project showcases my ability to dive deep into data, uncover trends, and drive strategic decisions.
Explore my work to see how I can bring fresh, data-driven perspectives to your organization. Let's unlock the potential of your data together!

1

Excel Project

2

PowerBI Projects

1

SQL Project

Key Skills

Stakeholder Management

Effective Communication

SQL

Power BI

Python

Advanced Excel

My Projects

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

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

JP Morgan Co. Agile Job SImulation

JP Morgan Co. Agile Job SImulation

Career Essentials in Data Analysis by Microsoft and LinkedIn

Career Essentials in Data Analysis by Microsoft and LinkedIn

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 6280096220

LinkedIn

https://www.linkedin.com/in/-rishabhmohan/

GitHub

https://github.com/Rishabh4303

Excel Project

Sales Analytics

Domain/Function: FMCG

Created 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

Sales Analytics

Customer Performance Report: Provides net sales performance of each customer across years.

Sales Analytics

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.

PowerBI Project

Business Insights 360 Dashboard

Domain/Function: FMCG

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

View Project
on GitHUB

Business Insights 360 Dashboard

User-empathetic landing page as a part of dashboard design.

Business Insights 360 Dashboard

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

PowerBI Project

Hospitality Insights Dashboard

Domain/Function: Hospitality

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels.

View Project
Engagement

View Project
on GitHUB

Hospitality Insights Dashboard

Financial Performance

Hospitality Insights Dashboard

Key Metrics for Property

Project Details

Overview:
Conducted a revenue analysis for AtliQ Grands using Power BI to identify revenue challenges and optimize performance.

Key Actions:
• Data Analysis: Identified key cities contributing to revenue and analyzed a 31% decline in bookings and a 24-25% cancellation rate.
• Dashboard Development: Created Power BI dashboards showing that 40% of revenue came from unorganized sources.
• Strategic Recommendations: Focused on high-value customers, optimized room types, and improved partnerships with booking platforms. Addressed a 28.17% revenue drop in the last 4 days of the month.

Outcomes:
Provided actionable insights and recommendations that helped improve revenue strategies and operational performance.

Skills Utilized:
• Data Analysis
• Power BI
• Strategic Planning
• Revenue Optimization

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights

Domain/Function: Consumer Goods

In this project, I conducted a comprehensive analysis of sales data for Atliq Hardware, a leading computer hardware company, to uncover actionable insights that could drive strategic decision-making.

View Project
Engagement

View Project
on

Ad-Hoc Insights

Some of the Actionable Insights extracted from Ad-Hoc Requests which helps in data-driven decision-making.

Ad-Hoc Insights

Some of the Actionable Insights extracted from Ad-Hoc Requests which helps in data-driven decision-making.

Project Details

- Conducted in-depth sales data analysis for Atliq Hardware, focusing on the Asia Pacific region.
- Utilized Power BI and SQL to identify key market trends and product performance.
- Analyzed a 44% increase in unique products from 2020 to 2021, highlighting growth areas.
- Evaluated discount strategies, identifying Flipkart as a major contributor to sales growth.
- Assessed manufacturing costs to support cost optimization efforts.
- Analyzed sales channels, revealing that Retailer Direct accounted for over 73% of gross sales.
- Enhanced data analysis, presentation skills, and understanding of the consumer goods sector.

* Explore the complete project presentation here: https://drive.google.com/file/d/1Hjoa1rKO0c0t2kAit3_celD6AXHfJtv1/view?usp=sharing