top of page

Excel Project

Project Description

Developed entirely in Excel, this project encompasses both data cleaning and visualization tasks, providing a seamless and comprehensive analysis experience.


The dashboard features three interactive visualizations designed to provide actionable insights into the survey data:

  • Average Income Per Purchase: Visualizes the average income per purchase, providing insights into the purchasing power of customers.

  • Distance Per Customer: Displays information about customer commuting habits, offering insights into their travel patterns and distances traveled.

  • Customer Age Bracket: Illustrates the distribution of customers across different age brackets, offering insights into the demographic profile of buyers.

 

Data Cleaning Steps:

  1. Employed Excel's built-in functionalities to streamline the dataset:

  2. Removed duplicate entries using the 'Remove Duplicates' feature.

  3. Utilized 'Find and Replace' functionality to manipulate certain column data, enhancing data consistency.

  4. Formatted the 'Income' column to Currency format for improved readability.

  5. Created an 'Age Bracket' column using a Nested IF Statement in Excel to categorize customers based on age groups.

 

Visualisation Development Highlights :

  1. Created 3 Pivot Tables for using them into Visualisation.

  2. Created Barchart Visualisation for showcasing Average Income Per Purchase.

  3. Created Linechart Visualisation for showcasing Distance Per Customer.

  4. Created Linechart Visualisation for showcasing Customer Age Bracket.

  5. Used Pivot Chart Analyser > Insert Slicer to create 3 filters Maritial Status, Region and Education.

bottom of page