Wiki Markup |
---|
{scrollbar} |
Wikipedia describes 'Business Intelligence' :
Business intelligence Intelligence (BI) refers to technologies, applications and practices for the collection, integration, analysis, and presentation of business information and sometimes to the information itself. The purpose of business intelligence-a term that dates at least to 1958-is to support better business decision making. Thus, BI is also described as a decision support system (DSS) |
Reference: http://en.wikipedia.org/wiki/Business_intelligence
As we can see the BI Business Intelligence market, if described in the loosest terms, is a set of commonly used terminology, tools, and technologies that are used to solve a set of commonly related problems.
The terminology, tools, and technologies include (with links to the relevant Wikipedia entries):
- Reporting: standard reports, parameterized reports, ad-hoc reports, desktop reporting, report bursting,
...
- enterprise reporting, report server, self-service reporting
- Analysis: slice-and-dice, pivot tables, on-line analytical processing (OLAP), cubes, dimensions and hierarchies, drill down
- Storage Models: data marts, data warehouses
...
- , star schemas, snowflake schemas, fact tables, de-normalization,
- Data: data integration, Extract-Transform-Load (ETL), Extract-Load-Transform (ELT), data quality, data profiling,
...
- metadata
- Predictive Analytics: data mining, predictive analytics and machine learning
- Analytical applications: balanced scorecard, Decision Support System (DSS), Executive Information System (EIS), dashboard
- Flavors: operational BI, real-time BI
...
[TODO
Describe (briefly):
- Reporting, analysis, dashboards, ad-hoc, OLAP
- Historical / trending vs live / operational reporting
- Transactional vs operation data store vs data-mart / data-warehouses.
- ETL
- Dimensions, attributes, measures, and keys
- Typical architectures
Include Include references to external sources.]]
BI Business Intelligence projects are often complex and expensive undertakings that have several problems.