An Analysis of Business Intelligence SystemsJoin now to read essay An Analysis of Business Intelligence SystemsThis 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.
First off, why do we need a business intelligence system for our business? Simply put, an effective business intelligence system can help us streamline almost any aspect of our data management and analysis processes. From organizing daily financial reports and data, to analyzing and predicting market trends, to new business development, a business intelligence system can provide all of these functions and more. The key is clearly defining our focus. To do this, we need to decide what data is most important to us; specifically, what data, if managed in more detail, will help our business reach its goals. Once we have defined our area of interest, we can begin investigating the specific business intelligence software and applications that will apply. Additionally, we also need to look at the acquisition of this business intelligence system from a financial standpoint. How much will this system cost us up front, and how much will it cost us over time in software upgrades and patches? Are the financial costs of the system an acceptable trade-off with the expected long-term business growth and profits which the system should help in providing? Finally, how will this system integrate with our already existing business intelligence systems? Will we need to completely overhaul our IT architecture to install a new intelligence system, or can we rely on software patches and bridges to utilize the new system? These are all factors that we need to consider when analyzing the myriad of possibilities available to us. For the purpose of this report, I will briefly discuss several different business intelligence applications and define them in general terms. Armed with this information, we can better narrow down our search once we have decided where our greatest need for a business intelligence system is, and what our already existing capabilities in this area are.
Crystal Enterprise 10 was the first business intelligence application I looked at. It is a web-based system that provides a data analysis capability along with data reporting (or receiving) and data dissemination capabilities. Data can be readily exported to other formats such as Microsoft Word or Excel, and the application can support Windows or UNIX platforms. However, according to Cindi Howson of IntelligentEnterprise.com this last capability is difficult to effect.
Next, I looked at the Hyperion Essbase 7.0 application. This application provides data integration, on-line analytical processing (OLAP) to include an ad-hoc analysis and application development tool, and reporting functions, but is best suited for financial applications. The application has excellent capabilities on Windows, UNIX, LINUX, AS400, and 390 platforms. However, Java is required for the application server. The Hyperion family of applications is closely associated with Oracle.
Cognos was the next application I researched. Although it is most closely associated with IBM, Cognos has actually developed specific management performance applications for each of the Microsoft, SAP, and Oracle environments as well. Cognos applications allow for the access, analysis, and reporting of all types of data, regardless of location or format. Java is required for the application server, and Windows and UNIX platforms are capably supported. In a Microsoft environment, the Cognos application can help build reports and financial plans by pulling data from SQL servers and Microsoft Analysis Services. In a SAP environment, the Cognos application helps consolidate and make more efficient the reporting, planning, and scorecarding functions. Finally, in an Oracle environment the Cognos application
is the single core of the Oracle software.
2: I’m aware of several people wanting to provide data to their companies that I could not provide (for example, by using data from Oracle in a spreadsheet, etc.), and I’d love to provide their use case reports when people get interested. It is also possible to develop an application that is designed for use with the Microsoft Azure Database Service (also available in this article). For example, I plan on supporting a REST API that contains a collection of functions for querying or retrieving data from databases, along with some basic APIs for the data to be fetched from SQL servers. I’d even like to make it possible to request the SQL Server credentials of a user as a login, or to extract the relevant data from a database.
An application on top of the IIS (Interfaces for Intranets) can provide the need, in my opinion, for multiple interfaces, while an application on the other side would be less likely to provide access to those interfaces. In fact, it’s possible to implement several different applications with access to the data available on one or the other table. I can build an application by designing a simple set of tools that integrate directly into the SQL Server management stack, using a variety of design styles and functionalities. If these application-specific applications were to be put together, most of the need for those applications would likely outweigh the need for APIs and APIs-like support provided by the other side with regard to application design.
3: One of the goals of this article was to make it possible in an environment using the underlying Azure APIs and the IIS (Interfaces for Intranets) to provide access to all the SQL Server features available on the Microsoft datacenter. I wanted to provide access to all of the information needed to complete a transaction between Microsoft and a data service provider for the event that would take place in the Azure application.
This post was adapted from an article in Microsoft Enterprise Management Guide 2. Read more about Azure Databases here .