Premium Essay

Comparative Analysis of Business Intelligence Tools

In:

Submitted By adityamalik93
Words 1293
Pages 6
Business Intelligence:

Business intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information to help corporate executives, business managers and other end users make more informed business decisions.

Business intelligence tools are a type of application software designed to retrieve, analyze, transform and report data for business intelligence. The tools generally read data that have been previously stored, often, though not necessarily, in a data warehouse or data mart.
BI Tools Analyzed:

When preparing the analysis of the business intelligence tools, I made a personal preference of analyzing the tools leading in the Gartner chart, and that these tools must have efficient service and customer usage. The 5 business intelligence tools which I have selected are as follows:

1. IBM Cognos
Link: http://www-01.ibm.com/software/analytics/cognos/

2. Oracle BI 12c Link: http://www.oracle.com/us/solutions/business-analytics/business-intelligence/foundation-suite/overview/index.html

3. SAS Enterprise Intelligence Platform
Link: http://support.sas.com/documentation/onlinedoc/intellplatform/index.html#intell92

4. Microsoft SQL Server + MS SharePoint Server
Link: https://technet.microsoft.com/en-us/library/ee210689(v=sql.105).aspx

5. MicroStrategy
Link: http://www.microstrategy.com/us
Criteria used for Evaluation:

I have researched for multiple criteria and then grouped them into 5 main groups based on their functionality or their possible use in the BI system. The main criteria groups are detailed as follows:

1. Infrastructure & Development
This group checks if the tool has the necessary development methodology, back-end integrity and so on. I have given this group a weight of 10%. The factors I have grouped into this super group are: * BI integrated infrastructure *

Similar Documents

Premium Essay

Lecture 1 Ccs

...e 2/4/2014 | 1 Comparative Country Studies (CCS) BSc IB - EBB686A05 International Business Lecturers: Henk Ritsema, coordinator Abdul Erumban Huib Stek 2/4/2014 | 2 Overview › › › › Introduction Course format Course plan Literature / Individual assignment › About Comparing Countries 1 2/4/2014 | 3 Introduction › The goals of this course are: 1. To develop and apply analytical skills to understand socio-economic differences between countries; 2. To assess how these differences impact the climate for doing business across countries.  Theory and Application 2/4/2014 | 4 Course format › Tutorials (with student teams): • Theory tutorials (TT) • Application tutorials (AT) › Combining theory with application  country Factbook • • • • Tools/Methods Application of tools Comparative analysis Recommendation › Industry perspective 2 2/4/2014 | 5 Assignments and Grading/Feedback › Team assignments (70%) & Individual assignment (30%) › Team assignments: • Paper on / synopsis of materials of Theory tutorials (30%) • Factbook grade (40%) › All assignments: minimum of 5 › Overall: minimum of 5.5 › Participation / performance as presenters, reviewers or chair (+/- 1 grade point on team assignments) › Are you allowed to take this course? Propaedeutics or positive BSA › Passing 2nd year courses but failing 1st year courses leads to removal from the program 2/4/2014 | 6 First Application tutorial (starting tomorrow) › Each team...

Words: 1951 - Pages: 8

Free Essay

Strategic Insiht

...Strategic Intelligence and in the process define the key terms so that there is no ambiguity about the topic being examined. I will define the concepts of strategy, insight and strategic intelligence before moving on to analyze the need for an international relations theory for conducting strategic insight. The paper will then explain constructivism and why it is the most appropriate theory for carrying out strategic insight. Strategy The concept of strategy has been around for as long as there have been organizations and wars. Strategy is a method or plan chosen to bring about a desired future, such as achievement of a goal or solution to a problem. 1Strategy is also about achieving and sustaining a position of lead over rivals through the successive capitalization of known or developing possibilities rather than restricting to any specific fixed plan designed at the onset. It can be said that strategy becomes a central plan through which an organization can affirm its essential continuity while at the same time purposefully handling its adjustment to the changing environment to gain competitive superiority. Strategy can also be viewed as a response to external opportunities and threats and to internal strengths and weaknesses; a means of achieving a long range competitive advantage, and a favorable competitive position and adapting to meet the demands of a changing environment. Insight A thought, fact, combination of facts, data and/or analysis of data that...

Words: 2992 - Pages: 12

Premium Essay

Essay Strategy Positioning

...choices and execution. Strategic positioning is the foundation that establishes organisations strategic potential, what it can do and strategic ambitions, what it actually seeks to do (Johnson et. al 2011). This requires good understanding of the externalinternal environment, organisational purpose and culture. The tools commonly used to develop understanding and perform a strategic analysis are presented in Appendix 1.0.This essay aims to lay the foundation for a comprehensive analysis of current strategic potential of Singapore Airlines (SIA). Firstly, the focus is on how to identify the sources of information about macro environment, unique features of airlines industry and in depth view of internal dynamics of SIA. Secondly, the focus is on comparison of four core tools in terms of relevance, advantages, disadvantages and creative adaptability for SIA. A preliminary application of these tools is made to illustrate the arguments for or against using a particular tool. The essay briefly touches on another crucial aspect of right expertise and competence for an effective analysis. The essay concludes with key observations and recommendations for a further comprehensive analysis of SIA.A simple structure is adopted in this essay as indicated in Fig 1.0 The airlines industry in general, with no exception of Singapore Airlines, has always been viewed as having certain unique features in terms its external environment. Johnson et al. (2011) describes the external environment in form...

Words: 1743 - Pages: 7

Premium Essay

Case Study

...who come up with suggestions and decisions that drive the business. The dashboard empowers decision makers as it gives them timely access to the best possible information that they can use in decision-making (InetSoft Technology Corp, 2015). The dashboard provides a robust infrastructure, analysis services and powerful integration, and intuitive and familiar interface that empower decision makers of any firm (InetSoft Technology Corp, 2015). Giving decision makers access to the right information will equip them better to make the right decisions. The dashboard allows decision makers to conduct comparative analysis during the decision-making process. The features of the mashup include data from various sources and web applications. The mashup provides real-time integrated view of the organization. These include data on revenues, salaries for each employee, and information on employee safety. The dashboard also incorporates key performance indicators in more understandable features. It also integrates chats that make information more usable. Data virtualization is also used to enable decision makers meet long-term and short-term business needs. The tool makes it easy for users to create, modify, and interact with their dashboard and reports as it makes using and interpreting data easier (InetSoft Technology Corp, 2015). The tool offers maximum self-service data exploration without seeking the help of an IT expert. The tool presents data in a clear and precise means making it easier...

Words: 510 - Pages: 3

Free Essay

Law Enforcement Today

...for the public’s safety as well. Law enforcement agencies are using The Home Land Security Information Network which allows them to securely collaborate with partners across the country. Law enforcement professionals also use HSIN to share information including Be on the Lookouts (BOLOs), Requests for Information (RFIs), For Your Information (FYIs), Intelligence Reports, and other Law Enforcement Sensitive documents. HSIN allows users to create and distribute messages to large, mission-specific contact lists. This rapid, secure information exchange provides law enforcement professionals with critical intelligence as they conduct work in the field ("Homeland Security Information Network - Law Enforcement Mission", n.d.). The purpose of this State and Local Fusion Center Concept of Operations (CONOPS) is to establish a framework for a comprehensive, coordinated and consistent approach for outreach by the Department of Homeland Security (DHS) to State and Local Fusion Centers (SLFCs). This CONOPS outlines DHS processes relating to SLFC support including intelligence and operational...

Words: 748 - Pages: 3

Premium Essay

Business Intelligence

...Abstract Business intelligence (BI) is a grouping of different resources that affect the way data is utilized within businesses. The technologies available with business intelligence focus on utilizing the data within a company the best possible way. The successfulness of business intelligence relies on the constant evolving of the solutions as well as the scalability of the program. Business intelligence solutions are available in self- service options as well mobile choices and use on the cloud. Business intelligence has and is making a big impact on companies all over the world in many different ways. Business Intelligence is a set or collection of concepts, procedures, styles, and technologies that change basic data into beneficial and valuable information for business related purposes. One main purpose of business intelligence is to take on large amounts of indistinct data in order to piece together and create new opportunities for a variety of business types. (Cooper & Schindler, 2014)The incorporation of business intelligence helps businesses process large amounts of data easily in order for the business to take on new prospects and put into place new and effective strategies for the business to gain market advantage and achieve long-term stability. (Jullens, 2013) The technologies utilized by business intelligence incorporate past, present and future possibilities for business procedures. Business intelligence utilizes presentations and technologies...

Words: 4093 - Pages: 17

Premium Essay

Approach to Building and Implementing Business Intelligence Systems

...Interdisciplinary Journal of Information, Knowledge, and Management Volume 2, 2007 Approach to Building and Implementing Business Intelligence Systems Celina M. Olszak and Ewa Ziemba University of Economics, Katowice, Poland olszak@ae.katowice.pl ewa.ziemba@ae.katowice.pl Abstract Abstract: The article aims at describing processes of building Business Intelligence (BI) systems. Taking the BI systems specifics into consideration, the authors present a suggested methodology of the systems creation and implementation in organisations. The considerations are focused on objectives and functional areas of the BI in organisations. Hence, in this context the approach to be used while building and implementing the BI involves two major stages that are of interactive nature, i.e. BI creation and BI “consumption”. A large part of the article is devoted to presenting objectives and tasks that are realised while building and implementing BI. Key words: Business Intelligence, methodology of BI construction, designing BI, business decision-making, knowledge management Introduction Socio-economic reality of contemporary organisations has made organisations face some necessity to look for instruments that would facilitate effective acquiring, processing and analysing vast amounts of data that come from different and dispersed sources and that would serve as some basis for discovering new knowledge. For long time management information systems (MIS) have been supporting organisations in their...

Words: 6255 - Pages: 26

Premium Essay

Finance Theory and Financial Strategy

...Finance theory and Financial strategy Strategic Planning means several things. But it certainly is a part of the decision-making in resource management of the business benefits. Finance theory has significant advantages in understanding the function of capital markets, the valuation of real assets and financial assets. Discounted cash flow analysis(DCF) is a tool that derived from finance theory which has been widely used. However finance theory also has little effect on strategic planning and there are three differences between financial theory and strategic planning: 1. Traditional financial theory and strategic planning might have some differences in language and culture. 2. Discounted cash flow analysis might be used in an incorrect way of strategy therefore it is not acceptable in terms. 3. Discounted cash flow analysis might fail to apply a strategic, even if it is used properly. The most relevant financial concepts in strategic planning is firms’ capital investment decisions and it is also a critical component of “financial theory”. The theory is focused on cash flow and return on the investment. The tool used in investment decisions is net present valued (NPV) which was calculated from present valued minus required investment or which was reduced to discounted cash flow formula because the net present value is a matter of cash flow that will gain in the future. [pic] ...

Words: 1179 - Pages: 5

Premium Essay

Sample

...Akshith Kumar Akshithkumar85@gmail.com 408.641.1038 SUMMARY: • Over 6 years of IT experience with strong expertise in using MicroStrategy tool Suite as Developer and Administrator. • Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Office and MicroStrategy Narrowcast Server. • Participated in the Software Development life-cycle of the data warehousing and Business Intelligence project. • Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy9.x/8.x versions. • Strong expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators. • Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations). • Expert in creation of Report Service Documents, Scorecards and Dashboards which helps in better understanding of business trends. • Sound knowledge of 2-Tier Client/Server Architecture and N-Tire Architecture. • Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts and methodologies. • Proven troubleshooting capabilities in Microstrategy Desktop. • Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability...

Words: 1749 - Pages: 7

Premium Essay

21. Describe How or Why Integer Programming or Goal Programming or Nonlinear Programming (Choose One) Might Be Used in a Real-World Business Situation. Be as Specific as You Can and Use Examples as Appropriate.

...OR nonlinear programming (choose ONE) might be used in a real-world business situation. Be as specific as you can and use examples as appropriate. Goal programming is an aid for decision-making problems with multiple, possibly conflicting goals. Typically, linear goal programming attempts to minimize a weighted sum of deviations from goals. This program is used in real-world business in an attempt to eliminate or, at the least, mitigate this disquieting disconnect. Goal programming is the most widely applied tool of multiple-objective optimization/multicriteria decision making. However, today’s goal programming models, methods, and algorithms differ significantly from those employed even in the early 1990s. Goal programming, may be combined with various tools from the artificial intelligence sector (most notably genetic algorithms and neural networks) so as to provide an exceptionally robust and powerful means to model, solve, and analyze a host of real-world problems. In other words, today’s goal programming while maintaining its role as the “workhorse” of multiple-objective decision analysis—is a much different tool than that described in most textbooks. Goal programming’s label as the “workhorse” of multiple-objective optimization has been achieved by its successful solutions of important real-world problems over a period of more than 50 years. Some examples among these applications are: • The analysis of executive compensation for General Electric during the 1950s •...

Words: 1137 - Pages: 5

Premium Essay

Artificial Intelligence

...SCM Research paper | Shreerang Datar Supply Chain Management (SCHM 6210) Spring 2016 RESEARCH PAPER “ARTIFICIAL INTELLIGENCE IN SUPPLY CHAIN MANAGEMENT” By Shreerang Datar (NUID 001649801) 04/14/2016 1 SCM Research paper | Shreerang Datar Table of Contents 1. Executive Summary……………………………………………………3 2. Introduction…………………………………………………………….4 3. Background…………………………………………………………….5 4. Findings………………………………………………………………...6 a. Artificial Intelligence Tools……………………………………..7 b. Business Examples…………………………………………….10 5. Future Trends and Challenges………………………………………...18 6. Conclusion……………………………………………………………19 7. Bibliography…………………………………………………………..20 2 SCM Research paper | Shreerang Datar Executive Summary: Surpassing the limits of business intelligence, artificial intelligence (AI) focuses on developing an algorithmic approach in decision making. This technology has come so far that inculcating human competencies like logic, reasoning, simulation and analytical thinking in a machine seems to be in reach. In the field of Supply Chain Management this technology is placing a strong foot in achieving creative optimization and automation in different supply chain processes. AI has found its applications in various SCM aspects which include Inventory management, Network design optimization, Logistics strategy formulation, demand forecasting, etc. It is designed to generate a step-wise mechanism for problem solving in which it defines the problem...

Words: 3566 - Pages: 15

Premium Essay

Assignment 1 Predictive Policing

...standard for police departments today. Predictive policing primary role is to simply pre-empt crime, it is rooted heavily in business analytics and relies advanced technical tools and data analysis. In 2009, Charlie Beck, Chief of Detectives for the Los Angeles defined predictive policing in the following terms: “With new technology, new business processes, and new algorithms, predictive policing is based on directed, information-based patrol; rapid response supported by fact-based prepositioning of assets; and proactive, intelligence-based tactics, strategy, and policy. The predictive-policing era promises measurable results, including crime reduction; more efficient police agencies; and modern, innovative policing.” Dr. John Morgan introduced the five elements of predictive policing that focuses on integrated operations, seeing the big picture, cutting-edge analysis and technology, linkage to performance, and the adaptability to changing conditions. Technology is used in many different ways to implement the basics of the five elements. It is used for simple tasks as crowd control to the complex task of traffic control. Technology is used predict the time and location of a possible future crime, to develop patrol staffing and resource allocation. It is used to identify individuals who are likely to reoffend and the early detection of career criminals, analysis of predatory patterns, threat and vulnerability assessments, there is a never ending list of tasks which technology is used...

Words: 1711 - Pages: 7

Premium Essay

Kaplan It521 Unit 3

...Unit 3: IT521: Decision Support Systems Jessica Brown IT 521 Kaplan University Even the best-organized data will become overwhelming to analyze with vast amounts of data especially for those not adverse in analytics. This was the problem for New York City Mayor’s Management Report (MMR), which offers indicators from city agencies to gauge performance. To solve this problem they decided to develop a Citywide Performance Reporting (CPR) system. The current Mayor of New York in 2008, Michael R. Bloomberg, stated the City was developing a performance measurement tool that would help make the workings of government transparent to all citizens and ensure that city agencies are accountable for their performance.() The CPR will eliminate the mystery about where and what kinds of performance information are available and increases accountability to its customers. The CPR was launched in February 2008 as an pioneering methodology to interactive, transparent performance management. The agencies involved in the implementation of the CPR dashboard were the Mayor’s Office of Operations in consultation with the Department of Information Technology and Telecommunications. CPR identifies where service delivery by more than 40 City agencies is trending in a positive or negative direction in an easy-to-use snapshot format. The following are the incentives of the CRP taken from NYC CPR At-A-Glance: * Tracks performance for the most important "outcome" measures - those directly...

Words: 684 - Pages: 3

Premium Essay

Excellence in Financial Management

...Excellence in Financial Management Course 12: Competitive (Part Intelligence (Part 2 of 2) Prepared by: Matt H. Evans, CPA, CMA, CFM This course provides more in-depth coverage about competitive intelligence – specific techniques and models used as well as CI Systems. Before taking this course, you should complete Part 1 of this course. This course is recommended for 2 hours of Continuing Professional Education. In order to receive credit, you will need to pass a multiple-choice exam which you can take over the internet at www.exinfm.com/training/course12-2 Chapter 1 Critical Concepts Before we get into Part 2 of this short course, let’s touch on the fundamentals behind competitive intelligence. From Part 1 of this course, we learned that competitive intelligence relies on a very analytical process to transform data and information into intelligence. We also understand that competitive intelligence is not just about studying the competition, but studying the entire external landscape - customers, suppliers, regulators, and all forces that impact the organization. Therefore, our analysis must be very broad in scope. The primary output from competitive intelligence is the ability to make forward-looking decisions. For example, Jack Welch, former CEO of General Electric determined strategy based on key intelligence questions: What is the detailed global position of your business and that of your competitors: market shares, strengths by product line, and by region...

Words: 12266 - Pages: 50

Premium Essay

Topics

...Topics for summer project FINANCE 1. vendor performance 2. quality circle 3. TQM 4. ISO 9000 5. value engineering 6. centralize purchase 7. management audit 8. company analysis with ratio/fund flow 9. study of stock exchange 10. role of SEBI 11. joint venture 12. takeover 13. merger 14. marginal cost as management tool 15. product life cycle 16. media plan 17. test marketing 18. export pricing 19. role of small scale industries in developing nation 20. role of SIDBI 21. role of EXLM bank 22. study of financial institute 23. mutual fund 24. Privatization insurance, road, ports etc. 25. waste management 26. trade union movement in India 27. labour welfare scheme 28. working capital management 29. cash management / fund management 30. importance of budget 31. invisible exports 32. tourism industries 33. brand equity 34. bench marking 35. co-operative movement in Agro-product 36. marketing Agro-product 37. DOT COM company in future 38. IT Parks 39. South East Asian origin 40. FDI 41. Regional Grouping / Trade Block 42. SEZ 43. packing need 44. social forestory 45. comparative study of industries (either financial angle or marketing angle or techno angle) 46. marketing of SSI produt 47. warehousing 48. transport 49. communication and custom service 50. universal bank 51. credit cards ...

Words: 1098 - Pages: 5