...

Introduction and Scope

Data Warehouse 1.0 is Stage One

The soon-to-be-released Mifos Technology Plan will probably have as one of its main goals "Transform Mifos into a best-of-breed business intelligence system for microfinance".  Part of this vision involves the development of a data warehouse that contains MFI data from the Mifos application as well as other sources.  The scope of this 'stage one' data warehouse initiative (DW 1.0) is to provide the ability to tackle the traditionally 'gnarly' mifos reports.

Focus on High Cost Gnarly Reports

Gnarly reports aren't the  'show me a list of clients and their addresses' type of report.  They are the operational and finance reports that show a raft of metrics, transaction totals and arrears aging information at MFI/Branch/Loan Officer/Center levels on current and historical date ranges.

Prior Mifos releases shipped with just a few reports... the Branch Progress report being typical of the gnarly type.  As a result, a number of clients have developed their own gnarly reports. (Ryan Whitney, Sam Birney, Sungard are some of the people who have been at the coalface).