Portfolio - Siddhartha Singh

PowerBI Project

Hospitality Analysis - Hotel Chain Business

Domain/Function: Hotel Chain Business

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
on GitHUB

Hospitality Analysis - Hotel Chain Business

Mock-up Dashboard

Streamlined a dashboard in Power BI using 3 months of data to diagnose revenue loss for AtliQ Grands.

Project Details

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 category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue.

Live Interactive Dashboard

Excel Project

Coffee Shop Sales Analysis

Domain/Function: Hospitality and Food Service

This project aims to analyze retail sales data from a coffee shop to uncover actionable insights that can improve business performance. Using Excel, I examined sales patterns by day of the week and hour of the day to identify peak times for sales activity.

View Project
Engagement

View Project
on GitHUB

Variation of sales by day of the week and hour of the day

In the morning from 9 AM to 11 AM, more number of orders were made as compared to other timings on a day.

Project Details

Developed an Excel dashboard to aggregate sales data from multiple sources for a coffee shop. Utilized Power Pivot, DAX Measure, and Power Query, resulting in a 6% performance enhancement and a projected 15% revenue growth.

Excel Project

Sales and Finance Analysis Report

Domain/Function: Sales and Finance

Generated Sales analytics for AtliQ Hardware, analyzing customer performance and sales targets using Excel Pivot Tables and DAX for in-depth insights. Automated data cleaning with Power Query, boosting accuracy and efficiency.

View Project
Engagement

View Project
on GitHUB

All Customers Net Sales Performance from 2019-2021

The P&L (profit and loss) statement for AtliQ Hardware that shows company's sales and cost of goods(COGS) for fiscal years from 2019-21

Project Details

In my Sales and Finance Reporting project for Atliq Hardware, I aimed to find out business insights by developing customer performance and sales target reports alongside comprehensive Profit and Loss (P&L) analyses. Notable findings includes Amazon's significant contribution as a customer, with India, the USA, and South Korea emerging as prominent markets, and a remarkable 301% growth in net sales from 2020 to 2021.
Leveraging advanced Excel features, ETL methodology, Power Query, and DAX, I refined my technical skills, while focusing on empathy-driven report design enhanced my soft skills.
These reports are intended to guide Atliq's strategic decision-making, benchmark performance, and inform future financial planning, marking a significant step towards aligning organizational objectives with financial insights. Through this project, I not only contributed valuable insights to Atliq's operations but also expanded my analytical and technical capabilities significantly.

Hello, I am

Siddhartha Singh

1

2

About

Key

My

Hospitality Analysis - Hotel Chain Business

Coffee Shop Sales Analysis

Sales and Finance Analysis Report

My

Evelyn Learning, Noida – Quality Analyst

Apr 2019 - Sep 2023

Contact Me

Email

Github

Linkedin

Call

Siddhartha Singh

Download Resume