Overview

row

Develop Objective

Develop a visualization dashboard based on a series of data about your own life. The actual data used for this project can range from daily sleep regimes, TV shows watched, types of food eaten, spending habits, commute times to work, travel habits, to blood pressure and nutrient intake. The amount of data you collect, and harvest will differ based on your specified objectives.

I chose the data of 2022 of my credit card payment records from 1/1/2022 to 12/31/2022. The intention is to discover some insights on my spending purpose.

Data Collection Methods

I managed to pull my credit card statement with an export of transaction date, post date, description, category, type, and amount.

Project Questions:

  1. What are the categories I spent most of my money?
  2. Is there are relationship between my transaction counts and total spending?
  3. What is the transaction average for each category?
  4. Comparing category Food/Drink with category Groceries, what is my insights of spending habits.
  5. Is there hidden spending patterns in shopping, travel, food & drink, or groceries?

Where my money?

Column

counts vs total

Column

per category1

Column

per category2

Column

insight

Column

shopping

Food & Drink

Groceries