Excel Project
Overview
In this Excel project, I worked with a dataset containing survey data about individuals and their bike purchasing habits. My tasks included data cleaning, the creation of pivot tables, and the development of an interactive dashboard within Excel. The resulting dashboard serves as a valuable tool for analyzing trends and patterns among bike purchasers, providing a user-friendly means to gain insights into the factors influencing individuals' decisions to purchase bicycles.
Step 1: Data Cleaning
The first step is to clean the data set. Data cleaning is essential to ensure the accuracy and reliability of data for meaningful analysis and decision-making. To clean the data I:
Remove duplicates
Translated the Martial Status & Gender columns to be more descriptive rather than just a single letter
Created an age brackets column using nested if statements
Step 2: Pivot tables
Using clean data I created these three pivot tables:
Purchases by age brackets
Purchases by Gender & Income
Purchases by Commute distance
Pivot tables allow us to quickly summarize and analyze large datasets, making spotting trends, patterns, and outliers easier. They provide a dynamic and flexible way to organize and present data, enabling better-informed decision-making and reporting.
Step 3: Dashboard
Using the pivot tables created in Step 2, I created an Interactive dashboard. This interactive dashboard allows us to dive deeper into other factors that could play into purchases such as Region, education, and children.