...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 different tasks. However, today many IT systems have undergone significant depreciation. Hitherto existing...
Words: 6255 - Pages: 26
...IBM Software Group Business Analytics Cognos Enterprise The right architecture for business intelligence The foundation for effective enterprise BI 2 The right architecture for business intelligence Overview In a fast, interconnecting and complex world, it is no longer enough to decide and act on the basis of limited information or traditional strategic planning cycles. New challenges and opportunities require agility: the ability to quickly assess, reinvent and adjust. Business analytics is helping many organizations achieve this kind of agility. Analytics software brings together business intelligence (BI) capabilities such as reporting, analysis and scorecarding with planning, scenario modeling, real-time monitoring and predictive analytics. It lets you tap into information within your organization and beyond, to connect with key stakeholders and to share insight, align and decide. Analytics-driven organizations not only seize opportunities: they outperform. IBM’s 2010 CFO study (involving more than 1,900 CFOs and senior finance leaders worldwide) showed that analytics-driven organizations had 33 percent more revenue growth and 32 percent more return on capital invested. Investing in analytics is considered a priority for many organizations, but a big question can be the technology platform. Which platforms provide the best foundation for positive business outcomes? What kind of architecture best lends itself to accessible analysis, intuitive collaboration...
Words: 4760 - Pages: 20
...“QlikView is a superb tool for managing inventory by allowing you to optimize stock levels and lower costs associated with excess stock. By using QlikView in our day-to-day operations, we’ve improved inventory utilization by 5 percent.” – Pravin Shinde, Analytics Manager, Flipkart Flipkart, the largest B2B e-commerce business in India, went live in 2007 with the objective of making books easily available to anyone with internet access. Founded by entrepreneurs Sachin Bansal and Binny Bansal, Flipkart has diversified from book sales into other products. It sells entertainment products—from movies, music to consumer electronics—as well as healthcare and personal products, home appliances, and clothing. Flipkart experiences massive growth quarter on quarter The rapid diversification has also brought rapid growth. This is illustrated by the company’s expanding network of warehouses and procurement operations. This kind of scale has added to the need for Flipkart to continually upgrade its business discovery software to better serve multiple business units with new applications. As a startup, Flipkart initially used open source technology to support the launch, but soon found that open source business intelligence (BI) tools had limited functionality. Shinde says: “Scalability was a problem. It was hard to drill down into our data to produce complex reports.” QlikView impresses Flipkart as replacement for open source BI In August 2011, the company ...
Words: 929 - Pages: 4
...automation to on-demand agile reporting to robust business intelligence and analytics (BI&A), data remains the future of business. Because of this trend, BI&A has become an industry in its own right. Software companies of all sizes are developing tools that are changing the future of business archetypes. According to Gartner, Inc., “By 2020, information will be used to reinvent, digitalize or eliminate 80% of business processes and products from a decade earlier” (Forbes 2015). As BI&A continues to quickly grow, there are multiple trends, techniques, platforms and expanding technologies that impact how organizations might tackle the development of a universal BI&A platform. The current “hot” trend, increasingly on the rise is self-service analytics, which opens the use of data to more people in a real-time way. Rado Kotorov, a Chief Innovation Officer at Information Builders predicts that for 2016: “…Self-service analytics will evolve beyond just self-service for analysts. There will be self-service information for the masses delivered not through tools but through purpose-built interfaces and apps. Just as the ATM in banking evolved from a cash-dispensing machine to a full transaction and account management terminal, so too will self-service mature and spread to the masses” (PC Mag 2015). Self-service analytics is a trend that takes away much of the technical, bewildering side of BI and replaces it with data analytics, visualization and statistics that the lay businessperson...
Words: 1940 - Pages: 8
...Accenture Insurance Reaping the Benefits of Analytics Six Ways to Make Your Business Intelligence Smarter 1 Gartner research shows that many insurers are still struggling to achieve a 360-degree view of their customers, and part of the issue they are grappling with is the completeness or the accuracy of the data they have on customers across their various repositories.1 Despite their hefty and increasing investments in data warehouses, architectures, analytics, and business intelligence (BI) platforms, many insurance companies still are not getting the value they want, and need, from their BI initiatives. Over the past 10 years, insurers have spent hundreds of millions of dollars on data warehousing and BI. One of the prime areas for insurer’s IT investments from 2010 to 2011 was in data warehousing; half of the 29 propertycasualty executives surveyed by the Ward Research Center indicated they were budgeting more money to better house their data.2 Despite the focus and investment, insurers saw little change; the same huge, bulky, flat report outputs from the old systems were simply migrated to the new systems. As a result, carrier information remains disjointed, conflicting, slow, and backwards-looking. Executives and managers continue to be overwhelmed by ominous reports. They have a hard time deciphering what the information means relative to business change. They either have too much or too little information, rarely at the point of need, and never with the ability...
Words: 3218 - Pages: 13
...Consultant with expertise in Oracle Financials modules (GL, AP, AR, FA and PA), Manufacturing Modules (OM, INV, Shipping, BOM, WIP, PO). • Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components. • Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flows. • Excellent knowledge of AOL (Application Object Library)/FND and System Administration Modules. • Experience in creating and customizing existing reports using BI and Reporting Tools like Oracle Discoverer, Reports 10g/6i/4i and XML/BI Publisher tools. • Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE components) in the domain of Oracle Applications E-Business Suite. • Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc. • Strong experience in Data Conversions and Design/Development of Interfaces using Oracle open interfaces and Oracle Public API’s. • Very Good understanding of Trading Community Architecture (TCA). • Familiar with Oracle Applications Framework (OA) technology, especially with personalization of existing OA Framework pages. • Experience in Application System Administration activities like managing concurrent managers, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing...
Words: 2129 - Pages: 9
...Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users Release 7.9.6.4 E35271-01 November 2012 Provides the steps to install and set up Oracle Business Intelligence Applications Release 7.9.6.4. Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users, Release 7.9.6.4 E35271-01 Copyright © 2009, 2012, Oracle and/or its affiliates. All rights reserved. Primary Author: P Brownbridge This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed...
Words: 60905 - Pages: 244
...BI Norwegian School of Management – Thesis Master of Science in Innovation and Entrepreneurship GRA 19002 Convergence, Complementarity or Disruption: Enterprise Search and Business Intelligence By Vedrana Jez Hand-in date: 01.09.2009 Supervisor: Dr. Espen Andersen This thesis is a part of the MSc programme at BI Norwegian School of Management. The school takes no responsibility for the methods used, results found and conclusions drawn. Acknowledgments I would like to thank my supervisor, Dr. Espen Andersen, for his support and guidance throughout the project. I am also grateful to all participants in this research for their contribution and time. Finally, I thank my family for their understanding, encouragement and patience. Thesis 01.09.2009 Content Content ..................................................................................................................... i Abstract .................................................................................................................. iv Introduction ............................................................................................................ 1 Research Methodology ........................................................................................... 2 Research Question .........................................................................................................2 Method Used ..................................................................
Words: 19593 - Pages: 79
...BI – Migration from Business Objects to Cognos |Umesh Ashok | |Tata Consultancy Services | |Mumbai | |umesh.ashok@tcs.com | ABSTRACT This White paper describes the POC Experience of migrating reports from Business Object XI R2 to Cognos BI 8.3 It highlights the challenges, solutions and best practices implemented for seamless transition TARGET AUDIENCE Cognos Architect and Developers of BO to Cognos Migration project PRE REQUISTIC Knowledge of Cognos BI 8.3, Business Objects XI R2 and RDBMS Databases. INTRODUCTION XYZ uses Business Object as a reporting tool to develop and deliver reports to the business to analyze the data. XYZ wants to upgrade these BO reports into Cognos reports using Cognos 8 BI suite. Existing BO Reports presented quite a challenge for migration because of many reasons like diverse formats of reports and multiple interfaces. Cognos BI environment is available with the XYZ. Prime goal to migrate BO reports...
Words: 2384 - Pages: 10
...manage this complexity would be appropriate EXCEPT Select one: a. hiring more sophisticated and computer-savvy managers. b. seeking new ways to avoid government compliance. c. avoiding expensive trial and error to find out what works. d. deploying more sophisticated tools and technique. The correct answer is: seeking new ways to avoid government compliance. 2. In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of prescriptive analytics? Select one: a. warning of an open shipment seal b. real time reports of the shipment's temperature c. location of the shipment d. optimal temperature setting The correct answer is: optimal temperature setting 3. In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of predictive analytics? Select one: a. real time reports of the shipment's temperature b. optimal temperature setting c. location of the shipment d. warning of an open shipment seal The correct answer is: warning of an open shipment seal Organizations counter the pressures they experience in their business environments in multiple ways. Which of the following is NOT an effective way to counter these pressures? Select one: a. adaptive actions b. retroactive actions c. reactive actions ...
Words: 1533 - Pages: 7
...update the researchers in specific fields. Facilitating them with latest Research Paper, Bibliography of research papers and books. The goal of AJMR is to bring fresh perspective to research in management and take research to masses through its open access, internet based technology. AJMR is a quarterly journal, and every quarter a new topic/theme is chosen and paper pertaining to it are called for and subsequently reviewed for publication. We take this opportunity to invite research papers, case studies, monographs on the below stated theme. The theme for the August issue is “Business Intelligence, Analysis and Strategy” Background Theme The key to thriving in a competitive marketplace is staying ahead of the competition. Making sound business decisions based on accurate and current information takes more than intuition. Business success depends upon opportunities availed, strategy designed and action taken. But in most of the situation like in retail where Fifty-Three percent (53%) of large retailers indicate that customer analysis is difficult due to enormity of data from different channels. Retailers have more data than they are capable of processing. More often than not retailers blame disparate sources and enormity of customer data as the primary reason for lack of adequate consumer insights that inhibits new customer acquisition, customer retention and reactivation....
Words: 649 - Pages: 3
...Department of Information Technology and Media (ITM) Author: Katarina Lundqvist, kalu9700@student.miun.se Study program: Master of Science in Engineering – Computer Engineering, 270 higher education credits Examiner: Tingting Zhang, tingting.zhang@miun.se Tutor: Aron Larsson, aron.larsson@miun.se Tutor: Mats Olsson, mats.olsson@sogeti.se Scope: 20102 words inclusive of appendices Date: 2010-03-17 M.Sc. Thesis in Computer Engineering AV, 30 higher education credits Tools for Business Intelligence A comparison between Cognos 8 BI, Microsoft BI and SAP BW/NetWeaver Katarina Lundqvist Abstract 2010-03-17 Tools for Business Intelligence A comparison between Cognos 8 BI, Microsoft BI and SAP BW/NetWeaver Katarina Lundqvist Abstract The aim of the thesis was to conduct a general study of Business Intelligence and BI systems followed by a comparison of Cognos 8 BI, Microsoft BI and SAP BW/NetWeaver. The goal was to distinguish similarities and differences between the tools regarding technique, cost, usability and educational need and to provide a mapping for different customer situations. The method consisted of a theoretical study followed by a practical part including development, testing and interviews. The comparison showed that SAP and Microsoft both use the client/server model while Cognos is an integrated web-based system built on SOA. SQL Server can only be installed on Windows while BW and Cognos also support UNIX, Linux and IBM. SSRS...
Words: 25350 - Pages: 102
...project is based off of a need to know what tools are available for small businesses who wish to compete with their bigger and more financially equipped counterparts. As someone who has always had a great interest in being an entrepreneur, I believe this is as great a medium as any other to delve into the topic of affordable business intelligence solutions for small businesses. In a recent study of small and medium businesses, it was found that they collect a lot of data but are face with the problem of having too much information and a great majority of them did not know how to make best use of it. In essence, they know the importance of collecting data but do not comprehend how to make sense of the data. (Aggarwal, McCabe, & Aggarwal, 2011) The study went on to show that 25% of the small and medium size businesses that took part in the study reported that one of their biggest challenges is getting better insights into the data they collect. But as Todd R. Weiss so put it, it’s also getting much harder for small businesses to find excuses for why they cannot compete with larger competitors on a regional, national and global scale because of the accessibility of software and services (specifically BI tools) via “the cloud”. (Weiss, 2012) This paper will briefly discuss what business intelligence is; why it is so important; the benefits that small and medium businesses stand to gain from implementing BI and name some specific tools that these businesses can implement. What...
Words: 1799 - Pages: 8
...into significant business insight by giving associations the ability to change information from different sources into precise, consumable data that can be shared safely all through the endeavor. It empowers clients to make educated business choices rapidly and unquestionably by giving the inquiry and reporting instruments they have to discover, offer, oversee, distribute and investigate data. The objective of Business Intelligence is to empower administration to settle on more shrewd choices on the premise of learning separated from information. Does this imply having information is constantly great, that having more information and removing more Knowledge from it is better, and that learning can be gotten just from information? Business insight is accepted to have the most elevated effect on associations over next couple of years as they progressively fuse the innovation in ERP and CRM programming, a late study appears. In looking over more than 1600 officials in 36 nations, the Aberdeen Group found that one in four distinguished BI and investigation as the product innovation with the most proclaimed impact in 2009. "Organizations are finding that BI has numerous uses inside of the association, however the boundaries to achievement lie in the capacity to make get to and use pervasive". David Hatch the administrators distinguished a few business activities as driving BI use inside of their associations. They incorporate manageability and green following, field Marketing and...
Words: 2162 - Pages: 9
...Introduction: We now live in an era of information overload. Nowadays, most Business Intelligence (BI) applications till now have focussed on managing the strategic and tactical business methods and initiatives of organizations. Without Business Intelligence, an organization runs the danger of settling on discriminating choices focused around deficient or wrong data. Settling on choices focused around "gut feel" won't take care of business! One of the fastest BI growth area, lies in its use for managing and optimizing daily business solutions and operations that include overseeing database workloads that answer a mixture of Online Transaction Processing (OLTP)-like questions and additional business insight enquiries. This paper stresses on the importance of operational Business Intelligence in organizations that are not very well equipped to implement BI, and looks at the necessities for building and deploying an operational BI framework. The three main types of BI are - Strategic - Tactical and - Operational. Operational BI is concerned mainly with overseeing and optimizing everyday business operations and solutions. It delivers the required data or information at the right time to the right clients or users for them to tackle current business problems quickly and fulfill new business requirements. It helps organizations work smart and become nimble, which enables them to be competitive and in turn improve customer satisfaction. Inventory (Stock), Network and Risk...
Words: 1830 - Pages: 8
