Powered by
Codebasics Data Analytics Bootcamp

Sahil Prasad

Data Aspirant

+91 8768727543 [email protected]

Resume

Hello, I am

Sahil Prasad.

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

I’m an aspiring Data Analyst with a strong ability to turn raw data into meaningful insights that drive decisions. Skilled in Excel, Power BI, and SQL, I enjoy uncovering patterns, simplifying complexity, and presenting data in a way that actually makes sense.

My journey started with a Bachelor’s degree in Agriculture, but along the way, I discovered a natural inclination toward data—analyzing it, questioning it, and using it to solve real-world problems. That curiosity led me to transition into data analytics.

While I’m at the beginning of my professional journey, I’ve built a solid foundation through hands-on business projects, where I’ve applied analytical thinking to real scenarios. These projects reflect not just my technical skills, but also my problem-solving mindset and attention to detail.

I’m now looking for opportunities where I can contribute, learn, and grow as a data analyst—turning data into decisions that matter.

Key Skills

Power BI

Excel

SQL

My Projects

Awards & Certificate

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

SQL Beginner to Advanced For Data Professionals

Excel: Mother of Business Intelligence

Microsft Certified: Power BI Data Analyst Associate

Microsft 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.

[email protected]

https://www.linkedin.com/in/sahil-prasad-aba7a240b/

+ 91 8768727543

https://github.com/sahil8906

Excel Project

Atliq Hardware

Domain/Function: FMCG

Analyzed AtliQ Hardwares’ global sales data to evaluate market performance and top products. Used Excel (Pivot Tables, charts, formulas) to track KPIs, identify growth trends, and uncover insights for data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Sales dashboard of AtliQ Hardwares showing country-wise performance (2019–2021), target gaps, and GM%. Highlights strong growth in key markets like India and USA while identifying underperformance using conditional formatting.

Dashboard highlighting top 10 products by sales growth (2020–2021). Shows revenue comparison and % increase, with products like AQ Smash 2 and AQ Electron leading. Uses filters and conditional formatting to identify high-performing products.

Project Details

This project analyzes the business performance of AtliQ Hardwares across global markets and product categories. It evaluates country-wise sales growth from 2019 to 2021, compares actual performance against targets, and identifies key revenue-driving regions such as India, USA, and Canada, along with underperforming markets.

It also includes product-level analysis, highlighting the top 10 products contributing to significant sales growth between 2020 and 2021. Products like AQ Smash 2 and AQ Electron 4 showed exceptional growth, indicating strong demand trends and business opportunities.

The analysis was performed using Excel, leveraging Pivot Tables, Pivot Charts, formulas, and conditional formatting to clean, organize, and analyze large datasets.

Through this project, I developed skills in exploratory data analysis, KPI tracking, and performance comparison, and improved my ability to turn raw data into actionable business insights.

PowerBI Project

Bharat Herald Business Report

Domain/Function: Media/ Broadcasting

Business Performance Dashboard for Bharat Herald using SQL, Excel, and Power BI. Analyzes print vs digital performance, tracking revenue, conversion, user growth, and ROI to deliver actionable insights for data-driven decisions.

View Project
on GitHUB

Other Tools

Excel

SQL

Bharat Herald Business Report

Interactive dashboard summarizing Bharat Herald’s key KPIs including revenue, users, conversion rate, cost per user, and growth. Highlights platform performance, conversion insights, and revenue trends to support data-driven decisions.

Bharat Herald Business Report

Print performance dashboard analyzing circulation, copies printed, waste %, and YOY growth. Highlights city-wise performance, waste distribution, and efficiency trends to identify gaps and improve print operations.

Project Details

The Bharat Herald Business Performance Dashboard is an end-to-end data analytics project built using SQL, Excel, and Power BI to evaluate business performance across print and digital channels. The project focuses on key metrics such as revenue, conversion rate, user growth, and ROI to understand how the company is transitioning in a digital-first environment. SQL was used for data extraction and querying, Excel for initial data cleaning and exploration, and Power BI for building an interactive and visually engaging dashboard. The analysis highlights trends, uncovers inefficiencies, and identifies opportunities to improve cost efficiency and conversion performance. This project demonstrates strong skills in data analysis, visualization, and storytelling, with a focus on delivering actionable insights for data-driven decision-making.

Project video

Live Interactive Dashboard

PowerBI Project

QuickBite Express: Food Delivery Performance Dashboard

Domain/Function: Food & Beverages (F & B)

Analyzed QuickBite Express food delivery data to track orders, revenue, customer behavior, and delivery performance. Built an interactive dashboard using SQL, Excel, and Power BI to uncover trends, improve efficiency, and support data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

QuickBite Express: Food Delivery Performance Dashboard

Interactive homepage of the QuickBite Express dashboard featuring navigation to key analysis sections like crisis overview, customer behavior, city impact, and delivery operations, with a clean layout and visual branding focused on food delivery insights.

QuickBite Express: Food Delivery Performance Dashboard

Executive Crisis Overview dashboard analyzing pre vs crisis performance with KPIs on orders, revenue, and losses. Includes trends for orders, cancellations, delivery time, ratings, and city-level insights with interactive filters for deeper analysis.

Project Details

The QuickBite Express project focuses on analyzing food delivery operations to uncover insights that drive business performance. Using SQL for data extraction, Excel for preprocessing, and Power BI for visualization, I built an interactive dashboard to track key metrics such as total orders, revenue trends, customer behavior, and delivery performance.

The analysis highlights peak order times, high-performing locations, and patterns in customer preferences, helping identify opportunities to optimize delivery efficiency and improve service quality. KPI tracking enables monitoring of order value, delivery time, and overall operational performance.

This project demonstrates my ability to transform raw data into actionable insights and build intuitive dashboards that support data-driven decision-making.

Live Interactive Dashboard

SQL Project

Swiggy Sales Analysis

Domain/Function: Food Delivery

SQL-based Swiggy sales analysis project exploring order trends, customer behavior, and pricing insights. Utilizes joins, aggregations, CTEs, and window functions to extract actionable insights and support data-driven decisions in the food delivery domain.

View Project
on GitHUB

Swiggy Sales Analysis

Quarterly order analysis using SQL, joining fact and date tables to track order volume trends. Highlights peak performance periods and supports business insights through aggregation, grouping, and sorting techniques.

Swiggy Sales Analysis

Price range analysis using SQL to categorize orders into buckets and measure demand distribution. Uses CASE statements, aggregation, and custom sorting to identify which pricing segments drive the highest order volume.

Project Details

This project presents a comprehensive sales analysis of a Swiggy-like food delivery dataset using SQL. It focuses on extracting meaningful business insights from multiple relational tables, including orders, customers, restaurants, and menu data. The analysis covers key metrics such as total revenue, order trends, customer behavior, and restaurant performance. Advanced SQL techniques like joins, aggregations, subqueries, CTEs, and window functions are used to solve real-world business problems—such as identifying top-performing restaurants, analyzing month-over-month growth, and tracking customer preferences. The project demonstrates strong data querying, transformation, and analytical skills, showcasing how raw data can be converted into actionable insights to support data-driven decision-making in the food delivery industry.