This repository contains an Excel 2016-based analysis of bike sales data, exploring various demographic factors and their relationship to bike purchasing behavior.
- Original Data: - Contains raw sales data including columns for ID, Marital Status, Gender, Income, and other demographic details.
- Working Sheet: - A cleansed version of the original data with refined values and additional categories such as Age Brackets.
- Pivot Table Worksheet: - Features pivot tables analyzing average income per purchase, commute distances, and customer buying propensity by age category.
- Dashboard: - An interactive dashboard providing visual insights into the data, equipped with slicers for dynamic filtering.
- Lookup Queries: - A tab dedicated to dynamic VLOOKUP queries that allow users to retrieve specific data points.
- Duplicates removal.
- Standardization of categorical fields (Marital Status, Gender) using Excel's find and replace.
- Income values were normalized.
- Age categories were defined using nested IF statements in Excel.
- VLOOKUP Queries: Interactive lookups like finding income based on customer ID.
- Pivot Tables: Analysis of data dimensions such as income and customer commute.
- Visualizations: Bar charts and line charts demonstrating various sales metrics.
- Slicers: Enhanced filtering options for interactive data exploration.
To use this dashboard effectively:
- Utilize slicers to filter data across various dimensions like education, marital status, and region.
- Use the Lookup Queries tab for specific data retrievals by entering the required information in designated cells.
This project is open-sourced under the MIT License. See the LICENSE file for more details.