Posts

DataBook

Image
As explained by Kurt Cagle and Chloe Shannon in their article,   DataBooks: Markdown as Semantic Infrastructure , a DataBook is effectively a microdatabase.   A DataBook is a document a human can read, a data file that a computer can process, and a toolbox that caries its own instructions . A DataBook is a technique that enables data and an explanation to travel together in a data pipeline . One important part of the magic of DataBook files to understand is that a DataBook can also easily be read and interpreted by LLMs. Another part of the magic of the DataBook is that everything travels together within one file including:  data meaning rules queries documentation Finally, DataBook files can easily be versioned by Github and Gitlab.  Both Github and Gitlab support MD files which are both based on CommonMarkup . And so, there appear to be different "flavors" of MD files, but they are close. There are no separate files which can be forgotten or lost.  ...

Model-driven Enterprise Architecture

Image
Often, when you are deeply immersed inside a system you cannot see the problems of that system. The system I am talking about is "the enterprise".   By enterprise I mean any economic entity, entity, business, business entity, commercial venture, undertaking, firm, industrial organization, company; small, medium, and large that is organized and has some purpose or "mission" or "mandate".  Could be a for profit business, a not-for-profit organization, a government agency. The "problem" was less of a problem until artificial intelligence came along.  But artificial intelligence is exposing  the "problem".  And, it is less of a problem and more of an inability to take advantage of an important opportunity. What causes the inability to take advantage, the real advantage, of  artificial intelligence is messy data.  The AI Ladder points this out: "AI is one of the greatest challenges and opportunities of our time. It is poised to change...

Business Events Ledger

Image
Back in 2018 I noticed something that I referred to as a fact ledger, see Introducing the Fact Ledger . I described a fact ledger thus:  "A fact ledger is a new type of ledger that offers utility and leverage when accounting, reporting, auditing, and analysis is done in a digital environment. My thinking on this has evolved and now I see what I would call a business events ledger .  And I am not the only one that sees this.  Kurt Cagle has the notion of what he refers to as an event graph or event ledger (see  Coherence, Holons, and the Spinning of Plates ).  Another accountant seems to have a similar idea and created an "events ledger".  I don't have permission to show this to you at the present time. And so fundamentally, my original notion of a "fact ledger" is an "event graph" or "event ledger" in terms of a holon as described by Kurt Cagle, see my Example Financial Statement Holon .  Applying this specifically to financial statement...

Modeling Against the Stream

Image
The two articles, Against the Stream and Meaning is Not Metadata  highlight a problem that I have experienced myself and have tried to solve related to digital financial reporting by creating things like my Logical Theory Describing Financial Report . Communication between business professionals that need software to do something and technical professionals that build that software is hard.  Very hard.  But it is important to persist to make sure the foundation is right. Why? Because you cannot retrofit a foundation to fix a foundation. The first article points out a "shared fiction" that currently exists between business professionals and technical professionals. What is important to understand is the ramifications of that shared fiction.   One ramification that I have experiences is software that is overly flexible in undesirable areas which results in software that is harder to use than it really needs to be.  Flexibility makes things more complicated. ...

Spreadsheet Monkey

Image
Heard a new term, spreadsheet monkey . A spreadsheet monkey  (a.k.a. Excel monkey , spreadsheet robot , data janitor) is a colloquial term for someone whose work revolves around repetitive spreadsheet tasks; like copying, pasting, reconciling, and formatting data; rather than engaging in higher‑level analysis or system design. The phrase captures the frustration of professionals trapped in manual workflows that could be automated or structured through better data integration. In essence, a spreadsheet monkey symbolizes the human cost of fragmented information systems: people acting as the “glue” between disconnected databases and reports. A spreadsheet monkey is someone stuck doing repetitive, manual, error‑prone spreadsheet tasks instead of strategic, automated, or model‑driven work. A spreadsheet monkey is someone who connects the " bucket brigade " of spreadsheets. This role will be changing.  Artificial intelligence will reshape accounting and finance . One new audit firm...

Pacioli in the Computer Age

Image
Accounting using the double entry bookkeeping mathematical model is a brilliantly engineered information system that, if utilized correctly, really can provide valuable outcomes. Initially developed in around 1211 CE by Italian bankers and then formally documented by Luca Pacioli in 1494 , double entry accounting will thrive in the era of artificial intelligence. Why? In order for artificial intelligence to make the best use of accounting information, the semantic fragmentation needs to be minimized. Minimizing that semantic fragmentation will allow traceability to be maximized. The human bucket brigade that is a significant portion of accounting, reporting, auditing, and analysis today will be rethought. At it's core, accounting is about capturing information related to business contract for an economic entity.  This is explained thoroughly by Theory of Accounting and Control . Those business contracts result in business events that are then entered into an accounting inform...

Example Financial Statement Holon

Image
As I have mentioned in other posts on my blog, a financial statement is a formal semantic structure , in fact a financial statement is a special type of formal semantic structure referred to as a holon . As I mentioned in my blog posts, Kurt Cagle and Chloe Shannon are providing a lot of very good information about holons on their substack. I have provided a bunch of good examples of financial reporting frameworks and reports   In this blog post I want to focus on one specific financial statement and see if I can explain that a financial statement is a "container" of  blocks of information and the "information blocks" that the financial statement contains. Cagle and Shannon point out that a holon is made up of four distinct knowledge graphs that maximize coherence and operationalize the holon which are: The Scene Graph or Interior State (a.k.a. the knowledge graph) The Boundary Graph (a.k.a. the control plane; the boundary layer) The Event Graph (a.k.a. the event...