Portfolio - Siddharth Dangi | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Siddharth Dangi

Data Aspirant

Resume

1

Excel
Project

2

PowerBI
Projects

About

Me

Hello I am Siddharth Dangi, I have completed B.Tech in Mechanical Engineering and a fervent interest in the field of Data Analytics. With a robust educational background in Mechanical Engineering, I can bring my engineering expertise with a passion for deriving meaningful insights from data. I bring a unique mix of skills, including SQL, Python, and Power BI, making me a wizard in turning raw data into useful insights.

Key

Skills

supply chain

Supply Chain Management

Data Driven Mindset

My

Projects

Sales Analytics

Sales Analytics

Used advanced excel tools like Power Query, Pivot Tables, and Excel Functions such as INDEX MATCH, VLOOKUP, XLOOKUP in order to Create a Sales Analytics Report.

Business Insights 360

Business Insights 360

Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market. Created Views for the Different divisions according to their requirements.

Hospitality Project Power BI

Hospitality Project Power BI

This Project gives a brief insight on the Hospitality industry Project and their KPIs. It gives us In depth information about the KPIs such as Revenue, Occupancy%, Avg Rating by the means of FY years, Specific Properties and Date filters.

Awards

& Certificate

German A1 Certification

German A1 Certification

Contact Me

Email

[email protected]

Github

https://github.com/siddharth-d11

Linkedin

https://www.linkedin.com/in/siddharth-dangi/

Call

+91 9503075001

Siddharth Dangi

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics

Used advanced excel tools like Power Query, Pivot Tables, and Excel Functions such as INDEX MATCH, VLOOKUP, XLOOKUP in order to Create a Sales Analytics Report.

View Project
Engagement

View Project
on GitHUB

Sales Analytics

Following Report gives us a brief insight on the Customer Net Sales Performance of AtliQ Hardwares worldwide, for FY 2019,2020,2021 and also 21 vs 20.

Sales Analytics

Following Report gives us a brief insight on the Market Performance of AtliQ Hardwares in comparison to the target set for FY 2021.

Project Details

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.

Importance of analyzing sales data: Identify sales patterns and track key performance indicators (KPIs).

Role of reports: Determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries.

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.

Importance of analyzing Finance data: Aid in benchmarking against industry peers and previous periods Foundation for budgeting and forecasting.

PowerBI Project

Business Insights 360

Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market. Created Views for the Different divisions according to their requirements.

View Project
Engagement

Business Insights 360

The following is the Supply Chain View of the BI360 project. This view gives us an insight on the Supply chain factors such as ABS Error, Net Error.

Business Insights 360

The following is the sales view of BI 360 Project.This gives us an insight on the sales KPIs such as customer performance by GM, NS, NS%.

Project Details

● Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database).
● Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of the report by 5%.
● The dashboard enabled Atliq hardware to analyze different department sales trends and make data-driven decisions, leading to a projected 10% revenue acceleration and 20% reduction in data-related expenses.

PowerBI Project

Hospitality Project Power BI

This Project gives a brief insight on the Hospitality industry Project and their KPIs. It gives us In depth information about the KPIs such as Revenue, Occupancy%, Avg Rating by the means of FY years, Specific Properties and Date filters.

View Project
Engagement

Hospitality Project Power BI

This Visual gives us an idea of Performance of hotels by Key Matrices like Revenue, Occupancy% and Avg Rating, Cancellation%.

Hospitality Project Power BI

This Visual Gives us an idea about Key Performance Indicators Present in the Hospitality Industry &gives us revenue, avg rating, occupancy % by City.

Project Details

● Designed a Power BI dashboard for Hospitality Domain.
● Conceptualized and executed a data-rich dashboard displaying Revenue, Occupancy, Avg Rating, and Cancellation % metrics for hotels; enabled the Revenue team to gain actionable insights into performance variations across different hotels and cities.
● This dashboard could assist in raising the revenue at least by 7% in the next quarter.