Powered by
Codebasics DA Bootcamp

Pranoy Roy

Data Aspirant

+91 8787791108 [email protected]

Hello, I am

Pranoy Roy.

1

Excel Project

2

PowerBI Projects

2

SQL Projects

About Me

Hi there! welcome to my portfolio website! I’m an aspiring Data Analyst with a degree in Information Science, and I’ve found my true passion in making sense of data. With 2.5 years of experience as an Application Analyst, I’ve worked with tools like Tibco and MuleSoft APIs, gaining a solid foundation in how technology drives business.

Recently, I’ve become captivated by the power of data analysis, and I’ve been diving deep into tools like Excel, Power BI, SQL, and Python. I’ve already completed several business projects where I used these skills to uncover insights that helped guide important decisions.

My portfolio showcases these projects and highlights my journey of continuous learning. I’m excited to bring my technical background and fresh perspective in data analysis to new challenges, and I’m eager to contribute to teams that value data-driven decisions.

Key Skills

Effective Communication

Stakeholder Management

SQL

Python

My Projects

My Experience

Awards & Certificate

Professional Google Data Analytics Certificate

Professional Google Data Analytics Certificate

AWS Certified Solutions Architect - Associate

AWS Certified Solutions Architect - Associate

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.

[email protected]

https://www.linkedin.com/in/pranoy-roy01/

+ 91 8787791108

https://github.com/pranoy100

Excel Project

Sales Analytics (FMCG)

Domain/Function: Sales Analytics (FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Sales Analytics (FMCG)

Provides net sales performance of each customer across years

Sales Analytics (FMCG)

Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Revenue Analysis

Domain/Function: Hospitality Domain

AtliQ Grands, a chain of luxury hotels, is experiencing a decline in market share. We need to develop a dashboard that will enable stakeholders to identify the root causes of this decline and support them in making informed decisions to regain their market position.

View Project
on GitHUB

AtliQ Hospitality Revenue Analysis

AtliQ Grands is focused on reversing its declining market share by using a Power BI dashboard to support data-driven decision-making.

AtliQ Hospitality Revenue Analysis

This is a Data modeling screenshot. Dimension tables are dim_hotels, dim_rooms and dim_date. Fact tables are fact_bookings and fact_aggregate_bookings

Project Details

🔍 Project Overview: AtliQ Grand, a leading 5-star hotel chain in India, is struggling with declining revenue due to poor decision-making and strong competition. They're turning to data and business intelligence for better decision-making.

📋 Objectives: The goal of this analysis is to provide AtliQ Grand's Revenue Team with clear insights from historical data. My role as a data analyst is to uncover key trends, define important metrics, create a meaningful dashboard, and offer recommendations to improve their decision-making.

💡 My Achievements:
✅ I've linked various datasets to provide a comprehensive view.
✅ I've mastered key metrics and terms in the hospitality industry.
✅ I've developed KPIs to track revenue by room types, booking platforms, and occupancy rates for a detailed revenue analysis.

Live Interactive Dashboard

SQL Project

Finance And Supply Chain Analytics

Domain/Function: Finance And Supply Chain Analytics

This project focuses on analyzing and extracting valuable insights from the AtliQ Hardware database, which contains data on sales, products, customers, and regions. The goal is to answer key questions related to sales performance, market trends, customer behavior, and supply chain forecasting.

View Project
on GitHUB

View Project
on

Finance And Supply Chain Analytics

Data sets including database, facts table and dim table and their connections

Finance And Supply Chain Analytics

Database overview including Tables, functions, stored procedures and views

Project Details

AtliQ Hardware's Finance & Supply Chain Analytics SQL Project

This project focuses on analyzing AtliQ Hardware's Finance & Supply Chain data, a global leader in PC, printer, and computer manufacturing. The dataset provides insights into sales reports, market trends, customer behavior, and supply chain forecasting.

To overcome the challenges of large Excel file sizes, MySQL is used for efficient data management.

Key Insights:

1) Amazon led net sales with $109.03M in FY 2021, followed by AtliQ Exclusive at $79.92M.
2) India generated the highest net sales of $210.67M, with the USA following at $132.05M in FY 2021.
3) Amazon accounted for 13.23% of total net sales in 2021.
4) In the APAC region, Amazon contributed 12.99% of total net sales in 2021.
5) India ranked #1 in total gross sales in the APAC region.

This project utilizes MySQL to optimize analysis and deliver actionable insights for AtliQ Hardware.

SQL Project

Consumer Goods AD_HOC Analysis

Domain/Function: FMCG Domain

AtliQ Hardwares Consumer Goods Analytics: Leveraging SQL queries, exploring sales data to uncover insights. Key findings: product trends, retailer performance, and sales channel analysis.

View Project
on GitHUB

View Project
on

Consumer Goods AD_HOC Analysis

Top 3 product by division with highest sold quantity in fiscal year 2021.

Consumer Goods AD_HOC Analysis

Stored procedure output: monthly gross sales report for customer 90002002.

Project Details

Overview:
In this project, we analyze a dataset from AtliQ Hardware, a global leader in PCs, printers, and accessories, to address ten ad hoc queries using SQL.

Key findings:

1) include a significant rise in unique products, with 334 in 2021 versus 245 in 2020.
2)The "Notebook" category leads with 129 distinct products, while the "Accessories" segment saw a notable increase of 34 products in 2021. 3)Flipkart stands out with the highest average pre-invoice discount at 30.83%.
4)Sales improved in March-April 2021 compared to 2020, and the "Retailer" channel remains dominant, contributing 73.22% of gross sales.