Portfolio - Shubham Agarwal | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Shubham Agarwal

Data Analyst

Resume

1

Excel
Project

2

PowerBI
Projects

About

Me

I’m Shubham Agarwal a data professional skilled in transforming raw data into meaningful insights through dashboards and reports. My focus areas include data cleaning, visualization, and reporting using tools like Power BI, SQL, Excel, and Python.Through hands-on certifications and project-based learning, I’ve built a strong foundation in business intelligence and enjoy using data to solve real-world problems.

Key

Skills

Python

Business Communication

Excel

Power BI

SQL

My

Projects

Sales Analysis Dashboard

Sales Analysis Dashboard

Domain/Function: Brick & Mortar Business

Sourced the Data through an Excel File and achieved 100% accuracy .Transformed Data as per requirement. Created queries using the function in the PBI desktop.Developed Charts and Graphs.Implemented data-driven reporting using KPIs, slicers, and filters to identify key insights.

Road Accident Analysis

Road Accident Analysis

Domain/Function: Public Safety

 Applied analytical for Translating Data into Informative Visuals and Reports (30%)
 Utilized analytics to transform raw data into visually compelling reports, ensuring effective communication of key insights.
 Identified the casualties by introducing the Type of Vehicles from the Data (25%)

Business Insights 360

Business Insights 360

Domain/Function: Brick & Mortar + E-Commerce

Developed a comprehensive Power BI dashboard by integrating sales data from 10 sources. Used DAX Studio to optimize performance, improving dashboard loading time by 30%.

My

Experience

I’m having experience in data handling, reporting, and dashboard creation using Excel, SQL, Power BI, and Python. I’ve worked on real-world projects across sales and operations domains.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

Contact Me

Email

[email protected]

Github

https://github.com/shubh-500

Linkedin

https://www.linkedin.com/in/shubhamagarwal001/

Call

+91 9759723989

Shubham Agarwal

Data Analyst

Download Resume

Resume

Excel Project

Sales Analysis Dashboard

Domain/Function: Brick & Mortar Business

Sourced the Data through an Excel File and achieved 100% accuracy .Transformed Data as per requirement. Created queries using the function in the PBI desktop.Developed Charts and Graphs.Implemented data-driven reporting using KPIs, slicers, and filters to identify key insights.

View Project
Engagement

View Project
on GitHUB

Sales Analysis Dashboard

E-commerce Sales Report Of Germany

Sales Analysis Dashboard

E-commerce Sales Report of China

Project Details

 Sourced the Data through Excel File and achieved 100% accuracy
 Transformed Data as per requirement
 Created queries using DAXfunction in PBI desktop
 Developed Charts and Graphs
 Implemented data-driven reporting using KPIs, slicers, and filters to identify key insights, resulting in a 25% increase in
conversion rates and a 15% reduction in customer churn.
 Data Driven Business Strategy
 Project Scoping & Scheduling
 Statistical Analysis & DataWarehouse
 Data Analytics & Data Visualization
 Database Management
 Technical Documentation
 Data Modeling
 Stakeholder Communication
 Financial Modelling using VBA (Excel)

PowerBI Project

Road Accident Analysis

Domain/Function: Public Safety

 Applied analytical for Translating Data into Informative Visuals and Reports (30%)  Utilized analytics to transform raw data into visually compelling reports, ensuring effective communication of key insights.  Identified the casualties by introducing the Type of Vehicles from the Data (25%)

View Project
Engagement

View Project
on GitHUB

Road Accident Analysis

Led a cross-functional team to transform raw accident data into visually compelling reports, boosting data comprehension by 50% among stakeholders.

Road Accident Analysis

Spearheaded the implementation of analytics solutions alongside emergency response units, reducing response times by 15% and enhancing efficiency.

Project Details

Applied analytical for Translating Data into Informative Visuals and Reports (30%)
 Utilized analytics to transform raw data into visually compelling reports, ensuring effective communication of key insights.
 Identified the casualties by introducing the Type of Vehicles from the Data (25%)
 Conducted detailed analysis to categorize and identify casualties based on the types of vehicles involved, enhancing
specificity in accident reporting.
 Created a Road Accident Dashboard for years 2021 and 2022 to gain insight on (30%)
 Developed comprehensive dashboards for the years 2021 and 2022, providing an interactive platform for gaining insights into
road accidents.
 Incorporated key metrics and trends, facilitating informed decision-making and measures for road safety.
 Published the Reports in PBI service (15%)
 Leveraged Power BI service to publish and share reports, ensuring accessibility and collaboration among stakeholders.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar + E-Commerce

Developed a comprehensive Power BI dashboard by integrating sales data from 10 sources. Used DAX Studio to optimize performance, improving dashboard loading time by 30%.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

AtliQ Hardware is a leading company that sells hardware like PC, mouse, printers other products to its customers.

Business Insights 360

📈 Finance View - It includes complete P&L statement, Net sales over time, Top products and customer by net sales.

Project Details

Created a Power BI dashboard using multi-source sales data for a retail and e-commerce business. Optimized it with DAX Studio, reducing load time by 30%. Covered key areas like finance, supply chain, and marketing, helping teams access insights faster and support a projected 15% revenue boost.