Portfolio - Sahil Chudasama

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

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

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 for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

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 metric

Live Interactive Dashboard

SQL Project

Finance and Supply Chain Analytics

Domain/Function: Finance and Supply Chain

In this project, we delve into a dataset related to Finance & Supply Chain within the domain of AtliQ Hardwares. AtliQ Hardwares is a renowned hardware company specializing in PCs, printers, mice, and computers, boasting a global presence.

View Project
Engagement

View Project
on GitHUB

View Project
on

Project Data Set

Croma India product wise sales report for fiscal year - 2021

Project Details

AtliQ Hardwares Finance & Supply Chain Analytics SQL Project

Welcome to the AtliQ Hardwares Finance & Supply Chain Analytics Project repository. Here, we analyze a dataset concerning Finance & Supply Chain within AtliQ Hardwares, a global leader in PC, printer, mouse, and computer manufacturing.

Objective:
This project aims to extract insights from the database, addressing sales reports, market analysis, customer behavior, and supply chain forecasting. With the expanding Excel file sizes causing performance issues, leveraging MySQL as the database management system offers a solution.

Key Insights:
- Amazon leads in net sales with $109.03M in fiscal year 2021, followed by AlliQ Exclusive with $79.92M.
- The Indian market generates the highest net sales at $210.67M in fiscal year 2021, with the USA following at $132.05M.
- Amazon contributes 13.23% of total net sales, and in the APAC region, it leads with a net sales contribution of 12.99%.

PowerBI Project

AtliQ Hospitality

Domain/Function: Hospitality

The problem statement was AtliQ grands is a chain of Luxury hotels and they are losing market share we need to build a dashboard that will help the stakeholders to find the cause of downfall and to help them take decisions to regain market share.

View Project
on GitHUB

AtliQ Grands aims to reverse declining market share with a Power BI dashboard for data-driven decisions.

DataBase Table Model

Project Details

🏨 Title: AtliQ Hospitality Revival Analysis 📊🔑

🔍 Project Overview:
AtliQ Grand, a prominent 5-star hotel chain in India, is facing revenue challenges due to ineffective decision-making and fierce competition. They're seeking to leverage "Business and Data Intelligence" for informed decisions.

📋 Objectives:
This data analysis initiative aims to empower AtliQ Grand's Revenue Team with actionable insights from historical data. As a data analyst, my mission is to deliver key findings, establish metrics, construct an insightful dashboard, and provide actionable recommendations to enhance decision-making.

💡 My Achievements:
✅ I've fostered connections between various datasets.
✅ I've grasped essential metrics and terminology in the hospitality domain
✅ I've devised measures and KPIs to monitor revenue across different segments, including room types, booking platforms, and occupancy rates, enabling a detailed analysis of revenue performance.

Live Interactive Dashboard

PowerBI Project

Shield Insurance Dashboard

Domain/Function: Insurance

Developed a Shield Insurance Dashboard with KPIs like Total Customers, Revenue, DRG, and DCG. Included Sales Mode and Age Mode analysis for insights into sales channels and customer segmentation. Focused on data storytelling and actionable insights.

View Project
Engagement

Landing attractive Home Page

General view representing customer & revenue trends by month and important KPI's like total customer,revenue , DCG & DRG

Project Details

Developed a Shield Insurance Dashboard to visualize and analyze key metrics, including Total Customers, Revenue, DRG, and DCG. The project features Sales Mode Analysis to evaluate revenue across channels and Age Mode Analysis for customer segmentation by age and policy preferences. It highlights the importance of data storytelling, actionable insights, and supporting strategic decisions in the insurance domain

Project video

Live Interactive Dashboard

PowerBI Project

Wavecon Telecom Analysis

Domain/Function: Telecom Analysis

Analyzing Wavecon's post-5G telecom landscape, uncovering market shifts, and optimizing user engagement. Recommendations include targeted strategies, plan evaluations, and city-specific revenue approaches for enhanced performance.

View Project
Engagement

View Project
on GitHUB

Visualize the Wavecon's telecom landscape evolution to uncover trends and insights with our Market Share Dashboard.

Explore Wavecon's diverse plans post-5G launch, identifying top performers and areas for improvement.

Project Details

Dive into Wavecon's 5G impact analysis, exploring revenue shifts, user engagement trends, and plan performances. From understanding city-wise dynamics to spotlighting top and bottom-performing plans, this project offers a comprehensive view. Recommendations focus on reducing unsubscribed users, enhancing active user retention, and optimizing new plan performance. City-specific revenue strategies add a targeted approach to post-5G challenges. Uncover insights for sustainable growth and strategic planning in the ever-evolving telecom landscape."

Hello, I am

Sahil Chudasama

1

4

1

About

Key

My

Sales Analytics(FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Finance and Supply Chain Analytics

AtliQ Hospitality

Shield Insurance Dashboard

Wavecon Telecom Analysis

Awards

Contact Me

Email

Github

Linkedin

Call

Sahil Chudasama

Download Resume