Portfolio - Mayukh Bose

Excel Project

Sales & Finance Analytics Report

Domain/Function: Sales & Finance

AtliQ Hardware aims to enhance sales strategies and boost net gross margins for growth and profitability. I created reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills to analyze financial performance and market standing.

View Project
Engagement

View Project
on GitHUB

The "Customer Performance Report" provides insights into the net sales performance of each customer across multiple years.

The "Market Performance vs Target" report enables stakeholders to assess the country's performance and compare it against set targets.

Project Details

In this project, I developed comprehensive sales and finance reports in Excel to help businesses refine strategies and increase profitability. The sales reports offered insights into customer performance, market trends, and target comparisons, empowering businesses to optimize discounts, improve negotiations, and identify new expansion opportunities. The finance reports, including P&L by fiscal year, month, and market, provided valuable financial insights for strategic decision-making.

Key skills developed:

Pivot Table creation
Power Query for data transformation
Basic DAX for modeling
Conditional Formatting
Report Presentation
Sales and Financial Metrics
This project equips businesses with the necessary tools to enhance sales and financial strategies, driving growth and maintaining a competitive edge.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar and E-Commerce

AtliQ Hardware, a fast-growing consumer electronics company, faced challenges in competing with data-driven rivals due to outdated Excel-based reporting and managing 1.8 million records across Finance, Sales, Marketing, Supply Chain, and Executive operations.

View Project
Engagement

View Project
on GitHUB

This is the main landing page of the dashboard, allowing users to navigate to various sections.

The data model consists of 10+ tables and utilizes a 'Snowflake' schema structure.

Project Details

This project leverages Power BI, SQL, and Excel to tackle operational challenges at AtliQ Hardware, a leading global consumer electronics company. The company’s heavy reliance on Excel for data analysis has caused significant losses in certain regions. To address this, senior management is launching a data analytics initiative, utilizing last year’s data to enhance decision-making and drive improvements.

💼 Finance View: Displays the profit and loss statement, including GM, NP, NS, and performance trends over time based on key metrics.
📣 Sales View: Highlights customer and product performance, unit economics, and a performance matrix by NS and GM%.
📣 Marketing View: Analyzes regional and product performance, unit economics, and a performance matrix by NS and GM%.
🚚 Supply Chain View: Evaluates forecast accuracy, net error, trends, and key metrics by customer and product.
👨‍🎓 Executive View: Provides insights on competitor market share, revenue by division and channel, key trends,

Project video

Live Interactive Dashboard

PowerBI Project

Insights for a Strategic Merger in the OTT Domain

Domain/Function: Telecom & Streaming Services

LioCinema, a top telecom provider, is merging with Jotstar, a leading streaming platform, to reshape digital entertainment in India. By combining Lio's subscriber base with Jotstar’s content library, the new entity will use Power BI analytics to boost engagement, optimize revenue, and drive growth.

View Project
Engagement

View Project
on GitHUB

Insights for a Strategic Merger in the OTT Domain

Provides a glimpse of total revenue across months, platform, city tiers

Start Schema data modelling for effective data analysis.

Project Details

This project uses Power BI and SQL to address key challenges in the strategic merger between Lio and Jotstar. By integrating subscriber data and content metrics, the goal is to enhance decision-making, boost engagement, and optimize revenue streams.

📊 Content Analysis: Evaluate content performance across genres, platform etc.
👥 Subscriber Insights: Understand subscriber demographics, acquisition sources, churn patterns.
⚡ Activity Analysis: Track Patterns of activity across age groups, city tiers, and subscription plans.
📈 Upgrade Insights: Insights into subscription upgrades and their influencing factors.
📉 Downgrade Insights Analysis of subscription downgrades and associated trends.
💰 Revenue Analysis: Patterns in total revenue across months, platform, city tiers etc.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics

Domain/Function: Consumer Goods

Using SQL queries answered 10 ad-hoc requests, making data the compass for AtliQ's journey to success. SQL, Excel, and PowerPoint tools are used. Key insights included a significant increase in unique products, a dominant 'Notebook' segment and seasonal sales trends

View Project
Engagement

View Project
on GitHUB

Shows the presence of AtliQ Exclusive Business in APAC region.

Visualizes the sales for AtliQ Exclusive per month

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Project video

PowerBI Project

Shield Insurance

Domain/Function: Insurance

Analyzed customer behavior and sales trends for Shield Insurance using Power BI as part of a data analytics bootcamp by Codebasics. Completed an end-to-end project during my internship, working with raw CSV files to deliver actionable insights.

View Project
Engagement

View Project
on GitHUB

Comparing online vs. offline sales, uncovering best-performing channels.

Customer segmentation with policy-wise revenue and settlement projections.

Project Details

Utilized Power BI to conduct a comprehensive analysis of Shield Insurance, covering revenue patterns, customer behavior, regional trends, sales channels, and age group segmentation. Delivered a detailed report that informed strategic decisions and provided actionable insights, contributing to an estimated 7–9% revenue growth and enhanced market reach through data-driven solutions.

Hello, I am

Mayukh Bose

1

3

1

About

Key

My

Sales & Finance Analytics Report

Business Insights 360

Insights for a Strategic Merger in the OTT Domain

Consumer Goods Analytics

Shield Insurance

Awards

Contact Me

Email

Github

Linkedin

Call

Mayukh Bose

Download Resume