his project involves the creation of an interactive Excel dashboard for SwiftAuto Traders to analyze and visualize car sales data. The dashboard includes several visualizations to provide insights into car sales, profits, and performance across different models and manufacturers. The project makes use of various charts and slicers in Excel for the analysis.

Objective: The primary goal of this project is to showcase the ability to manipulate and visualize car sales data effectively using Excel. The dashboard aims to provide:

Profit and Sales Analysis for each dealer. Sales Performance across various car models and manufacturers. Resale Value Analysis comparing prices and resale values. Insights into Retention Percentage by car models. Files in this Project: Car_Sales_Kaggle_DV0130EN_Lab3_Start.xlsx: The original dataset used to create the dashboard. dashboards.xlsx: The final Excel file that contains the complete dashboard with interactive charts and slicers. Key Visualizations: Average Price and Year Resale Value: A bar chart comparing the average price and resale value of various car models. Power Performance Factor: A column chart displaying the performance across different car models. Unit Sales by Model: A donut chart showcasing unit sales by car model. Retention Percentage: A pie chart illustrating customer retention by car model. Tools Used: Microsoft Excel for creating and organizing the visualizations and dashboard. Excel Slicers for interactive filtering. Charts: Bar charts, pie charts, column charts, and sunburst charts. How to Use: Download the Dataset: You can download the Car_Sales_Kaggle_DV0130EN_Lab3_Start.xlsx file from Kaggle and follow the steps to create a similar dashboard in Excel. Open the Dashboard: The dashboards.xlsx file contains the final version of the dashboard. Simply open it in Excel and start exploring the interactive charts and slicers.

Sheet 1 (Raw-Data): The raw data of the study is provided, presenting the tagging results for the used measures described in the paper. For each subject, it includes multiple columns: A. a sequential student ID B an ID that defines a random group label and the notation C. the used notation: user Story or use Cases D. the case they were assigned to: IFA, Sim, or Hos E. the subject's exam grade (total points out of 100). Empty cells mean that the subject did not take the first exam F. a categorical representation of the grade L/M/H, where H is greater or equal to 80, M is between 65 included and 80 excluded, L otherwise G. the total number of classes in the student's conceptual model H. the total number of relationships in the student's conceptual model I. the total number of classes in the expert's conceptual model J. the total number of relationships in the expert's conceptual model K-O. the total number of encountered situations of alignment, wrong representation, system-oriented, omitted, missing (see tagging scheme below) P. the researchers' judgement on how well the derivation process explanation was explained by the student: well explained (a systematic mapping that can be easily reproduced), partially explained (vague indication of the mapping ), or not present.

Tagging scheme:
Aligned (AL) - A concept is represented as a class in both models, either

with the same name or using synonyms or clearly linkable names; Wrongly represented (WR) - A class in the domain expert model is incorrectly represented in the student model, either (i) via an attribute, method, or relationship rather than class, or (ii) using a generic term (e.g., user'' instead ofurban planner''); System-oriented (SO) - A class in CM-Stud that denotes a technical implementation aspect, e.g., access control. Classes that represent legacy system or the system under design (portal, simulator) are legitimate; Omitted (OM) - A class in CM-Expert that does not appear in any way in CM-Stud; Missing (MI) - A class in CM-Stud that does not appear in any way in CM-Expert.

All the calculations and information provided in the following sheets

originate from that raw data.

Sheet 2 (Descriptive-Stats): Shows a summary of statistics from the data collection,

including the number of subjects per case, per notation, per process derivation rigor category, and per exam grade category.

Sheet 3 (Size-Ratio):

The number of classes within the student model divided by the number of classes within the expert model is calculated (describing the size ratio). We provide box plots to allow a visual comparison of the shape of the distribution, its central value, and its variability for each group (by case, notation, process, and exam grade) . The primary focus in this study is on the number of classes. However, we also provided the size ratio for the number of relationships between student and expert model.

Sheet 4 (Overall):

Provides an overview of all subjects regarding the encountered situations, completeness, and correctness, respectively. Correctness is defined as the ratio of classes in a student model that is fully aligned with the classes in the corresponding expert model. It is calculated by dividing the number of aligned concepts (AL) by the sum of the number of aligned concepts (AL), omitted concepts (OM), system-oriented concepts (SO), and wrong representations (WR). Completeness on the other hand, is defined as the ratio of classes in a student model that are correctly or incorrectly represented over the number of classes in the expert model. Completeness is calculated by dividing the sum of aligned concepts (AL) and wrong representations (WR) by the sum of the number of aligned concepts (AL), wrong representations (WR) and omitted concepts (OM). The overview is complemented with general diverging stacked bar charts that illustrate correctness and completeness.

For sheet 4 as well as for the following four sheets, diverging stacked bar

charts are provided to visualize the effect of each of the independent and mediated variables. The charts are based on the relative numbers of encountered situations for each student. In addition, a "Buffer" is calculated witch solely serves the purpose of constructing the diverging stacked bar charts in Excel. Finally, at the bottom of each sheet, the significance (T-test) and effect size (Hedges' g) for both completeness and correctness are provided. Hedges' g was calculated with an online tool: https://www.psychometrica.de/effect_size.html. The independent and moderating variables can be found as follows:

Sheet 5 (By-Notation):

Model correctness and model completeness is compared by notation - UC, US.

Sheet 6 (By-Case):

Model correctness and model completeness is compared by case - SIM, HOS, IFA.

Sheet 7 (By-Process):

Model correctness and model completeness is compared by how well the derivation process is explained - well explained, partially explained, not present.

Sheet 8 (By-Grade):

Model correctness and model completeness is compared by the exam grades, converted to categorical values High, Low , and Medium.

Compare state-level estimates from the 2021-2022 National Surveys on Drug Use and Health (NSDUH) using p-values. The tables accompany the2021-2022 NSDUH State Estimates of Substance Use and Mental Disorders, and can be used to determine whether the difference in estimates between two geographic areas are statistically significant. Aguide to their useis also available.The tables are available in an Excel spreadsheet or a zip file containing CSV text files. Each tab or text file contains p-values for a particular measure and a particular age group.

Vrinda Store: Interactive Ms Excel dashboardVrinda Store: Interactive Ms Excel dashboard Feb 2024 - Mar 2024Feb 2024 - Mar 2024 The owner of Vrinda store wants to create an annual sales report for 2022. So that their employees can understand their customers and grow more sales further. Questions asked by Owner of Vrinda store are as follows:- 1) Compare the sales and orders using single chart. 2) Which month got the highest sales and orders? 3) Who purchased more - women per men in 2022? 4) What are different order status in 2022?

And some other questions related to business. The owner of Vrinda store wanted a visual story of their data. Which can depict all the real time progress and sales insight of the store. This project is a Ms Excel dashboard which presents an interactive visual story to help the Owner and employees in increasing their sales. Task performed : Data cleaning, Data processing, Data analysis, Data visualization, Report. Tool used : Ms Excel The owner of Vrinda store wants to create an annual sales report for 2022. So that their employees can understand their customers and grow more sales further. Questions asked by Owner of Vrinda store are as follows:- 1) Compare the sales and orders using single chart. 2) Which month got the highest sales and orders? 3) Who purchased more - women per men in 2022? 4) What are different order status in 2022? And some other questions related to business. The owner of Vrinda store wanted a visual story of their data. Which can depict all the real time progress and sales insight of the store. This project is a Ms Excel dashboard which presents an interactive visual story to help the Owner and employees in increasing their sales. Task performed : Data cleaning, Data processing, Data analysis, Data visualization, Report. Tool used : Ms Excel Skills: Data Analysis · Data Analytics · ms excel · Pivot Tables

This dataset contains video game sales data prepared for an Excel data analysis and dashboard project.

It includes detailed information on:

Game titles

Platforms

Genres

Publishers

Regional and global sales

The dataset was cleaned, structured, and analyzed in Microsoft Excel to explore patterns in the global video game market. It can be used to:

Practice data cleaning and pivot tables

Build interactive dashboards

Perform sales comparisons across regions and genres

Develop business insights from entertainment data

🧩 File Information

Format: .xlsx (Excel Workbook)

Columns: Name, Platform, Year, Genre, Publisher, NA_Sales, EU_Sales, JP_Sales, Other_Sales, Global_Sales

💡 Use Cases

Excel dashboard and chart creation

Data visualization and storytelling

Business and market analysis practice

Portfolio or learning projects

👤 Prepared by

Adewale Lateef W — for data analysis and Excel dashboard learning purposes.

This repository describes the dataset used for intraspecific (among individuals) and intraspecific (between species) comparisons, and data for female-entrance analysis.

Compare state-level estimates from the 2017-2018 National Surveys on Drug Use and Health (NSDUH) using p-values. The tables accompany the2017-2018 NSDUH State Estimates of Substance Use and Mental Disorders, and can be used to determine whether the difference in estimates between two geographic areas are statistically significant. A guide to their use is also included.The tables are available in an Excel spreadsheet or a zip file containing CSV text files. Each tab or text file contains p-values for a particular measure and a particular age group.

These tables show the significance testing results between a particular state and other states or the national estimate. They are in CSV or Excel format.

📊 Road Accident Data Analysis: Interactive Excel Dashboard 🚗

Excited to share my Kaggle project focusing on road accident data analysis. Leveraging Excel's power, I've developed an interactive dashboard offering comprehensive insights for safer roads.

Key Aspects:

Data Processing & Cleaning: Ensured data reliability through meticulous processing. KPIs: Primarily focused on Total Casualties, with detailed breakdowns for Fatal, Serious, Slight, and by Car type. Visualizations: Engaging charts - Doughnuts, Line, Bar, and Pie - offering a holistic view of accident trends. Interactivity: User-friendly features include Urban/Rural and Year filters for dynamic exploration. Unique Insights:

Monthly Trends: Line chart for a nuanced comparison of current vs. previous year casualties. Road Type Breakdown: Bar chart to showcase casualties distributed across different road types. Geospatial Analysis: Doughnut charts detailing casualties by location and area. Call for Collaboration: Seeking Kaggle community input for refinement and optimization. Let's collectively contribute to making our roads safer through data-driven insights!

DataAnalysis #RoadSafety #InteractiveDashboard #KaggleProject #Excel #DataVisualization #CollaborationOpportunity

Looking forward to your feedback and contributions! 🚀🌐

All Comparisons of Differentially Expressed Genes - excel sheet containing the annotations and fold change values of the all the differentially expressed genes between the different clone comparisonsFinal List of Common Genes - excel sheet containing the list of genes that were commonly differentially expressed between all the aphid clone comparisons. Also contains table and bar chart presenting the number of times each candidate gene selected from previous literature was found in each aphid clone comparison.Non-direct and Direct Competition - excel sheet containing number of nymphs produced by all 6 clones on the 3 host plants in the non-direct competition, and the number of nymphs produced by the two clones NS and Viola in the direct competition experiment.sterror - excel sheet containing the means and standard error values of the 6 grouped resistant and susceptible clones in the non-direct competition experiment, used to make the bar plot for the non-direct competition experiment.sterror2 - excel sheet containing the means and standard error values of the resistant clone Viola and susceptible clone NS in the direct competition experiment, used to make the bar plot for the direct competition experiment.cabbagettest - excel sheet containing the number of nymphs produce by the 6 grouped resistant and susceptible clones on the 3 host plants, used to conduct the unpaired t tests to compare the reproductive performance of resistant and susceptible clones on the 3 different host plants when in not in competitiondirectcompetition - excel sheet containing the number of nymphs produce by the resistant clone Viola and susceptible clone NS on the 3 host plants, used to conduct the unpaired t tests comparing the reproductive performance of resistant and susceptible clones on the 3 different host plants when in direct competitionAPHID HOST SHIFT DISS Rscript - R script containing all my statistical tests: unpaired t tests of resistant and susceptible clones on the 3 host plants when in direct and non direct competition, and kruskal Wallis tests and post hoc Dunns test to identify significant differences between individual and resistant and susceptible clones on the different host plants. Also contains all my code for my bar charts for the non-direct and direct competition experiments and the code for my box plots showing the significant differences between individual clones and resistant and susceptible clones on the different host plants.Up and Down-regulated Genes Graph - excel sheet containing the number of and and down regulated genes in each aphid clone comparison and the bar graph generated from this data.

In this project, I analysed the employees of an organization located in two distinct countries using Excel. This project covers:

1) How to approach a data analysis project 2) How to systematically clean data 3) Doing EDA with Excel formulas & tables 4) How to use Power Query to combine two datasets 5) Statistical Analysis of data 6) Using formulas like COUNTIFS, SUMIFS, XLOOKUP 7) Making an information finder with your data 8) Male vs. Female Analysis with Pivot tables 9) Calculating Bonuses based on business rules 10) Visual analytics of data with 4 topics 11) Analysing the salary spread (Histograms & Box plots) 12) Relationship between Salary & Rating 13) Staff growth over time - trend analysis 14) Regional Scorecard to compare NZ with India

Including various Excel features such as: 1) Using Tables 2) Working with Power Query 3) Formulas 4) Pivot Tables 5) Conditional formatting 6) Charts 7) Data Validation 8) Keyboard Shortcuts & tricks 9) Dashboard Design

This resource, a MS Excel refresher, extends the level for this Data Nugget. Students are given an Excel workbook with the data and asked to graph and calculate diversity using Excel functions (rather than drawing graphs by hand as in the original data nugget). The data set used is the same. I use this activity in an upper division Environmental Science course for majors that focuses on Restoration Ecology. The simplicity of the data set and the comparisons of reptile diversity among urban, non-urban and urban rehabilitated lend for a great example for doing calculations in spreadsheets.

This report from the GLA Intelligence Unit compares 2011 census estimates of the population aged 0-18 to the following alternative data sources:

• ONS 2010 based sub-national population projections (SNPP);

• GLA 2011 round population projections;

• General Practitioner registrations; and

• Child benefit claims.

The report is available to download here.

An Excel file containing the data behind charts and tables in the report is available to download here

Purpose – The conversion between calibrated airspeed (CAS) and equivalent airspeed (EAS) is relatively cumbersome, because it involves the calculation of incompressible flow, for which the equations are quite long. If calculations on the computer are required, conversions with equations are necessary. In contrast, this project calculates a CAS to EAS Compressibility Correction Chart, which allows to convert CAS to EAS very quickly by reading the correction from a graph. --- Methodology – In Excel, compressibility correction is achieved through flight mechanics formulas. The correction is calculated with two distinct functions, one based on Mach Number and the other on pressure altitude. These functions are graphed individually and then integrated to produce the Compressibility Correction Chart. --- Findings – The Compressibility Correction Chart was successfully recreated as a 2-D graph. Upon comparison with other correction charts, the EAS-CAS-results demonstrate a mere 0% deviation, proving the accuracy of the findings and validating their near-perfect alignment. --- Research Limitations – Due to a limitation in Excel, which allows for 255 series for plotting, the range of input parameters had to be adjusted accordingly. The iterations of altitude span 1000 ft intervals, while those for Mach Number span 0.05 intervals. --- Practical Implications – Pilots can easily use the Compressibility Correction Chart for quick and highly accurate calculations when needed. --- Originality – CAS-EAS Compressibility Correction Charts are available in other sources. This paper represents a recreation of the 2-D Correction Chart by the combination of plots: one as function of Mach Number and the other of pressure altitude, using the Excel Software.

Excel spreadsheet containing, in separate sheets, the underlying raw data for graphs and figure panels. (XLSX)

The trematode parasite Schistosoma mansoni causes schistosomiasis, which affects over 200 million people worldwide. Schistosomes are dioecious, with egg laying depending on the females’ obligatory pairing with males. Long non-coding RNAs (lncRNAs) are transcripts longer than 200 nucleotides with low or no protein-coding potential that have been involved in other species with reproduction, stem cell maintenance, and drug resistance. In S. mansoni, we recently showed that the knockdown of one lncRNA affects the pairing status of these parasites. Here, we re-analyzed public RNA-Seq data from paired and unpaired adult male and female worms and their gonads, obtained from mixed-sex or single-sex cercariae infections, and found thousands of differentially expressed pairing-dependent lncRNAs among the 23 biological samples that were compared. The expression levels of selected lncRNAs were validated by RT-qPCR using an in vitro unpairing model. In addition, the in vitro silencing of three selected lncRNAs showed that knockdown of these pairing-dependent lncRNAs reduced cell proliferation in adult worms and their gonads, and are essential for female vitellaria maintenance, reproduction, and/or egg development. Remarkably, in vivo silencing of each of the three selected lncRNAs significantly reduced worm burden in infected mice by 26 to 35%. Whole mount in situ hybridization experiments showed that these pairing-dependent lncRNAs are expressed in reproductive tissues. These results show that lncRNAs are key components intervening in S. mansoni adult worm homeostasis, which affects pairing status and survival in the mammalian host, thus presenting great potential as new therapeutic target candidates.

Compare state and regional estimates for measures of substance use and mental health using p-values. The tables are a companion to the state-level estimatetablesfrom the 2022-2023 National Surveys on Drug Use and Health (NSDUH). This resource includes both the p-value tables and a guide for their use in determining whether differences between two geographic areas are statistically significant.The tables are available in an Excel spreadsheet or a zip file containing CSV text files. Each tab or text file contains all the geographies for a particular measure and a particular age group.

📊 Bank Transaction Analytics Dashboard – SQL + Excel

🔹 Overview

This project focuses on Bank Transaction Analysis using a combination of SQL scripts and Excel dashboards. The goal is to provide insights into customer spending patterns, payment modes, suspicious transactions, and overall financial trends.

The dataset and analysis files can help learners and professionals understand how SQL and Excel can be used together for business decision-making, customer behavior tracking, and data-driven insights.

🔹 Contents

The dataset includes the following resources:

📂 SQL Scripts:

Create & Insert tables

15 Basic Queries

15 Advanced Queries

📂 CSV File:

Bank Transaction Analytics.csv (main dataset)

📂 Excel Charts:

Pie, Bar, Column, Line, Doughnut charts

Final Interactive Dashboard

📂 Screenshots:

Query outputs, Charts, and Final Dashboard visualization

📂 PDF Reports:

Project Report

Dashboard Report

📄 README.md:

Complete documentation and step-by-step explanation

🔹 Key Insights

26–35 age group spent the most across categories.

Amazon identified as the top merchant.

NetBanking showed the highest share compared to POS/UPI.

Travel & Shopping emerged as dominant categories.

🔹 Applications

Detecting suspicious transactions.

Understanding customer behavior.

Identifying top merchants and categories.

Building business intelligence dashboards.

🔹 How to Use

Download the dataset and SQL scripts.

Run Bank_Transaction_Analytics.SQL to create and insert data.

Execute the queries (Basic + Advanced) for insights.

Open Excel files to explore interactive charts and dashboards.

Refer to Project Report PDF for documentation.

🔹 Author

👩‍💻 Created by: Prachi Singh

GitHub: Bank Transaction Analytics Dashboard(https://github.com/prachi-singh-ds/Bank-Transaction-Analytics-Dashboard)

⚡This project is a complete SQL + Excel integration case study and is suitable for Data Science, Business Analytics, and Data Engineering portfolios.

This interactive sales dashboard is designed in Excel for B2C type of Businesses like Dmart, Walmart, Amazon, Shops & Supermarkets, etc. using Slicers, Pivot Tables & Pivot Chart.

Dashboard Overview

1. Sales dashboard ==> basically, it is designed for the B2C type of business. like Dmart, Walmart, Amazon, Shops & supermarkets, etc.
2. Slices ==> slices are used to drill down the data, on the basis of yearly, monthly, by sales type, and by mode of payment.
3. Total Sales/Total Profits ==> here is, the total sales, total profit, and profit percentage these all are combined into a monthly format and we can hide or unhide it to view it as individually or comparative.
4. Product Visual ==> the visual indicates product-wise sales for the selected period. Only 10 products are visualized at a glance, and you can scroll up & down to view other products in the list.
5. Daily Sales ==> It shows day-wise sales. (Area Chart)
6. Sales Type/Payment Mode ==> It shows sales percentage contribution based on the type of selling and mode of payment.
7. Top Product & Category ==> this is for the top-selling product and product category.
8. Category ==> the final one is the category-wise sales contribution.

Datasheets Overview

1. The dataset has the master data sheet or you can call it a catalog. It is added in the table form.
2. The first column is the product ID the list of items in this column is unique.
3. Then we have the product column instead of these two columns, we can manage with only one also but I kept it separate because sometimes product names can be the same, but some parameters will be different, like price, supplier, etc.
4. The next column is the category column, which is the product category. like cosmetics, foods, drinks, electronics, etc.
5. Then we have 4th column which is the unit of measure (UOM) you can update it also, based on the products you have.
6. And the last two columns are buying price and selling price, which means unit purchasing price and unit selling price.

Input Sheet

The first column is the date of Selling. The second column is the product ID. The third column is quantity. The fourth column is sales types, like direct selling, are purchased by a wholesaler or ordered online. The fifth column is a mode of payment, which is online or in cash. You can update these two as per requirements. The last one is a discount percentage. if you want to offer any discount, you can add it here.

Analysis Sheet: where all backend calculations are performed.

So, basically these are the four sheets mentioned above with different tasks.

However, a sales dashboard enables organizations to visualize their real-time sales data and boost productivity.

A dashboard is a very useful tool that brings together all the data in the forms of charts, graphs, statistics and many more visualizations which lead to data-driven and decision making.

Questions & Answers

1. What percentage of profit ratio of sales are displayed in the year 2021 and year 2022? ==> Total profit ratio of sales in the year 2021 is 19% with large sales of PRODUCT42, whereas profit ratio of sales for 2022 is 22% with large sales of PRODUCT30.
2. Which is the top product that have large number of sales in year 2021-2022? ==> The top product in the year 2021 is PRODUCT42 with the total sales of $12,798 whereas in the year 2022 the top product is PRODUCT30 with the total sales of $13,888.
3. In Area Chart which product is highly sold on 28th April 2022? ==> The large number of sales on 28th April 2022 is for PRODUCT14 with a 24% of profit ratio.
4. What is the sales type and payment mode present? ==> The sale type and payment modes show the sales percentage contribution based on the type of selling and mode of payment. Here, the sale types are Direct Sales with 52%, Online Sales with 33% and Wholesaler with 15%. Also, the payment modes are Online mode and Cash equally distributed with 50%.
5. In which month the direct sales are highest in the year 2022? ==> The highest direct sales can be easily identified which is designed by monthly format and it’s the November month where direct sales are highest with 28% as compared with other months.
6. Which payment mode is highly received in the year 2021 and year 2022? ==> The payments received in the year 2021 are the cash payments with 52% as compared with online transactions which are 48%. Also, the cash payment highly received is in the month of March, July and October with direct sales of 42%, Online with 45% and wholesaler with 13% with large sales of PRODUCT24. ==> The payments received in the year 2022 are the Online payments with 52% as compared with cash payments which are 48%. Also, the online payment highly received is in the month of Jan, Sept and December with direct sales of 45%, Online with 37% and whole...

Project Priority Matrix (Dynamic Excel Tool)

Overview

This dataset provides a dynamic Excel model for prioritizing projects based on Feasibility, Impact, and Size.
It visualizes project data on a Bubble Chart that updates automatically when new projects are added.

Use this tool to make data-driven prioritization decisions by identifying which projects are most feasible and high-impact.

Goal

Organizations often struggle to compare multiple initiatives objectively.
This matrix helps teams quickly determine which projects to pursue first by visualizing:

• Feasibility → How achievable a project is
• Impact → The potential benefit or value it delivers
• Size → The level of effort or resources required

How It Works

1. Each project is rated on a 1–10 scale for:
   • Feasibility
   • Impact
   • Size
2. The Excel file uses a Bubble Chart:
   • X-axis: Feasibility
   • Y-axis: Impact
   • Bubble size: Project Size
3. The chart automatically updates when new projects or scores are added.

Example (partial data):

Interpretation Guide

Excel Features

• Dynamic Bubble Chart (updates with new data)
• Named Ranges for auto-expanding data
• Optional Conditional Formatting
• Data Validation for consistent scoring

How to Use

1. Download and open Project_Priority_Matrix.xlsx.
2. Go to the Data sheet.
3. Add your project names and scores (1–10).
4. Watch the chart update instantly to reflect your data.

You can use this for: - Portfolio management
- Product or feature prioritization
- Strategy planning workshops

File Information

• File: Project_Priority_Matrix.xlsx
• Format: Excel (.xlsx)
• Version: 1.0
• Last Updated: October 2025

License

Free for personal and organizational use.
Attribution is appreciated if you share or adapt this file.

Author: [Asjad]
Contact: [m.asjad2000@gmail.com]
Compatible With: Microsoft Excel 2019+ / Office 365