Wednesday, October 23, 2019

Business Intelligence

Analyse and compare the system and technologies associated with business intelligence. For example data warehouse, executive information systems and online analytical processing (OLAP).

Data warehouse - the data
It is used to describe the process of storing all the company's data in internal or external databases from various sources with the focus on analysis, and generating actionable insights through online BI tools.

Essentially combines information from several sources into one comprehensive database.

Example
In the business world, a data warehouse might incorporate customer information from a company's point-of-sale systems (the cash registers), its website, its mailing lists and its comment cards. Alternatively, it might incorporate all the information about employees, including time cards, demographic data, salary information, etc.




Image result for data warehouse in business intelligence

Executive information systems - our systems (pc)
An executive information system (EIS) is a decision support system (DSS) used to assist senior executives in the decision-making process. It does this by providing easy access to important data needed to achieve strategic goals in an organization. An EIS normally features graphical displays on an easy-to-use interface. Executive information systems can be used in many different types of organizations to monitor enterprise performance as well as to identify opportunities and problems.



Related image

Online analytical processing (OLAP) - process inside
A computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view. OLAP business intelligence queries often aid in trends analysis, financial reporting, sales forecasting, budgeting and other planning purposes.

*analyze


Image result for online analytical processing (olap)


References

BI Blog | Data Visualization & Analytics Blog | datapine. (2019). Data Warehousing And Business Intelligence: A BI Architecture Guide. [online] Available at: https://www.datapine.com/blog/data-warehousing-and-business-intelligence-architecture/ [Accessed 24 Oct. 2019].


Vmokshagroup.com. (2019). [online] Available at: https://vmokshagroup.com/wp-content/uploads/2017/09/data-warehouse.gif [Accessed 24 Oct. 2019].



Investinganswers.com. (2019). Data Warehousing Definition & Example. [online] Available at: https://investinganswers.com/dictionary/d/data-warehousing [Accessed 24 Oct. 2019].


Techopedia.com. (2019). What is an Executive Information System (EIS)? - Definition from Techopedia. [online] Available at: https://www.techopedia.com/definition/1016/executive-information-system-eis [Accessed 24 Oct. 2019].


I.pinimg.com. (2019). [online] Available at: https://i.pinimg.com/originals/1c/9f/93/1c9f938d0f16a78320896fb4c3a363ac.jpg [Accessed 24 Oct. 2019].


SearchDataManagement. (2019). What is OLAP (online analytical processing)? - Definition from WhatIs.com. [online] Available at: https://searchdatamanagement.techtarget.com/definition/OLAP [Accessed 24 Oct. 2019].


Cdn.ttgtmedia.com. (2019). [online] Available at: https://cdn.ttgtmedia.com/rms/onlineimages/crm-olap.png [Accessed 24 Oct. 2019].


No comments:

Post a Comment

Key considerations for planning and undertaking research

Determine what the key considerations are for planning and undertaking research. Research questions.  Certain research quest...