Adding Value with a Data Warehouse
A data warehouse provides a company with a centralized data aggregation available for multiple purposes. This single source of data offers a number of benefits, including:
• Eliminating repetitive and contradictory data.
• Maintaining current and consistent data between the various analytical tools that the company may utilize.
• Providing a single location from which reports and analytics can be run, thus ensuring that all employees are looking at common information. This eliminates the problem of different systems showing different results for the same inquiry.
To provide a closer look at the process of constructing a data warehouse, we have a summary of our standard methodology for a data warehouse project.
Selecting a Cost–Effective Solution
A full–scale data warehouse may not always be the most cost–effective approach to meeting the client’s requirements.
In some cases, a data mart may be the better choice. In contrast to a data warehouse, which is a centralized data aggregation available for multiple purposes, the structure of a data mart is driven by a specific purpose.
B–Three constructed a full–scale data warehouse for the Modus Operandi component of the City of Pittsburgh’s Automated Police Reporting System.
A major local university conducting important studies on diabetes engaged B–Three to meet its data management requirements. B–Three constructed a data mart and created the processes to populate it with Electronic Medical Record (EMR) data.
A firm providing professional healthcare services to a large number of community hospitals asked B–Three to recommend a solution for efficiently generating its internal reports. B–Three proposed, designed, and built a data warehouse. Working closely with client personnel, B–Three created 19 new internal reports to be run against the data warehouse.