Portfolio - Shubham Prasad | Codebasics

Powered by
Codebasics DA Bootcamp

Shubham Prasad

Data Aspirant

Resume

1

Excel Project

1

PowerBI Project

About Me

I'm Shubham Prasad, a Data Analyst who transforms complex data into actionable business insights. My expertise spans the full analytics toolkit – from Excel and SQL to Power BI and Python.

In my flagship project at AtliQ Hardware, I developed the Business Insights 360 dashboard that identified market gaps and drove improvements in revenue and profit margins. My portfolio spans from healthcare analytics, where I developed a mental health diagnostic tool, to creating AI-powered solutions that enhance decision-making.

Beyond technical work, I'm passionate about knowledge sharing, having conducted workshops on Large Language Models and Computer Vision. I thrive on collaborative problem-solving and am constantly expanding my analytics toolkit to deliver more value.

My goal is simple: to uncover the stories hidden in data and transform them into strategic advantages for organizations.

Key Skills

Power BI

Excel

SQL

Communication

Data Cleaning and Preprocessing

Statistical Analysis

ETL Processes

Stakeholder Communication

Version Control (Git)

Machine Learning basics

My Projects

P&L Report

Domain/Function: Data Analytics

Business insights 360

Business insights 360

Domain/Function: Insights & Visualization

PowerBI Project

Awards & Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

Coursera Data Science

Coursera Data Science

Coursera Python

Coursera Python

Accenture Data Analytics and Visualization Job

Accenture Data Analytics and Visualization Job

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]

LinkedIn

https://www.linkedin.com/in/07shubhamprasad/

Call Me

+91 8484807954

GitHub

https://github.com/shubhamprasad07

Excel Project

P&L Report

Domain/Function: Data Analytics

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. Empower businesses to monitor and evaluate their sales activities and performance.

View Project
on GitHUB

Other Tools

Pivot Table

Power Query

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I developed a comprehensive sales report using Excel pivot tables to help businesses optimize their sales strategies. The report enables companies to determine effective customer discounts, negotiate confidently with consumers, and identify promising countries for business expansion. By analyzing sales data, the generated insights provide actionable recommendations to enhance customer satisfaction, boost revenue generation, and streamline decision-making processes.

Through this project, I gained expertise in:
Creating and managing pivot tables :-
- Utilizing Power Query for efficient data preparation
- Applying basic DAX formulas for advanced calculations
- Implementing conditional formatting for improved data visualization
- Beautifying reports to enhance presentation and clarity
- Understanding key sales domain metrics

PowerBI Project

Business insights 360

Domain/Function: Insights & Visualization

AtliQ Hardware's 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.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Excel

Dax Studio

Business insights 360

Supply Chain View

Business insights 360

Executive View

Project Details

This project aimed to develop a comprehensive report for stakeholders in sales, marketing, finance, and the executive team. Key focuses included robust data modeling, user-centric report design, and drillable insights for deeper analysis.

I gained hands-on experience with:
- Power Query (Basic and Advanced Operations)
- Basic and Complex DAX Formulas
- Data Modeling with 10+ tables
- Selecting the right visuals and formatting
- Applying dashboard design principles
- Using bookmarks for enhanced interactivity
- Deploying reports in Power BI Service
- Implementing stakeholder feedback
- Analyzing key Sales, Marketing, Finance, and Supply Chain metrics

Live Interactive Dashboard