Portfolio - Sumit Mahato

Sumit Mahato

Data Aspirant

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Welcome to my portfolio! I’m an aspiring Data Analyst with a passion for turning data into actionable insights. Though my background is in Computer Applications, I quickly found my strengths in data analysis. I've developed skills in tools like Excel, Power BI, SQL, and Python, allowing me to uncover trends and solve real-world problems.

While I haven't worked in a formal role yet, I’ve completed several business-focused projects, all showcased below. These experiences have helped me apply my knowledge and gain valuable hands-on practice. I’m excited to bring my skills to a professional environment and help drive data-driven decisions.

Key Skills

Mysql

Python

Stackholder Management

Machine Learning

power bi

Microsoft Excel

My Projects

AtliQ Hospitality Analysis

Domain/Function: Hospitality

Business Insights 360 Dashboard for Various Department of AtliQ Hardwares

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

Sales Insights for AtliQ Hardware

Domain/Function: FMCG/Sales

Customer Performance Report

Domain/Function: Sales & Finance

Consumer Goods Analytics

Domain/Function: Customer Goods Analytics/Executive Management

Hospitality Analysis

Domain/Function: Hospitality

Awards & Certificate

Excel: Mother of Business Intelligence

Python: Beginner to Advanced For Data Professionals

SQL Beginner to Advanced For Data Professionals

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Data Science

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/sumit-mahato/

Call Me

+91 6295631515

GitHub

https://github.com/Sumit-Mahat0

PowerBI Project

AtliQ Hospitality Analysis

Domain/Function: Hospitality

AtliQ Grands, a 20-year hospitality leader, faced declining market share and revenue due to rising competition and poor decision-making. To overcome this, management adopted Business & Data Intelligence to enable data-driven decisions, enhance operational efficiency, and optimize overall performance

View Project
Engagement

View Project
on GitHUB

AtliQ Exotica leads with ₹316M revenue, 57.2% occupancy & 24.4% cancellation rate

AtliQ Blu has the highest occupancy rate of 61.9%

Project Details

AtliQ Grands, a well-established player in the hospitality industry for over 20 years, has been facing a decline in market share and revenue due to increasing competition and ineffective decision-making. To tackle this challenge, the management decided to incorporate Business & Data Intelligence to drive data-backed decisions and optimize performance.

🔥 Key Insights from the Dashboard
📍 Mumbai generates the highest revenue (₹661M), followed by Bangalore, Hyderabad & Delhi
📍 AtliQ Exotica leads with ₹316M revenue, 57.2% occupancy & 24.4% cancellation rate
📍 AtliQ Blu has the highest occupancy rate of 61.9%
📍 Week 24 & Week 27 recorded the highest revenue (₹139.6M)
📍 AtliQ lost ~₹196.8M due to cancellations
📍 Elite rooms have the highest bookings & cancellation rates

Project video

Live Interactive Dashboard

PowerBI Project

Business Insights 360 Dashboard for Various Department of AtliQ Hardwares

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

AtliQ Hardware, a fast-growing hardware company specializing in peripherals, faced significant challenges in the Latin American market. To support their growth, I developed the Business Insights 360 Project, empowering them to make smarter business decisions through the power of data.

View Project
Engagement

View Project
on GitHUB

On the dashboard home page, all view buttons are available. Users can go to a specific page by clicking the corresponding button.

Data modelling involving 10+ tables

Project Details

AtliQ Hardware is a rapidly growing company with a global presence, selling computers and computer accessories through three main channels:

Retailers
Direct Sales
Distributors

Recently, the company faced unexpected losses after opening a new store in the U.S. based on surveys, intuition, and basic Excel analysis. AtliQ competitors, armed with advanced analytics teams, use data-driven decision-making to thrive in the market. To stay competitive, AtliQ has made the strategic decision to build their own analytics team, which will use data insights to inform future business strategies.

Project video

Live Interactive Dashboard

PowerBI Project

Sales Insights for AtliQ Hardware

Domain/Function: FMCG/Sales

Atliq Hardware, a top supplier of computer hardware and peripherals in India, is struggling to effectively track and analyze its sales performance. Bhaven Patel, the Sales Director, is seeking a more efficient solution to monitor sales and pinpoint opportunities or problem areas in the business.

View Project
Engagement

View Project
on GitHUB

Dashboard

AIMS GRID is a Project Management Tools

Project Details

Atliq Hardware is a company that supplies computer hardware and peripherals to clients across India, like premium Stores and Nomad Stores. Their head office is in Delhi, with several regional offices throughout the country. Bhaven Patel, the Sales Director, is facing challenges as the market grows rapidly. He struggles to track sales and get accurate business insights.
Bhaven needs simple, clear insights into how the business is performing and which areas need focus. He wants a dashboard that shows real-time data, allowing him to easily understand trends and make informed decisions, such as launching promotions or engaging with customers in regions where sales are declining. Ultimately, he wants data-driven insights that provide an accurate picture of the business without relying on vague or overly optimistic reports.

Project video

Live Interactive Dashboard

Excel Project

Customer Performance Report

Domain/Function: Sales & Finance

I created 2 detailed reports for the sales team to help them evaluate customer performance and understand how well they are doing in the market compared to their targets. These reports provide insights to guide their strategy and decision-making.

View Project
Engagement

View Project
on GitHUB

Pivot tables summarize data for easy filtering and calculation, while conditional formatting highlights key info, making data easier to understand.

Key metrics like Net Sales, COGS, and Gross Margin are tracked, and filters for region, market, and customer help analyze the data.

Project Details

In this project, I used Excel pivot tables to create a sales report that helps businesses set effective customer discounts, improve negotiations, and spot opportunities for growth in key countries. The reports provide valuable insights and recommendations to help optimize sales strategies, boost customer satisfaction, and increase revenue.

What I learned:
Pivot tables
Power Query
Basic DAX
Conditional formatting
Report design and formatting
Sales metrics

This project is designed to give businesses the tools and insights they need to track and improve their sales activities, uncover new opportunities, and drive growth in a competitive market.

Project video

SQL Project

Consumer Goods Analytics

Domain/Function: Customer Goods Analytics/Executive Management

View Project
Engagement

View Project
on GitHUB

Sql Query - Which channel helped to bring more gross sales in the fiscal year 2021 and the percentage of contribution

Pie-chart show the percentage of contribution

Project Details

As a leading computer hardware manufacturer in India with a growing presence in other countries, Atliq Hardware needed data-driven insights to make quicker, smarter decisions. My role was to analyze and transform 10 ad Hoc SQL queries into actionable insights.

🎯Key Insights:
➡️Product Growth: Unique products increased by 36.33% (from 245 in 2020 to 334 in 2021).
➡️Segment Highlights: The Notebook segment led with 129 products, while Networking had the fewest.
➡️Sales Trends: Sales peaked in November at 62 million, highlighting the need for focused marketing in that period.
➡️Channel Performance: Retailers contributed 73% of total sales, suggesting potential growth opportunities in the Direct and Distributor channels.

🎯Recommendations:
➡️Continue expanding product variety.
➡️Leverage peak sales periods for marketing efforts.
➡️Strengthen Direct and Distributor channels to boost overall sales.

Python Project

Hospitality Analysis

Domain/Function: Hospitality

A detailed data analysis for Atliq Grands, a well-known hotel chain with a strong presence in major Indian cities like Mumbai, Bangalore etc. 🏨 🔍 Using tools like Python and pandas, I uncovered key insights, including a decline in market share and revenue, which highlighted areas for improvement.

View Project
Engagement

View Project
on GitHUB

Booking platform and Number of bookings

AtliQ Grands have 4 category of rooms Available and picture the Occupany rate.

Project Details

A detailed data analysis for Atliq Grands, a well-known hotel chain with a strong presence in major Indian cities like Mumbai, Bangalore, Delhi, and Hyderabad. 🏨
I uncovered key insights, including a decline in market share and revenue, which highlighted areas for improvement. 🚀
💡 Working closely with Atliq's management team, we turned these insights into actionable strategies to improve customer experience, enhance bookings, and drive revenue growth. 📈

🎯Project Approach:
➡️Collected and cleaned booking data, guest demographics, and stay details.
➡️Preprocessed the data, handling missing values and outliers.
➡️Conducted exploratory data analysis (EDA) to discover trends.
➡️Created data visualizations to highlight key findings.

🎯Outcomes:
➡️Identified customer preferences, peak booking seasons, and behavior trends.
➡️Delivered insights to enhance customer satisfaction and streamline operations.
➡️Produced visual reports to guide strategic decisions.