Portfolio - Mohit Lalchandani

Excel Project

Excel Sales Analytics

Created Customer Performance Report, Market Performance vs Target Report, P&L statements by Fiscal Year, Markets and Months using Pivot Table, Color Formatting that defines highest sales & used various methods like Data cleaning, ETL and Data Model relationship.

View Project
on GitHUB

P&L for Markets

Gross Margin% by QTRs

Project Details

Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance.

Importance of analyzing sales data: Identify sales patterns and track key performance indicators (KPIs).

Role of reports: Determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries.

Finance Report :
Project objective:

1. Create Profit and Loss (P&L) reports by Fiscal Year & Months

2. Create Profit and Loss (P&L) reports by Markets

Purpose of sales analytics: Evaluation of financial performance, support decision-making, and facilitate communication with stakeholders.

Importance of analyzing Finance data: Aid in benchmarking against industry peers and previous periods Foundation for budgeting and forecasting.

Role of reports: Align financial planning with strategic goals Instill confidence in the organization's financial outlook.

PowerBI Project

AtliQ's Hospitality Project

This is AtliQ's Hospitality Project. In this project I have worked on various aspects like DAX, data cleaning , data extraction, data manipulation and data modeling.

View Project
Engagement

Property by Key Metrics

Revenue, Occupancy and Average Rating by City

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. However, they do not have an in-house data analytics team to provide them with these insights.

Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.

Live Interactive Dashboard

Excel Project

Customer, Order Fulfillment, Finance Dashboard

There are 3 Dashboards in this project. First one is Customer Satisfaction, which is about rating, No of interactions and second is Finance dashboard tells about Overall sales, Avg sales & No of sales for a particular segment. Last one is Order Fulfillment Dashboard that is for sales trend,

View Project
Engagement

Customer, Order Fulfillment, Finance Dashboard

Order Fulfillment Dashboard

Finance Dashboard

Project Details

Problem statements :
# To include every agent's avg customer satisfaction (C-SAT)
# Day wise customer satisfaction
# No of interactions with customers of every agent
# Overall Sales Value & Avg Sales Value
# What are Total orders, Total Revenue, Avg Revenue & Most ordered products
# Offline orders vs Online orders

Insights 📈
- Adrien Martin having avg C-SAT of 7.3 which is best among all three agents.
- Roch Cousineau has highest interaction with customers [285]
- Least C-SAT was recorded on 31-08-22 which was only 1.
- In east region sales for 200 bucket was highest 40% between 700 - 900 range.
- Overall sales trend started declining after 22-06-22
- Most ordered products hold 25% each share among 4 products.
- Large Paneer Tikka Pizzabun gave highest revenue of 43,250/-

PowerBI Project

Business Insights 360

AtliQ Hardware is growing rapidly in the recent years, and they have decided to implement the data analytics using PowerBi in their company for the first time to surpass their competitors in the market and to make data driven decisions. This project is hoped to give answers to the questions of owner

View Project
Engagement

Finance View

Marketing View

Project Details

AltiQ hardware is a company which has grown vastly in the recent years, and opened business all over the globe. It is a company which sells, computer and computer accessories through three mediums/channel
Retailers
Direct
Distributors
Recently the company has faced a unforeseen loss by opening store in America based on the surveys, intuition and some excel analysis and also the company’s competitors has handful of analytics team to perform analysis and make data driven decision. So, the AltiQ hardware has no other option other than building their analytics team for data driven insights and decisions in the future to survive better in the industry.

Hello, I am

Mohit Lalchandani

2

2

About

Key

My

Excel Sales Analytics

AtliQ's Hospitality Project

Customer, Order Fulfillment, Finance Dashboard

Business Insights 360

Awards

Contact Me

Email

Github

Linkedin

Call

Mohit Lalchandani

Download Resume