Portfolio - Subhadeep Sinha Roy

Subhadeep Sinha Roy

Data Enthusiast

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Hi there! I'm Subhadeep, and I'm excited to share my journey with you. I'm on a mission to become a Data Analyst, and I've got some unique skills to offer.

🔍 I started with a degree in Bio Technology and later got an MBA in Marketing. For the past ten years, I've been working in retail sales. I'm really good at using tools like Excel, SQL, and Power BI to make sense of data.

💼 While I haven't held the title of Data Analyst in a formal job role, but I've proactively engaged in projects where I applied these skills to solve practical business challenges. You can explore these projects in my portfolio.

🧠 One thing you should know about me is that I'm a lifelong learner. I love learning new things, and I'm always eager to grow and improve.

Thanks for visiting; I'm eager to help with your data needs!

Key Skills

SQL

Problem Solving

Communation

Adaptability

My Projects

Power Bi Project 360

Domain/Function: Consumer Electronics

Sales Analytics (FMCG)

Domain/Function: IT Hardware Sales Analysis

Provide Insights to Management in Consumer Goods Domain

Domain/Function: Consumer Goods /Sales Analysis

Analyze Promotions and Provide Tangible Insights to Sales Director

Domain/Function: Retail/Promotion Analysis

Provide Insights To An Automotive Company On Electric Vehicles Launch In India

Domain/Function: Automobile/Market Analysis/Sales Analysis

Data analysis in Hospitality Domain using Python

Domain/Function: Hospitality Domain

Awards & Certificate

SQL Beginner to Advanced For Data Professionals

Excel: Mother of Business Intelligence

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

Google Analytics

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/subhadeepsinharoy/

Call Me

+1 3025462074

GitHub

https://github.com/Subha263/

PowerBI Project

Power Bi Project 360

Domain/Function: Consumer Electronics

AtliQ, an electronics company, aimed to make data-driven decisions and needed insights into its business. I have created diverse dashboards using Power BI for different teams. This empowered them to make informed data-oriented decisions and enhance overall business performance.

View Project
Engagement

View Project
on GitHUB

Dashboard Home Page

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 metrics

Project video

Live Interactive Dashboard

Excel Project

Sales Analytics (FMCG)

Domain/Function: IT Hardware Sales Analysis

This project focuses on analyzing the company's sales performance and market standing. The insights provided by advanced Excel techniques such as Pivot Tables and Power Query, help the sales team optimize strategies, improve customer relationships, and track market goals effectively.

View Project
Engagement

View Project
on GitHUB

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.

SQL Project

Provide Insights to Management in Consumer Goods Domain

Domain/Function: Consumer Goods /Sales Analysis

Atliq Hardwares seeks more data insight! Director Tony Sharma's move: a SQL challenge for analysts using SQL & Power BI. The goal? A vibrant presentation guiding management in smart decisions for global growth.

View Project
Engagement

View Project
on GitHUB

View Project
on My Sql

Concise database diagram showcases key tables (dim_date, dim_product, dim_customer, fact_sales_monthly etc), enhancing data management efficiency.

Top 3 products in each division that have a high total_sold_quantity in the fiscal_year 2021

Project Details

Objective: Atliq Hardwares aims to enhance data-driven decision-making for global expansion.

Challenge Launch: Director Tony Sharma initiates a SQL challenge for junior data analysts, prioritizing a blend of technical proficiency and soft skills.

Technical Emphasis: Candidates are assessed for SQL expertise, ensuring they can navigate complex data structures and queries.

Tool Integration: Emphasis on Power BI skills to empower analysts in creating visually compelling presentations from the extracted insights.

Data Storytelling: Analysts will craft a narrative using SQL and Power BI, transforming raw data into a compelling story.

Presentation Finale: The end goal is a dynamic presentation to the management, bridging the gap between technical insights and actionable strategies.

Management Empowerment: The presentation will provide management with actionable insights, aiding informed decision-making for the company's global expansion.

PowerBI Project

Analyze Promotions and Provide Tangible Insights to Sales Director

Domain/Function: Retail/Promotion Analysis

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well

View Project
Engagement

View Project
on GitHUB

Analysis the impact of various Promo types on ISU% & IR%

Analysis the impact of various Promo types on Category & Product level

Project Details

Created Dashboards for Sales , Stores, Promotions ,Product & Category level ,aim to analyze the impact of promotion based on Promo types. Identified the best & worst Promo impacting on ISU%(Incremental Sold Quantity Percentage ) & IR%(Incremental Revenue Percentage),also identified that promo which maintaining the healthy margin.

Project video

Live Interactive Dashboard

PowerBI Project

Provide Insights To An Automotive Company On Electric Vehicles Launch In India

Domain/Function: Automobile/Market Analysis/Sales Analysis

AtliQ Motors is an automotive giant from the USA.As a part of their expansion plans, they wanted to launch their bestselling models in India where their market share is less than 2%. Before proceeding further they wanted to do a detailed market study of existing EV/Hybrid market in India .

View Project
Engagement

Market Share Analysis, Sales Analysis ,Sales Trend Analysis ,Top & Bottom Performer Analysis

State wise sales & Penetration Rate Analysis, Top 10 States with highest CAGR (Compound Annual Growth Rate),Sales Projection for 2030

Project Details

The goal of this project is to find out the insights of EV Market of India. Find out the insights States wise & Makers wise, Sales projection for 2030 .This Insights will help AtliQ Motors to plan properly for their launching.

Project video

Live Interactive Dashboard

Python Project

Data analysis in Hospitality Domain using Python

Domain/Function: Hospitality Domain

Analyzed booking data for AtliQ Grands, a hotel chain, using Python to uncover key insights into occupancy rates, revenue trends, and customer behavior. Delivered actionable recommendations to optimize hotel performance, boost revenue, and market share.

View Project
Engagement

View Project
on GitHUB

View Project
on

Average rating by City

Pie chart showing revenue generated from different booking platforms

Project Details

Project Details
🎯𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐌𝐢𝐬𝐬𝐢𝐨𝐧: Harnessing Python for a thorough analysis of the hotel landscape, this project aims to empower Atliq Grands with data-driven insights and strategic recommendations, helping them make informed decisions and regain their competitive edge.

🌟𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:

● 𝐃𝐚𝐭𝐚 𝐂𝐥𝐞𝐚𝐧𝐢𝐧𝐠: Eliminated missing values and outliers to ensure pristine data quality.

● 𝐃𝐚𝐭𝐚 𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧: Added occupancy percentage columns for richer insights.

📊𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐔𝐧𝐜𝐨𝐯𝐞𝐫𝐞𝐝:

● 𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞 𝐛𝐲 𝐑𝐨𝐨𝐦 𝐓𝐲𝐩𝐞.
● 𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞 𝐩𝐞𝐫 𝐂𝐢𝐭𝐲.
● 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐑𝐚𝐭𝐞𝐬 𝐨𝐧 𝐖𝐞𝐞𝐤𝐝𝐚𝐲𝐬 𝐕𝐒 𝐖𝐞𝐞𝐤𝐞𝐧𝐝𝐬.
● 𝐉𝐮𝐧𝐞 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 𝐟𝐨𝐫 𝐃𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐭 𝐂𝐢𝐭𝐢𝐞𝐬.
● 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐩𝐞𝐫 𝐂𝐢𝐭𝐲.
● 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐓𝐫𝐞𝐧𝐝𝐬.
● 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐛𝐲 𝐇𝐨𝐭𝐞𝐥 𝐓𝐲𝐩𝐞.