| Wiki Markup |
|---|
{scrollbar} Wikipedia describes 'Business Intelligence' : |
...
| Business 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) |
...
\\ \\ BI is sometimes used interchangeably with briefing books, report and query tools and executive information systems. In general, business intelligence systems are data-driven DSS. \\ \\ BI systems provide historical, current, and predictive views of business operations, most often using data that has been gathered into a data warehouse or a data mart and occasionally working from operational data. Software elements support the use of this information by assisting in the extraction, analysis, and reporting of information. Applications tackle sales, production, financial, and many other sources of business data for purposes that include, notably, business performance management. Information may be gathered on comparable companies to produce benchmarks. | Reference: [http://en.wikipedia.org/wiki/Business_intelligence |
...
] As we can see the 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|http://en.wikipedia.org/wiki/Reporting], report server, self-service reporting |
...
* Analysis: slice-and-dice, pivot tables, on-line analytical processing (OLAP), cubes, dimensions and hierarchies, [drill |
...
down|http://en.wikipedia.org/wiki/Data_drilling] * Storage Models: [data marts|http://en.wikipedia.org/wiki/Datamart], [data warehouses|http://en.wikipedia.org/wiki/Data_Warehousing], star schemas, snowflake schemas, fact tables, de-normalization, * Data: [data integration|http://en.wikipedia.org/wiki/Data_Integration], [Extract-Transform-Load (ETL)|http://en.wikipedia.org/wiki/Extract%2C_transform%2C_load], [Extract-Load-Transform (ELT)|http://en.wikipedia.org/wiki/Extract%2C_Load_and_Transform], [data quality|http://en.wikipedia.org/wiki/Data_quality], [data profiling|http://en.wikipedia.org/wiki/Data_profiling], |
...
[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 references to external sources.]]
...
[metadata|http://en.wikipedia.org/wiki/Metadata] * Predictive Analytics: [data mining|http://en.wikipedia.org/wiki/Data_mining], [predictive analytics|http://en.wikipedia.org/wiki/Predictive_Analysis] and [machine learning|http://en.wikipedia.org/wiki/Machine_learning] * Analytical applications: [balanced scorecard|http://en.wikipedia.org/wiki/Balanced_scorecard], [Decision Support System (DSS)|http://en.wikipedia.org/wiki/Decision_Support_System], [Executive Information System (EIS)|http://en.wikipedia.org/wiki/Executive_information_system], [dashboard|http://en.wikipedia.org/wiki/Executive_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 references to external sources.\]\] Business Intelligence projects are often complex and expensive undertakings that have several problems. |