Projects

Excel Project: Adventure Works Sales Analysis Dashboard (Time series overview section)

I Built a two-dimensional interactive dashboard in Microsoft Excel to analyze revenue, profit, customer, and product performance, featuring a Time Series view for tracking trends and seasonality and a Detail view for identifying profit drivers across customers, products, and regions. Leveraged Excel formulas, Power Query for data cleaning, Power Pivot (DAX) for modeling, Pivot Tables for analysis, and charts with slicers for interactive visualization, showcasing end-to-end data analytics and storytelling.

 Click HERE To View Project : -

Adventure Works Sales Analysis Dashboard (Detail Overview section)

The Customer and Product Analysis dashboard provides a detailed view of profit drivers by examining customer segments, top-performing products, pricing tiers, and regional contributions. It highlights high-value customers, best-selling products, and key markets, enabling deeper insights into purchasing behavior and profitability to support targeted business decisions.

 Click HERE To View Project : -

Power BI Project: Zomato Sales  Insights Dashboard

I Built an interactive Power BI dashboard for Zomato to analyze sales, orders, ratings, and city performance. Cleaned data in Power Query Editor by handling missing values and standardizing formats. Performed data transformation and modeling using DAX to create key metrics and relationships. Designed dynamic visuals with slicers, enabling clear insights into trends, top-performing cities, and customer behavior for data-driven decision-making.

 Click HERE To View Project : -

Web scraping project

I built a scalable intelligence database of 501 AI/Data companies using Python (BeautifulSoup) and Instant Data Scraper. This hybrid approach saved 10+ hours (71% efficiency gain) while ensuring 90% accuracy. The final executive-ready Excel framework enables for scale competitive intelligence and streamline CRM integration.

 Click HERE To View Project : -

Power BI Project : Uber XL Ride Performance Dashboard

This project analyzes ride operations for Uber (Uber XL), transforming raw data into actionable insights on revenue, bookings, cancellations, and trip distances. Data was cleaned in Power Query Editor by handling missing values, removing duplicates, and standardizing formats. I performed data transformation by creating time-based fields and key metrics, then built a structured data model with relationships and DAX measures for KPIs. The final dashboard features interactive visuals (charts, KPI cards, slicers) to track performance trends, top locations, and service efficiency, enabling data-driven decision-making.

 Click HERE To View Project : -

Power Bi Project: Meta Ad Performance Dashboard

I developed an interactive Power BI dashboard for Meta Platforms(Facebook & Instagram) to analyze engagement performance across campaigns. This section focuses on analyzing ad performance on Facebook, highlighting key metrics such as impressions, clicks, engagements, and conversions. Data was prepared using Power Query Editor, then transformed and modeled with DAX to generate meaningful KPIs. Interactive visuals and filters allow users to explore campaign performance, identify trends, and understand audience engagement, supporting more effective ad optimization.

 Click HERE To View Project : -

Power Bi Project: Meta Ad Performance Dashboard (Instagram Section)

This section provides insights into campaign performance on Instagram, focusing on reach, engagement, and conversion metrics. After cleaning the data in Power Query Editor, transformations and calculations were applied using DAX. The visuals are designed to be interactive, enabling users to filter by campaigns and audience segments, uncover trends, and evaluate content performance for better decision-making.

 Click HERE To View Project : -

Power Bi Project: SwiftRoute Logistics (Executive Overview)

This project presents a 4-dimensional dashboard for SwiftRoute Logistics, offering a high-level view of key KPIs such as total orders, on-time delivery rate, CSAT, and average delivery time. It enables quick decision-making across operations. Built using Microsoft Power BI, the process involved data cleaning in Power Query Editor, DAX-based KPI creation, and interactive visualization design. Skills applied include data storytelling, Data modeling , KPI development, and dashboard design to deliver actionable business insights.

 Click HERE To View Project : -

Power Bi Project: SwiftRoute Logistics (Driver’s Overview)

The Driver’s Overview analyzes driver performance across SwiftRoute Logistics by evaluating experience vs. ratings, delivery trends, and delay frequency. It supports drill-down analysis for individual drivers, enabling performance tracking and optimization. A dynamic selection allows deep-diving into a specific driver’s performance, including delivery count, tenure, and monthly efficiency trends. This helps identify top performers and areas needing improvement.

 Click HERE To View Project : -

Power Bi Project: SwiftRoute Logistics (Hub’s Overview)

The Hub’s Overview evaluates operational capacity and efficiency across all logistics hubs. It compares order volume against hub capacity and ranks hubs based on performance. Additionally, it visualizes processing time across weekdays, helping identify bottlenecks and optimize resource allocation for improved throughput.

 Click HERE To View Project : -

Power Bi Project: SwiftRoute Logistics (Vehicles Overview)

This section analyzes fleet performance by tracking active vs. maintenance vehicles and total orders handled by each vehicle model. It provides insights into vehicle utilization, efficiency, and contribution to overall logistics operations, enabling better fleet management and maintenance planning.

 Click HERE To View Project : -

Research , Data collection & Analysis Project : Top  Skill Requirements For Data Analysts

Driven by the frustration of skilled analysts failing to secure roles, this dashboard captures the "ground truth" of the current job market by mapping the precise requirements of top employers. I manually curated over 100 high-fidelity data rows from LinkedIn job postings to identify the specific tools and experience levels companies actually prioritize. This research findings provides Market Intelligence revealing the technical benchmarks candidates must meet to be competitive.

 Click HERE To View Project : -

Research & Data collection Project : Skill Mismatch Analysis

To uncover why certified candidates remain unemployed, this dashboard compares educational content with industry reality. I audited EdTech platforms, manually extracting curriculum data to perform a Gap Analysis in Microsoft Excel. By identifying where syllabi lag behind the fast-evolving AI sector, this framework built with Python for deduplication and Attribute Mapping transformed fragmented data into a strategic asset, proving exactly why traditional training often falls short of professional expectations.

 Click HERE To View Project : -

Excel Project Retail Sales Performance Dashboard

I built an end-to-end Retail Sales Dashboard in Excel to transform raw data into a $24.8M revenue story. I used Power Query for rigorous data cleaning and Power Pivot to build a sophisticated data model with custom DAX measures. By leveraging Pivot Tables, I analyzed two critical dimensions: time-series trends to track monthly revenue fluctuations and performance metrics to pinpoint our most profitable customers and store locations.

 Click HERE To View Project : -

Excel Project: Pizza Sales Performance Dashboard

For this project, I developed an interactive Pizza Sales Dashboard to uncover peak operational hours and product performance. I began by using Power Query to clean and transform the raw transaction data, then utilized Power Pivot to create a data model and custom DAX measures for KPIs like Average Order Value. Through Pivot Tables, I analyzed two key dimensions: operational efficiency, focusing on daily/hourly order trends, and product profitability, identifying the best and worst-selling pizza categories.

 Click HERE To View Project : -

Excel Project: Pizza Sales Performance Dashboard - Copy

For this project, I developed an interactive Pizza Sales Dashboard to uncover peak operational hours and product performance. I began by using Power Query to clean and transform the raw transaction data, then utilized Power Pivot to create a data model and custom DAX measures for KPIs like Average Order Value. Through Pivot Tables, I analyzed two key dimensions: operational efficiency, focusing on daily/hourly order trends, and product profitability, identifying the best and worst-selling pizza categories.

Web scraping project: 500+ Dataset of AI & Analytics companies

In this project, i scraped and compiled a dataset of 500+ AI and analytics companies using Python (BeautifulSoup and browser extraction tools). Extracted key attributes such as location, services, industry, company size, and founding year. Performed data cleaning and transformation in Excel to standardize and structure the data. Delivered a high-quality dataset ready for exploratory analysis, visualization, and business insights.

 Click HERE To View Project : -

Data collection project: 100+ Freelance Data analyst Profile information

I conducted targeted research to identify freelance data analysts based in Pune, India, collecting 100+ profiles through Google search and LinkedIn. I manually extracted key information such as location, skills, experience, portfolio links, and contact details and structured it in Excel. I then performed data cleaning and transformation to standardize the dataset, creating a reliable, analysis-ready resource for talent insights and outreach..

 Click HERE To View Project : -

Data collection project :  40+ Edtech for Data Analysis Placement Detail

I researched and compiled a dataset of 40+ EdTech institutions in India offering data analytics programs with placement opportunities. Using AI tools like ChatGPT, Gemini, and Claude, I identified relevant websites and manually extracted placement coordinator details, contacts, and institutional data. I structured the dataset in Excel and performed cleaning and transformation, delivering a standardized, high-quality dataset ready for analysis, outreach, and student decision-making.

 Click HERE To View Project : -

Data collection project :  30+ Tech for Data Analysis Companies in Hinjewadi

I built a clean, reliable database of over 30 tech companies in Hinjewadi. I used AI tools to help find the information, then manually checked and verified every detail against official websites to ensure accuracy. I organized, cleaned, and formatted this data into a professional Excel sheet. This project highlights my skills in data research, quality control, and turning raw information into a ready-to-use resource.

 Click HERE To View Project : -

My handbooks and research projects Documents

A collection of self-created handbooks and reports documenting how to use key data analysis tools and techniques, which i created during my on-the-job training internship with ACC. It includes practical notes, step-by-step guides, and a presentation-focused report analyzing important KPIs for EdTech startups. These documents reflect my ability to simplify complex tools, communicate insights effectively, and apply data analysis concepts to real-world business scenarios.

 Click HERE To View Project : -
I BUILT MY SITE FOR FREE USING