What Is a Data Warehouse ?

The purpose of data warehousing is to combine all of a company 's data and allows users to access the data directly, create reports, and obtain responses to

This data is collected and organized in order to process orders and maintain good customer service. The logical view of data would allow a knowledge worker to arrange and access information based on the needs of the business separating it from the physical view of how information is arranged and stored. The ability to do this allows for an employee to create detailed reports in order to determine information such as customer information and their order numbers and dates. This is imperative for a company like Comcast who has over 27 million customers in order to have a system to keep important data to analyze. Using a data warehouse allows them to gather from several databases and then the company can use the information to determine for example how many units of voice products are sold to create the necessary business intelligence to make future decisions and remain

Data can be stored in data warehouses. However, they need data cleansing to standardise the data.

Data management is vital to any business as this is a key tool to an organisations business improvement, as you can refer back to data, and compare them against benchmarks. Analysing data can provide evidence for possible future structure such as identify trends, as well as indicate where improvements can be made. However there are strict procedures to be followed when collecting and storing data.

One crucial thing that organizations need to consider in today’s unstructured data world is to successfully integrate data warehouses. For this, the companies need to re-consider their enterprise data architecture and classify the governance strategy that can be talented through such efforts. There lies a need for data managers

A data warehouse is a large databased organized for reporting. It preserves history, integrates data from multiple sources, and is typically not updated in real time. The key components of data warehousing is the ability to access data of the operational systems, data staging area, data presentation area, and data access tools (HIMSS, 2009). The goal of the data warehouse platform is to improve the decision-making for clinical, financial, and operational purposes.

We can say that “Data is the fuel of next generation”. Today we live in the world that is driven by data. The World Economic Forum summarizes the fourth industrial revolution as a possibility for billions to be connected, machines with enormous processing power and high-volume data storage. These possibilities are evolving exponentially in field of Internet of Things, Artificial Intelligence, Machine Learning, bio technology, autonomous vehicles, etc. To handle such a large volume of data in a uniform manner, it is required to be processed and stored for analysing and getting business insights. This exponential growth and the increasing demands in all fields has led the data warehousing technology to emerge tremendously. In this report, we will discuss about the two broad approaches for designing and implementing data warehouse presented by two data warehouse giants Ralph Kimball and Bill Inmon. Also, we will compare the architectural design approach, implementation approach along with their advantage and dis advantage from a business point of view.

IT managers need to learn and implement data warehousing because it is very powerful tool provides storage, functionality and responsiveness to queries beyond the capabilities of today 's databases. It also improves the data access performance. Since it is very rare today to remove the data because most users have only read-access also rapid access to a larger volume of data which could be inconvenient sometimes.

Moreover, its relation to the data warehouse turns the first pattern of development on its head. Here multiple data marts are parents to the data warehouse, which evolves from them organically. The third pattern of development attempts to synthesize and remove the conflict inherent in the first two. Here data marts are seen as developing in parallel with the data warehouse. Both develop from islands of information, but data marts don’t have to wait for the data warehouse to be implemented. It is enough that each data mart is guided by the enterprise data model developed for the data warehouse, and is developed in a manner consistent with this data model. Then the data marts can be finished quickly, and can be modified later when the enterprise data warehouse is finished. These three patterns of data mart development have in common a viewpoint that does not explicitly consider the role of user feedback in the development process. Each view assumes that the relationship between data warehouses and data marts is relatively static. The data mart is a subset of the data warehouse, or the data warehouse is an outgrowth of the data marts, or there is parallel development, with the data marts guided by the data warehouse data model, and ultimately superseded by the data warehouse, which provides a final answer to the islands of information problem. Whatever view is taken, the role of users in the dynamics of data warehouse/data

In Philip Russom’s webinar he provides an overview of what a Data Warehouse (DW) modernization is, why many users’ DWs need modernization. The top five most common reasons for DW modernization including: Advanced Analytics, Scale, Speed, Productivity and Cost Control, what is the result from modernization, and his recommendations

The data warehouse comes ready for use, but an organization has to get prepared to use it. The main factor is data warehouse usage. A data warehouse can be used for decision making for management staff.

Furthermore, the Gartner website argues that “BI has become a strategic initiative and is now recognised by chief information officers (CIOs) and business leaders as instrumental in driving business effectiveness and innovation,” (Anon., 2007). Gartner also argues that “BI projects were the number one technology priority for 2007” (Anon., 2007). According to the Bill Inmon, data warehouse is “a subject-oriented, integrated, time variant and non-volatile collection of data used in strategic decision making”. Hammergen & Simon, (2009) define data warehouse more simpler by saying that “ Data warehousing is therefore the process of creating an architected information management solution to enable analytical and information processing despite platform, application, organizational, and other barriers.“ It is important to note that data warehouse system is different from relational database. The reasons of that are: (1) In the data warehouse data is stored for long term; (2) DW is designed for high performance for analytical queries; (3) its OLAP (Online Analytical Processing) technology enables to view data in various form; (4) linking between tables are simple (Tushman, 2014). Databases, in contrast, have a low performance regarding data analysis; joins between tables are

In data warehousing, there is a distinction between a data warehouse and a data mart. A data warehouse collects information about subjects that span the entire organization, such as customers, items, sales, assets, and personnel, and thus its scope is enterprise-wide. For data warehouses, the fact constellation schema are commonly used since it can model multiple, interrelated subjects.

These changes could also drive a change in the culture of the company to become more data driven. If there was confidence in the data warehouse and the reporting coming from it as well as trust between the business departments and the data team this could drive improvement across the company. Discovering opportunities for improvement using data is the currently unrealized goal of the data warehouse. All improvements and changes and improvements outlines in this document have that goal in mind.

Data warehouse are multiple databases that work together. In other words, data warehouse integrates data from other databases. This will provide a better understanding to the data. Its primary goal is not to just store data, but to enhance the business, in this case, higher education institute, a means to make decisions that can influence their success. This is accomplished, by the data warehouse providing architecture and tools which organizes and understands the