a collection of subject-orientated data collected over a period of time and stored on a computer to provide information in support of managerial decision making....
The client is one of the largest financial institutions in the world. The client's challenges were: using the existing data collection mechanism to present a unified metrics representation of the restructured organization, ensuring due consideration of people and process-related issues and recommending and implementing a data warehousing tool, providing various...
The client, a US-based telecom service provider, had existing systems that were not flexible for report generation. Business users were unable to extract complete information easily and quickly. Infosys provided end-to-end Data warehousing solution using Oracle and Business objects. A strategy was defined for building the Oracle Data Warehouse. This...
The client is one of Europe's largest financial services group with leading positions in corporate & commercial banking, retail banking, credit cards and general insurance. The client needed a business intelligence solution to consolidate the mortgage administration processes, satisfy better sales cycle management, mortgage product performance analysis, financial forecasting based...
The National Institutes of Health NIH is one of eight agencies of the Public Health Service and part of the U.S. Department of Health and Human Services. NIH decided that, to meet its users' need for easy access to integrated business information, it needed outside help to bring a data...
Deutsche Bank Alex. Brown DBAB wanted to enhance its management reporting system used by internal brokers and its parent company. DBAB wanted to create a central data repository that each data source could automatically update. The key to building this repository was to create specific rules governing the data elements...
Continued advances in hardware technologies combine to create a new class of information services, termed mobile e-services, or simply m-services, which exploits the advances in, among others, wireless communications, positioning, and miniaturization. Because the users do not merely interact with the services from behind stationary desktop computers, but from a...
The client, a world's leading emerging markets bank, wanted to thrust on its capabilities in personal banking and credit business loans and cards. To foray deeper into the business, the client required data warehousing and business intelligence solutions to be implemented effectively and quickly. Wipro developed a complete Data warehousing...
A company had a huge data warehouse that was consolidated from various systems using an ETL (Extract, Transform, and Load) tool. Infosys, which was asked to reengineer the data warehouse and make it modular, delivered a solution that reduced the batch processing time by 70%. As a result of the...
To make effective decisions, business users need dashboards and reports that blend both historical and the latest transaction data. Unfortunately, few Business Intelligence products today can generate views that merge data from multiple systems, including data warehouses and operational systems that contain the most up-to-date information. This situation forces users...
Developing customer profitability can provide dividends to mobile operators. The mobile industry is still less than twenty years old, and as such is moving from a growth to a maturity stage. Like many other industries, different performance measurement metrics are used depending on the stage of evolution. The days when...
Enterprise organizations use Data WareHouses DWHs to analyze their performance. Performance is judged regarding the achievement of goals. DWH data models are well established. There exist numerous domain-specific modeling approaches. Enterprises also often model their goals in terms of formal or semiformal goal models. The problem is that these two...
Equipment logistics, maintenance, and repair are important aspects of construction equipment management. A well-managed equipment fleet helps reduce downtime, as well as total maintenance and repair costs. With quickly growing fleets of equipment, large contractors tend to divert the maintenance and repair of equipment from equipment managers to project managers....
The past few years have seen the rise of Business Intelligence solutions, such as data warehouses, data marts, OLAP tools, and data mining. Database cycle improvements dominate the thinking of IT professionals and their business partners as they strive to increase competitive advantage. The concept of a data warehouse is...
As old as business itself, Customer Relationship Management CRM has grown to be a number one priority in corporations around the globe, primarily because of the growth of the Internet and Web. Central to the move toward a customer-centric enterprise is the data warehouse and today, many firms both large...
How are you addressing the single most difficult problem facing data warehouses? Data Quality. When the quality of data is compromised incorrect interpretation and use of information from your data warehouse can destroy the confidence level of its customers, your users. Once the user's confidence in your warehouse is eroded...
Data warehouse provides an effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensional database modeling and the presentation of...
This paper describes a method for data warehouse development. One critical success factor of data warehouse development is determining information requirements. Hence, the method focuses on gathering of requirements and information needs of the users first. An extended data warehouse architecture and a technique for decomposition of the system serve...
Increased data volumes and accelerating update speeds are fundamentally changing the role of the data warehouse in modern businesses. More data, coming in faster, and requiring immediate conversion into decisions means that organizations are confronting the need for a Zero-Latency Data Warehousing. The Zero-Latency Data Warehouse ZLDWH is an extended...
Real-time computing is the term used to describe systems which are subject to constraints in time. Typical data warehousing processes are, more often than not, batch processes that are allowed as much time as needed to perform the required transformations and loading processes. Leading industry analysts agree that real time...
What is the one thing without which a world-class supply chain cannot exist? Accurate data. But that's easier said than deployed. Compliance requirements such as Sarbanes-Oxley, supply chain optimization needs and continued integration of enterprise applications to improve business performance. Mergers and acquisitions, which require companies to consolidate internal data...