Powered by
Codebasics DA Bootcamp

Vineet Kumar Dubey

Data Analyst

+91 6386952717 [email protected]

Resume

Hello, I am

Vineet Kumar Dubey.

2

PowerBI Projects

1

SQL Project

1

Excel Project

About Me

Hi, I'm Vineet — an aspiring Data Analyst with hands-on experience in Excel, SQL, and Power BI. I enjoy working with data to find patterns, build dashboards, and turn complex information into meaningful insights.

I believe the value of data lies in asking the right questions and using insights to solve real problems. My goal is to make data more understandable and useful for better decision-making — not just to build pretty charts.

Key Skills

Power BI

MySQL

Excel

My Projects

Awards & Certificate

SQL Beginner to Advanced For Data Professionals

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

Excel: Mother of Business Intelligence

SQL (Intermediate)- HackerRank

SQL (Intermediate)- HackerRank

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/vineet-dubey-5880831ba/

+ 91 6386952717

https://github.com/vineet463?tab=repositories

PowerBI Project

Business Insights 360

Domain/Function: Fast Moving Consumer Goods

Developed a comprehensive BI solution with Power BI to replace AtliQ Hardware’s outdated Excel reporting system, delivering real-time insights across Finance, Sales, Marketing, and Supply Chain to drive data-driven decisions and support global expansion.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Home View: Central hub for navigating all dashboards with interactive buttons for Finance, Sales, Marketing, Supply Chain, and Executive.

Business Insights 360

Executive View dashboard to provide leadership with high-level KPIs, business performance insights, and data-driven decision support across multiple departments.

Project Details

This project provides a centralized Business Intelligence solution for AtliQ Hardware, a rapidly growing electronics company facing challenges with traditional Excel-based reporting. Using SQL and Power BI, I developed interactive dashboards across Finance, Sales, Marketing, Supply Chain, and Executive domains.

The solution is built on a snowflake schema data model with data integrated from SQL and Excel sources. Advanced DAX calculations and DAX Studio optimization techniques were used to improve dashboard performance and analytical capabilities.

The project replaces manual reporting with automated, real-time dashboards that support faster and data-driven decision-making. Key insights focused on profitability, forecast accuracy, operational efficiency, customer trends, and expense analysis.

This project also strengthened my skills in KPI reporting, dashboard design, business analysis, stakeholder-focused reporting, and storytelling with data.

Project video

Live Interactive Dashboard

SQL Project

Executive Management

Domain/Function: Consumer Goods

Analyzed real-world business scenarios using SQL for AtliQ Hardware. Solved 10 ad-hoc data problems with optimized queries and visualized insights using Power BI to support executive decision-making.

View Project
Engagement

View Project
on GitHUB

Executive Management

Finding Unique Product count for each segment

Executive Management

Top 3 products in each division that have a high total sold quantity in the fiscal year 2021

Project Details

This project focuses on solving real-world business problems in the Consumer Goods domain using SQL analytics. Developed as part of the Codebasics SQL Challenge, the project analyzes data for AtliQ Hardware, a growing electronics company aiming to improve data-driven decision-making.

Using SQL, I solved 10 ad-hoc business requests by analyzing customer, product, sales, manufacturing, and pricing data. Advanced SQL concepts such as CTEs, Joins, Window Functions and Aggregate Functions were used to generate actionable insights.

The project helped identify top-performing products, customer trends, sales performance, discount patterns, and channel contributions. Insights were later visualized through dashboards and presentations to support executive-level decision-making.

Tools Used: SQL, Power BI, Excel
Skills: Data Analysis, Business Intelligence, KPI Reporting, Query Optimization, and Dashboard Storytelling.

Project video

Excel Project

Sales & Finance Reporting

Domain/Function: Consumer Goods

Comprehensive sales and finance analytics project for AtliQ Hardware using Ms Excel. Delivered data-driven insights, performance benchmarking, and strategic reporting through dashboards, Power Query, Power Pivot, and DAX.

View Project
on GitHUB

Sales & Finance Reporting

This report highlights Net Sales for different customers across the years 2019, 2020, and 2021. It also shows the percentage growth in performance from 2020 to 2021.

Sales & Finance Reporting

This report is to identified the top 10 products based on the percentage increase in net sales from 2020 to 2021. This helps the company to understand which products are performing well and which ones are driving revenue growth.

Project Details

AtliQ Hardwares operates across multiple global markets with a wide product mix.
It focuses on Sales and Finance Analytics using Excel to help businesses monitor performance, analyze trends, and support data-driven decision-making. The project includes customer performance reports, market performance analysis against targets, and Profit & Loss (P&L) reports by fiscal year, months, and markets.

PowerBI Project

Atliq Mart Supply Chain analysis

Domain/Function: FMCG / Supply Chain

Analyzed supply chain performance using Power BI dashboards to track OTIF, delivery efficiency, inventory performance, and customer-level KPIs for data-driven operational insights.

View Project
Engagement

View Project
on GitHUB

Atliq Mart Supply Chain analysis

Monitors key supply chain KPIs such as OT%, IF%, OTIF%, LIFR%, and VOFR% while providing customer-level performance insights to identify operational inefficiencies and service gaps.

Atliq Mart Supply Chain analysis

Analyzes monthly supply chain metric trends and product-level performance using LIFR% and VOFR% insights to evaluate fulfillment efficiency and target achievement.

Project Details

This project focuses on analyzing and improving supply chain performance for AtliQ Mart using data analytics and dashboard reporting. The objective was to identify operational inefficiencies and provide insights to improve order fulfillment, delivery performance, and customer service levels.
Using Power BI interactive dashboards were developed to track key supply chain KPIs such as OT%, IF%, OTIF%, LIFR%, and VOFR%. The analysis included customer-level performance tracking, target vs actual comparisons, and operational trend analysis to support data-driven decision-making.
The project helps visualize supply chain bottlenecks, monitor service performance, and identify areas requiring improvement across logistics and inventory operations.

Live Interactive Dashboard