Data Analytics Tutorial : Lesson 6 - Personal Expenses (Part 1)

Explore the fundamentals of simple statistical analysis in data analytics, covering classification of data with the aid of graphs.

Analysing your Monthly personal Expenses better

Ever wondered where you are spending your money and what your spend patterns are suggesting. Understand you expense patterns like never before using TalktoData.AI.  

In this tutorial we'll look at the below Data Analysis :

1. Hour wise Spend Pattern
2. Hourly spends vs Category

With this Analysis, we are trying to understand the category spends vs time of the day (ex: Spending more during late night for food), and general hourly spend patterns.

Please use the attached sample data set to follow along with this Tutorial

Fig. 1 : Snapshot of the Data in .CSV file

Steps to perform Analysis on this data

Step 1:

Login in to your Free Talktodata.AI account and upload the data set. Below is the screenshot for reference.

Fig.2 : Steps to Login and Upload the sample data file

Step 2:

Asking the Tool to perform the first Analysis. For example, i'm using the command

"can you give me hourly spend pattern"

Fig. 3: Graph Output

Step 3:

Now lets further analyse the data. As we can see majority of the expenses are occurring during the Lunch and Dinner time. Lets see what categories the spends are in.

I'm using the prompt : "generate graph spend hour vs category using Plotly Express"

Fig. 4: Graph Output

To ensure accurate results, it's important for us to ask the right questions.

Here is a simple guide on how to ask the right questions

You can further enhance this visualisation by asking the assistant to add data tags, change graph colours, add an average line etc. Now go-ahead and start your AI Assisted Data Analytics Journey.

Click here to Download the sample data set.

For any queries or support, please visit https://talktodata.ai/