business intelligence application examples

Normally this role will be necessary in all but trivial cases, although it may not have a full-time requirement on small sites.ī.I. This role brings value when bundled reports do not meet requirements and additional work is necessary to get management information from the databases but a dedicated B.I. Depending on their level of technical skill and access to the underlying databases they may be dependent on other staff such as database administrators to produce the data extracts. specialist, or may be undertaken part-time by somebody.

Spreadsheet jock - working from data sets extracted directly from operational systems, this role will produce reports and analysis using desktop tools such as Excel or Access. role might fall into a few different categories: Depending on the level of sophistication required, a B.I. The value depends very much on the individual organisation and its requirements. Database Professionals dedicate their time and careers to mastering these. There is a science behind BI, as well as each of these facets individually. These are extremely simplified descriptions of what Business Intelligence encorporates.

Online Analytical Processing (OLAP) used to design, create and manage structures that contain data aggregrated from source data stores. Integration is a mile deep, but that's the most basic functionality of it. On the very simplest level, it is the means of extracting, transforming, and loading data into a data source, from a data source (which could be anything as simple as a flat file). Reporting is the creation, deployment, and management of reports as well as the added ability for users to customize reporting dynamically.ĭata integration and transformation solutions. Business Intelligence, at the highest level, includes three main facets: Business Intelligence is often a completely separate sect from Database Administration and Database Development.

Business intelligence application examples