Portfolio - Ajay Chauhan

Excel Project

Excel-Sales-Finance-Analytics-Project

Project Objectives: Customer Performance Evaluation: Formulated a detailed report for assessing customer performance. Market Performance Analysis: Executed a thorough examination to juxtapose market performance against sales targets.

View Project
Engagement

View Project
on GitHUB

To identify gaps, compare actual 2021 market performance to 2021 targets for Atliq hardware across 25 countries.

Net sales increased substantially from FY2019 to FY2021, with FY2021 reaching 4.5X higher sales than FY2019

Project Details

Sales Analytics Intent: Empowered enterprises with the capability to oversee, evaluate, and enhance their sales activities and outcomes. Significance of Sales Data Analysis: Revealing sales trends, monitoring crucial performance indicators, and facilitating data-driven decision-making.

Role of Reports: Determining effective customer incentives, aiding negotiations, and pinpointing expansion opportunities in potential markets.

Significance of Finance Data Analysis: Benchmarking against industry peers and historical periods, laying the groundwork for budgeting and forecasting.

Role of Reports: Aligning financial planning with strategic objectives and instilling confidence in the organization's financial outlook.

Technical Skills:

Mastery in ETL (Extract, Transform, Load) methodology.

Expert creation of date tables using Power Query.

Ability to derive fiscal months and quarters.

Python Project

Python-Atliq-Hotel-Analytics

This analysis is designed to uncover insights into the operational performance, booking trends, and customer preferences of AtliQ Grants Hotel. It involves an exploration of the hotel booking dataset, including data cleaning and an in-depth exploratory data analysis.

View Project
Engagement

View Project
on GitHUB

Import all 5 CSV files (dim_date, dim_hotels, dim_rooms, fact_aggregated_bookings, fact_bookings) into Pandas dataframes.

Handle/remove any null values in key columns like hotel_id, booking_id etc. Correct data formats/types across columns (e.g. convert data to datetime.

Project Details

The dataset is available in CSV format within the datasets directory and comprises the following components:

dim_date.csv: Contains details about dates and related attributes. dim_hotels.csv: Provides information about different hotels, including types and locations. dim_rooms.csv: Offers details about the available rooms in hotels, such as room types and capacities. fact_aggregated_bookings.csv: Presents aggregated information about hotel bookings, including total bookings and revenue for each hotel. fact_bookings.csv: Contains individual booking records with specific details, including booking dates, customer information, and room details. new_data_august.csv: Introduces additional data for the month of August, enhancing the existing analysis. Refer to the individual CSV files to explore the data comprehensively and understand the structure and content of each dataset.

SQL Project

SQL-PROJECT

SQL Supply and Finance Project A collection of Finance and Supply chain SQL queries that would generate crucial domain specific reports utilizing SQL concepts like Stored Procedure,Temporary Tables, Joins,etc.

View Project
Engagement

View Project
on GitHUB

Join the new helper table with dim_customer and dim_products to enrich analysis Calculate forecast accuracy metrics like percentage error at product.

Break down monthly sales by product category or brand to analyze trends Generate a rolling annual total sales column to smooth out seasonality.

Project Details

Statement:

Finance and Supply chain SQL related queries that would generate crucial domain specific reports utilizing crucial SQL concepts .

👉Learnings

👉Advanced SQL:

1) Subquery
2) CTE
3) Stored procedures
4)Views
5) Windows Functions

👉Business Related Knowledge:

1) Domain Knowledge
2) Agile
3) Jira Project Management tool
4) Kanban

👉Daily Learning:

1) Practice SQL
2) Unlearn and Learn again
3) Improve Communication

PowerBI Project

Powerbi-Project-Business-360

Issue Statement:- The endeavor entailed addressing a corporate challenge for a fictitious enterprise named AtliQ Hardware, engaged in the global manufacturing and distribution of hardware goods.

View Project
Engagement

View Project
on GitHUB

Total net sales for 2022 estimate is $3.74B, up 353% vs last year Gross margins are at 37.8%, slightly higher than 36.2% last year

61.33% of net sales come from PC division 72.97% of net sales come through retail channels

Project Details

Issue Statement:- The endeavou entailed addressing a corporate challenge for a fictitious enterprise named AtliQ Hardware, engaged in the global manufacturing and distribution of hardware goods. Formerly reliant on Microsoft Excel for analysis, the project's sponsor sought to transition the analytics team towards developing a Power BI-based dashboard capable of monitoring critical metrics across diverse departments and facilitating data-driven insights, given the company's operational expansion and escalating data volumes.

Resolution:- I devised intuitive dashboards (Views) customized to cater to distinct departmental needs, furnishing a holistic depiction of the company's operational efficacy.

➡️ Financial Perspective ➡️ Sales Perspective ➡️ Marketing Perspective ➡️ Supply Chain Perspective ➡️ Executive Perspective

Live Interactive Dashboard

PowerBI Project

Uber Analysis

Domain/Function: finance

The goal was to Analyze monthly sales and Revenue , operational & Performance ,Payment & Transaction & Customer Feedbacks We give end user demand of busy route and day & night wise performance

adasdsaada

adsdadwq

Project Details

ad adAD

Hello, I am

Ajay Chauhan

1

1

1

2

About

Key

My

Excel-Sales-Finance-Analytics-Project

Python-Atliq-Hotel-Analytics

SQL-PROJECT

Powerbi-Project-Business-360

Uber Analysis

My

Awards

Contact Me

Email

Linkedin

Call

Ajay Chauhan

Download Resume