Interactive Excel Dashboard

Joy Johnson

Data Visualizer
Business Analyst
Data Analyst
Microsoft Excel

Project Overview

An analysis of sales transaction, customer demographics information and revenues generated in order to track important metrics as well as monitor customer purchasing behavior and sales trend over time.

Method of Analysis

Data cleaning and wrangling (removing duplicates, ensuring consistency in format and eliminating errors to maintain accuracy of data)
Data transformation and analysis to identify trends and patterns in data
Developing dashboard to visualize data and present results of findings through the use of dynamic charts and graphs
Generating reports to provide more insights into the relevance of the analysis in meeting the business needs

Summary of Findings

Majority of the customers were between the age range of 27-46, in other words they were mostly young adults
Customer purchase preferences showed that bikes were in high demand, with mountain bikes generating the highest revenue for products
Customer demographics showed that 52% were males while 48% were females, which means that there wasn't much disparity between both gender preferences
The United States had the highest customers and yielded the most income in revenue
Partner With Joy
View Services

More Projects by Joy