Premium Essay

Data Warehousing in Universities

In: Business and Management

Submitted By otienoscar
Words 2816
Pages 12
Design and Implementation of a Data Warehouse Prototype for the University of Nairobi within the Context of Relational Online Analytical Processing (Data Analysis)


1. JORAM KIPLIMO D61/68960/2013 0724431978


PRESENTED TO: Dr. Muranga Njihia

Word count: 2752


Data ware housing is a booming industry with many interesting research problem. The data warehouse is concentrated on only few aspects. The discussion here is about the data warehouse design and usage in the case of the University of Nairobi Environment. Data warehouse can be built using a top-down approach, bottom – down approach or a combination of both. In this research paper we are discussing about the data warehouse design process.
Data Warehouse (DWH) systems are used by decision makers for performance measurement and decision support. Currently the main focus of the DWH research field is not as much on the interaction of the DWH with the organization, its context and the way it supports the organization’s strategic goals, as on database issues. The aim of the study is to emphasize and describe the relationship between the DWH and the organization with conceptual models, and to use this knowledge to support data interpretation with business metadata.


Data Warehouse (DWH)
Data Mart
Extraction, Transformation and Loading (ETL); Software that is used to extract data from a data source like a operational system or data warehouse, modify the data and then load it into a data mart, data warehouse or multi-dimensional data cube.
Legacy System: Older systems developed on platforms that tend to be one or more generations behind the current state-of-the-art applications.
Meta Data: Information in a...

Similar Documents

Premium Essay

Data Mining Case Study

...Indiana University Health – A Cerner data warehouse in 90 days - Case Study Name: Goutham Para Provide brief but complete answers. One page maximum (print preview to make sure it does not exceed one-two pages). Q1: Describe the original data warehouse designed for Indiana University Health and its limitations. Please describe the new data warehouse and the differences between each? The original data warehouse structured and designed for Indiana University Health is traditional enterprise data warehouse. They designed data warehouse by using early binding architecture. There would be errors it takes months to update (health catalyst). Indiana University developed a new data warehouse health catalyst with help of late binding architecture. They promised to complete the work within 90 days as soon as possible with no risk. Health catalyst gave deadline data of 14 billion rows in to Enterprise Data warehouse (EDW), it is totally clinical data for ten years of Indiana university’s health network (health catalyst). The observed difference between both data warehouses is old and slow process. Considering health catalyst is faster for storing enormous data very fast without any faults. Q2: Identify the major differences between a traditional data warehouse......

Words: 666 - Pages: 3

Free Essay

Teradata Introduction

...Coffing Data Warehousing Education Outline 02/17/05 TERADATA EDUCATION OUTLINE Coffing Data Warehousing has provided quality Teradata education, products and services for over a decade. We offer customized solutions to maximize your warehouse. Toll Free: 1-877-TERADAT Business Phone: 1-937-855-4838 Email: Website: In addition to the course material listed in this outline, we also offer Teradata classes in Teradata Basics, Implementation, SQL, Database Administration, Design and Utilities. Please contact us so we can customize a course to fit your specific needs. © 2006 Coffing Data Warehousing – All rights reserved. Confidential. 1 Coffing Data Warehousing Education Outline 02/17/05 PURPOSE Coffing Data Warehousing has been providing quality Teradata education for over a decade. We offer customized courses to maximize the effectiveness of each class. The purpose of this proposal is to build a lasting relationship with your company. To this end, we have combined our comprehensive Teradata education services in a unique package that we feel best suits the diverse needs of your company while offering our high quality product at competitive pricing. Coffing Data Warehousing is excited to offer you, our preferred partner, an innovative new way to look at training at the CoffingDW Teradata University (CDW-TU). This approach provides the ability to maximize learning potential. Our goal is to make your......

Words: 1512 - Pages: 7

Premium Essay

Data Warehousing

...Data Warehousing Saikrishna Burugula IST 7000 Data Management Wilmington University Abstract A data storage could be a subject-oriented, integrated, time-variant, non-updateable assortment of knowledge utilized in business intelligence and support of organizing decision-making method (Inmon, Strauss & Neushloss, 2008). In data warehousing when the data is stored it is not updated, commonly data warehousing intended for evaluation connected with data source in addition to addressing queries it can be called copy of addressing data (Prabhu, 2002). The key intention with this paper is typically to target on the actual design connected with data warehouse in addition to modeling techniques like ER modeling and Dimensional modeling. Introduction A Data Warehouse is not just a new combination of all of the in business databases in an organization. Because of its attention on business intelligence, exterior data, and time variant information, a data warehouse is usually a special type of database. The good thing is, you should not learn another number of database abilities to do business with a new information storage place. Most data warehouses tend to be relational databases designed in many ways optimized pertaining to selection assistance, definitely not in business information running. Facts warehousing could be the procedure whereby organizations create and gaze after information...

Words: 1513 - Pages: 7

Premium Essay

Data Warehousing

...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......

Words: 1682 - Pages: 7

Premium Essay


...Facts SAP HANA® – An In-Memory Data Platform for Real-Time Business Objectives Solution Benefits Quick Facts Fast, broad, and meaningful insight at your service Fast, broad, and meaningful insight at your service Real-time analytics No matter what business you’re in, your success may depend on one thing: insight. Not just insight gleaned from standardized reports and data, but insight gleaned from data across your entire enterprise – data that you can use the very second it’s created to help your business thrive. That’s the power of real-time business insight – and that’s the power of the SAP HANA® platform Historically, real-time business insight has not been possible because separate analytical and transaction databases require that numerous complex data models have to be built in order to make data meaningful to business users. There are also scale limitations, as large data sets from different sources in the company can’t be used simultaneously to provide meaningful and instant answers to complex questions. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, preaggregation, and tuning. You can instantly access huge volumes of structured and unstructured data, including text data, from different sources. SAP HANA is a completely reimagined platform for real-time business. It transforms business by streamlining transactions, analytics, planning, predictive, and sentiment data processing on a single......

Words: 1692 - Pages: 7

Premium Essay

Continental Airlines

...Continental Airlines Flies High with its Real-Time Data Warehouse John Paul Barber Schreiner University MKTG 4324, Business Intelligence Dr. Mark D. Woodhull February 16, 2015 Continental Airlines is the fifth-largest carrier in the United States as well as the eleventh largest carrier company in the world. The airline company provides service to 84 domestic and 53 international locations resulting in over 2000 daily flights. This high level of demand creates a large obligation for data and information to be properly stored and organized. Continental Airlines uses business intelligence and data warehousing to help collect their information and develop a system to accelerate decisions and construct flight schedules. Continental Airlines was founded in 1934 with a single-engine aircraft located in the southwestern United States. The company was doing well until 1994; Continental was in dire financial decline. The company had already filed for bankruptcy twice and was on the fast approach to file for the third and maybe final time. The sales of tickets began to fall due to the lack of focus on consumer concerns such as on-time percentages, baggage arrival problems, and constant overbooking. When Gordon Bethune became CEO of Continental in 1994, he initiated this plan. Continental Airlines uses a system called Go Forward that consists of several interrelated, concurrent actions Bethune selected to target the need for improvement in customer needs as well as...

Words: 958 - Pages: 4

Free Essay


...Objective To become Data warehousing Techno-Functional Consultant Current Role: Team member Synopsis of Experience: ➢ Over 2+ years of IT experience in Application Development, Testing of Data Warehousing Projects. ➢ Worked extensively on ETL tool (Informatica 9.1). ➢ Working knowledge on BI Tool (BOXI) ➢ Good exposure to data analysis, data extraction and data loading. ➢ Extensively worked on Oracle 10G. ➢ Strong understanding of Dimensional Modeling, Star and Snowflake Schemas. ➢ Having good inter-personal, analytical and communication skills. Work Experience: ➢ Have been working since Dec 2011 to Till Date as Developer in Vertiv solutions (INDIA) pvt ltd. Education: B.Tech from Jawaharlal Nehru Technological University Technical Skills: Operating System : MS-DOS, Window 7, UNIX Database : Oracle 9i, MS-SQL Server ETL Tool : Informatica Power Center 9.1 OLAP Tool : Business Objects Scheduler : Autosys Other Utilities : TOAD 8.0 Project Information: Project#1 Vertiv solutions (INDIA) pvt ltd. Client: Hewlett Packard, Houston USA Project: E-WARRANTY MANAGEMENT SYSTEM Duration: Dec 2011 – Mar 2013 Environment: Windows XP, UNIX, Informatica 7.1.2, Business Objects 6.5, Oracle9i, TOAD8.0, MS-SQL Server2000, MS-DTS About the Client: Hewlett......

Words: 593 - Pages: 3

Premium Essay

El-Alamein for Printing and Packaging Goes Digital

...Interactive Session: management El-alamein for printing and packaging goes digital Founded in 1921, El-Alamein is one of the leading companies in the Middle East in the printing and packaging industry. With head-quarters (HQ) located in Alexandria, El-Alamein occupies an area of 40,000 square meters and employs more than 700 employees. El-Alamein has managed to obtain international quality certificates including: ISO 9001, ISO 14001, ISO OHSAS 18001, and BRC/IOP. The company has two main Strategic Business Units (SBUs): offset factory as well as a flexible factory. “Since 1921, El-Alamein Co. led the revolution of the Printing and Packaging industry in Egypt. El-Alamein is the approved supplier to the biggest international companies in the fast food industry. The company produces paper cups for cold and hot drinks as well as ice-cream packages with their different shapes and sizes. The company also produces eight-cornered carton boxes to pack sandwiches and burgers, in addition to different shapes and sizes of fried potatoes boxes. The company produces wrapping paper for sandwiches and fast food, and produces printed multi-layered paper bags by using automatic heat sealing for the bottom and side-seams.” The company faces many challenges: there isn't a reliable infrastructure, network, servers, storage or PCs; there isn't an IT/IS department in the organization chart; competitors have taken serious steps in becoming digitally enabled, and information loss has......

Words: 929 - Pages: 4

Premium Essay


...Supply Chain Logistics Systems Memo Laniece Seamon University of Phoenix ISCOM 352 January 21, 2013 The increased rate of change within the economy was driven by a number of large level forces, due to empowered consumers, technology, globalization, shifts in economic power, and regulations. All of these elements of change raised the importance of supply chain management as a strategic move to gain a competitive advantage. Supply chain management involves integrating three key components across the board within a company’s supply chain; they are information, product or materials, and cash flow. The order processing pertains to the flow of information within the logistics system, which includes several operations. Customers may be required to fill out an order form for requested products. The order is then transmitted and checked. The customer’s items are checked to see if it is in stock and then payment is verified. Next, the items are retrieved from the inventory, packaged and delivered along with their shipping documents. Lastly, the customer must be informed about the status of their order. Inventory management is an important role within logistics system operations and planning. Inventories are stockpiles of products or goods waiting to be transported, manufactured, or sold. Logistics management is a balancing act between minimizing costs and ensuring the availability of goals. Appropriate decisions must be made between key elements such as inventory......

Words: 728 - Pages: 3

Free Essay

My First Draft Final

...My Project Ray Vance Professor James Manning CIS-499 Strayer University October 27, 2013 This is a record that I CEO Jim Gold has to offer the shareholders, showing a decided gain in the last six months, and the promise of much more to come in the next 3-5years. Despite stiff competition in several quarters, Wilcox Watch Manufacturing has shown to be far more superior to the closest competitors in nine local locations, and fourteen foreign Countries as well. However with the introduction of several hundred new products, and the planned merger with our partnering Firm: JEMCO, exciting new opportunities are opening up all around us. Also, everyone is excited and looking forward to the World Watch Exposition, for many of our already packaged new arrival sales showcases. Mission Statement Of The Company Wilcox Watch Manufacturing guarantees all design, developing, manufactures, inventory and distribution of parts, optical target design, every close tolerance creation, and laser induced thread, watch mold and fabrication processes. Including all computer aided Theodolites, Photogram Metric Systems, Tracking Lasers, plus all new managed systems of measurement and design, that are current or may emerge will only use the very best parts and design. This includes Support Management and System Design Technologies and Quality Control Safety with up to date Modern specifications. We are......

Words: 896 - Pages: 4

Premium Essay

Audit Program Design

...Audit Program Design Part III Tywana Bowman University of Phoenix ACC545/Financial Accounting Professor Michael DeMarco September 26, 2010 Introduction In order to conduct a substantial audit of Apollo Shoes the auditor must obtain a sufficient understanding of the entity and the entity’s environment, including the internal control. The understanding of the entity and its environment helps the auditor in a variety of ways throughout the audit, including establishing materiality, considering appropriateness, and designing audit procedures that can facilitate the growth of Apollo Shoes. Before the auditor can begin the process of conducting the audit of the inventory and warehousing cash cycles, the auditor must prepare the audit plan and program for Apollo Shoes. Developing the audit strategy and plan aids the auditor in determining the necessary resources to perform the engagement. The auditor must develop a plan in mind that will reduce audit risk to an acceptable level for the inventory and warehousing cash cycle. The audit plan should include a description of nature, timing, and extent of the planned risk assessment procedures. The audit plan and program significantly affects the types and extent of further audit procedures to be used by the auditor in determining whether the financial statements are fairly stated in accordance with the US GAAP. The auditor should consider audit risk in relation to the individual account balances, classes of transactions, and......

Words: 1093 - Pages: 5

Premium Essay

Why I Want To Study In Computer Science And Technology

...message drives me on to reach my goal. I was deeply inclined towards the field of science and technology, being allured by its sheer vastness and the plethora of knowledge. My desire to pursue graduate studies in the field of Computer Science and Technology is a cumulative result of my interest in it and my strong desire to contribute something meaningful to the society to the best of my abilities. I believe graduate study will refine and sharpen my skills and help me in realizing my goal as a research scholar in an academic or a commercial research oriented organization. The desire to explore and innovate in academic and research-oriented setting, leads me to apply to the Master of Science program in Computer Science & Engineering at the University of North Carolina, Chapel Hill...

Words: 1281 - Pages: 6

Free Essay


...progression and where I can make a significant contribution. Key Skills * Vast working experience in fixed assets * Solid experience in warehouse bar coding  * Profound Knowledge of inventory practices and procedures  * Extensive knowledge of various tasks associated with inventory management of supplies and equipments * Knowledge of warehousing, logistics, supplier integration, strategic supply management  * Knowledge of Inventory Management System  * Ability to use computerized inventory systems * Familiarity with inventory, purchasing, and financial and accounting concepts * Proficiency in computer applications  * Outstanding ability to maintain accounting database  * Immense Ability to make work schedule and take initiative to do tasks  * Excellent form filling skills  Work experience Inventory Assistant ------------------------------------------------- Manila Central University, Caloocan City April 2013 – Present * Responsible to provide highest level of accuracy and efficiency in accounting supplies and fixed assets of the university. Responsible to deliver customer service responsively and work...

Words: 586 - Pages: 3

Free Essay


...Business Requirements for ADCA 10/30/2013 Professor Dr. Phillip Duncan Strayer University CIS 499 Information Systems Capstone Business Requirement Plan Currently our system consist of SQL database sitting on 5 Cisco servers onsite. I plan to have that changed to oracle databases in a virtual world and out sourcing the cloud storage. Our current data warehouse is at ten terabytes. This is expected to increase by twenty percent a year therefore this must also be taken into account when searching for a provider of cloud storage. This will save on cost of equipment and also space. This savings of cost and space will be used to hire more technical personnel such as an oracle database administrator and a JavaScript programmer. We currently are running windows 7 but will be upgrading to windows 8 because it is better suited to the virtual world than windows 7. In regards to infrastructure and security, right now we have a basic to average network set up with a DMZ for our clients and intranet with a few firewalls. Not much can be done since we are running a SQL database. This will change when we upgrade to oracle. More security on the network and our client’s information will now be able to be applied. We will also create and maintain a backup center located off site. This center will not be cloud based but an actual server room. We will have to address that privacy issues associated with using a JavaScript method instead of log files to maintain the sites. ......

Words: 1621 - Pages: 7

Premium Essay

4. What Role Did “Themes” Play in the Cpr Dashboard?

...ITECH7406- Business Intelligence and Data Warehousing Team assignment – 2015 Team assignment consists of Team report and team presentation Weighting: 25% (15% for the report and 10% for the presentation) Team report There are new and exciting developments that are taking place in the Business Intelligence literature that is constantly shaping the use and implementation of Business Intelligence and Data warehousing tools and applications in organizations. The primary objective of this research project is to provide a forum for students to investigate the practice, approaches and understanding of business intelligence as it is being applied in the real world to realize organizational objectives. Some of the potential topics are: * Development and acquisition approaches for emerging decision support environments * Challenges in harness big data and relevant analytics for effective, timely inputs to strategic decision making * Cultural, social and political dimensions of the adoption of emerging decision support technologies * Data and business analytics in the cloud * Emerging technology for real-time analytics * Knowledge-driven analytics: application of emerging technologies such as text mining, data mining, rule-based systems, semantic web technologies, or in-memory databases to address specific decision support needs * Mobile technologies for decisions analytics and support There are two deliverables to this project. 1.......

Words: 1161 - Pages: 5