Business intelligence explained

Business intelligence (BI) consists of strategies and technologies used by enterprises for the data analysis and management of business information.[1] Common functions of BI technologies include reporting, online analytical processing, analytics, dashboard development, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics, and prescriptive analytics.

BI tools can handle large amounts of structured and sometimes unstructured data to help organisations to identify, develop, and otherwise create new strategic business opportunities. They aim to allow for the easy interpretation of these big data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability, and help them take strategic decisions.[2]

Business intelligence can be used by enterprises to support a wide range of business decisions ranging from operational to strategic. Basic operating decisions include product positioning or pricing. Strategic business decisions involve priorities, goals, and directions at the broadest level. In all cases, BI is most effective when it combines data derived from the market in which a company operates (external data) with data from company sources internal to the business such as financial and operations data (internal data). When combined, external and internal data can provide a complete picture which, in effect, creates an "intelligence" that cannot be derived from any singular set of data.[3]

Among myriad uses, business intelligence tools empower organizations to gain insight into new markets, to assess demand and suitability of products and services for different market segments, and to gauge the impact of marketing efforts.[4]

BI applications use data gathered from a data warehouse (DW) or from a data mart, and the concepts of BI and DW combine as "BI/DW"[5] or as "BIDW". A data warehouse contains a copy of analytical data that facilitates decision support.

History

The earliest known use of the term business intelligence is in Richard Millar Devens' Cyclopædia of Commercial and Business Anecdotes (1865). Devens used the term to describe how the banker Sir Henry Furnese gained profit by receiving and acting upon information about his environment, prior to his competitors:

The ability to collect and react accordingly based on the information retrieved, Devens says, is central to business intelligence.[6]

When Hans Peter Luhn, a researcher at IBM, used the term business intelligence in an article published in 1958, he employed the Webster's Dictionary definition of intelligence: "the ability to apprehend the interrelationships of presented facts in such a way as to guide action towards a desired goal."[7]

In 1989, Howard Dresner (later a Gartner analyst) proposed business intelligence as an umbrella term to describe "concepts and methods to improve business decision making by using fact-based support systems."[8] It was not until the late 1990s that this usage was widespread.[9]

Definition

According to Solomon Negash and Paul Gray, business intelligence (BI) can be defined as systems that combine:

with analysis to evaluate complex corporate and competitive information for presentation to planners and decision makers, with the objective of improving the timeliness and the quality of the input to the decision process."[10]

According to Forrester Research, business intelligence is "a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making."[11] Under this definition, business intelligence encompasses information management (data integration, data quality, data warehousing, master-data management, text- and content-analytics, et al.). Therefore, Forrester refers to data preparation and data usage as two separate but closely linked segments of the business-intelligence architectural stack.

Some elements of business intelligence are:

Forrester distinguishes this from the business-intelligence market, which is "just the top layers of the BI architectural stack, such as reporting, analytics, and dashboards."[12]

Compared with competitive intelligence

Though the term business intelligence is sometimes a synonym for competitive intelligence (because they both support decision making), BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes, and disseminates information with a topical focus on company competitors. If understood broadly, competitive intelligence can be considered as a subset of business intelligence.[13]

Compared with business analytics

Business intelligence and business analytics are sometimes used interchangeably, but there are alternate definitions.[14] Thomas Davenport, professor of information technology and management at Babson College argues that business intelligence should be divided into querying, reporting, Online analytical processing (OLAP), an "alerts" tool, and business analytics. In this definition, business analytics is the subset of BI focusing on statistics, prediction, and optimization, rather than the reporting functionality.[15]

Unstructured data

Business operations can generate a very large amount of data in the form of e-mails, memos, notes from call-centers, news, user groups, chats, reports, web-pages, presentations, image-files, video-files, and marketing material. According to Merrill Lynch, more than 85% of all business information exists in these forms; a company might only use such a document a single time.[16] Because of the way it is produced and stored, this information is either unstructured or semi-structured.

The management of semi-structured data is an unsolved problem in the information technology industry.[17] According to projections from Gartner (2003), white-collar workers spend 30–40% of their time searching, finding, and assessing unstructured data. BI uses both structured and unstructured data. The former is easy to search, and the latter contains a large quantity of the information needed for analysis and decision-making.[18] Because of the difficulty of properly searching, finding, and assessing unstructured or semi-structured data, organizations may not draw upon these vast reservoirs of information, which could influence a particular decision, task, or project. This can ultimately lead to poorly informed decision-making.

Therefore, when designing a business intelligence/DW-solution, the specific problems associated with semi-structured and unstructured data must be accommodated for as well as those for the structured data.

Limitations of semi-structured and unstructured data

There are several challenges to developing BI with semi-structured data. According to Inmon & Nesavich,[19] some of those are:

Metadata

To solve problems with searchability and assessment of data, it is necessary to know something about the content. This can be done by adding context through the use of metadata. Many systems already capture some metadata (e.g. filename, author, size, etc.), but more useful would be metadata about the actual content – e.g. summaries, topics, people, or companies mentioned. Two technologies designed for generating metadata about content are automatic categorization and information extraction.

Generative AI

Generative business intelligence is the application of generative AI techniques, such as large language models, in business intelligence. This combination facilitates data analysis and enables users to interact with data more intuitively, generating actionable insights through natural language queries. Microsoft Copilot was for example integrated into the business analytics tool Power BI.[20]

Applications

Business intelligence can be applied to the following business purposes:

Roles

Some common technical roles for business intelligence developers are:[23]

Risk

In a 2013 report, Gartner categorized business intelligence vendors as either an independent "pure-play" vendor or a consolidated "mega-vendor".[24] In 2019, the BI market was shaken within Europe for the new legislation of GDPR (General Data Protection Regulation) which puts the responsibility of data collection and storage onto the data user with strict laws in place to make sure the data is compliant. Growth within Europe has steadily increased since May 2019 when GDPR was brought. The legislation refocused companies to look at their own data from a compliance perspective but also revealed future opportunities using personalization and external BI providers to increase market share.[25]

See also

Bibliography

Notes and References

  1. Book: Dedić N. & Stanier noC.. 2016. Measuring the Success of Changes to Existing Business Intelligence Solutions to Improve Business Intelligence Reporting. Lecture Notes in Business Information Processing. Springer International Publishing. 268. 225–236. 10.1007/978-3-319-49944-4_17. Measuring the Success of Changes to Existing Business Intelligence Solutions to Improve Business Intelligence Reporting. 978-3-319-49943-7. 30910248 . https://hal.inria.fr/hal-01630541/file/432749_1_En_17_Chapter.pdf.
  2. (Book: Rud, Olivia . Business Intelligence Success Factors: Tools for Aligning Your Business in the Global Economy . 2009. Wiley & Sons. Hoboken, N.J.. 978-0-470-39240-9 .)
  3. Book: Coker. Frank . Pulse: Understanding the Vital Signs of Your Business . Ambient Light Publishing. 2014 . 41–42 . 978-0-9893086-0-1.
  4. Chugh, R. & Grandhi, S. (2013,). "Why Business Intelligence? Significance of Business Intelligence tools and integrating BI governance with corporate governance". International Journal of E-Entrepreneurship and Innovation', vol. 4, no.2, pp. 1–14.
  5. Book: Golden. Bernard. Amazon Web Services For Dummies. John Wiley & Sons. 2013. 234. 9781118652268. 2014-07-06. [...] traditional business intelligence or data warehousing tools (the terms are used so interchangeably that they're often referred to as BI/DW) are extremely expensive [...].
  6. Book: Miller Devens, Richard. Cyclopaedia of Commercial and Business Anecdotes; Comprising Interesting Reminiscences and Facts, Remarkable Traits and Humors of Merchants, Traders, Bankers Etc. in All Ages and Countries. business intelligence.. D. Appleton and company. 15 February 2014. 210. 1865.
  7. A Business Intelligence System. 10.1147/rd.24.0314. Luhn, H. P. . Hans Peter Luhn . 1958 . IBM Journal of Research and Development. 2. 4. 314–319. https://web.archive.org/web/20080913121526/http://www.research.ibm.com/journal/rd/024/ibmrd0204H.pdf. 2008-09-13.
  8. Web site: A Brief History of Decision Support Systems, version 4.0 . 10 July 2008 . D. J. Power . 10 March 2007. DSSResources.COM .
  9. Web site: A Brief History of Decision Support Systems . Power . D. J. . 1 November 2010 .
  10. Book: Springer-Verlag Berlin Heidelberg, Springer-Verlag Berlin Heidelberg . Topic Overview: Business Intelligence . 21 November 2008. 10.1007/978-3-540-48716-6 . 978-3-540-48715-9 .
  11. Web site: Topic Overview: Business Intelligence . Evelson . Boris . 21 November 2008.
  12. Web site: Want to know what Forrester's lead data analysts are thinking about BI and the data domain? . Evelson . Boris . 29 April 2010 . 4 November 2010 . https://web.archive.org/web/20160806102752/http://blogs.forrester.com/boris_evelson/10-04-29-want_know_what_forresters_lead_data_analysts_are_thinking_about_bi_and_data_domain . 6 August 2016 . dead .
  13. Web site: What's Not BI? Oh, Don't Get Me Started... Oops Too Late... Here Goes... . Kobielus . James . 30 April 2010 . "Business" intelligence is a non-domain-specific catchall for all the types of analytic data that can be delivered to users in reports, dashboards, and the like. When you specify the subject domain for this intelligence, then you can refer to "competitive intelligence", "market intelligence", "social intelligence", "financial intelligence", "HR intelligence", "supply chain intelligence", and the like. . 4 November 2010 . https://web.archive.org/web/20100507103207/http://blogs.forrester.com/james_kobielus/10-04-30-what%E2%80%99s_not_bi_oh_don%E2%80%99t_get_me_startedoops_too_latehere_goes . 7 May 2010 . dead .
  14. Web site: Business Analytics vs Business Intelligence? . timoelliott.com . 2011-03-09 . 2014-06-15.
  15. Analytics at Work: Q&A with Tom Davenport . Henschen . Doug . 4 January 2010 . 26 September 2011 . 3 April 2012 . https://web.archive.org/web/20120403080949/http://www.informationweek.com/news/software/bi/222200096 . dead .
  16. Rao. R.. 2003. From unstructured data to actionable intelligence. IT Professional. 5. 6. 29–35. 10.1109/MITP.2003.1254966.
  17. Blumberg, R.. S. Atre. amp. 2003. The Problem with Unstructured Data. dead. DM Review. 42–46. https://web.archive.org/web/20110125033210/http://soquelgroup.com/Articles/dmreview_0203_problem.pdf. 25 January 2011.
  18. Negash, S. 2004. Business Intelligence. Communications of the Association for Information Systems. 13. 177–195. 10.17705/1CAIS.01315. free.
  19. Inmon, B. & A. Nesavich, "Unstructured Textual Data in the Organization" from "Managing Unstructured data in the organization", Prentice Hall 2008, pp. 1–13
  20. Web site: Novet . Jordan . 2023-05-23 . Microsoft is bringing an A.I. chatbot to data analysis . 2024-08-19 . CNBC . en.
  21. Moro . Sérgio . Cortez . Paulo . Rita . Paulo . Business intelligence in banking: A literature analysis from 2002 to 2013 using text mining and latent Dirichlet allocation . Expert Systems with Applications . February 2015 . 42 . 3 . 1314–1324 . 10.1016/j.eswa.2014.09.024. 10071/8522 . 15595226 . free .
  22. Book: Developing Business Intelligence Apps for SharePoint . Feldman, D. . Himmelstein, J. . O'Reilly Media, Inc . 140–1 . 2013 . 9781449324681 . 8 May 2018.
  23. https://docs.microsoft.com/en-us/learn/modules/data-analytics-microsoft/3-roles Roles in data - Learn | Microsoft Docs
  24. News: Gartner releases 2013 BI Magic Quadrant . ZDNet . Andrew Brust. 2013-02-14. 21 August 2013.
  25. http://infoworld.com/d/cloud-computing/saas-bi-growth-will-soar-in-2010-511 SaaS BI growth will soar in 2010 | Cloud Computing