Data Cleaning and Dashboard in Google Sheets: Bicycle Customers

This portfolio project is a practice in performing data cleaning and building a dashboard within Google Sheets. The dataset was taken from Alex the Analyst's "Data Analyst Portfolio Project" series. Viewing access to the Google sheet is available here. While this work is my own, I am grateful for this series for being such a helpful guide.

Dashboard:

To utilize the interactivity of this dashboard, please view the sheet directly at this link. (Slicers do not work in Google Sheet embeddings as the one shown below.)

Steps taken during analysis:

  • Removed duplicates (26 in total).
  • Updated "Marital Status" and "Gender" to use full words (instead of first letter, e.g. M = Married).
  • Changed "Income" data type to currency.
  • Used IF statements to group customers by age.
  • Modified group names to ensure proper ordering (Google Sheets does not offer custom ordering).
  • Used pivot tables, charts, and slicers to develop a dashboard to explore the data further--see below. **NOTE** to use the slicers, you must access the Google sheet through the shared link (slicers do not work in the embedding below.)