Portfolio - Vansh Bhatt | Codebasics

Powered by
Codebasics DA Bootcamp

Vansh Bhatt

Data Aspirant

EMAIL

[email protected]

PHONE

+91 9310983558

Download CV

About Me

👋 Welcome to my portfolio!
I’m Vansh Bhatt, an aspiring Data Analyst passionate about transforming raw data into actionable insights. With a Bachelor’s degree in Computer Applications and a strong foundation in analytical tools such as Excel, Power BI, SQL, and Python, I specialize in uncovering patterns, solving complex problems, and supporting data-driven decision-making.

While I am yet to begin my professional journey within an organization, I have successfully completed multiple business-focused projects, which you can explore in my portfolio. These projects demonstrate my ability to approach real-world challenges, analyze datasets effectively, and deliver solutions that add measurable value.

I am eager to apply my skills, curiosity, and dedication in a dynamic professional environment—contributing to impactful strategies, optimizing processes, and driving growth through data.

1

Excel Project

3

PowerBI Projects

1

SQL Project

Key Skills

Power BI

SQL

Power Query

Advanced Excel

Problem Sloving

Python

My Projects

My Experience

AtliQ Technologies – Data Analyst Intern (August 2025 – Present)

Debugged SQL queries in MySQL Workbench for accurate data extraction.
Enhanced data integrity by standardizing, deduplicating, and normalizing client datasets.
Conducted variance analysis and business trend evaluation using Pandas, Excel, and Power BI.
Created interactive dashboards and visualizations using Power BI to present findings to senior management.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

HackerRank

Let's Work Together!

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

[email protected]

Call Me

+91 9310983558

LinkedIn

https://www.linkedin.com/in/vansh-bhatt-2965ba322

GitHub

https://github.com/vanshbhatt05

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares (FMCG)

Domain/Function: Sales & Finance

🔍This project delves into the company's financial health and market position. 📊Using advanced Excel techniques, we craft insightful reports like "Customer Net Sales Performance" and "Market Performance vs. Target" to guide strategic decisions.

View Project
Engagement

View Project
on GitHUB

Excel-Sales and Finance Analytics Project of AtliQ Hardwares (FMCG)

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

Excel-Sales and Finance Analytics Project of AtliQ Hardwares (FMCG)

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 impactful project, I've leveraged Excel pivot tables to create dynamic sales reports that empower businesses to optimize customer discounts, streamline negotiations, and identify lucrative market opportunities. These reports aren't just data summaries; they're strategic assets delivering actionable insights to elevate sales strategies, bolster customer satisfaction, and drive revenue growth.

My journey through this project honed my expertise across pivotal areas:
1. Mastering pivot tables for comprehensive data analysis.
2. Harnessing the power of Power Query for seamless data integration.
3. Commanding the fundamentals of DAX for advanced data modeling.
4. Elevating data presentation through strategic conditional formatting.
5. Extracting invaluable insights from sales metrics to fuel strategic decisions.

This project is more than just number-crunching—it's about arming businesses with the tools and knowledge to supercharge their sales initiatives.

PowerBI Project

AtliQ Business Insights 360🔍

Domain/Function: Business Intelligence

AtliQ Hardware encountered difficulties handling data in Excel😕. Goal: Transition from Excel to Power BI for improved understanding 📊. Objective: Gain insights into finance💰, sales💼, and supply chain areas🛒. Data Volume: 1.8 million entries📈. Tools Utilized: SQL, Power BI, Excel, DAX Studio💻.

View Project
Engagement

View Project
on GitHUB

AtliQ Business Insights 360🔍

Designing a compelling landing page that connects seamlessly with users, establishing it as an indispensable feature of our dashboard interface. 🎨🤝

AtliQ Business Insights 360🔍

Creating a data model with over 10 tables 📊💻

Project Details

🌟𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬🌟

🏠𝐇𝐨𝐦𝐞 𝐏𝐚𝐠𝐞: The central hub is designed for effortless navigation, offering swift entry to crucial information.

💰𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐕𝐢𝐞𝐰: Vital financial key performance indicators (KPIs), interactive charts, and adaptable parameters for a comprehensive financial analysis.

📈𝐒𝐚𝐥𝐞𝐬 𝐕𝐢𝐞𝐰: Gain insights into sales dynamics through scatter charts, product/customer performance data, and donut charts.

📢𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 𝐕𝐢𝐞𝐰: Explore in-depth marketing insights, including segment performance, waterfall charts, and versatile tables.

🚚𝐒𝐮𝐩𝐩𝐥𝐲 𝐂𝐡𝐚𝐢𝐧 𝐕𝐢𝐞𝐰: Streamline the supply chain by utilizing key metrics, trend charts, and detailed breakdowns.

👨🏻‍💼𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐯𝐞 𝐕𝐢𝐞𝐰: An essential section tailored for executives, delivering crucial metrics, revenue contributions, trend charts, and detailed tables.

Live Interactive Dashboard

SQL Project

Consumer Goods AD-HOC Insights💡

Domain/Function: Consumer Goods

Using SQL queries🔍10 AD-HOC requests guided AtliQ's success journey with data. Key insights revealed📈increased product diversity, dominance in 'Notebook' sales📒, and seasonal trends📊. SQL, Power BI, and PowerPoint tools were utilized.🛠️

View Project
on GitHUB

View Project
on View Project on Power BI

Other Tools

Power BI

Consumer Goods AD-HOC Insights💡

MARKET

Consumer Goods AD-HOC Insights💡

SQL QUERIES

Project Details

🌐𝐀𝐛𝐨𝐮𝐭 𝐭𝐡𝐞 𝐂𝐨𝐦𝐩𝐚𝐧𝐲: AtliQ Hardware excels in the computer hardware sector, serving both domestic and international markets.

🔍𝐓𝐡𝐞 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: Responding to the need for data-driven decisions, AtliQ Hardware's management initiated a SQL challenge to strengthen their analytics team. My task was to interpret 10 ad-hoc SQL requests and transform them into actionable insights.

🎯𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐚𝐧𝐝 𝐓𝐚𝐤𝐞𝐚𝐰𝐚𝐲𝐬:

📌𝐌𝐚𝐬𝐭𝐞𝐫𝐞𝐝 𝐃𝐚𝐭𝐚 𝐈𝐧𝐭𝐞𝐫𝐩𝐫𝐞𝐭𝐚𝐭𝐢𝐨𝐧: Emphasized thorough understanding of data before delving into SQL queries.

📌𝐄𝐧𝐡𝐚𝐧𝐜𝐞𝐝 𝐒𝐐𝐋 𝐒𝐤𝐢𝐥𝐥𝐬: Explored advanced concepts like Common Table Expressions (CTE), JOIN operations, Stored Procedures, etc.

📌𝐋𝐢𝐧𝐤𝐞𝐝 𝐒𝐐𝐋 𝐭𝐨 𝐑𝐞𝐚𝐥-𝐖𝐨𝐫𝐥𝐝 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬: Demonstrated practical applications of SQL in business contexts, beyond mere skill

PowerBI Project

Hospital Emergency Room Dashboard

Domain/Function: Hospital Emergency Room

This Power BI-based interactive dashboard provides valuable insights into the operations of a hospital’s Emergency Room (ER). It enables stakeholders to monitor, analyze, and make data-driven decisions to improve patient management and enhance service quality.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Hospital Emergency Room Dashboard

MONTHLY VIEW

Hospital Emergency Room Dashboard

CONSOLIDATED VIEW

Project Details

The purpose of this dashboard is to help hospital management and key stakeholders:
Monitor the performance of the Emergency Room (ER) using key operational metrics.
Track patient flow, wait times, and satisfaction to identify service bottlenecks.
Gain clarity on admission rates and department referrals for better resource planning.
Make timely, data-driven decisions to improve overall service efficiency.

Live Interactive Dashboard

PowerBI Project

Blinkit Sales Dashboard

Domain/Function: Blinkit Sales

📊This is an interactive sales analysis dashboard built for Blinkit data. It provides key insights on sales performance, outlet types, item categories, fat content, and location-based sales.

View Project
on GitHUB

Other Tools

Excel

Blinkit Sales Dashboard

MONTHLY SALES

Blinkit Sales Dashboard

DELIVERY DETAILS

Project Details

Key Insights
Total Sales: $1.2M
Average Sales: $141.0
Number of Items: 8,523
Average Rating: 4.0
Features
Filter Panel: Outlet type, Tier, Item type filters
Fat Content Analysis: Regular vs Low Fat comparison
Outlet Established Year Sales: Yearly sales trend
Item Type Sales: Top and bottom-performing product categories
Outlet Location Type: Tier-wise sales contribution
Outlet Type Analysis: Sales, Avg Sales, and No. of Items

Live Interactive Dashboard