MSc. CIS Theses and Dissertations (2022)

Permanent URI for this collection

http://hdl.handle.net/11071/13185

Browse

Recent Submissions

Now showing 1 - 1 of 1
  • Thumbnail Image
    Item
    Design and implementation of data warehouse and business intelligence system for decision making within a DT-SACCO ecosystem: case study of DT-SACCO in Nairobi, Kenya
    (Strathmore University, 2022) Adeyemi, Olaoye John
    The implementation of data warehouse and business intelligence systems for decision making within a Deposit Taking Savings and Credit Corporative (DT SACCO) ecosystem in Nairobi, Kenya. DT SACCO are a subsection of SACCO which is similar to credit union (CU) in Europe, Americas and other parts of the world. The DT SACCOs perform regular activities similar to that of a regular bank. Banks in Kenya which are one of the major competitors of the DT SACCOs have different technologies to study the market trends and predict in advance what they have to invest in for them to beat their competitions. However, the DT SACCO is still catching up technology-wise. As the use of technology grows amongst the DT SACCOs, the ability to make decisions for the managers is becoming more difficult as it takes longer time for them to wait for reports from different departments to support the decision they make. It is important to have a clear 360-degree view of the business before making critical decisions. For a full view of the business data to be obtained, it is critical to integrate disparate data sources within the ecosystem of the DT SACCO. An implementation of data warehouse done by the Boeing Employee Credit Union (BECU) has seen the CU members gain in terms of Return-to-Members. "Return-to-member is the number of dollars the member has saved by doing business with BECU, as opposed to doing business with a commercial bank. This metric is calculated by adding the average dollars saved due to no fee services, dollars saved on lower interest loans, and dollars earned due to higher interest on savings. As of July 2000, the return-to-member value at BECU was $272, meaning that each member saves $272 annually by doing business with BECU rather than one of their commercial competitors." (O'Hara & Brohman, 2002). Implementation of data warehouse and business intelligence system within a DT SACCO ecosystem will provide support for decision making that will make members save more money and access better services from their respective SACCOs.