Excel data into dashboards

Excel

Data analysis of learners assessment data using Excel

🔷 Super Store Sales Analysis 🔷 Super Store Sales Analysis Dashboard built in MS Excel to analyze sales, profit, and customer behavior. Used Pivot Tables, Charts, and Slicers for interactive exploration. Explored trends across regions, categories, and customer segments.

Dashboard of road accidents occured during the period of 2021-22 with different reasons behind. Using Ms excel for the data processing and creating pivot tables , using fucntions and may more features of excel to create the final dashboard to give quick overview of data

Built an interactive Coffee Sales Dashboard in Excel leveraging Pivot Tables, Slicers, XLOOKUP, and INDEX-MATCH to analyze product-wise, regional, and time-based sales trends.

"Excel and Power Query practice projects: formulas, pivot tables, charts, and data transformation."

No description provided.

This analytics Excel dashboard provides a comprehensive overview of Liverpool's forward players' performance across all competitions in the 2024/2025 season. Key metrics include total goals, assists, big chances created/missed, shooting accuracy, dribbling efficiency, and player availability due to injuries.

Excel: Events Schedule Management with VBA macros and Formulas

A comprehensive analysis of sales and customer feedback data at Cafe Harmony, leveraging a master sample of 608 entries. Using advanced analytics and Excel visualizations, I uncovered insights into sales trends, stock management, product satisfaction, and consumption patterns—empowering strategic decisions to elevate the overall customer experience

Vrinda Store Analysis data cleaning, processing, analysis and dashboard creation in Excel.

An interactive coffee sales dashboard built in Excel using PivotTables, slicers and XLOOKUP.

This project showcases the ability to convert raw data into meaningful insights and build dashboards suitable for business decision-making, making it ideal for Data Analyst and Business Analyst roles.

The Excel Formulas and Data Analysis Showcase is an educational repository designed to provide users with an in-depth understanding of Excel formulas and their practical application in data analysis.

Repositório com conteúdo de estudos referente ao Excel.

Practicing essential Excel analyst formulas like CONCATENATE, RIGHT LEFT MID, IFERROR, SUMIFS, INDEX, SUMIFS, SEQUENCE, EDATE, and more for data analysis tasks.

In this research, coffee sales data is examined using Microsoft Excel and a dashboard, with a specific focus on crucial elements such as the average sales of various coffee types, cumulative sales by country over time, top customers, and the overall sales trajectory.

Interactive coffee sales Excel dashboard built with Pivot Tables, XLOOKUP, Slicers, and Timeline filters — covering orders, customers, and product data with dynamic visualizations.

Coffee Sales Dashboard

An interactive Excel dashboard analysing data science roles across countries, job schedules, and salary ranges. Demonstrates advanced Excel techniques including dynamic filtering, median-based salary analysis, XLOOKUP integration, and KPI-driven visual design.

Comprehensive Sales & Customer Feedback record analysis at Café Harmony using advanced Excel analytics.

Automated inventory reconciliation & out-of-stock alert system using Google Sheets and Apps Script

Analyzing Coffee Sales in MS Excel using XLOOKUP & INDEX MATCH

Sales Performance Tracker

Some important fuction and some Projects

Designed an interactive sales performance dashboard using Excel. Incorporated pivot tables and charts for visual representation. | Data Analyst BootCamp and a few Projects

Dynamic coffee sales analysis using MS Excel, XLOOKUP, VLOOKUPS, Pivoting, pivot table visualizations and data analytical principles.

This project analyses bike sales data using Microsoft Excel 365. Pivot Tables were used to explore relationships between customer demographics and bike purchases, while charts, slicers, and conditional formatting were used to build an interactive dashboard to understand sales trends.

This repository contains all my Microsoft Excel Reports & Dashboards.