Courses/Resources

Here are links to Courses and Other Resources that may be helpful in understanding Financial Systems, such as presentations, individual slides used in videos, spreadsheets and templates, etc. for use in financial systems work.

Courses

I have constructed some preliminary courses on Financial Systems. They are all free, and use a combination of my vlog as lectures organized by topic and selections from my books.

Only the Reclassification Course, the most advanced course, includes assessments and is considered complete.

I would love feedback and suggestions as to what courses might be helpful to develop further.

CwK E155-E164 Intro to Accounting Cycle TN1

Fundamentals of Accounting

Financial System Basics for Beginners

Accounting can seem daunting, but if you have a bank account or a credit card, you are already using the basics of accounting today.

Continue Reading

When you check your “balance” you are looking at a type of Balance Sheet. Checking transactions and the net change for the month is like the Income Statement.

The accounting cycle is what drives accounting. In this course we’ll highlight the simple steps of the accounting cycle.

With this background you’ll be ready to perform business analysis or contribute to a financial systems development project.

CwK E1 Sturctured Data- TN New

Fundamentals of Finance Data

Financial System Basics for Beginners

Financial systems can be as simple a piece of ledger paper and pencil.

Continue Reading

But most modern systems are much more complex. This course helps lay the foundation for understanding the principles behind how financial systems work. It’s ok if you’ve never used a paper ledger, but having used a spreadsheet and having looked at a checking account or credit card statement would be helpful in understanding these principles.

The course starts with structured verses unstructured data, transactions and events verses balances, measurement concepts, posting, ledgers, attributes for creating balances called the chart of account, step-ups, and basic computer processes like joins and more.

With this background you’ll be ready to perform business analysis or contribute to a financial systems development project.

CwK E76 Meeting Analogy Big Data - TN

How a Computer Works on “Big Data”

Computer Basics for Big Data

Computers can seem quite mysterious, but they needn’t be. A simple business meeting analogy can make them much more transparent.

Continue Reading

Understanding how a computer works becomes even more important when dealing with a lot of data, or “Big Data” which causes computers to perform poorly.

The course is an introductory course to the larger topic of estimating Big Data projects. It begins quite simply, but moves rapidly into the very heart of computers, and some fairly advanced topics. It concludes with some thoughts about how these topics related to Big Data projects.

With this background you’ll be ready to perform business analysis or contribute to a Big Data systems development project.

CwK E63 HP Reclass Overview - TN

Financial System Reclass Processes

What happens when balance attributes change

Balances are created by selecting and summarizing attributes of transactions that will be included in the balance.

Continue Reading

These attributes are termed the “Posting Key”. We might use the transaction attributes themselves, or we might derive the balance attributes from them by joining to other tables or doing some other form of transformation.

This is a simple form of reclassification. Reclassifications can happen for many other reasons; for example rules which post transactions to balances might change; new balances might be needed which divide amounts stored in historical balances; or report regulations might demand a balance be associated with another portion of a report.

In this course you will learn about the underlying principles of how reclassification processes can be handled in financial system.

Resources

Detailed Slides

Finance Architecture Diagram

Various slides used in the vlog are shown here, for closer inspection, including views of the intersection of risk and finance data, consolidated data supply chains, the data volume impact of transactions vs. balances upon the daily financial cycle, and others.

 

Report Process Estimation Spreadsheet

ReportsWorksheet

Balancing Act Part 4 presents a proven method for developing financial reporting applications used on some of the largest financial reporting projects in the world.  One portion of this method is report estimation processes.

The spreadsheet template, example and instructions can be used in conjunction with the Balancing Act Chapter 30. Assess Reporting NeedsChapter 31. Estimate the Data Basis and Chapter 32. Define Summary Structures to estimate processing time and environment requirements before the system is built.

Reusable Video Slides

The following slides have been used in vlog videos.  They are available here for download to inspect more closely or to reuse in explaining vlog concepts.  These slides may be distributed freely.

CwK E1 Sturctured Data- TNCwK E2 Measurement- TNCwK E3 Transparency- Video TNCwK E4 Posting- TNCwK E5 Timing - TNCwK E11 ERP Posting Processes - ThumbnailCwK E12 Data Warehouses - TN smallCwK E13 Interim Reporting - TNCwK E18 Intro to Step Ups - TNCwK E19 Power of Step Ups - TNCwK E21 Intro to Joins - TNCwK E22 Normalization - TNCwK E35 Master File Update - TNCwK E44 Temporal Events and IL - TNCwK E52 DSC Length and Width - TNCwK E53 DSC Step Ups - TNCwK E63 HP Reclass Overview - TNCwK E64 HP Switch View - TNCwK E65 HP Recast View - TNCwK E66 HP Effective Date Joins -TNCwK E67 HP Reclass View - TNCwK E68 HP Backdating - TNCwK E69 HP Reclass Data Model - TNCwK E71 Architecture Code Sets - TNCwK E155-E164 Intro to Accounting Cycle TN1