Portfolio - Siddharth Shanker Rai

Siddharth Shanker Rai

Data Aspirant

Resume

2

PowerBI Projects

1

Excel Project

About Me

Aspiring Data Analyst

Key Skills

MYSQL

PYTHON

My Projects

Business Insights 360

Domain/Function: Sales Data Analysis

Indian EV/Hybrid Market Study

Domain/Function: Sales Analysis (Indian EV/Hybrid Market Study)

AtliQ Sales and Finance Analytics

Domain/Function: Finance and Sales

Awards & Certificate

Microsoft Certified: Power BI Data Analyst 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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/siddharth-rai-b070ba2a2/

Call Me

+91 7428540945

GitHub

https://github.com/SiddharthShankerRai/Excel-Sales-Analytics

PowerBI Project

Business Insights 360

Domain/Function: Sales Data Analysis

𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝟑𝟔𝟎 is a comprehensive dashboard designed to provide actionable insights across Finance, Sales, Marketing, Supply Chain, and Executive functions. Its primary objective is to help the company to understand sales trends and enable data-driven decision-making.

View Project
Engagement

𝐹𝑖𝑛𝑎𝑛𝑐𝑒 𝑉𝑖𝑒𝑤: A detailed profit and loss statement for analyzing crucial KPI indicators, complemented by an area chart showing Net Sales pe

𝑆𝑎𝑙𝑒𝑠 𝑉𝑖𝑒𝑤: An analysis of customer and product performance based on Net Sales and Gross Margin, featuring a performance matrix (scatter char

Project Details

This initiative addresses the challenges faced by AtliQ Hardware, a global consumer electronics company that has encountered significant losses in certain regions due to insufficient analytics. With the Business Insights 360 Dashboard, AtliQ Hardware can leverage data analytics to transform challenges into opportunities and drive strategic growth!

Live Interactive Dashboard

PowerBI Project

Indian EV/Hybrid Market Study

Domain/Function: Sales Analysis (Indian EV/Hybrid Market Study)

The Indian EV/Hybrid Market Study Dashboard comprehensively analyzes India's electric and hybrid vehicle market. The study is segmented into two key categories: State/UT-wise distribution and manufacturer-wise breakdown, providing a detailed overview of the market landscape.

View Project
Engagement

State/UT-wise Distribution Analysis (for both 2-wheelers and 4-wheelers)

Maker-wise Distribution Analysis (for both 2-wheelers and 4-wheelers)

Project Details

Problem Statement: Over the past five years, AtliQ Motors has achieved a 25% market share in the electric and hybrid vehicle segment in North America. However, their current market share in India is less than 2%.

Live Interactive Dashboard

Excel Project

AtliQ Sales and Finance Analytics

Domain/Function: Finance and Sales

An Excel report that combines Sales Analytics and Finance Analytics. The report comprehensively analyzes the company's sales data and financial performance, with insights that can help us make data-driven decisions.

View Project
on GitHUB

Role of the report: Determine effective customer discounts, facilitate negotiations with consumers, and identify business expansion opportunity.

Role of the report: Align financial planning with strategic goals Instill confidence in the organization's financial outlook.

Project Details

Sales Report :
Project objective:
1. Create a customer performance report
2. Conduct a comprehensive comparison between market performance and sales targets.
Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance.

Finance Report :
Project objective:
1. Create Profit and Loss (P&L) reports by Fiscal Year & Months
2. Create Profit and Loss (P&L) reports by Markets
Purpose of sales analytics: Evaluation of financial performance, support decision-making, and facilitate communication with stakeholders.