Portfolio - Gaurav Mishra

Excel Project

Sales and Finance Report

This Excel project aims to provide comprehensive insights into the company's financial performance and market positioning through the creation of various reports like "P and L Reports", "Market Performance vs. Target", etc. These reports are designed using both basic & advanced Excel.

View Project
Engagement

View Project
on GitHUB

This report shows Market Performance vs Target for all Divisions and all Regions.

Provides P&L statement categorized by Market and Fiscal Year.

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
7. Power Pivot
8. Pivot Table
9. Advanced Functions like Lookups & Calculate

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

The Business Insights 360 is a powerful dashboard created using Microsoft Power BI. This multi-functional dashboard has been customized to provide AtliQ Hardware with valuable insights into their different departments such as Finance, Sales, Marketing, and Supply Chain.

View Project
Engagement

View Project
on GitHUB

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

Executive View

Project Details

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

📈Financial View: Delve deep into the Profit and Loss statements, analyze the trends in Net Sales Performance, and conduct an examination of top-performing Products and Customers using various criteria.

💼Sales View: Immerse yourself in the performance of both Customers and Products.

📣Marketing View: Uncover insights into Product Performance, and scrutinize Market, Regional, and Customer Performances.

🚚Supply Chain View: Investigate the accuracy of forecasts, Net Errors, Absolute Errors, etc.

🤵Executive view: Integrated view of key insights for executives.

Live Interactive Dashboard

PowerBI Project

Revenue Insights : Hospitality Domain

This project exemplifies the profound impact of data on revolutionizing the hospitality industry through the analysis of key metrics such as Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, DSRN, etc.

View Project
on GitHUB

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

KPI visual cards.

Project Details

AtliQ Grands operates a chain of five-star hotels located throughout India and has a 20-year history in the hospitality industry. However, they are currently experiencing a decline in both market share and revenue within the luxury and business hotel sector due to competition from rivals and ineffective management decisions. To address this situation, the managing director of AtliQ Grands is pursuing a strategic plan to incorporate "Business and Data Intelligence" into their operations to regain market share and increase revenue.

TASKS PERFORMED

Develop metrics as per the provided metric list.
Construct a dashboard based on the mock-up provided by stakeholders.
Generate insightful information that goes beyond what is outlined in the metric list and the mock-up dashboard.

SKILLS APPLIED

1. Power BI
2. SQL
3. Excel
4. DAX Studio

Live Interactive Dashboard

SQL Project

Finance Analytics & Report Generation

This project focuses on Finance Analytics and Report Generation, aimed at providing efficient and customized reporting solutions for critical decision-making. Leveraging SQL, the project streamlines the process by implementing stored procedures, user-defined functions, and optimizing queries.

View Project
on GitHUB

Executing fact_sales_monthly table

Executing fact_gross_price table

Project Details

Key Features:

1. Customizable Reports: Generate reports based on input parameters like in_fiscal_year, in_top_n, and customer_code.
2. Insightful Metrics: Extract key metrics including forecast accuracy, market badge, monthly gross sale for customers, and more.
3. User-Friendly Design: Emphasis on readability and simplicity in complex queries for easy comprehension.

Depending on region, markets, and products we can use this data to understand customer preferences for sold quantity, forecast accuracy, discounts, and Net sales. And we can use this to raise sales and customer satisfaction.

Features Used:
1-Views.
2-Stored Procedures.
3-User-Defined Functions.
4-Window Functions.
5-CTE.
6-Subquery.

......and more.

Python Project

Python : Hospitality Revenue Insights

Our objective was to conduct a comprehensive 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐢𝐧 𝐭𝐡𝐞 𝐇𝐨𝐭𝐞𝐥 𝐃𝐨𝐦𝐚𝐢𝐧 with the help of key steps such as 𝐃𝐚𝐭𝐚 𝐄𝐱𝐩𝐥𝐨𝐫𝐚𝐭𝐢𝐨𝐧, 𝐃𝐚𝐭𝐚 𝐂𝐥𝐞𝐚𝐧𝐢𝐧𝐠, 𝐃𝐚𝐭𝐚 𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧, and 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐢𝐨𝐧.

View Project
on GitHUB

Pie chart of revenue realized per booking platform.

Different booking platforms count.

Project Details

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐒𝐭𝐞𝐩𝐬:

1. 𝐅𝐢𝐧𝐝𝐢𝐧𝐠 𝐔𝐧𝐢𝐪𝐮𝐞 𝐏𝐫𝐨𝐩𝐞𝐫𝐭𝐲 𝐈𝐃𝐬: Explored and identified unique property IDs within our aggregate bookings dataset.
2. 𝐓𝐨𝐭𝐚𝐥 𝐁𝐨𝐨𝐤𝐢𝐧𝐠𝐬 𝐏𝐞𝐫 𝐏𝐫𝐨𝐩𝐞𝐫𝐭𝐲: Calculated the total number of bookings for each property ID.
3. 𝐎𝐯𝐞𝐫𝐛𝐨𝐨𝐤𝐞𝐝 𝐃𝐚𝐲𝐬: Uncovered the days when bookings exceeded the property's capacity.
4. 𝐇𝐢𝐠𝐡𝐞𝐬𝐭 𝐂𝐚𝐩𝐚𝐜𝐢𝐭𝐲 𝐏𝐫𝐨𝐩𝐞𝐫𝐭𝐢𝐞𝐬:Identified properties with the highest capacity.
5. 𝐇𝐚𝐧𝐝𝐥𝐢𝐧𝐠 𝐌𝐢𝐬𝐬𝐢𝐧𝐠 𝐕𝐚𝐥𝐮𝐞𝐬: Addressed columns with missing data by using appropriate substitutes, such as mean or median.

𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬:

1. 𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞: Computed the average occupancy rate for each room category.
2. 𝐂𝐢𝐭𝐲-𝐰𝐢𝐬𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲: Explored and presented the average occupancy rate per city.
3. 𝐖𝐞𝐞𝐤𝐝𝐚𝐲 𝐯𝐬. 𝐖𝐞𝐞𝐤𝐞𝐧𝐝: Investigated and compared occupancy on weekdays and weekends.

Hello, I am

Gaurav Mishra

1

2

1

1

About

Key

My

Sales and Finance Report

Business Insights 360 Dashboard

Revenue Insights : Hospitality Domain

Finance Analytics & Report Generation

Python : Hospitality Revenue Insights

Awards

Contact Me

Email

Github

Linkedin

Call

Gaurav Mishra

Download Resume