Day 3.2 Deep Dive 6 Phases of data analysis

Kenny Hin
3 min readMay 31, 2022

Glanced over the course syllabus. It looks like an information, data dense course. Reading and noticed a few things about the review. When Google displays the reviews, of course, they are overwhelmingly positive. The ‘top reviews from the prepare data for exploration’ section displays 5 comments — they seems not to be bots for one which is good. Although when you ‘view all reviews’ — and scroll down to the sorted ‘this is helpful’ comments — you realize the most helpful comments are most 3 stars or less. The comments are critics of the course and most are just demanding more content, which i think are fine. Everyone rates things differently so can not put too much weight or any. Will need to experience it myself.

Take a step back, and take let the data speak for itself. — Don’t try to predict it or have expectations.

Day 4 — Learning log activity: Create a table.

Finally! I’ve been waiting to insert some data. I am not going to use the data i used from the previous logs because the data is quite scattered. Instead, I’m going to work on tracking other aspects, but on EXCEL! Check it out below:

I love coffee shops and it’s apparent in the excel sheets as most of my revenue goes towards coffee. But I mostly go for the environment rather than the coffee — helps me think when I’m in different environment but costly nonetheless. The totals of each table uses SUM formula. For the meals table, starting the month of June, i’m going to start tracking how much my meals cost from cooking at home and how much i can save. I am currently eating Salmon, which i spent $37 on, and have had 3 meals. All I did was divide the cost by the amount of meals — excluding the rice. The coffee was free today because well, I’m at Panera bread and i kept the cup ; )

Learning Log: Organize your data in a table

Reflect on, and address, the opportunities in your personal life or current job to organize data into tables.

A couple opportunities I noticed in my personal life in terms of spending. I’m unemployed at the moment so I’m always itching to go out and be around people. I am also a big fan of coffee shops because they trigger some type of motivation for me — the mere fact of being in a different environment where everyone is either communicating or working keeps me at bay in terms of getting my own work done — but still costly nonetheless. Most of my outside spending is coffee, fries, and dessert — and that accounts for nearly $200, or 65% of my outside spending. Compared to my groceries, where i’ve spent a smidge less than $200 for meals.

With that being said, I want to continue to track and limit my unnecessary outside spending and also see how much each meal cost if i cooked at home. If I consider my own data as a business, it could correlate as making money for the business because money saved is money earned.

--

--