Which of the following is an umbrella term that combines architectures tools databases analytical tools applications and methodologies?

Business intelligence (BI) is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies. It was coined first by Gartner group in the 1990’s. It is a content-free expression, so it means different things to different people. BI’s major objective is to enable interactive access (sometimes in real time) to data, to enable manipulation of data, and to give business managers and analysts the ability to conduct appropriate analyses. By analysing historical and current data, situations, and performances, decision makers get valuable insights that enable them to make more informed and better decisions. The process of BI is based on the transformation of data to information, then to decisions, and finally to actions.

A BI system has four major components: a data warehouse, with all the relevant source data; business analytics, a collection of tools and algorithms for manipulating, mining, and analysing the data in the data warehouse; business performance management (BPM) for monitoring and analysing performance; and a user interface (e.g., a dashboard) that can powerfully display the insights generated by analytics.

Business cycle times are now extremely compressed; faster, more informed, and better decision making is therefore a competitive imperative. Managers need the right information at the right time and in the right place. This is the mantra for modern approaches to BI. Organizations need to work very smart. Paying careful attention to the management of BI initiatives is a necessary aspect of doing business today.

Analytics consists of utilising all the available data to answer key questions that Business needs to answer to improve its profitability and other objectives. For instance, the Chief Marketing Officer needs to know which customer segments to target for cross and upselling, the Chief of Risk needs to know if all checks and balances are put in place not to compromise financially or information wise. The Chief Information Officer would need to have fullest control on the budgets and ROI on IT spends and ensure that the applications designed run to their potential. The Chief Executive Officer on the other hand would like to know if any new products need to be designed and developed to cater to unmet needs of customers. Most of these questions can today be answered by digging deeper into enterprise and external data, and by processing the data for generating rich insights using advanced analytics.

Analytics is typically classified as descriptive analytics, predictive analytics, and prescriptive analytics. Descriptive analytics is the use of historical data combined with simple statistical techniques meant for visualising and interacting with the historical data. This often helps understand what the current state of the enterprise is. Predictive analytics, on the other hand leverages advanced mathematical and statistical modelling to come up with forecasts of any selected variable such as quarterly sales. This is used to help plan the activities better. Prescriptive analytics leverages techniques such as optimisation in order to arrive at the best course of action given the current state and predicted future states of the system.  Decision making is thus enabled almost to near real time with the embedding of data and analytics into organisational processes.

Business Case

ABC Corp is one of the world leaders in the travel industry, providing both business-to-consumer services as well as business-to-business services. It serves travellers, travel agents, corporations, and travel suppliers through its four main companies. The current volatile global economic environment poses significant competitive challenges to the airline industry. To stay ahead of the competition, ABC Corp recognized that airline executives needed enhanced tools for managing their business decisions by eliminating the traditional, manual, time-consuming process of collecting and aggregating financial and other information needed for actionable initiatives.

This enables real-time decision support at airlines throughout the world that maximize their (and, in tum, ABC’s) return on information by driving insights, actionable intelligence, and value for customers from the growing data. ABC Corp developed an Enterprise Travel Data Warehouse (ETDW) to hold its massive reservations data. ETDW is updated in near-real time with batches that run every 15 minutes, gathering data from all of ABC’s businesses. A C Corp also uses its ETDW to create Executive Dashboards that provide near-real-time executive insights using an enterprise class BI platform appropriate technology infrastructure. The Executive Dashboards offer their client airlines’ top-level managers and decision makers a timely, automated, user friendly solution, aggregating critical performance metrics in a succinct way and providing at a glance a 360-degree view of the overall health of the airline.

At one airline, ABC Corp’s Executive Dashboards provide senior management with a daily and intra-day snapshot of key performance indicators in a single application, replacing the once-a-week, 8-hour process of generating the same report from various data sources. The use of dashboards is not limited to the external customers; ABC Corp also uses them for their assessment of internal operational performance.

Need to automate for quick action

In order to serve the near real time need to generate and consume business insights, the BI and Analytics platform should be ready with a variety of prebuilt data warehouses, data marts, and data models, canned BI reports for a variety of business stakeholders, and the ability to perhaps self serve some insights. This calls for automation of the data engineering, as well as the insights and reports generation engine. A variety of self service platforms also help in jump starting the journey to BI and Analytics. Recent advances in natural language processing and speech recognition have also enabled AI enabled BI. For instance, the business user could type in their requirement in English, whilst the BI server would recognise what reports could be pre-fetched from the array of canned reports; alternatively, it might end up generating a bespoke report if the query is unique in nature.

Conclusions

BI and Analytics enable an enterprise to embed data into every day operations and decision making. It is important to build the BI system with the right architecture, the right technologies and the right user enablement in order for a significant ROI in this field. Successful organisations embed and empower business users as part of the BI platform build and use process.

-- Jump to section --DescriptionAvailabilityLearning outcomesContentAssumed knowledgeAssessment itemsCompulsory requirementsContact hours

Business intelligence (BI) is an umbrella term that combines architectures, tools, databases, analytical tools, applications and methodologies. The major objectives of business intelligence are to enable interactive access to data and to give business managers the ability to conduct analysis and make better decisions. The course covers how to design, implement and integrate business intelligence techniques and systems into the enterprise.

Availability

Online

Singapore NAIHE

Learning outcomes

On successful completion of the course students will be able to:

1. Describe the concepts and components of Business Intelligence and how they are relevant to an enterprise.

2. Critically evaluate the use of BI for supporting decision making in an enterprise.

3. Describe and use the technologies, applications, tools and methodologies that make up Business Intelligence.

4. Demonstrate an understanding of the technological architecture that underpins BI systems in an enterprise.

5. Conceptually implement parts of a BI enterprise system.

Content

  • Information value, classification of types and sources of value, and types of processing that can add value to corporate data sources.
  • The nature and role of business intelligence in contributing to the delivery of business value and competitive advantage in modern enterprises.
  • The relationship of the business intelligence environment, in particular data warehousing and data mining, to different enterprise contexts.
  • The data integration process, data profiling, data cleansing and data enhancement, and their contribution to adding value to data.
  • Data warehouse design; star schemas, redundancy, data distribution and security issues.
  • Adding value to data; knowledge discovery, and data mining.
  • Web-based decision support and mining technology in business intelligence.

Assumed knowledge

Basic competency in Microsoft Excel.

Experience with Databases and SQL, such as in INFO6001 Database Management 1 or equivalent

Assessment items

Quiz: Examination - Class Online Quiz *

Written Assignment: Essay/Written Assessment

Participation: Group Tutorial Participation and Contribution

* This assessment has a compulsory requirement.

Compulsory Requirements

In order to pass this course, each student must complete ALL of the following compulsory requirements:

Course Assessment Requirements:

  • Quiz: Minimum Grade / Mark Requirement - Students must obtain a specified minimum grade / mark in this assessment item to pass the course. - Students whose overall mark in the course is 50% or more, but who score less than 40% in the compulsory item and thus fail to demonstrate the required proficiency, will be awarded a Criterion Fail grade which will show as FF on their formal transcript. However, students in this position who have scored at least 25% in the compulsory assessment item will be allowed to undertake a supplementary 'capped' assessment in which they can score at most 50% of the possible mark for that item.