What is a BI analytical application ?
Posted by Dylan Wan on February 28, 2007
A BI analytical application provides the following four key components:
- Pre-built ETL to extract data from the operational tables in the transaction system and load to the data warehouse
- Denormalized Star schema which is optimized for BI queries
- Best practice metric and calculation libraries that are created based on the data warehouse and operational sources.
- Pre-built graphics, reports, dashboards, and alerts that designed for specific roles and business processes
It is actually a very lengthly process to build an BI analytical application. That is why people now buy the pre-built BI analytical applications.