Business Intelligence

Create a table of comparisons for operational data, data warehouse, and data mart

Describe the purpose of 3 tools and explain how it works. Include the advantages and disadvantages.

Spreadsheets

• It is a file that has rows and columns
• Helps to sort the data, easy to arrange data, calculate the numerical data
• It has the ability to calculate values using mathematical formulas and the data in cells
• Mostly used in banks to calculate the bank balance

Advantages:

1. Easy to create instant calculations
2. Easy to change the data
3. It keeps the data organized efficiently
4. Can create multiple spreadsheets in one file

Disadvantages:

1. Take time to learn the formulas
2. Calculation error may be not recognized by the software or app
3. Take time to enter the data into each cell
4. Some of the files may be incompatible

Data Mining

• Process of analyzing the hidden patterns of data that are according to the different perspectives to categorize the data into a useful information
• The data is collected and assembled in common areas (data warehouse) for the efficient analysis, data mining algorithms, facilitating the business decision making and other information requirements to cut costs and increase revenue

Advantages:

1. Contribute in the strategic decision making by discovering the information
2. Discover information that was not expected to be obtained
3. Huge database can be analyzed 
4. Can offer the customers of the products or services that they need

Disadvantages:

1. Difficulty of collecting the data 
2. Depending on the amount of the database that it can take some time to process the information
3. Lack of appropriate security system that can be a risk in the privacy of the user's information
4. Not a perfect process if the information is inaccurate, can affect the outcome of the decision making process

Operational Dashboard

• Focusing on the performance of monitoring and measure the important metrics for any user
• Contain a set of well defined business metrics (KPIs and KRIs)
• The information is updated in real time
• Allowing the employee to monitor closely the efficiency and effectiveness of the operations

Advantages:

1. Manage the delivery of roll-up reporting to assist the measurement of corporate KPIs
2. Consistent, corporate

Disadvantages:

1. Costly to assure the executive, management, and operational needs are met
2. The impact leans heavily on maintaining the consistency 

Research the role of business processes within an organization and their function at different levels.

References:

Your Article Library. (2013). Decisions Making: Strategic, Tactical and Operational Decisions | Business Management. [online] Available at: http://www.yourarticlelibrary.com/information-technology/decisions-making-strategic-tactical-and-operational-decisions-business-management/10271 [Accessed 26 Oct. 2019].

JReport Blog. (2014). 5 Types of Business Intelligence Technologies Explained - JReport Blog. [online] Available at: https://www.jinfonet.com/blog/5-types-of-business-intelligence-technologies-explained/ [Accessed 26 Oct. 2019].

Techopedia.com. (2019). What is a Data Mart? - Definition from Techopedia. [online] Available at: https://www.techopedia.com/definition/134/data-mart [Accessed 26 Oct. 2019].

Definitions, S. and Hope, C. (2019). What is a Spreadsheet?. [online] Computerhope.com. Available at: https://www.computerhope.com/jargon/s/spreadsheet.htm [Accessed 26 Oct. 2019].

Gaille, B. (2016). 11 Pros and Cons of Spreadsheets. [online] BrandonGaille.com. Available at: https://brandongaille.com/11-pros-and-cons-of-spreadsheets/ [Accessed 26 Oct. 2019].

Techopedia.com. (2019). What is Data Mining? - Definition from Techopedia. [online] Available at: https://www.techopedia.com/definition/1181/data-mining [Accessed 26 Oct. 2019].

LORECENTRAL. (2018). Advantages and disadvantages of data mining ~ LORECENTRAL. [online] Available at: https://www.lorecentral.org/2018/12/advantages-and-disadvantages-of-data-mining.html [Accessed 26 Oct. 2019].

Dundas.com. (2014). Types of Dashboards: The Operational Dashboard. [online] Available at: https://www.dundas.com/resources/dundas-data-visualization-blog/types-of-dashboards-the-operational-dashboard [Accessed 26 Oct. 2019].

MashMetrics. (2019). Pros and Cons of Dashboards, Custom Reports and Performance Monitoring | MashMetrics. [online] Available at: https://mashmetrics.com/marketing-reports-dashboards-performance-alerts-pros-cons-of-each/ [Accessed 26 Oct. 2019].