{"repo":"weismanm12/finances-database","free":true,"listed":false,"github":"https://github.com/weismanm12/finances-database","clone":"git clone https://github.com/weismanm12/finances-database.git","description":"Personal finance database creation, SQL analysis, and Power BI dashboard","language":"Jupyter Notebook","stars":26,"topics":["dashboard","dataanalysis","database-schema","datacleaning","datamodeling","datavisualization","datawrangling","dax","etl","mysql"],"license":null,"category":"databases-storage","readme_excerpt":"Personal Finance Database and Dashboard Introduction In this project, I developed a MySQL database called spend save tracking all of my financial transactions. This includes purchases, deposits, withdraws, credit card payments, and more. Any transaction that results in a change in a bank account or credit card balance is tracked in this database. These transactions are extracted from my banking website in the form of CSV files, transformed using customized Python scripts, and loaded into the database via the SQLAlchemy Python library. I then created SQL views to understand my spending habits and developed a Power BI dashboard linked to the database to view these habits visually. Technologies and Skills - Technologies : SQL (MySQL), MySQL Workbench, Python (NumPy, Pandas, SQLAlchemy), Power BI, DAX - Skills : Data modeling, database development, data wrangling, data cleaning, ETL, data analysis, data visualization/dashboarding Inspiration I wanted to know more about my spending habits. I had an idea of which categories I spent the most on, but I did not know exactly how much I was spending. I also wanted to have a way to track my spending habits over time, allowing me to see which months of the year I tend to spend the most money in. To a lesser degree, I also wanted to track my bank account balances over time. --- Identifying Requirements My primary objective was to create a system that could meticulously monitor every transaction flowing through my bank and credit card accou","default_branch":null,"files":null,"tree":[],"storefront":"/r/weismanm12","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/weismanm12/finances-database/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}