Portfolio - Ashutosh Jaiswal

Excel Project

AtliQ Hardware Sales and Finance Report

This project involves the creation of comprehensive reports for AtliQ Hardware, focusing on both Sales and Finance analytics. The primary tool used for data analysis and reporting is Microsoft Excel.

View Project
on GitHUB

This report shows the key insights for sales and sales growth for different customers.

This report shows the comprehensive profit and loss analysis for each fiscal year.

Project Details

Sales Reports
Customer Performance Reports:

Highlights sales figures and growth percentages.
Detailed analysis of customer contributions to overall sales.
Market Performance Reports:

Comparison of sales figures against market performance.
Insight into market trends and sales strategies.
Sales Target Comparison Reports:

Analysis of actual sales versus target sales.
Identification of gaps and areas for improvement.
Finance Reports
P&L Reports by Fiscal Year:

Comprehensive profit and loss analysis for each fiscal year.
Year-over-year performance metrics.
P&L Reports by Fiscal Month:

Monthly breakdown of profit and loss.
Detailed insights into financial performance trends.

PowerBI Project

AtliQ Grand Hospitality Dashboard

Domain/Function: Hospitality | Revenue

This project was created to provide insightful data analysis for AtliQ Grand, a luxury hotel chain facing revenue challenges in India's competitive hospitality market.

View Project
Engagement

View Project
on GitHUB

At-a-glance view of AtliQ Grand's key metrics, trends, and performance insights. Interactive visuals for informed decision-making in hotel management.

Real-time insights on hotel chain performance. Track key metrics, identify trends, and make data-driven decisions to boost profitability.

Project Details

AtliQ Grand, a renowned luxury hotel chain, has been struggling with revenue and market share due to increased competition and ineffective management decisions. The objective of this project was to leverage data analytics to regain market share and boost revenue in the luxury/business hotels category.

Techniques Used
>Data modeling
>Data cleaning in Power Query
>DAX measures and calculated columns
>Building filter panes using bookmarks and selection

The dashboard includes the following key business metrics:

>Revenue
>Occupancy %
>RevPAR (Revenue Per Available Room)
>ADR (Average Daily Rate)
>Realization %
>Total Bookings
>DBRN (Days Before Reservation Needed)
>DSRN (Days Since Reservation Needed)
>DURN (Duration of Stay)

Live Interactive Dashboard

PowerBI Project

Business Insight 360

Domain/Function: Finance | Sales | Marketing | Supply Chain

Power BI project developed for AtliQ Hardware, providing comprehensive business insights across finance, sales, marketing, and supply chain. Created as part of the Codebasics Data Analytics Bootcamp.

View Project
Engagement

View Project
on GitHUB

This is finance dashboard that shows important information about net sales, gross margin %, net profit % and other profit and loss statements.

This is finance dashboard that shows important information about forecast accuracy, net error, absolute error and other key metrices.

Project Details

AtliQ Hardware faced challenges in consolidating and analyzing data from diverse sources, which impeded their ability to make informed business decisions. The objective was to develop an interactive report that provided key insights across various business functions, including finance, sales, marketing, supply chain, and executive teams.

Live Interactive Dashboard

SQL Project

Ad-Hoc Query Analysis for Atliq Hardwares

Domain/Function: Consumer Goods | Executive Management

This project involved conducting a detailed ad-hoc SQL query analysis for Atliq Hardwares, a leading computer hardware producer. The goal was to address 10 business requests, provide actionable insights, and support executive decision-making.

View Project
Engagement

View Project
on GitHUB

Ad-Hoc Query Analysis for Atliq Hardwares

Query 1 insights and visuals for the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.

Query 3 insights and visuals for all the unique product counts for each segment and sort them in descending order of product counts.

Project Details

Atliq Hardwares is a leading computer hardware producer in India and other countries. To improve their data-driven decision-making capabilities, the company aims to expand its data analytics team by hiring junior data analysts. Tony Sharma, the Data Analytics Director, has designed a SQL challenge to assess candidates' technical and soft skills. This challenge involves solving 10 business-related ad-hoc requests using SQL to extract insights from company datasets.

Hello, I am

Ashutosh Jaiswal

1

2

1

About

Key

My

AtliQ Hardware Sales and Finance Report

AtliQ Grand Hospitality Dashboard

Business Insight 360

Ad-Hoc Query Analysis for Atliq Hardwares

Contact Me

Email

Github

Linkedin

Call

Ashutosh Jaiswal

Download Resume