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
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
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.
The primary test business insights appearances are assembling the vital information about the business. The key for get-together information is computerizing the methodology.
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
Business Intelligence (BI) is the consolidation and analysis of internal data and / or external data for the purpose of effective decision-making. At the core of all BI initiatives is a data warehouse to hold the data and analytics software. The data warehouse stores data from operational systems in the organization and restructures it to enable queries and models to extract decision support reports.
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.
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).
This report is an analysis of business intelligence systems currently available to our business. As an introduction, I will address in general terms why we need to purchase a business intelligence system and how it will aid our business. Then I will discuss several applications in detail, paying particular attention to the information and analysis capabilities of each, and the hardware and software required for each. Finally, I will conclude with a short evaluation of the products discussed and offer a recommendation as to the best application for our business. I will pay particular attention to IBM, Microsoft, SAP, and Oracle.
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.
Companies are adopting business intelligence system within their organizations because by using the system reports they can gain the advantages of understanding their internal strength and weaknesses to face external competitors and challenges to increase profits and reduce cost on their everyday operations and processes.
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.
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.
9. An integrated BI tools business case can be built around which of the following? Görüþ Bildirmek Üzere Ýþaretle
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.
Once you begin exploiting BI capabilities to work with multiple data sources, you’ll discover how easy it is to add other data sources to the mix, with seemingly endless options to the insights you can gain. Core tasks like distributing and collecting information from different managers, consolidating multiple spreadsheets, creating organizational plans, and debugging broken formulas, will suddenly become substantially easier.