- 96
- 168 250
DataResearchLabs
United States
เข้าร่วมเมื่อ 27 พ.ย. 2020
Data Research Labs. My "scratchpad in the sky" for sharing tools, tips, and tricks. Topics range from data analysis to data science, from SQL to Python to R, and from tools to techniques to scripts. Goal is to share simple, useful information.
Why You Need a Free Loan Tracking Spreadsheet in Your Life Tool Kit
Why You Need a Free Loan Tracking Spreadsheet in Your Life Tool Kit
Did you know that approximately 80% of Americans are in debt with a home mortgage, home equity loan, car loan, student loan, personal loan, or some other type of loan?
Yet many do not know really understand the nuances of principal and interest, what is pre-payment to principal, how to make extra payments, and why it can be good to make pre-payments.
As borrowers, we need to understand and forecast costs over time to make better decisions such as:
• “Can I afford the monthly payment?”
• “How many years earlier can I pay off the loan by making extra pre-payments?”
• “How much money do I save by making extra pre-payments?”
• “I just received a $5,000 bonus at work / or I just inherited $15,000. Should I use it to pay down my home loan?”
• “Should I choose 15-year mortgage or 30-year mortgage with pre-payments?”
• “What will my monthly payments need to be to pay off the loan 5 years early? 10 years early? 15 years early?”
• “Did my bank accidentally give themselves extra interest rather than putting all the pre-payment toward principal?”
This video tutorial will help answer these questions with six examples using a free loan amortization Excel spreadsheet. You can enter your future, present, and/or past loan terms and model different payment scenarios. You can analyze the various costs and benefits to arrive at the best decision for your unique circumstances.
Enjoy. :)
------- Chapter Timestamps (click to jump forward): -----------------------------
0:00 - Intro
0:13 - Most people have loans, so why track them?
0:43 - Example #1: A simple loan amortization calculator
2:19 - Example #2: Extra Payments Reduce Cost & Duration
4:59 - Example #3: Should I use an unexpected windfall to pre-pay my loan
6:46 - Example #4: 15-year vs. various 30-year payment schemes
14:00 - Example #5: Manually tracking payments
15:31 - Example #6: But wait, there's more -- the STANDARD Edition
21:40 - The End
------------------------------------------
- Download FREE Edition: github.com/DataResearchLabs/my_loan_tracker/tree/main/download
- Purchase STANDARD Edition: www.etsy.com/shop/DataResearchLabs/
- Help: github.com/DataResearchLabs/my_loan_tracker
- Read this on Medium: mpierce710006.medium.com/a07925ee4e4e
Connect with me on social media:
- LinkedIn: www.linkedin.com/in/mpiercead576/
- TH-cam: th-cam.com/channels/QciXv3xaBykeUFc04GxSXA.html
- GitHub: github.com/DataResearchLabs
Subscribe to my TH-cam Channel:
- th-cam.com/channels/QciXv3xaBykeUFc04GxSXA.html?sub_confirmation=1
#mortgate #prepayment #amortization #loan
Did you know that approximately 80% of Americans are in debt with a home mortgage, home equity loan, car loan, student loan, personal loan, or some other type of loan?
Yet many do not know really understand the nuances of principal and interest, what is pre-payment to principal, how to make extra payments, and why it can be good to make pre-payments.
As borrowers, we need to understand and forecast costs over time to make better decisions such as:
• “Can I afford the monthly payment?”
• “How many years earlier can I pay off the loan by making extra pre-payments?”
• “How much money do I save by making extra pre-payments?”
• “I just received a $5,000 bonus at work / or I just inherited $15,000. Should I use it to pay down my home loan?”
• “Should I choose 15-year mortgage or 30-year mortgage with pre-payments?”
• “What will my monthly payments need to be to pay off the loan 5 years early? 10 years early? 15 years early?”
• “Did my bank accidentally give themselves extra interest rather than putting all the pre-payment toward principal?”
This video tutorial will help answer these questions with six examples using a free loan amortization Excel spreadsheet. You can enter your future, present, and/or past loan terms and model different payment scenarios. You can analyze the various costs and benefits to arrive at the best decision for your unique circumstances.
Enjoy. :)
------- Chapter Timestamps (click to jump forward): -----------------------------
0:00 - Intro
0:13 - Most people have loans, so why track them?
0:43 - Example #1: A simple loan amortization calculator
2:19 - Example #2: Extra Payments Reduce Cost & Duration
4:59 - Example #3: Should I use an unexpected windfall to pre-pay my loan
6:46 - Example #4: 15-year vs. various 30-year payment schemes
14:00 - Example #5: Manually tracking payments
15:31 - Example #6: But wait, there's more -- the STANDARD Edition
21:40 - The End
------------------------------------------
- Download FREE Edition: github.com/DataResearchLabs/my_loan_tracker/tree/main/download
- Purchase STANDARD Edition: www.etsy.com/shop/DataResearchLabs/
- Help: github.com/DataResearchLabs/my_loan_tracker
- Read this on Medium: mpierce710006.medium.com/a07925ee4e4e
Connect with me on social media:
- LinkedIn: www.linkedin.com/in/mpiercead576/
- TH-cam: th-cam.com/channels/QciXv3xaBykeUFc04GxSXA.html
- GitHub: github.com/DataResearchLabs
Subscribe to my TH-cam Channel:
- th-cam.com/channels/QciXv3xaBykeUFc04GxSXA.html?sub_confirmation=1
#mortgate #prepayment #amortization #loan
มุมมอง: 122
วีดีโอ
MSSQL Data Dictionary Generator - How to Download & Deploy
มุมมอง 6013 ปีที่แล้ว
This brief tutorial walks you through downloading and deploying (configuring) the MSSQL Data Dictionary Generator. Chapter Timestamps (click to jump forward): 0:00 - Intro 0:12 - How do I download the tool? 1:50 - How do I deploy and configuer the tool? 3:35 - How do I access the source code? 5:00 - TechNote: If there are any issues with references... 5:54 - The End - Download Application: gith...
MSSQL Data Dictionary Generator - Output Screens, Exports, Reports, and Scripts
มุมมอง 6903 ปีที่แล้ว
This Data Dictionary Generator tool is easier and faster to use than scripts to easily document an existing database schema. You can dump the tables, views, colun descriptions, data types/lengths/sizes/precision, key constraints, and othr information. Results can be instantly exported to CSV, Excel, or even PDF. You can generate just the comments script for tables and columns for you to edit an...
MSSQL Data Dictionary Generator - Overview
มุมมอง 2.9K3 ปีที่แล้ว
This Data Dictionary Generator tool is easier and faster to use than scripts to easily document an existing database schema. You can dump the tables, views, column descriptions, data types/lengths/sizes/precision, key constraints, and other information. Results can be instantly exported to CSV, Excel, or even PDF. You can generate just the comments script for tables and columns for you to edit ...
How to use Notepad++ to Find and Fix Bad Characters in a String or Text File
มุมมอง 18K3 ปีที่แล้ว
As a data analyst, sometimes you’ll encounter situations where a text file, or a web API response string, or a database field value is crashing your software application, and it is up to you to figure out why. Common problem characters include non-breaking-spaces (CHAR-160) which looks exactly like a space (CHAR-32) but behaves differently. Or maybe it is an EmDash (CHAR-151) from a user copy-p...
Text File End of Line Editor - How to Download & Deploy
มุมมอง 1283 ปีที่แล้ว
Text File End of Line Editor - How to Download & Deploy This brief tutorial walks you through downloading and deploying (configuring) the Text File End-of-Line Editor. Chapter Timestamps (click to jump forward): 0:00 - Intro 0:08 - How do I download the tool? 2:00 - How do I deploy and configure the tool? 3:49 - How do I access the source code? 4:20 - How do I use this tool to FIX the issue? 5:...
Text File End of Line Editor - Overview
มุมมอง 4143 ปีที่แล้ว
As a data analyst, sometimes you’ll be called in to help figure out why a text file written on one platform (say Linux web server) won’t read into an application on another platform (say Windows PC app). Often, the root cause is different character codes used to terminate lines in the text file. Some applications have the extra functionality to handle multiple codes, others do not. In those cas...
How to Use an Advanced Data Validation Script in SQL Server
มุมมอง 1.7K3 ปีที่แล้ว
This video walks you through how to use the advanced data validation script in SQL Server. It includes 66 sample test cases demonstrating one of each type of data validation check, from table level row counts, key checks, data mismatches, and heuristics to field level numeric-, date-, and text-specific checks. All the SQL validation test cases run sequentially in Oracle SQL Developer, returning...
How to Use a Basic Data Validation Script in SQL Server
มุมมอง 2.9K3 ปีที่แล้ว
This video walks you through how to use the basic data validation script in SQL Server. It includes 66 sample test cases demonstrating one of each type of data validation check, from table level row counts, key checks, data mismatches, and heuristics to field level numeric-, date-, and text-specific checks. All the SQL validation test cases run sequentially in Oracle SQL Developer, returning th...
SQL Server Data Validation Best Practices
มุมมอง 7K3 ปีที่แล้ว
This video walks you through 6 data validation best practices with examples. One example shows you how to go beyond the default status values of "Pass" and "Fail" to implement "Skip" and "Warn". The second example shows how and why to validation tests to just the recent data, not all data (no point in re-testing unchanged data over and over). The third example shows howto ignore known bad data ...
MSSQL Data Validation Examples: Regular Expressions with LIKE Operator
มุมมอง 6723 ปีที่แล้ว
This video walks you through 14 regular expression data validation test case examples. There are validation tests for phone numbers, social security numers, zip5 and/or zip9, text only, numeric only, no leading or trailing whitespace, only lowercase, only uppercase, titlecase, email addresses, and urls. Included also are two tips on web searches to support use of regular expressions: (1) search...
MSSQL Data Validation Examples: Text Fields
มุมมอง 1683 ปีที่แล้ว
This video walks you through 24 text field data validation test case examples. There are validation tests for nulls and nullstrings, no leading or trailing spaces, in or not in a value ilst, and text field length. There are upper case, lower case, alpha, and numeric characters checks. There are bad characters tests for single quotes, quotes, carriage returns, line feeds, tabs, non-breaking-spac...
SQL Server Data Validation Examples: Numeric and Date Fields
มุมมอง 2.4K3 ปีที่แล้ว
This video walks you through 11 standard data validation test case examples. The numeric validation tests check for nulls, negative numbers, inside a specific range, in a list, not in a list, and comparing multiple numeric fields or doing calculations. The date validation tests check for nulls, dates inside a range, make sure there is or is not a time part, and comparing multipe date fields. Th...
SQL Server Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs
มุมมอง 1.2K3 ปีที่แล้ว
This video walks you through 5 powerful advanced data validation test case examples. These table-level tests cover thresholds for column null rates and value frequencies observed. These tests also covering monitoring table structure and table data changes. You can refactor and re-use the samples in your projects. The scripts in the demo are all out on Github along with 66 total sample validatio...
SQL Server Data Validation Examples: Row Counts, Duplicates, and Foreign Key Orphans
มุมมอง 5K3 ปีที่แล้ว
This video walks you through 7 sample data validation test cases. These table-level tests cover four flavors of row count, and three different unique and foreign key checks. You can refactor and use in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests. Chapter Timestamps (cl...
How to Use an Advanced Data Validation Script in Oracle
มุมมอง 2503 ปีที่แล้ว
How to Use an Advanced Data Validation Script in Oracle
How to Use a Basic Data Validation Script in Oracle
มุมมอง 1.2K3 ปีที่แล้ว
How to Use a Basic Data Validation Script in Oracle
Oracle Data Validation Examples: Regular Expressions
มุมมอง 2903 ปีที่แล้ว
Oracle Data Validation Examples: Regular Expressions
Oracle Data Validation Examples: Text Fields
มุมมอง 4403 ปีที่แล้ว
Oracle Data Validation Examples: Text Fields
Oracle Data Validation Examples: Numeric and Date Fields
มุมมอง 2133 ปีที่แล้ว
Oracle Data Validation Examples: Numeric and Date Fields
Oracle Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs
มุมมอง 2503 ปีที่แล้ว
Oracle Data Validation Examples: Null Rates, Value Thresholds, and Table Schema or Data Diffs
Oracle Data Validation Examples: Row Counts, Duplicates, and Foreign Key Orphans
มุมมอง 6683 ปีที่แล้ว
Oracle Data Validation Examples: Row Counts, Duplicates, and Foreign Key Orphans
Toad Data Point Tips and Tricks for Data Analysts
มุมมอง 7K3 ปีที่แล้ว
Toad Data Point Tips and Tricks for Data Analysts
How to generate Greenplum data dictionary from SQL script
มุมมอง 923 ปีที่แล้ว
How to generate Greenplum data dictionary from SQL script
How to generate PostgreSQL data dictionary from SQL script
มุมมอง 8K3 ปีที่แล้ว
How to generate PostgreSQL data dictionary from SQL script
How to generate MySQL data dictionary from SQL script
มุมมอง 8K3 ปีที่แล้ว
How to generate MySQL data dictionary from SQL script
How to generate SQL Server data dictionary from SQL script
มุมมอง 15K3 ปีที่แล้ว
How to generate SQL Server data dictionary from SQL script
How to generate Oracle data dictionary from SQL script
มุมมอง 2.3K3 ปีที่แล้ว
How to generate Oracle data dictionary from SQL script
Nice work, suscribed.!
How much math do you need to do well on the degree and what other pre-requirements do you need to succeed in the master's program...!?. Thank You for sharing
also @10:38, my TDP 6.0.5 does not bring up options of copy cells. It simply copies the text into the clipboard.
Very nice tips. I am using TDP 6.0.5. Somehow double-clicking error message does not do anything for me. Did I miss something obvious?
4:12 I would love to know how have you done that? rest is Amazing , very helpful
Thank youuu from Indonesiaa.. Its Worked!!
Very well made video.
this is a goldmine, great video and thank you for the resources
te encuentro en la calle te doy un beso
I spent almost an entire day evaluating XML files that were crashing an application. Eventually, my suspicions turned to bad hidden characters. Sure enough. This was extremely helpful. Thank you!
Thanks!
Dangerously useful mate. Hope it still available in git.
thanks for the script! super helpful
Excellent video!! Thank you for these tips. They are very helpful
Thank you for the video! Saved me so much time as well
man get a mic u are not on a spaceship
Hey Thank you but this script is having some errors Like Msg 10757, Level 15, State 1, Line 82 The function 'STRING_AGG' may not have a WITHIN GROUP clause. Msg 10757, Level 15, State 1, Line 95 The function 'STRING_AGG' may not have a WITHIN GROUP clause. Msg 156, Level 15, State 1, Line 115 Incorrect syntax near the keyword 'AS'. Please help
i love your break down on how long each course took. i can tell you like data :)
Can you transfer credits for some classes??
Thank you sir!
Thank you sir. This video spare me a lot of extra work doing data dictionary for documentation 🥲
This was a nice little tour of what to focus on, than you very much for this
Life Saver! Thanks so much for posting and thoroughly detailing.
Great tutorial - thanks! Are you aware of a similar schema dump script that would work in Snowflake?
Interesting
For Output/10'57'', is there a hotkey to select "Copy to clickboard", or we can only click choose for output?
no explanation on capturing complete (scrolling) web pages?
Great video. Was really considering and wanted to do the university of Texas Austin computer science. But went with data analytics at WGU. Started this month already almost done with my second class. Plan to finish within the first 6 month term.
Very useful information
Glad you liked it
Thank you so much sir. You save my life.
You are most welcome
can you please clear my doubt, to get the certificate should we need to complete all the 9 curses ?....or can i get certificate for each course separately
Great video
I am 76 and retired. My career took place while the digital spreadsheet was developed and improved. I started with VisiCalc, like mostly everyone else. I too, used Lotus 1-2-3 when I was in a PC environment, but when I moved to Mac, Excel became my go-to spreadsheet. I can attest to what you said about ROI on time invested learning Excel. Today, I don't need the full power of Excel any more, but use a spreadsheet daily to keep track of my own finances on a spreadsheet born in the late 90's. I use Numbers now, since it is free with my computer. Plus, Numbers uses almost all the same commands as Excel, with some minor differences, so I didn't have to learn a new spreadsheet from the ground up when I switched. For those who are on a budget, Open Office has a free online spreadsheet, very similar to Excel. As a CFO in the 80's, 90's, and 00's, Excel was the single most valuable tool that I had available. I still have a very large paper spreadsheet that I did in 1980 to remind me not to take Excel for granted.
Good job!, thanks for sharing it.
You are welcome. :)
Thank you! Really useful and timesaving
Glad it was helpful!
great work, congrats!
Sir, please can you let me know if data science still have a good perspective in the futur ? Will it be replaced by AI tools in the 5 next years ? I would like to specialized in computer vision and data science but i m afraid to be replaced by robot in the futur. Cant wait for your answer. Thank you in advance.
Awesome! are there any transferable credits from certificates that count as classes? if so, which ones? I heard there are two but no one has told me which ones lol
Would you be able to share your study plan?
Great video, but I want to only single table data dictionary. This is position by this sql script
Im so nervous about the Data Analytics program. Im more nervous about the coding language classes
Hi, thanks, it’s very useful. Do you have a version that use DBMS specialized packages to automatically generate a SQL file to sync database schemes structure ?
Very nice...
I really enjoyed your teaching method! it will be great to see a tutorial on a full text search with postgresql.. something like searching book content..
Great video! Can I get your opinion about this degree for someone switching careers? I have some experience working in IT but my bachelor's is in Biology. I want to do a master's degree because I would be applying for financial aid. Do you think employers would take me seriously as a Data Analyst if my undergrad isn't really relevant? Thanks!
After 13 years, my husband with an MBA is making barely more than a teacher salary. He has a great deal of experience analyzing data, but a lot that he doesn't know in the computer programming section. Would this help him pivot careers?
Please help me asap huhuhuhuuu
Hello can you help me iam currently using the 2022 or 2023 version i am not sure hhahaha and there is an error like the STRING_AGG
Great Video Sir. I got my code file removed with errors .
Thanks for the detailed video with Excel Tips !
this video just saved me so much time! thank you so much for doing this.