Dataset

This dataset was created by Pinky Verma

Contents

Dataset

This dataset was created by Aziza Afrin

Contents

The dataset includes customer id,Martial Status,Gender,Income,Children,Education,Occupation,Home Owner,Cars,Commute Distance,Region,Age,Purchased Bike. Blog

The link for the Excel project to download can be found on GitHub here. It includes the raw data, Pivot Tables, and an interactive dashboard with Pivot Charts and Slicers. The project also includes business questions and the formulas I used to answer. The image below is included for ease. https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F12904052%2F61e460b5f6a1fa73cfaaa33aa8107bd5%2FBusinessQuestions.png?generation=1686190703261971&alt=media" alt=""> The link for the Tableau adjusted dashboard can be found here.

A screenshot of the interactive Excel dashboard is also included below for ease. https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F12904052%2Fe581f1fce8afc732f7823904da9e4cce%2FScooter%20Dashboard%20Image.png?generation=1686190815608343&alt=media" alt="">

This is a dataset downloaded off excelbianalytics.com created off of random VBA logic. I recently performed an extensive exploratory data analysis on it and I included new columns to it, namely: Unit margin, Order year, Order month, Order weekday and Order_Ship_Days which I think can help with analysis on the data. I shared it because I thought it was a great dataset to practice analytical processes on for newbies like myself.

Dataset

This dataset was created by Kesar_vani

Released under CC0: Public Domain

Contents

Dataset

This dataset was created by MYTHILI KB

Contents

Bike sales dataset analysis

Dataset

This dataset was created by Shiva Vashishtha

Contents

Dataset

This dataset was created by Andrés Armando Sánchez Martín

Released under Community Data License Agreement - Sharing - Version 1.0

Contents

The Superstore Sales Data dataset, available in an Excel format as "Superstore.xlsx," is a comprehensive collection of sales and customer-related information from a retail superstore. This dataset comprises* three distinct tables*, each providing specific insights into the store's operations and customer interactions.

Dataset

This dataset was created by Mohammed Azarudheen

Released under Other (specified in description)

Contents

Tool: Microsoft Excel

Dataset: Coffee Sales

Process: 1. Data Cleaning: • Remove duplicates and blanks. • Standardize date and currency formats.

1. Data Manipulation: • Sorting and filtering function to work
   with interest subsets of data. • Use XLOOKUP, INDEX-MATCH and IF
   formula for efficient data manipulation, such as retrieving, matching and organising information in spreadsheets

2. Data Analysis: • Create Pivot Tables and Pivot Charts with the formatting to visualize trends.

3. Dashboard Development: • Insert Slicers with the formatting for easy filtering and dynamic updates.

Highlights: This project aims to understand coffee sales trends by country, roast type, and year, which could help identify marketing opportunities and customer segments.

Dataset

This dataset was created by Tiyas Roy Choudhury

Contents

Dataset

This dataset was created by Sanjana Murthy

Released under CC BY-NC-SA 4.0

Contents

This data contains Sort & Filter functions

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.

Dataset

This dataset was created by Sanjana Murthy

Released under Community Data License Agreement - Permissive - Version 1.0

Contents

This dataset illustrates customer data from bike sales. It contains information such as Income, Occupation, Age, Commute, Gender, Children, and more. This is fictional data, created and used for data exploration and cleaning.

The link for the Excel project to download can be found on GitHub here. It includes the raw data, the cleaned data, Pivot Tables, and a dashboard with Pivot Charts and Slicers for interaction. This allows the interactive dashboard to filter by Marital Status, Region, and Education.

Below is a screenshot of the dashboard for ease. https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F12904052%2Fcbc9db6fe00f3201c64e4fdb668ce9d1%2FBikeBuyers%20Dashboard%20Image.png?generation=1686186378985936&alt=media" alt="">

Data organization for the figures in the document: Figure 3A LineOutWithSun_SSAzi_135to225_green_Correct_ROI5_INFO.xls Figure 3b LineOutWithSun_SSAzi_m45to45_green_Correct_ROI5_INFO.xls Figure 4 fulllinear_inDic_SqAzi_m180to0_CP_20to50_green_Correct_ROI5_INFO.xls fulllinear_inDic_SqAzi_m180to0_CP_20to50_green_Sim_Correct_ROI5_INFO.xls Figure 5a LineOut_Camera_Elevation_SqAzi_m180to0_green_Sim_Correct_ROI5_INFO.xls LineOut_Camera_Elevation_SqAzi_m180to0_green_Correct_ROI5_INFO.xls Figure 5b LineOut_Camera_Elevation_SqAzi_0to180_green_Correct_ROI5_INFO.xls LineOut_Camera_Elevation_SqAzi_0to180_green_Sim_Correct_ROI5_INFO.xls Figure 6a LineOutColor_SqAzi_m180to0_CP_20to50_Correct_ROI5_INFO.xls Figure 6b LineOutROI_SqAzi_m180to0_CP_20to50_green_Correct_INFO.xls Figure 7 fulllinear_inDic_SqAzi_m180to0_CP_20to50_green_Correct_ROI5_INFO.xls LineOut_MeshAoPDif_Camera_Elevation_SqAzi_0to180_green_Correct_ROI5_INFO.xls LineOut_MeshAoPDif_Camera_Elevation_SqAzi_m180to0_green_Correct_ROI5_INFO.xls

Dataset

This dataset was created by AYUSH CHOUDHARY

Contents

Excel spreadsheets by species (4 letter code is abbreviation for genus and species used in study, year 2010 or 2011 is year data collected, SH indicates data for Science Hub, date is date of file preparation). The data in a file are described in a read me file which is the first worksheet in each file. Each row in a species spreadsheet is for one plot (plant). The data themselves are in the data worksheet. One file includes a read me description of the column in the date set for chemical analysis. In this file one row is an herbicide treatment and sample for chemical analysis (if taken). This dataset is associated with the following publication: Olszyk , D., T. Pfleeger, T. Shiroyama, M. Blakely-Smith, E. Lee , and M. Plocher. Plant reproduction is altered by simulated herbicide drift toconstructed plant communities. ENVIRONMENTAL TOXICOLOGY AND CHEMISTRY. Society of Environmental Toxicology and Chemistry, Pensacola, FL, USA, 36(10): 2799-2813, (2017).