excel-project

Building an interactive Microsoft Excel dashboard to allow the users to quickly identify trends in coffee bean sales.

☕ Interactive Excel BI Dashboard | Analyzed 149K+ sales transactions using Power Query & Pivot Tables to uncover $698K revenue insights & growth trends. 📈

This project showcases a complete data cleaning and basic analytics workflow on a real-world-style employee health dataset, simulating inconsistencies often found in raw data. It includes both uncleaned and cleaned Excel files, plus a pivot-based dashboard to derive insights.

This Power BI dashboard is tailored for marketing strategists to analyze sales trends and customer behavior. It offers key insights that enable the identification of sales opportunities and the optimization of marketing campaigns, ultimately enhancing business sales.

Excel data into dashboards

This Personal Income & Expense Tracker is designed to help individuals manage their finances by tracking income sources and expenses on a monthly basis. Created using Excel by Shaikh Minhaj as part of Assignment 1 from the Codebasics Data Analytics Bootcamp

This project showcases a complete data cleaning and basic analytics workflow on a real-world-style employee health dataset, simulating inconsistencies often found in raw data. It includes both uncleaned and cleaned Excel files, plus a pivot-based dashboard to derive insights.

This project showcases a dynamic sales dashboard built in Microsoft Excel. It transforms raw transactional data into actionable insights, visualizing product performance, sales trends over time, and quantity/revenue distribution, aiding in quick decision-making.

A collection of Excel-based data analytics and dashboard projects focused on transforming raw business data into interactive dashboards, actionable insights, and decision-support reports using Pivot Tables, Power Query, KPI cards, slicers, and data visualization techniques.

Interactive Retail Sales Dashboard in Microsoft Excel featuring Pivot Tables, Pivot Charts, Slicers, KPI analysis, and business insights for retail sales data.

An analytical overview of call center operations aimed at improving service efficiency and customer satisfaction. The project leverages performance metrics and operational data to deliver insights through detailed reporting.

Built a refreshable ETL pipeline in Excel using Power Query and the Olist E-Commerce dataset. Imported, cleaned, transformed, validated, and merged multiple datasets into a single analytical table, demonstrating data cleaning, multi-table joins, validation checks, and analytical modelling workflows.

A data-driven study on UPI usage, user perception, security trust, and challenges in India using Excel Dashboard & Survey Analysis

GST Reconciliation project comparing GSTR-1 and GSTR-3B to identify mismatches.

Interactive Excel dashboard project using Pivot Tables, Charts, Slicers, and Data Analysis techniques to generate business insights.

Interactive Excel dashboard analyzing sales, profitability, and delivery performance to generate actionable supply chain insights.

Comprehensive finance analytics project for Atliq Hardware – Excel-based dashboards and reports analyzing customers, markets, and profitability.

Interactive Sales Analysis Dashboard built with Advanced Excel, Power Pivot (Data Model), Pivot Tables, Dynamic KPIs, Slicers, Timeline, and Business Intelligence techniques.

Interactive Excel sales dashboard analysing Superstore revenue, profit, regional performance, product trends, and KPIs using PivotTables, charts, slicers, and advanced Excel analytics techniques for business reporting and decision-making.

Excel-based crash incident analysis (2019–2023) with data cleaning, pivot tables, visualizations, and an interactive dashboard.