Portfolio - Mainak Ghosh

Mainak Ghosh

Data Aspirant

1

Excel Project

1

PowerBI Project

About Me

Welcome to my Portfolio!

I'm an aspiring Data Analyst with a B.Tech degree in Computer Science & Engineering. My journey through personal projects & Data Analytics Bootcamp sparked a passion for extracting actionable insights from data to drive business growth.

Proficient in Power BI, Excel, and SQL to analyze and interpret data, uncovering trends that enhance performance. My expertise lies in data analysis, interpretation & insightful reporting, empowering businesses to make informed decisions and effectively communicate key insights to stakeholders.

I embrace problem-solving mindset with a focus on rapid learning, constantly broadening my skills. Through various business projects, I have refined my ability to align data strategies with organizational goals.

I'm eager to leverage my abilities and contribute to a dynamic team. Let's connect and unlock the potential of data for your team!

Key Skills

Stakeholder management

Excel

Power BI

SQL

Python

My Projects

Sales & Finance Analysis - AtliQ Hardware

Domain/Function: FMCG

Business Insights 360 - AtliQ Hardware

Domain/Function: FMCG

Awards & Certificate

Excel: Mother of Business Intelligence

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

Power BI Job Simulation: PwC Switzerland

Community Champion of the Month - July,2024

Resume Project Challenge #12 - Appreciation Certificate

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.

Mail Me

[email protected]

https://www.linkedin.com/in/mainakghosh25/

GitHub

https://github.com/mk-ghosh-25

Excel Project

Sales & Finance Analysis - AtliQ Hardware

Domain/Function: FMCG

Develeloped 2 P&L Report for Sales & Finance team driving financial decision making for the Management ensuring efficiency & growth of the company & optimizing market performance.

View Project
Engagement

View Project
on GitHUB

Customer Net Sales Performance for different regions, markets & divisions for FY 2019-2021 & Sales Comparision between 2020 & 2021

Quarter-wise P&L Statement for FY 2019-2021

Project Details

Analyzed AtliQ Hardware’s financial and sales performance from 2019 to 2021 to support strategic decision-making.

Key Learnings:

ETL Process to streamline data handling
Data Cleaning: Efficiently streamlined data using Power Query Editor
Data Modeling: Established relationships using Power Pivot
DAX Measures: Created measures for detailed financial and sales analysis
Pivot Tables: Generated comprehensive P&L statements and sales performance reports

Financial Insights
Net Sales increased from $87.48M in 2019 to $598.88M in 2021
Gross Margin grew from $36.24M to $218.16M
GM% declined from 41.43% to 36.43%

Sales Insights
Top Product: 'AQ Electron 4 3600 Desktop Processor' with $19.35M in sales
16 new products in 2021 generated $176.16M in sales
Highest sales markets: India, USA, and South Korea

The comprehensive report provided valuable insights enabling data-driven decisions for growth & efficiency.

PowerBI Project

Business Insights 360 - AtliQ Hardware

Domain/Function: FMCG

AtliQ Hardware, a computer hardware company faces challenges with mantaining large volumes of data. Objective: Move from Excel to PowerBI based analytics for effective reporting that draws actionable insights enabling data-driven decisions for AtliQ's growth & to sustain market competitiveness.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

DAX Studio

Executive view: Offers historical data on crucial metrics & KPIs for executive members, enabling strategic decision making

Data Modeling: Established relationships between 15 tables for accurate & effective analysis

Project Details

AtliQ Hardware faced challenges with outdated Excel-based analysis, requiring advanced methods for effective reporting & data-driven decision-making.

Power BI Techniques Implemented:
Data modeling with 15 table relationships
DAX measures, calculated columns
Bookmarks, page navigation
Dynamic titles, conditional formatting
Publishing & sharing on Power BI Services

Dashboard Highlights:
Home Page: Centralized navigation hub
Finance View: Detailed financial metrics
Sales View: Sales performance insights
Marketing View: Strategy analysis
Supply Chain View: Operations optimization
Products View: Product & customer insights
Executive View: Strategic decision-making metrics

This project enhanced AtliQ’s data-driven informed, cross-departmental decisions making abilities.