snippetModerate
Can you give me one example of Business Intelligence?
Viewed 0 times
canbusinessyouexamplegiveintelligenceone
Problem
I don't really understand what Business Intelligence is all about. If I start from having a corporate DB, what is it that a BI person would do? I found plenty of material on the web, but it usually is a bit too complex. I want a simple example that would make me understand what BI is all about and what would a BI person produce that is of value to my organization.
Solution
Business Intelligence is often a completely separate sect from Database Administration and Database Development. Business Intelligence, at the highest level, includes three main facets:
Reporting
Reporting is the creation, deployment, and management of reports as well as the added ability for users to customize reporting dynamically.
Integration
Data integration and transformation solutions. 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). Integration is a mile deep, but that's the most basic functionality of it.
Analysis
Online Analytical Processing (OLAP) used to design, create and manage structures that contain data aggregrated from source data stores. A catch phrase for this is data mining.
These are extremely simplified descriptions of what Business Intelligence encorporates. There is a science behind BI, as well as each of these facets individually. Database Professionals dedicate their time and careers to mastering these.
- Reporting
- Integration
- Analysis
Reporting
Reporting is the creation, deployment, and management of reports as well as the added ability for users to customize reporting dynamically.
Integration
Data integration and transformation solutions. 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). Integration is a mile deep, but that's the most basic functionality of it.
Analysis
Online Analytical Processing (OLAP) used to design, create and manage structures that contain data aggregrated from source data stores. A catch phrase for this is data mining.
These are extremely simplified descriptions of what Business Intelligence encorporates. There is a science behind BI, as well as each of these facets individually. Database Professionals dedicate their time and careers to mastering these.
Context
StackExchange Database Administrators Q#6619, answer score: 19
Revisions (0)
No revisions yet.