Portfolio - Ritwick Mukherjee

Ritwick Mukherjee

Data Analyst

Resume

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

As a recent graduate with a B.Tech in Mechanical Engineering aspiring to delve into the realm of data analysis, you offer a unique blend of technical acumen and analytical curiosity. Your engineering background has instilled in you a robust problem-solving mindset and a meticulous attention to detail. Eager to pivot towards the data-driven landscape, you are equipped with a solid foundation in mathematics and statistics, complemented by your proficiency in tools like Excel, Python, and MATLAB. With a thirst for knowledge and a proactive approach to learning, you are poised to leverage your diverse skill set to unravel insights from complex datasets and drive informed decision-making in the realm of data analysis.

Key Skills

Tableau

Python

Data Visualization

Report & Story talling

MySql

Excel

My Projects

Business 360 - Brick & Mortar and e- commerce

Sales Dashboard

Music Store Insights Analysis

Wavecon Telecom Analysis

Shield Insurance

Domain/Function: Insurance

Awards & Certificate

DATA ANALYTICS USING PYTHON, POWER BI, TABLEAU, SQL ,ADVANCED EXCEL AND STATISTICS

Data Analytics and Visualization Job Simulation

Ethics in the Age of Generative AI

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/ritwick-mukherjee/

Call Me

+91 7074403626

GitHub

https://github.com/ritwickmukherjee1

PowerBI Project

Business 360 - Brick & Mortar and e- commerce

Business 360 - Brick & Mortar and e-commerce" offers a comprehensive exploration of retail ecosystems, bridging the traditional brick-and-mortar model with the dynamic landscape of e-commerce. Delving into consumer behavior, market trends, and operational strategies,

It is a finance view which shows Profit & loss ,net sales performance ,top & bottom product & customer by net sales and filter by years , Quarter .

This marketing view shows Product performance , Performance Metrix. Region/market/customer performance , unit economics

Project Details

Project Description: Business 360 - Brick & Mortar and e-commerce" entails devising a comprehensive retail strategy that seamlessly integrates brick-and-mortar operations with e-commerce initiatives. Teams will conduct market research to identify consumer preferences and trends, analyzing data to inform strategic decisions.

Excel Project

Sales Dashboard

Created an interactive Excel sales dashboard to analyze data: import and organize sales data by year, category, sales, profit, customer, state, and month. Visualize with charts like funnel, line, pie, map, bar, and area for insightful business decisions.

View Project
Engagement

View Project
on GitHUB

...

Project Details

Unlock Insights with an Interactive Sales Dashboard in Excel!

Gain deep insights into your sales data with this comprehensive guide to creating an interactive Excel dashboard. Import and organize your cleaned dataset by Year, Category, Sales, Profit, Customer, State, and Month. Use Data Validation for dropdown filters. Visualize data with various charts: a funnel chart for sales by category, a line chart for profit trends, a pie chart for top customers, a map for sales by state, a bar graph for customer count, and an area chart for monthly sales trends. Enhance your data analysis and presentations!

SQL Project

Music Store Insights Analysis

Excited to share insights from my SQL data analysis project on a music store's dataset. I uncovered key findings about employees, invoices, customers, and music preferences, helping target marketing and boost engagement! 🎵🚀

View Project
Engagement

View Project
on GitHUB

Here is the Schema of the Dashboard

Problem statements

Project Details

I'm excited to share the results of my recent SQL data analysis project focused on a music store's dataset. This project involved several interesting queries to uncover valuable insights about employees, invoices, customers, and music preferences. Key insights include identifying the senior-most employee, analyzing countries with the most invoices, finding top invoices by value, discovering the best customer city, recognizing the top spender, listing rock music enthusiasts, inviting top rock bands, identifying longest tracks, and uncovering popular music genres by country. Excited to continue exploring and deriving insights from data! 🎵🚀💡

Wavecon Telecom Analysis

Wavecon Telecom, a leading telecom provider in India, has recently launched 5G services, aiming to assess its impact. Analyzing revenue, KPI performance, plan effectiveness, and continuity post-launch is pivotal for strategic decisions in this inaugural presentation.

View Project
Engagement

View Project
on GitHUB

Data Model

Problem Statement

Project Details

Analyze the dashboard and provide insights by addressing key questions.

Introduction:
Wavecon Telecom, a leading telecom service provider in India, recently launched 5G services across major cities and seeks to understand the impact.

Key Questions:
What is the impact of the 5G launch on our revenue?
Which KPI is underperforming post-5G launch?
Which plans are performing well in terms of revenue post-5G launch? Which plans are not?
Is any plan significantly affected by the 5G launch? Should we continue or discontinue it?
Has any plan been discontinued post-5G launch? What are the reasons?
This task has greatly enhanced my analytical skills and boosted my confidence in presenting insights.

Project video

PowerBI Project

Shield Insurance

Domain/Function: Insurance

Introducing Shield Insurance Company, your trusted partner from Chennai to Mumbai. Offering tailored policies for ages 18+, we are committed to safeguarding what matters most and ensuring peace of mind in life's journey.

View Project
Engagement

View Project
on GitHUB

Overview

Sales Mode Analysis

Project Details

Introducing Shield Insurance Company, your trusted partner from the dynamic streets of Chennai to the bustling heart of Mumbai. Shield offers a range of insurance policies tailored to your needs, starting from the age of 18. With our unwavering commitment to safeguarding what matters most, we're here to ensure peace of mind in every step of life's journey.

In our General View Analysis, we examine key metrics such as revenue, customers, trend charts by revenue/customers, and customer segmentation. Shield Insurance boasts a total revenue of 989.3 million, serving 27 thousand customers. Our DCG stands at 148.29, with a DRG of 5.47 million. In Sales Mode Analysis, we explore revenue and customer trends across various sales modes, with offline agent sales leading at 56%, highlighting the importance of personal connections. Age Group Insights reveal that the 31-40 age bracket dominates in numbers and expected settlements, with a value of 182 million.