Portfolio - Sabyasachi Bhattacharjee | Codebasics

Powered by
Codebasics DA Bootcamp

Sabyasachi Bhattacharjee

Product Analyst

EMAIL

[email protected]

Download CV

About Me

Hello Everyone, Welcome to my Portfolio website. My name is Sabyasachi Bhattacharjee, a data enthusiast on a mission to reveal the secret of hidden stories behind numbers. With a background in Electronics and Communication Engineering (holding a stellar 8.74 YGPA),

I developed my knack for data analysis and thus decided to deep dive into upscaling more in the data industry. I am specialized in tools like Power BI, Excel, MySQL and Python which enable me to transform raw data into actionable insights. During a transformative 3-month tenure as a Power BI Developer Intern, I gained hands-on experience that fueled my passion further.

Explore my portfolio to witness first hand the projects that I have undertaken and the value that I can add to your team. Let's collaborate together to uncover the insights that can drive your organization's success.

1

Excel Project

2

PowerBI Projects

1

SQL Project

Key Skills

Python

SQL

Communication Skill

Presentation Skills

Power BI

Project Management

UAT

Fabric

AI Automation

n8n

Airtable

Excel

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Let's Work Together!

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.

EMAIL

[email protected]

LinkedIn

https://www.linkedin.com/in/sabyasachi-bhattacharjee/

GitHub

https://github.com/Sabya02

Excel Project

Sales Analysis Report

I created two reports for the sales team, simplifying customer performance assessment and goal tracking. These reports offer insights for strategy adjustments, empowering the team to understand customers, markets, and achieve sales targets.

View Project
Engagement

Sales Analysis Report

Provides net sales performance of each customer across years

Sales Analysis Report

Enables stakeholders to assess the country's performance and compare it to set targets. Conditional formatting for better insights.

Project Details

In this project, I made a sales report using Excel's pivot tables. This report helps businesses figure out the best discounts for customers, makes it easier to negotiate with them, and shows where they could grow in new countries.

I learned a bunch of useful stuff while doing this project:

1. Pivot tables (they're super handy)
2. Power Query (helps clean up data)
3. DAX (basic formulas)
4. Making things look good with Conditional Formatting
5. Making the report look nice
6. Understanding sales numbers

Overall, this project is about giving businesses the tools and info they need to keep an eye on sales, make them better, and find new opportunities for growth. By studying sales data, businesses can find new ways to succeed in a changing market.

PowerBI Project

Hospitality Analysis- Atliq Grands

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.

View Project
Engagement

Hospitality Analysis- Atliq Grands

Detailed analysis of key metrices, look on different trends, total bookings by platform and category.

Hospitality Analysis- Atliq Grands

Modelling view involving 5 tables of 2 fact table and 3 dimensions table

Project Details

The objective to create the dashborad is to help stakeholders figure out root cause of the problem and take decisions to regain the market share.
The dashboard is build keeping the user perspective in mind. It is built upon data from 3 months, 3 dimension table and 2 Fact tables which includes all 4 cities where AtliQ grands has the operations.
There are total 4 pages in this report-
1. Overview Page- It gives an eagle's view to stakeholders
2. Metrics Analysis- It gives trend analysis and key metrices.
3. Analysis by room class- Provides a detailed overview of bookings over different cateories.
4. Insights- This page depicts over useful insights that stakeholders would look on.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods AD-Hoc Insights

Worked in a consumer goods domain project for Atliq Hardware to provide insights to managements using SQL queries. Also based n the queries, I need to create a detailed report for depth analysis.

View Project
Engagement

View Project
on GitHUB

Consumer Goods AD-Hoc Insights

Modelling view of 6 tables having 4 fact and 2 dimensional table.

Consumer Goods AD-Hoc Insights

Segment wise increasing trend for year 2021 vs 2020.

Project Details

Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too.
However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. So, for that I as a Data Analyst have been given the task to find the issues regarding why the management is facing a loss and also work on the shortcommings.
Steps are as follows-
1. Run SQL queries to find the rquests.
2. Worked on the requests and imported the queries into Power BI to find out detailed insights.
3. Based on the queries, developer an interactive report.

Project video

PREDICO- Smart Health Care Predictor

The main purpose of this project is to create a virtual health care system which provides one stop solution to predict a particular disease. It takes the symptoms/measures from user as input and characterize the illness using ml algorithm to track down the disease with which a person is affected.

View Project
Engagement

View Project
on GitHUB

PREDICO- Smart Health Care Predictor

Working workflow of the model

PREDICO- Smart Health Care Predictor

It signifies how it actually helps in predicting the disease along with UI/UX and smart chatbot system.

Project Details

The main purpose of this project is to create a virtual health care system which provides one stop solution regarding prediction of a particular disease. It takes the symptoms from the users as input and characterises the illness utilizing the ML algorithm to track down the most affecting dangerous disease causing the illness.

As a result of which we have a clear idea of which disease a person is affected so that we get a clear cut idea of medical sources for the treatment. A Chabot named Predo is also integrated with it for instant assistance. It also helps the doctor as an personal assistant.
How it works?
1. It takes the measures of the user as input and characterizes the illnesses by utilizing the ML algorithm.
2. To track down the most affecting danger factors causing these illnesses.
3. Also a assistant bot named Predo is also integrated with it so that it can provide immediate assistance to the user.

Project video

PowerBI Project

Business Insights 360

Domain/Function: Brick & mortar and Ecommerce

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

Other Tools

Power BI

SQL

Excel

DAX Studio

Business Insights 360

Overview of Finance view of Atliq's Hardware finance department wise growth.

Business Insights 360

Overview of Executive view of Atliq's Hardware executive department wise growth.

Project Details

Designed and implemented a robust business intelligence dashboard for Atliq Hardware, utilizing a strategic blend of star and snowflake schemas.
Integrated and transformed vast data from 14 million records, spanning finance, sales, marketing, and supply chain departments.
Facilitates departmental insights and executive overviews, enhancing data-driven strategies.

Live Interactive Dashboard