Business intelligence software

Business intelligence software is a type of application software designed to retrieve, analyze, transform and report data for business intelligence. The applications generally read data that has been previously stored, often - though not necessarily - in a data warehouse or data mart.

## Contents

* 1 History
* 1.1 Development of business intelligence software
* 1.2 Cloud-hosted business intelligence software
* 2 Types
* 3 Open source free products
* 4 Open source commercial products
* 5 Proprietary free products
* 6 Proprietary products
* 7 References

## History

### Development of business intelligence software

The first comprehensive business intelligence systems were developed by IBM and Siebel (currently acquired by Oracle) in the period between 1970 and 1990.[1][2] At the same time, small developer teams were emerging with attractive ideas, and pushing out some of the products companies still use nowadays.[3]

In 1988, specialists and vendors organized a Multiway Data Analysis Consortium in Rome, where they considered making data management and analytics more efficient, and foremost available to smaller and financially restricted businesses. By 2000, there were many professional reporting systems and analytic programs, some owned by top performing software producers in the United States .[4]

### Cloud-hosted business intelligence software

In the years after 2000, business intelligence software producers became interested in producing universally applicable BI systems which don’t require expensive installation, and could hence be considered by smaller and midmarket businesses which could not afford on premise maintenance. These aspirations emerged in parallel with the cloud hosting trend, which is how most vendors came to develop independent systems with unrestricted access to information.[5]

From 2006 onwards, the positive effects of cloud-stored information and data management transformed itself to a completely mobile-affectioned one, mostly to the benefit of decentralized and remote teams looking to tweak data or gain full visibility over it out of office. As a response to the large success of fully optimized uni-browser versions, vendors have recently begun releasing mobile-specific product applications for both Android and iOS users.[6] Cloud-hosted data analytics made it possible for companies to categorize and process large volumes of data, which is how we can currently speak of unlimited visualization, and intelligent decision making.

## Types

The key general categories of business intelligence applications are:

* Spreadsheets
* Reporting and querying software: applications that extract, sort, summarize, and present selected data
* Online analytical processing (OLAP)
* Digital dashboards
* Data mining
* Business activity monitoring
* Data warehouse[7]
* Local information systems
* Data cleansing[8]

Except for spreadsheets, these tools are provided as standalone applications, suites of applications, components of Enterprise resource planning systems, application programming interfaces or as components of software targeted to a specific industry. The tools are sometimes packaged into data warehouse appliances.

## Open source free products

* Apache Hive, hosted by the Apache Software Foundation
* BIRT Project, by the Eclipse Foundation
* D3.js
* KNIME
* Orange
* Pentaho
* R
* TACTIC
* Superset
* Grafana

## Open source commercial products

* JasperReports: reporting, analysis, dashboard
* Palo: OLAP server, worksheet server and ETL server
* Pentaho: reporting, analysis, dashboard, data mining and workflow capabilities
* TACTIC: reporting, management, dashboard, data mining and integration, workflow capabilities

## Proprietary free products

* Biml - Business Intelligence Markup Language
* Datacopia
* icCube
* InetSoft
* Splunk

## Proprietary products

* ActiveReports
* Actuate Corporation
* BOARD
* Comarch
* Crystal Reports
* Data Applied
* Decision Support Panel
* Dimensional Insight
* Domo
* Dundas Data Visualization
* GoodData \- cloud-based
* Google Data Studio \- cloud-based
* IBM Cognos
* icCube
* InetSoft
* Information Builders
* InfoZoom
* JackBe
* Jedox
* Klipfolio Dashboard
* Kyvos
* Lavastorm Analytics
* LIONsolver
* List & Label
* LiveChat
* Logi Analytics
* Looker
* Metatron Discovery
* Microsoft
* SQL Server Reporting Services
* SQL Server Analysis Services
* PerformancePoint Server 2007
* Proclarity
* Power Pivot
* Power BI
* MicroStrategy
* Oracle
* Hyperion Solutions Corporation
* Business Intelligence Suite Enterprise Edition
* Panorama Software
* Pentaho (now Hitachi Data Systems)
* Pervasive DataRush
* Phocas Software
* Plotly
* PolyAnalyst
* Qlik
* QlikView
* Qlik Sense
* RapidMiner
* Roambi
* RW3 Technologies
* SAP NetWeaver Business Intelligence
* Business Objects
* Sisense
* SAS
* Siebel Systems
* Spotfire (now Tibco)
* Sybase IQ (now SAP IQ)
* Tableau Software
* TARGIT Business Intelligence
* Teradata
* WebFOCUS
* XLCubed
* Zendesk
* Zoho Analytics (as part of the Zoho Office Suite)
* Zoomdata

## References

1. ↑ "History of Business Intelligence Software". business-intelligence.financesonline.com. https://business-intelligence.financesonline.com/#history.
2. ↑ "A Detailed Look At The History Of Business Intelligence Software". comparecamp.com. http://comparecamp.com/detailed-look-history-business-intelligence-software.
3. ↑ "Integrating Oracle Business Intelligence / Siebel Analytics with Siebel CRM", oracle.com,.
4. ↑ "Applied Multiway Data Analysis", onlinelibrary.wiley.com,.
5. ↑ "Cloud BI: 5 Benefits of Cloud Business Intelligence" , compudata.com,.
6. ↑ "Mobile business intelligence brings benefits -- and barriers", searchbusinessanalytics.techtarget.com,.
7. ↑ Exploring Data Warehouses and Data Quality Published by Spotless Data Retrieved 15 May, 2017]
8. ↑ Exploring Data Analysis Published by Spotless Data Retrieved 15 May, 2017]

* v
* t
* e

Data warehouses

Creating a data warehouse

| Concepts|

* Database
* Dimension
* Dimensional modeling
* Fact
* OLAP
* Star schema
* Snowflake schema
* Reverse star schema
* Aggregate

|

Variants|

* Anchor modeling
* Column-oriented DBMS
* Data vault modeling
* HOLAP
* MOLAP
* ROLAP
* Operational data store

Elements|

* Data dictionary/Metadata
* Data mart
* Sixth normal form
* Surrogate key

Fact|

* Fact table
* Early-arriving fact
* Measure

Dimension|

* Dimension table
* Degenerate
* Slowly changing

Filling|

* Extract-Transform-Load (ETL)
* Extract
* Transform
* Load

Using a data warehouse

| Concepts|

* Business intelligence
* Dashboard
* Data mining
* Decision support system (DSS)
* OLAP cube
* Data warehouse automation

|

Languages|

* Data Mining Extensions (DMX)
* MultiDimensional eXpressions (MDX)
* XML for Analysis (XMLA)

Tools|

* Business intelligence software
* Reporting software
* Spreadsheet

Related

| People|

* Bill Inmon
* Ralph Kimball

|

Products|

* Comparison of OLAP servers
* Data warehousing products and their producers

0.00

(0 votes)

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Finance:Business_intelligence_software&oldid=859033"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template