Portfolio - Rahul Dhawas

Excel Project

Sales Analytics & Finance Analytics Project (FMCH)

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

Sales Analytics & Finance Analytics Project (FMCH)

The Customer Performance Report displays the yearly net sales performance for each customer.

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets

Project Details

In this project, I have created a sales report utilizing Excel pivot tables. This report serves as a valuable tool for businesses to determine optimal customer discounts, streamline negotiation processes, and identify opportunities for expanding into promising markets. The reports I've crafted offer actionable insights to assist businesses in enhancing their sales strategies, enhancing customer satisfaction, and increasing revenue.
Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into sales-related metrics
Overall, this project revolves around equipping businesses with the tools and knowledge necessary to enhance their sales efforts. By delving into sales data, businesses can uncover

PowerBI Project

AtliQ- Business Insights-360

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, Excel, DAX Studio.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page to toggle between different views to get insightful information

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

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Grands-Hospitality Analytics

This project serves as a prime example of how data can bring about a significant transformation and enhancements in the hospitality sector. It accomplishes this by deep diving into essential metrics like Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, DSRN, and more.

View Project
Engagement

View Project
on GitHUB

Designing Ket metrices View to provide users with key part of our dashboard to draw some insights.

This page shows the Occupancy and Average key metrices form cities(Bangalore)

Project Details

AtliQ Grands, renowned for its chain of five-star hotels across India, boasts an enriching of 2 decades in history of the hospitality sector. Nevertheless, they are currently grappled with diminishing market share and revenue in the luxury and business hotel segment, attributed to competitive pressures and less effective management choices. In response to this challenge, the managing director of AtliQ Grands is embarking on a strategic initiative to integrate "Business and Data Intelligence" into their operations. The primary aim is to recapture market share and bolster revenue.
ACHIEVED OBJECTIVES
1. Formulated metrics in accordance with the provided metric list.
2. Designed a dashboard aligning with stakeholder-provided mock-up.
3. Leveraged Power BI
4. Employed SQL
5. Harnessed Excel
6. Utilized DAX Studio

Project video

Live Interactive Dashboard

PowerBI Project

car_sales-data-analysis

Our company is a car dealership that sells various car models. To track and analyze our sales performance we need a comprehensive sales dashboard in POWER BI.The objective of this project is to design and develop dashboard which hold important KPI's related to our car sales.

View Project
Engagement

View Project
on GitHUB

In this Dashboard important KPI's are shown above which provides knowledge about car sales, car price, and cars sold.

In this Dashboard important customer report is shown above which has details about their car_id,dealer name, colour, model..

Project Details

Project Overview:

The Multi-Dealer Car Sales Platform is an innovative initiative designed to streamline and optimize the process of selling cars through a network of various independent dealers. This project aims to create a centralized, digital ecosystem that facilitates seamless interactions between a primary car dealership and its network of affiliated dealers, enhancing efficiency, transparency, and customer satisfaction.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

Using SQL queries, I successfully addressed 10 ad-hoc requests, transforming data into a strategic asset for Atliq's success. Leveraging SQL, Excel, and PowerPoint, I uncovered key insights, including a notable increase in unique products, the dominance of the 'Notebook' segment, and significant sea

View Project
Engagement

View Project
on GitHUB

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

Line chart is the output of sql query of screenshort 1 for visualizing monthly sales trends

Project Details

In the "Consumer Goods Domain" project, I worked on Atliq Hardware's database, addressing the challenge of data-driven decision-making by responding to ten ad-hoc requests to extract actionable insights.

Key findings included a substantial increase in unique products, a dominant 'Notebook' segment, a thriving 'Accessories' category, seasonal sales trends, and the crucial role of the 'Retailer' channel.

This project highlighted the transformative potential of data analytics in guiding decisions, revealed the dynamic nature of the consumer goods market, underscored the importance of product diversity and seasonality awareness, and illustrated the impact of distribution channels on sales performance.

Through this project, I enhanced my data analysis, problem-solving, and communication skills, significantly contributing to my professional growth as a data analyst.

Hello, I am

Rahul Dhawas

1

3

1

About

Key

My

Sales Analytics & Finance Analytics Project (FMCH)

AtliQ- Business Insights-360

AtliQ Grands-Hospitality Analytics

car_sales-data-analysis

Consumer Goods Analytics

Contact Me

Email

Github

Linkedin

Call

Rahul Dhawas

Download Resume