Business intelligence software: Difference between revisions
Hemagowdaa (talk | contribs) Tag: Reverted |
ClueBot NG (talk | contribs) m Reverting possible vandalism by Arasu rrk to version by Kuru. Report False Positive? Thanks, ClueBot NG. (4364709) (Bot) |
||
(9 intermediate revisions by 8 users not shown) | |||
Line 1: | Line 1: | ||
{{Short description|Application software to read and analyze stored data}} |
|||
'''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]]. |
'''Business intelligence software''' is a type of [[application software]] designed to retrieve, analyze, transform and report data for [[business intelligence]] (BI). The applications generally read data that has been previously stored, often - though not necessarily - in a [[data warehouse]] or [[data mart]]. |
||
==History== |
==History== |
||
Line 5: | Line 6: | ||
The first comprehensive business intelligence systems were developed by [[IBM]] and [[Siebel Systems|Siebel]] (currently acquired by [[Oracle Corporation|Oracle]]) in the period between 1970 and 1990.<ref >{{cite news | title =History of Business Intelligence Software| publisher =business-intelligence.financesonline.com| url =https://business-intelligence.financesonline.com/#history | access-date =28 October 2018}}</ref><ref >{{cite news | title =A Detailed Look At The History Of Business Intelligence Software| publisher =comparecamp.com| url =http://comparecamp.com/detailed-look-history-business-intelligence-software | access-date =28 October 2018}}</ref> At the same time, small developer teams were emerging with attractive ideas, and pushing out some of the products companies still use nowadays.<ref>[http://www.oracle.com/us/support/licensecodes/siebel/siebel-crm-bi-integration-166917.html "Integrating Oracle Business Intelligence / Siebel Analytics with Siebel CRM"], ''oracle.com'',.</ref> |
The first comprehensive business intelligence systems were developed by [[IBM]] and [[Siebel Systems|Siebel]] (currently acquired by [[Oracle Corporation|Oracle]]) in the period between 1970 and 1990.<ref >{{cite news | title =History of Business Intelligence Software| publisher =business-intelligence.financesonline.com| url =https://business-intelligence.financesonline.com/#history | access-date =28 October 2018}}</ref><ref >{{cite news | title =A Detailed Look At The History Of Business Intelligence Software| publisher =comparecamp.com| url =http://comparecamp.com/detailed-look-history-business-intelligence-software | access-date =28 October 2018}}</ref> At the same time, small developer teams were emerging with attractive ideas, and pushing out some of the products companies still use nowadays.<ref>[http://www.oracle.com/us/support/licensecodes/siebel/siebel-crm-bi-integration-166917.html "Integrating Oracle Business Intelligence / Siebel Analytics with Siebel CRM"], ''oracle.com'',.</ref> |
||
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|United States of America]].<ref> |
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|United States of America]].<ref>{{cite book | chapter-url=http://onlinelibrary.wiley.com/doi/10.1002/9780470238004.fmatter/pdf | doi=10.1002/9780470238004.fmatter | chapter=Frontmatter | title=Applied Multiway Data Analysis | series=Wiley Series in Probability and Statistics | date=2008 | isbn=978-0-470-16497-6 }}</ref> |
||
===Cloud-hosted business intelligence software=== |
===Cloud-hosted business intelligence software=== |
||
Line 12: | Line 13: | ||
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 (operating system)|Android]] and [[iOS]] users.<ref>[http://searchbusinessanalytics.techtarget.com/feature/Mobile-business-intelligence-brings-benefits-and-barriers "Mobile business intelligence brings benefits -- and barriers"], ''searchbusinessanalytics.techtarget.com'',.</ref> 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. |
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 (operating system)|Android]] and [[iOS]] users.<ref>[http://searchbusinessanalytics.techtarget.com/feature/Mobile-business-intelligence-brings-benefits-and-barriers "Mobile business intelligence brings benefits -- and barriers"], ''searchbusinessanalytics.techtarget.com'',.</ref> 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. |
||
== Key Features of a BI Software == |
|||
Business Intelligence (BI) tools offer several key benefits that enhance business operations and decision-making processes: |
|||
* '''Improved Decision-Making''': BI tools provide valuable insights by analyzing data, helping businesses make informed decisions quickly and accurately. |
|||
* '''Increased Efficiency''': Automating data collection and analysis processes saves time and resources, allowing employees to focus on strategic tasks. |
|||
* '''Enhanced Data Quality''': BI tools ensure data is accurate, consistent, and up-to-date, which improves the reliability of the insights derived from the data. |
|||
* '''Better Business Insights''': By uncovering patterns, trends, and correlations in data, BI tools help businesses gain a deeper understanding of their operations and market dynamics. |
|||
* '''Competitive Advantage''': Access to real-time data and advanced analytics allows businesses to respond swiftly to market changes and stay ahead of the competition. |
|||
* '''Cost Reduction''': Identifying inefficiencies and areas for improvement through data analysis can lead to significant cost savings for businesses. |
|||
* '''Customizable Reports and Dashboards''': BI tools offer customizable reporting and dashboard capabilities, enabling users to tailor the presentation of data to meet specific needs and preferences. |
|||
* '''Scalability''': BI tools are scalable and can grow with the organization, ensuring that data analytics capabilities remain robust as data volumes increase. |
|||
== Types == |
== Types == |
||
The key general categories of business intelligence applications are: |
The key general categories of business intelligence applications are: |
||
Line 60: | Line 50: | ||
<!-- Do not list product without articles or add external links, they will be removed. --> |
<!-- Do not list product without articles or add external links, they will be removed. --> |
||
* [[Business Intelligence Markup Language|Biml - Business Intelligence Markup Language]] |
* [[Business Intelligence Markup Language|Biml - Business Intelligence Markup Language]] |
||
* [[Datacopia]] |
|||
* [[icCube]] |
|||
* [[InetSoft]] |
* [[InetSoft]] |
||
* [[Splunk]] |
* [[Splunk]] |
||
Line 79: | Line 67: | ||
* [[Dundas Data Visualization]] |
* [[Dundas Data Visualization]] |
||
* [[GoodData]] - cloud-based |
* [[GoodData]] - cloud-based |
||
* [[ |
* [[Looker Studio]] - cloud-based |
||
* [[IBM]] [[Cognos]] |
* [[IBM]] [[Cognos]] |
||
* [[icCube]] |
|||
* [[InetSoft]] |
* [[InetSoft]] |
||
* [[Information Builders]] |
* [[Information Builders]] |
||
Line 141: | Line 128: | ||
==References== |
==References== |
||
{{reflist}} |
{{reflist}} |
||
* Key features of BI Software [https://www.enqdb.com Enqdb https://www.enqdb.com/glossary/bi-tool.html] |
|||
{{Data warehouse}} |
{{Data warehouse}} |
Latest revision as of 12:15, 17 December 2024
Business intelligence software is a type of application software designed to retrieve, analyze, transform and report data for business intelligence (BI). The applications generally read data that has been previously stored, often - though not necessarily - in a data warehouse or data mart.
History
[edit]Development of business intelligence software
[edit]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 of America.[4]
Cloud-hosted business intelligence software
[edit]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
[edit]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
[edit]- Apache Hive, hosted by the Apache Software Foundation
- BIRT Project, by the Eclipse Foundation
- D3.js
- JasperReports
- KNIME
- Orange
- Pentaho
- TACTIC
- Superset
- Grafana
Open source commercial products
[edit]- 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
[edit]Proprietary products
[edit]- ActiveReports
- Actuate Corporation
- BOARD
- Comarch
- Crystal Reports
- Data Applied
- Decision Support Panel
- Dimensional Insight
- Domo
- Dundas Data Visualization
- GoodData - cloud-based
- Looker Studio - cloud-based
- IBM Cognos
- InetSoft
- Information Builders
- InfoZoom
- JackBe
- Jaspersoft
- Jedox
- Klipfolio Dashboard
- Kyvos
- Lavastorm Analytics
- LIONsolver
- List & Label
- LiveChat
- Logi Analytics
- Looker
- Metatron Discovery
- Microsoft
- MicroStrategy
- Oracle
- Panorama Software
- Pentaho (now Hitachi Data Systems)
- Pervasive DataRush
- Plotly
- PolyAnalyst
- Qlik
- RapidMiner
- Roambi
- RW3 Technologies
- SAP NetWeaver Business Intelligence
- 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
See also
[edit]References
[edit]- ^ "History of Business Intelligence Software". business-intelligence.financesonline.com. Retrieved 28 October 2018.
- ^ "A Detailed Look At The History Of Business Intelligence Software". comparecamp.com. Retrieved 28 October 2018.
- ^ "Integrating Oracle Business Intelligence / Siebel Analytics with Siebel CRM", oracle.com,.
- ^ "Frontmatter". Applied Multiway Data Analysis. Wiley Series in Probability and Statistics. 2008. doi:10.1002/9780470238004.fmatter. ISBN 978-0-470-16497-6.
- ^ "Cloud BI: 5 Benefits of Cloud Business Intelligence" Archived 2018-09-29 at the Wayback Machine, compudata.com,.
- ^ "Mobile business intelligence brings benefits -- and barriers", searchbusinessanalytics.techtarget.com,.
- ^ Exploring Data Warehouses and Data Quality Published by Spotless Data Retrieved 15 May, 2017]
- ^ Exploring Data Analysis Published by Spotless Data Retrieved 15 May, 2017]