...IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 Before using this information and the product it supports, be sure to read the general information under Notices. This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/order v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/planetwide To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU (426-4968). When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. © Copyright International Business Machines Corporation 2000 - 2002. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents About the...
Words: 7362 - Pages: 30
...Proposal – Data Warehouse Inventory What is data warehouse? It’s a simple assembling of data gathered from various sources and available to the global customers in a way they can understand to their business level. Statement of Problem: Our intention is to develop inventory application (User interface) so that client can easily track their warehouse. For creating interface we are using ETL and IBM Cognos. Methods to solve problem: * Creating Database for customer * Extract transform and loading the data * Data Mapping * Creating Package from Framework Manager using IBM Cognos * Developing Interface using IBM Cognos Report Studio Tools: IBM DB2, Informatica Power center, IBM Cognos 10.2 Resources: 3 Client: Volvo Trucks. Software Development Life Cycle 1. Requirements 2. Design 3. Development 4. Testing 5. User Signoff Requirements for data warehouse design: A. Goals: 1. To design the flexible data warehouse as per the client requirements. 2. Get the raw data into the centralized repository so that the users can access it in a flexible manner. 3. We should make sure the data cannot be edited by the users. B. Clients Requirements: 1. We need to get all the details of the client products available in their inventory. 2. We need to study the client environment and take down the end to end process. C. Business Questions: 1. Need to discuss about the design duration. 2. Number of resource required for the...
Words: 316 - Pages: 2
...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
...Data warehousing is a fairly new but not so new development in the information systems field. Data warehousing can be traced back being in existence since the 1980’s when Teradata in 1983 introduced a database management system (DBMS) designed for decision support systems (Ponniah, 2010). The influence from the two Irish IBM architects Barry Devlin and Paul Murphy who in 1988 laid the foundations for what we call today a data warehouse in their original article “An Architecture for a Business and Information Systems” (Bouman & van Dongen, 2009). It was not long after that Bill Inmon, referred to as the father of data warehousing authored one of the most influential decision support books “Building the Data Warehouse” in 1991(Ponniah, 2010). Since then Prism Solutions in 1991 introduced the Prism Warehouse Manager software for developing data warehouses. The Data Warehousing Institute was also founded 1995 and has and continues to promote data warehousing by way of serving as the leading voice in the business world providing education, research, and support (Ponniah, 2010). With the business environment being more global, competitive, multifaceted and unpredictable there is a need for systems that would satisfy emerging business needs and new technological advances (Wixom & Watson, 2001). The enterprise for enhanced customer relations and e-commerce alone these days require large integrated repositories and advanced analytical repositories (Wixom & Watson, 2001). Data warehousing...
Words: 1682 - Pages: 7
...diagram, the following: Primary Data Warehouse and Data Mart. In this connection, explain the difference between ROLAP and MOLAP. A Primary Data Warehouse is a central repository of a database of a complete organization. It holds multiple subject areas and very detailed information. A Data Mart is a subset or an aggregation of the data stored to a primary data warehouse. It often holds only one subject area – for example, a specific department, finance or sales. It may hold more summaried data, and is typically smaller than a warehouse because of its employment on a different grain. Figure 1.1 illustrates the difference between data mart and a primary data warehouse. Since the data mart typically holds one subject area, it is much smaller than a primary data warehouse. These data marts can be viewed as small, local data warehouses replicating the part of primary data warehouse which is required by a specific domain or department. Data Warehouse Data Mart Data Warehouse Data Mart Figure 1.1 A data warehouse does not necessarily use a dimensional model, since it is partly normalized RDBMS, but data marts are multidimensional cubes. This connection gives arise to two concepts, ROLAP and MOLAP. ROLAP is an implementation based on a relational database, in our case which is a primary data warehouse, and MOLAP is an implementation based on a multidimensional database which are data marts. ROLAP tools use the relational database to access the data and generate SQL queries to calculate...
Words: 685 - Pages: 3
...[Type text] DATA WAREHOUSE Introduction In todays competitive and information packed age, management, executives and business users need well organized data for decision support and for the organizational planning. Decision Support Systems (DSS) were developed to aid executives and managers to better understand the information and facilitate at making better decisions. But DSS has its own limitations. Due to the information requirement and their complexity, it was difficult for Decision Support System to extract all necessary information from the data. Therefore to overcome this drawback, a new data storage system, called the Data Warehouse was developed. What is a Data Warehouse? A data warehouse is a relational database. It is not used for daily routine transaction processing. It contains remarkable (having great significance) data derived from the transaction data. It also contains data from other sources like external systems, or applications. It is designed for query and analysis. Copyright 2011. Do not copy or publish any part of this document without author's permission. [Type text] Data Warehouse Vs Traditional Database A database is a collection of the relational data. Database system comprises of a database and database software. Similarly, a data warehouse is a collection of relational data as well as supporting system. If we look closer at it, we will find that both the traditional database and the data warehouse have indexes, fields, keys, views...
Words: 2229 - Pages: 9
...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 issues suited for different databases. • Worked extensively on Oracle, Teradata, DB2, and SQL Server with Micro strategy Suite. • Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions. • Expertise in test planning and testing methodology for Quality...
Words: 1749 - Pages: 7
...Reporting Infrastructure Tool Evaluation Introduction Ease of use of the AWS data warehouse is one of the key tenants of the AWS DW team. Currently AWS DW customers connect directly to data warehouse databases (RO & Primary) and use SQL to extract the data. Providing a general-purpose and self-service reporting infrastructure significantly reduces the effort spent by data warehouse customers to exact data and subsequently build metrics decks and dashboards. Oracle Business Intelligence (OBIEE) and Tableau are being evaluated for their suitability for our AWS data warehouse customers. We are recommending Tableau. We have determined that it provides the best self-service experience for general purpose reporting needs and for more advanced data analytics and data visualization needs of the users of the AWS data warehouse. Problem Statement AWS data warehouse customers build and maintain SQL’s to extract data from the data warehouse. Once the raw data is extracted, it is often combined with custom data for individual services. Metrics on excel worksheets are then generated/updated. These excel worksheets are circulated to service team members and leadership for analyzing the usage and revenue of their products and also for identifying opportunities for operational improvements. Most tasks that involve creating the metric desks are manual, consuming significant effort of the data warehouse customers. The manual efforts are typically error prone and associated with the...
Words: 829 - Pages: 4
...Training Curriculum Data Warehousing: • Introduction to Business Objects Enterprise Reporting • Fundamentals of Data warehouse Concepts • Introduction to Dimensional Modeling • Developing a Star Schema Reporting: • Building and editing queries with Web Intelligence • Performing on report analysis with Web Intelligence • Filtering Queries using conditions, prompts etc., • Using Combined Queries and merging dimensions • Displaying data in various formats (Ex: Tables, Charts etc.,) Advanced Reporting: • Calculations, Formulas and variables • Ranking Data, using Alerters to highlight data, Formatting numbers and Dates • Understanding Calculation Contexts • Web Intelligence Functions, Operators and Keywords • Calculating values with Smart Measures Universe Designer: • Designer and Universe Fundamentals • Creating a schema with Tables and Joins • Resolving Join problems in a schema • Defining Classes, Objects, hierarchies, using cascading list of values for hierarchies • Testing the universe • Working with OLAP universes Xcelsius 2008: • Application Overview • Creating and Updating Xcelsius visualizations • Using Xcelsius components ( Chart, Containers, Selectors etc.,) • Exporting Xcelsius visualizations to various applications (Power point, PDF, Flash • Creating templates, Alerts and Dynamic visibility • Using Data Manager ( Creating and configuring connections) • Live Office Connections, Query As A Web Service (QWAAS), XML data Connections Crystal...
Words: 462 - Pages: 2
...Contrasting the following: Transient data: Data is created within an application session changes to the data were made by writing over the previous data and of the previous data is deleted. The data is not stored in databases and the data which is stored previously was completely deleted. Transient data are stored in RAM and the data which is deleted cannot be recovered. Periodic data: It is a data which is stored cannot be deleted or altered in other words, once we entered the data we cannot make any changes. As the data becomes permanent, so changes cannot be made. Data warehouse: A Data warehouse is concept- oriented, that includes the subjects about the customers, product, time, etc. it is a unique database which focus on time-variant data, external data. The data warehouse helps in centralizing the data which were...
Words: 905 - Pages: 4
...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 management information systems (i.e. MIS, DSS, ES, EIS) have not always met decision makers’ expectations, such as: • • • • making decisions under time pressure; monitoring competition; possessing such information on their organisations that includes different points of view; and...
Words: 6255 - Pages: 26
...subtype: Basically disjoin subtype is a type of scenario that is often run into in data modelling. IN this modelling there is a one specific thing that this each subtype of entity is described with different own table. For example if we create a table name Animal there should be different entities for all subtype it should be like Living, instincts, marine lives, there are three different types of entity type that are disjoint types. (Enhanced E-R Model, 2001) Overlapping: Overlapping subtype are the subtypes that contain non-unique subsets of the super type entity relationship sets. In simple wording it can be said that this type of super type is contain one or more subtype on the same time. For example here if here we talk about a professor of the university he can be administrator of any department on the other hand a student can be a professor at that university. It means there is overlapping between student and professor. Figure 2 (E-R Modelling) Task 1.2...
Words: 638 - Pages: 3
...Corporate data are essential to organization's survival rate since these are decisive factors in maintaining their competitiveness on the market. Even for companies in non-Internet industries, they still need assistance from network capabilities for communication and collaboration. Information flow determined the daily operation flow within a company. Depending on the field that the organization falls into, these data can be internal, external, or both. By digitalized most of the physical documents, it is also important to enforce necessary security in order to protect essential information of the organizations and their clients. Due to the enormous amount of information collected on a daily basis, organizations tend to struggle to manage the high volume of physical documents without the help of IS database storage. Databases reduce the amount of physical documents by storing the information in a systematic way. The Information are collected from marketing, sales, customer connectivity, supply chain inventory and external data. These information provides a closer look at the status of the business's standing. The information comes in huge clumps. In order to crunch through the huge datasets, we rely on huge data management vendors whom are working as database warehouse equipped with powerful software and hardware that are capable of handling and analyzing large amount information from Fortune 500 companies such as Oracle, IBM, Microsoft and Teradata. The database warehouse is a...
Words: 1040 - Pages: 5
...FIRST QUARTER 2007 PREDICTIVE ANALYTICS Extending the Value of Your Data Warehousing Investment By Wayne W. Eckerson Research Sponsors MicroStrategy, Inc. OutlookSoft Corporation SAS SPSS Sybase, Inc. Teradata, a division of NCR www.tdwi.org PREDICTIVE ANALYTICS Extending the Value of Your Data Warehousing Investment By Wayne W. Eckerson Table of Contents Research Methodology and Demographics . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 What Is Predictive Analytics? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 The Business Value of Predictive Analytics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Measuring Value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 How Do You Deliver Predictive Analytics? . . . . . . . . .. . . . . . . . . . . . . . . . . . . . 11 The Process of Predictive Modeling. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 1. Defining the Project. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 2. Exploring the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3. Preparing the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
Words: 14129 - Pages: 57
...| Content | Page | 1 | Abstract | 3 | 2 | What is Data Warehouse? | 3 | 3 | Who uses Data Warehouse? | 4 | 4 | Characteristics of Data Warehouse | 4 | 5 | Basic Elements of Data Warehouse | 5 | 6 | Basic Processes of Data Warehouse | 7 | 7 | Basic Components of Data Warehouse | 8 | 8 | Data Warehouse Architecture | 9 | 9 | Steps to build successful Data Warehouse | 12 | 10 | Selection of Data Warehouse | 13 | 11 | Cost and Size of Data Warehouse | 15 | * Abstract: This document is for explaining what data warehouse is and how does it work. It also explains how data warehousing is useful for companies and organizations for the purpose of decision making and offers a broad array of decision support services to all companies. Data warehousing technique is adopted by many of the companies who use Information Technology to gain a competitive advantage. Companies who have started using this technology are building various techniques to develop hardware, software and other tools that help data warehouse to function more effectively. In this term paper I have given a brief idea about the development and basic terms that are necessary to understand data warehousing. The paper also states advantages and disadvantages encountered while developing data warehouse. * What is Data Warehouse: Data Warehouse is a database in which information of an organization is stored...
Words: 2065 - Pages: 9
