Analyze your bank statement like a pro.
Does it ever happen that your bank account is empty at the end of the month or of the year? Though it should not? And you have no idea where you spent all the money you earned? Find out and analyze your bank account and know where you spend your money for free!
--------------------------------------------
TABLE OF CONTENTS
--------------------------------------------
00:00 - Why would you need to analyze your bank account?
00:59 - Downloading bank statement
02:15 - Preparing *.csv file for work with Excel
04:13 - Preparing data for the import
04:52 - Importing data to the PowerBI desktop program
06:54 - Creating a pie chart to see all expenses in one chart
09:00 - Additional table chart to see more details
10:48 - More advanced analysis of our bank statement
11:57 - Adding additional category in the bank statement file
13:34 - Easy way to categorize your data
15:02 - Updating PowerBi file with the new column
17:02 - New chart with new categories
17:39 - Eliminating remaining entries with "No category"
20:03 - Conclusion. Thank you for watching!
20:48 - FAILS
Like my video? Patreon link to support me, get extra perks, and download files I have created in my videos:
/ datafriendly