The key ingredient of
business intelligence is of course, the data. To satisfy the rigorous demands of business intelligence to retrieve data accurately and efficiently, the data must be stored in
repositories designed for that purpose. Millbrook has repositories already designed and built, specifically for the kinds of data used by insurance companies.
Before it can be stored, the data must first be
extracted from the many systems used by an insurance company that handle policies, claims, reinsurance, accounting, workflow, etc. Often, these systems use different codes to process transactions, have data elements that have changed their meaning over time, or mean something different based on line of business. Combine that with external data that has its own meaning, and you can see why data must be transformed to become a single version of the truth. Only then can data be loaded into a repository that business intelligence can use successfully.
For most companies, this process of extract, transform, and load
(ETL) is often the most tedious and challenging phase of any business intelligence/data warehousing project. The answer is simple, give the job to Millbrook. We do it every day, and we have much of the ETL code already pre-built.
To learn more 
