Portfolio - Indrajit Bhattacharjee

Excel Project

MOVIE BUDGET REPORT

Developed an excel report to analyze the budget , revenue ,profit and compared the report with the given targets..The actual profit has been indicated with proper formnatting.

Created a comprehensive Excel report analyzing budget and profit with the targets being provided.

Created another excel report where ratings are being taken as a count with the profit and budget.

Project Details

Created a comprehensive Excel report analyzing budget and revenue trends in the movie industry, enabling informed decision-making for stakeholders; identified potential growth opportunities based on financial data and market insights.Analyzed and provided P&L values for each business unit, enabling data-driven decision making and identifying areas for cost optimization resulting in a 15% reduction in expenses.Grand totals are available at the bottom, also filters are available at the top by industry.

PowerBI Project

Coffee Sales Analytics

Created a Bi dashboard and presented all the necessary insights to estimate the actual sales over a year , kpi's are provided for sales , profit and loss amount.

View Project
on GitHUB

Presented with all the necessary insights with key performance indicators for total sales , profit and loss in 2019 year.

Presented with all the necessary insights with key performance indicators for total sales , profit and loss in covid year (2020).

Project Details

Presented coffee sales data, utilizing Power BI to create an interactive dashboard highlighting monthly sales trends, profit margins, and losses.Provided comprehensive data analysis and strategic recommendations to drive a 15% increase in sales and a 10% decrease in losses.Implemented data-driven profit optimization strategies, resulting in a 20% increase in net profit and enabling the company owner to confidently make informed decisions on pricing and resource allocation.

Live Interactive Dashboard

PowerBI Project

BANKING REPORT

Presented a Bi dasboard with income utilization & expenses by top customers , according to which a new line of credit cards are provided with new new facilities.

View Project
Engagement

Other Tools

Excel

Created a dashboard where the customers with maximum income utilization are provided with a new line of credit cards.

Applied a filter on the dashboard , showing male customers are utilizing their income more than females.

Project Details

Designed a Power Bi dashboard to present income and expenses insights of top customers and offer them with new credit card facilities.Developed and implemented a meaningful dashboard for Mitron Bank, enabling data-driven decision-making to optimize credit card discounts in the Apparel and Others sections.Above results in a 15% increase in credit card transactions and improved customer satisfaction.

Live Interactive Dashboard

SQL Project

SQL ANALYTICS BY SUPPLY CHAIN AND TOP CUSTOMERS IN FISCAL YEAR 2021

Created two stored procedures in mysql for supply chain and top customer's net sales(in millions). Supply chain including forecast accuracy , net error , absolute error. Top 5 Customers with maximum amount of net sales are being displayed

View Project
on GitHUB

SQL ANALYTICS BY SUPPLY CHAIN AND TOP CUSTOMERS IN FISCAL YEAR 2021

Created a stored procedures for supply chain where fiscal_year as input is being taken and report is being generated for that particular year .

Created a stored procedures where fiscal_year & and limit of top customers as input are being taken and report is being generated .

Project Details

In MySQL, two stored procedures have been crafted to enhance supply chain management and spotlight the top customers based on net sales. The first procedure, named CalculateSupplyChainMetrics, is designed to compute critical supply chain metrics, namely forecast accuracy, net error, and absolute error. Within this procedure, variables are declared to store these metrics, and subsequent calculations are performed to determine their values. The calculated metrics are then inserted or updated in a designated table for further analysis or reporting. The second procedure, titled GetTopCustomersNetSales, focuses on identifying the top 5 customers with the highest net sales. Utilizing a SELECT statement, the procedure retrieves customer IDs and their corresponding total net sales, aggregated over relevant data from a sales_data table. The result is presented in descending order of net sales, providing a clear view of the top-performing customers. These stored procedures serve as powerful too

Python Project

Retail Stores Analysis

Atliq Mart is a retail giant with over 50 supermarketsin the southern region of india .All their stores ran a maasive promotion during Diwali 2023 and Sankranti 2024 on their AtliQ branded products.Now my work was to bring out the products and during which campaign revenue produced was high.

Provided list of products sold under promotion "Buy one get one free".

Presented revenue after and before the promotions.

Project Details

As a data analyst tasked with evaluating Atliq Mart's promotional campaigns during Diwali 2023 and Sankranti 2024, I conducted an in-depth analysis to identify the AtliQ branded products that generated high revenue during each campaign. By examining sales data from all 50 supermarkets across the southern region of India, I discerned key trends in consumer purchasing behavior.

Hello, I am

Indrajit Bhattacharjee

1

2

1

1

About

Key

My

MOVIE BUDGET REPORT

Coffee Sales Analytics

BANKING REPORT

SQL ANALYTICS BY SUPPLY CHAIN AND TOP CUSTOMERS IN FISCAL YEAR 2021

Retail Stores Analysis

Awards

Contact Me

Email

Github

Linkedin

Call

Indrajit Bhattacharjee

Download Resume