Overview

row

Introduction

The Quantified Self (QS) is a movement motivated to leverage the synergy of wearables, analytics, and “Big Data”. This movement exploits the ease and convenience of data acquisition through the internet of things (IoT) to feed the growing obsession of personal informatics and quotidian data. The website http://quantifiedself.com/ is a great place to start to understand more about the QS movement. The value of the QS for our class is that its core mandate is to visualize and generate questions and insights about a topic that is of immense importance to most people – themselves. It also produces a wealth of data in a variety of forms. Therefore, designing this project around the QS movement makes perfect sense because it offers you the opportunity to be both the data and question provider, the data analyst, the vis designer, and the end user. This means you will be in the unique position of being capable of providing feedback and direction at all points along the data visualization/analysis life cycle.

Project Objectives

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. Ultimately the project must meet certain key objectives: 1. You must provide an written summary of your data collection, analysis and visualization methods, including the why you chose your methods, and what tools you utilized. 2. Your summary must outline ≥ 5 questions that can be evaluated using a data-driven approach. These questions should be more than just “How many miles did I run”, although a couple of your questions could be stated that way. 3. You must collect, manage, and store the data necessary for this visualization. 4. You must design and create an appropriate set of visualizations (try not to use just one type of visualization) within a dashboard/storyboard that provides insight into your specified questions, with a minimum of ≥ 1 interactive graphical element.

Project Deliverables

To complete this assignment you must deliver two items: 1. A ≤ 3 page write up of the questions, data acquisition, storage, manipulation, visualization methods and a written summary of each visualization. This summary should be part of your final dashboard not a separate document. 2. The final visualization dashboard.

row

OVERVIEW

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’s my money?

Column

Transaction counts vs Spending

Column

Average transaction for each category

Column

Category by Bar chart

Category by Pie chart

Insights of Food/Drink vs Groceries

Column

Food & Drink

Groceries

Hidden Spending Patterns

Column

shopping