Portfolio - sayan bhattacharjee | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

sayan bhattacharjee

Data Aspirant

1

Excel
Project

2

PowerBI
Projects

About

Me

A passionate person with Problem solving, Critical Thinking, Service Management mentality , seeking an entry-level position as a Data Analyst in a reputed company like yours. Want to learn new technologies and want to implement them in real-life quality deliverd innovations to make the world better.

Technical

Skills

Excel

PowerBI

Effective Communication

Stakeholder Management

My

Projects

Business Insights 360

Business Insights 360

Domain/Function: FMCG

AtliQ Technologies, a dynamic hardware company specializing in peripherals, faced a significant challenge in Latin America. Their mission? To overcome this obstacle through data-driven decision-making.

Hospitality Domain Dashboard

Hospitality Domain Dashboard

Domain/Function: Hospitality

The Challenge was all about creating a dashboard for the Revenue Management team of AtliQ Grand Hotel chain, which can provide key insights and trend.

Sales Analysis

Domain/Function: Sales

Vrinda Store wants to create an annual sales report for 2022. So that, Vrinda can understand their which type of customer they have to target for improve sales in 2023 .

My

Experience

Deep Tours and Travels (10/2023-02/2024)
Analyst

o Spearheaded the design and implementation of comprehensive Power BI reports for Finance, Sales, Marketing, and Executive teams at leading tech giants, resulting in data-driven decision-making and a 15% increase in overall revenue.

o Ensured data quality by employing Power Query for data cleaning and conducted complex calculations using DAX functions, resulting in report optimization by 15%.

o Realized ETL (Extract, Transform, and Load) processes to streamline data flow into Power BI and troubleshooted issues whenever required, resulting in a 75% increase in reporting efficiency.

o Performed executive dashboard/report automation and also designed mobile layout as per client’s requirements to produce unique solutions.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

Contact Me

Github

https://sayanbhattacharjee.github.io/

Linkedin

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

sayan bhattacharjee

Data Aspirant

PowerBI Project

Business Insights 360

Domain/Function: FMCG

AtliQ Technologies, a dynamic hardware company specializing in peripherals, faced a significant challenge in Latin America. Their mission? To overcome this obstacle through data-driven decision-making.

View Project
Engagement

Other Tools

mysql

excel

Business Insights 360

Dynamic BI dashboard spanning over 5 years, 14M records, for all departments from Finance to Supply chain. Helping to business to have empowered.

Business Insights 360

Analyzed crucial KPI indicators such as Net Sales, Gross Margin % and Net Profit %. We created a comprehensive Profit & Loss Statement with YOY growth

Project Details

AtliQ Hardware is rapidly growing company in the recent years, and they have decided to implement the data analytics using PowerBi in their company for the first time to surpass their competitors in the market and to make data driven decisions. This project is hoped to give answers to the questions of stakeholder in terms all the aspects like finance, sales, marketing and supply chain.
Business Insights 360 is a comprehensive Power BI dashboard designed to empower AtliQ Hardware with actionable insights across Finance, Sales, Marketing, and Supply Chain.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Domain Dashboard

Domain/Function: Hospitality

The Challenge was all about creating a dashboard for the Revenue Management team of AtliQ Grand Hotel chain, which can provide key insights and trend.

View Project
Engagement

Other Tools

excel

Hospitality Domain Dashboard

Revenue Management team of the Atliq Grand hotel chain, which can provide key insights on Revenue trends

Hospitality Domain Dashboard

Revenue by week number and category

Project Details

AtliQ grands is a Luxury hotel chain loosing its market share, they need to find reasons for this and take right decisions . The Dashboard helps Stakeholders to figure out root cause of the problem and find a way to deal with it. This dashboard contains level 1 data from market for last 3 months.

Project video

Live Interactive Dashboard

Excel Project

Sales Analysis

Domain/Function: Sales

Vrinda Store wants to create an annual sales report for 2022. So that, Vrinda can understand their which type of customer they have to target for improve sales in 2023 .

View Project
Engagement

View Project
on GitHUB

View Project
on Rishab Mishra problem challenge

Excited to share the Annual Report Dashboard for Vrinda Store 2022

Our data reveals some insightful trends: Sales and Orders: A strong performance with sales peaking in the first half of the year.

Project Details

Provide end user support,coordination, and documentation 100% of financial analysis projects, Analyzed problems current and past financial data and performance Evaluated trends in financial performance Performed 100% comprehensive business analysis using data analysis, diagnose, and modelig.

Project video

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.