Data Warehousing / Business Intelligence

Data Warehousing/Business Intelligence (DW/BI) systems integrate multiple data sources to enable advanced analytics through alternative data collections and views, improve the performance of complex queries without impacting operational systems, maintain comprehensive data histories of source systems, and increase data quality.

Unique Design Decisions

Loblolly understands the design decisions that are generally unique to data warehousing/business intelligence systems. For BI projects, visualization of requirements is particularly important to show the potential of a given set of BI tools and data. Visualization allows users to see interactions between data sources, timing constraints, and possibilities not available in most static reporting environments. The identification of data collections required to address the business requirements for any data warehouse project is key to its success. Once the data collections have been designed, the system of record for all data elements is identified along with the establishment of the order of precedence for those source systems. Additional requirements regarding data security and data sharing are also collected and incorporated into the overall design.

Expertise

Loblolly is putting our expertise in EIM to work on a project to develop an enterprise-wide data warehouse strategy. This project will integrate data across state agencies to improve the delivery of services to Texans, evaluate program effectiveness, assure that services are delivered in a cost effective manner, and forecast the State’s future needs.

Strategy

The Loblolly team is now developing the strategy to perform the following functions:

  • Data Governance – Policies and enabling technical capabilities to manage, safeguard, and improve access to agency information
  • Master Data Management (MDM) – Infrastructure to match or link records across different data sources to establish a unified and contextually accurate view of an entity (customer, client, patient, provider, etc.) across agencies
  • Enhanced Analytics and Reporting – Deployment of Business Intelligence (BI) capabilities to improve business analysis and decision making.