The Return on Investment of Data Warehousing

1905 Words4 Pages
bulb-icon

Recommended: History of database technology

The Return on Investment of Data Warehousing

This paper will present the return on investment (ROI) of data warehousing (DW). The history of data warehousing is based on the definition and timeline. Then, detailed information about return on investment will be discussed. Following, will be information about data warehousing new technology of hardware and software. Data Warehousing is a new term in my department where we use the Network Appliance (NetApps) Netfiler storage devices/units. The information read was very informative and helpful in my understanding data warehousing better. Finally, a conclusion about the return on investment of data warehousing.

According to Ralph Kimball's article, www.dwinfocenter.org/defined.html, "a data warehouse is a copy of transaction data specifically structured for querying and analysis." The author has two quibbles with the Ralph's definition and they are: "1) sometimes non-transaction data are stored in a data warehouse – though probably 95-99% of the data usually are transaction data and 2) querying and reporting rather than "query and analysis" because the main output from data warehouse systems are either tabular listings (queries) with minimal formatting or highly formatted "formal" reports." "Queries and reports generated from data stored in a data warehouse may or may not be used for analysis." The author states, "he especially like about Ralph's definition is what he does not say which is the form of the stored data has nothing to do with whether something is a data warehouse." A data warehouse can be normalized and de-normalized. It can be a relational database, multidimensional database, flat file, hierarchical database and object database. Data warehouse...

... middle of paper ...

...r or collaboration and shared solutions." These two CIOs are speaking from experience, not usage of management reports or historical data, which provides management with decision making solutions. Federal agencies need to share data and there is a data-sharing model (GJXDM) to simplify the exchange of law enforcement files. This is very crucial because we read or see on the news, all the time how a person is in one state as a regular citizen working who is actually a felon in another state. Another big area of concern is public-safety agencies as well as courts. I work with three Acquisition systems that have the same data field types and names, but do not share information so you have to type the same date in each system which equals to three times of data redundancy. I am glad I chose this topic for my paper because it is always good to learn new information.

Show More
Related

  • albertsons

    752 Words  | 2 Pages

    Data warehouse developer is responsible for maintaining the practices of modeling, dimensional data, relational structures, and other reporting techniques. Candidates possessing an inner desire for long term employment opportunities in a team oriented fast paced wonderful environment. They need to be qualified with Information Systems, Computer Science and other related fields. It would be preferable to possess minimum of 7 years’ experience with warehouse design and analysis experience with complete knowledge about data modeling and warehouse methodologies. Job requirements for Albertsons Data warehouse developer jobs-

    Read More

  • Manuel Sacapano Case Study

    915 Words  | 2 Pages

    Nothing is perfect in the world of clinical systems implementation, so a Chief Informatics Officer is always on the go. He travels around the country to attend meetings in order to figure out how to best balance compliance, security, ease of use, automation of manual processes, and safety in electronic medical records systems and other hospital software systems. Clinicians have constantly evolving needs and often come to the Chief Informatics Officer with a clear idea of the problem they want to solve, but no idea of how to solve it. Reliably the pen records lessons from the meetings and concerns of clinicians as it travels with him. It crafts written reports to advise senior management on how to face the endless stream of projects, so that those which can accomplish the greatest good for the most people over the longest time period can be

    Read More

  • St. Rita's Hospital: Data Governance

    1718 Words  | 4 Pages

    Data governance (DG) is an emerging field within the healthcare industry that has coincided with the data explosion. A definitive definition of DG varies among the bodies of authority and education. Despite the differences between the nuances of the various definitions, they all contain the same core elements. Taking the common themes of the definitions into account, the definition of DG for St. Rita’s Hospital is: the system that establishes data asset management as an enterprise endeavor. As such, policies and procedures shall be put forth that protect, manage, and monitor the asset so that the data can be utilized and protected to benefit the organization in an optimized manner.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects...

    Read More

  • Triple Aim In Healthcare Delivery

    689 Words  | 2 Pages

    Healthcare organizations should have a robust foundation focused on clinical, administrative, and patient satisfaction data, as well as the tools to track and measure performance (Balgrosky et al., 2017). The data capture to achieve the Triple Aim can be through an enterprise data warehouse (EDW) (Health Catalyst, 2017). An EDW is beneficial for ACOs because it organizes all health system data into a single secure source while also identifying the areas needed to make improvements. For instance, medical professionals can analyze patient satisfaction surveys through an EDW to determine what needs to be improved to ensure quality care. Interoperability can further the objectives of a Triple Aim by the ability of IT systems and providers to exchange information for the effectiveness of healthcare delivery.

    Read More

  • Data Quality Definition

    3222 Words  | 7 Pages

    Cooperative IS. According to Massimo Mecella et al. “is a large scale information system that interconnects various systems of different and autonomous organizations, sharing common objectives” [30]. The main problems with these information systems are the many copies of the same objects (duplicate copies) and the possibility of poor data quality from one source to spread through the cooperative systems. Thus it is very important for the individual information systems to be trusted.

    Read More

  • Business Intelligence

    340 Words  | 1 Pages

    A data warehouse comprised of disparate data sources enables the “single version of truth” through shared data repositories and standards and also provides access to the data that will expand frequency and depth of data analysis. Due to these reasons, data warehouse is the foundation for business intelligence.

    Read More

  • Public Health Informatician Essay

    842 Words  | 2 Pages

    A rising concern with informatics and public health is the barrier between data sharing. A major challenge for public health informatics is facilitating the improved exchange of information between public health and clinical care. Many of the data in public health information systems still come from forms filled out by hand, which are later computer-coded. Some reports are electronic but the initial data still have to be entered manually, this results in serious underreporting of data. Information silos typically do not share priorities, goals or even the same tools. Departments operate as individual units; silos occur due to an organization structure. Silos make it difficult to share information, agencies store same information in multiple places. Furthermore, silos increase health agency cost.

    Read More

  • DataClear Going Global Analysis

    781 Words  | 2 Pages

    DataClear had also recorded very impressive sales growth in its first two years and, given the projections, were looking at 300 percent average revenue growth thru '02. The case analysis available shows that DataClear has a $600 million annual domestic market for its current product and $1.2 billion when you add in the global market in telecommunications and financial services. With product expansion, there was a potential annual $2.7 billion market ($1.5billion domestic/$1.26 billion abroad) to target in the telecommunications, financial services, chemical, petrochemical, and pharmaceutical industries combined.

    Read More

  • IMy Degree in Management Information Systems

    993 Words  | 2 Pages

    The fascination about information management, the seminar on ‘Hadoop vs RDBMS’ as well as the exposure to data-ware housing made me realize the need of a concrete base in MIS. My long term goal is to conduct research in the field of Information Systems and I look forward to develop my career in the field of MIS and a graduate degree at University of ______, _______will be the right step in that direction.

    Read More

  • Business Intelligence and Data Science

    1145 Words  | 3 Pages

    For the past couple of decades the majority of businesses have wanted to construct a data-driven organization or company. Furthermore, companies around the world are considering harnessing data as a basis of competitive advantage over other companies. As a result, business intelligence and data science use are popular in many organizations today. The increase in adoption of these data systems is in response to the heavy rise in communications abilities the world over. Which, in turn ,has increased the need for data products. Indeed, the Data Scientist profession is emerging to be one of the better-paying professions due to the urgent need of their labor. This paper is going to discuss what business intelligence is all about and explain data science that is usually confused to be similar to business intelligence. I will tackle a brief overview of data scientists and their role in organizations.

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

  • Business Intelligence

    1331 Words  | 3 Pages

    The dynamics of our society bring many challenges and opportunities to the business world. Within the last decade, hundreds of jobs have emerged particularly in the technology sector to help keep up with the ever-changing world and to compete on a larger and better scale than the competition. Two key job markets and the basis of this research paper are business intelligence or BI and data mining or DM. These two fields play a very important role in small to large companies and are becoming higher desired sectors within the back offices of the workplace. This paper will explore what the meaning of BI and DM really is, how they are used and what we can expect as workers and learners of the technology and business fields for the future.

    Read More

  • Your Choice Furniture

    2090 Words  | 5 Pages

    Mehdi Khosrow-Pour, D.B.A. 2006, Cases on information technology : lessons learned,Vol 7, Hershey, Pa. : Idea Group.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    Data can be organized a specific way for each business to be able to get the best use. Employees can also access the system at the same time but in different ways. For example, the customer service team can pull up documents and keep track of complaints at the same time that the marketing team is in a

    Read More

More about The Return on Investment of Data Warehousing

Open Document