Business Intelligence
Definition and Capabilities
Compiled
By
JAIRO A. TABORDA
For
Information Technology Department
Municipality of Envigado
Important Note:
These are original texts and were written and revised on 10 February 2012 by Gartner Inc. The original document is part of Gartner 's Magic Quadrant research methodology to provide a graphical and analytical competitive positioning of Business Intelligence technology providers.
Content
Business Intelligence 1 Market Definition/Description 3 1. Integration 3 1.1 BI infrastructure 3 1.2 Metadata management 3 1.3 Development tools 3 1.4 Collaboration 4 2. Information Delivery 4 2.1 Reporting 4 2.2 Dashboards 4 2.3 Ad hoc query 4 2.4
…show more content…
*
2.2 Dashboards * This subset of reporting includes the ability to publish formal, Web-based or mobile reports with intuitive interactive displays of information, including dials, gauges, sliders, check boxes and traffic lights. These displays indicate the state of the performance metric compared with a goal or target value. Increasingly, dashboards are used to disseminate real-time data from operational applications or in conjunction with a complex event processing engine. *
2.3 Ad hoc query * This capability enables users to ask their own questions of the data, without relying on IT to create a report. In particular, the tools must have a robust semantic layer to allow users to navigate available data sources. These tools should include a disconnected analysis capability that enables users to access BI content and analyze data remotely without being connected to a server-based BI application. In addition, these tools should offer query governance and auditing capabilities to ensure that queries perform well. *
2.4 Microsoft Office integration * In some use cases, BI platforms are used as a middle tier to manage, secure and execute BI tasks, but Microsoft Office (particularly Excel) acts as the BI client. In these cases, it is vital that the BI vendor provides integration with
Dashboard is a data visualization tool that displays the current status of metrics and key performance indicators (KPIs) for an enterprise. Also, dashboard consolidates and arranges numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department. The essential features of a dashboard product include a customizable interface and the ability to pull real-time data from multiple sources. An Executive Dashboard gives a clear picture of the data and the insights visually to the corporate executives.
2. Business intelligence: Delivers synchronized, business-critical data in a variety of diagnostic tools to view market trends and build relationships that help facilitate timely decision making (Microsoft Dynamics NAV, 2011).
In detail, a strong resistance will come from some of the operating companies that already have “their own small-scale business intelligence applications in place”. These companies may not see any valid reason or advantage to switch and implement a new software system. Furthermore, another obstacle that SYSCO might confront will be the objection from the existing managers and IT experts averse and incapable of using a new software with different functions. Moreover, the forthcoming implementation time of the BI software proposed by the Assistant Vice President of Technology and Applications Twila Day might raise doubts and concerns among management as well as
The value of Business Intelligence increases as the delivery of information is embedded in the processes and systems of the enterprise which results from all data being store for end users. The BI software seems to be very efficient in its
What’s Good: Allows drill-down, search and storytelling features in real-time. A flexible, scalable data analysis and visualization tools made for all users. The solution can be tailored for specific business functions.
In my role as a Business Intelligence Analyst at Greenspring Associates, a Venture Capital Fund of Funds, from 2010 to 2014, I had the opportunity to implement an innovative process that unlocked a wealth of information through reporting and analytics. This process involved completely revamping the reporting, analytics and data collections procedures in place.
When a person gets behind the wheel of a car, they are presented with a dashboard. The dashboard provides the driver with important information, such as the level of gas in the tank, the current speed, engine temperature and more. The information presented provides the driver with actionable insights. For example, if the gas gauge indicates the car is running low on fuel, the actionable response would be to find the nearest gas station and refill the tank. Similarly, web applications use dashboards to depict high level views of data metrics, which provide useful information and leads to actionable business intelligence.
As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software
Design, code and deliver user friendly multi-tier business intelligence solutions that utilize data warehouse/data mining technologies to consume data across various database platforms and data stores.
Walmart is the biggest retailer in the world and handles more than one million customer transactions every hour and generates more than 2.5 petabytes of data storage (Venkatraman & Brooks, 2012). To put this into perspective, this data is equivalent to 167 times the number of books in America’s Library of Congress (Venkatraman & Brooks, 2012). So how can Wal-Mart use this massive amount of data and what useful information can this data provide? This paper will provide a brief overview of the importance of Business Intelligence (BI) and how the largest retailer in world, Walmart, is using it.
R.L Fielding (2008) reiterates that Business Intelligence is a thorough and holistic analysis of the company records, data, information, and software application for effective decision making. All decision making processes need an organized, readily-accessible, and human readable compilations of data. With the use of an effective tool the firm can easily figure out their own business processes, the behavior of their customers, and the economic trend of the industry. With these facts, the firm can arrive at a better strategy to achieve their specified goals with confidence.
The primary test business insights appearances are assembling the vital information about the business. The key for get-together information is computerizing the methodology.
9. An integrated BI tools business case can be built around which of the following? Görüþ Bildirmek Üzere Ýþaretle
ABC Industries is a diversified global organization that provides a variety of services, such as financial, technical, and manufacturing of products across the globe. Its facilities are located in Europe, Asia, and the United States with revenue of $35 billion. The company has suffered problems with its retrieving qualitative data from one source. Recommendations are to utilize a data warehouse to retrieve the data to strategize analysis, root cause of issues, and Data warehouse is one of the most important components in a Business Intelligence (BI) architecture. Inmon (2005) defines data warehouse as “a subject-oriented, integrated, time-variant, and non-volatile collection of data in support of management’s decision making process” (p. 29). According to Hoffer et al., 2007; Inmon, 2005 characterizes a data warehouse is a
The tool being studied is SAP Crystal Reports. The function of this tool is to provide reports for managers based on information in the company's data set. What the tool does is that it takes "operational and industry" data and uses that to produce reports that make information easy to access, read and understand.