Database Data Warehouse Design Our company, Data Analytic Limited, specializes in collecting and analyzing data for various organizations. Over the years, we have assisted various companies to turn raw data into valuable information that assists the companies in making effective decision profitable in the short and long run. Our research and data analytics are geared towards giving extra edge to various companies. Our services include processing and analyzing terabytes of data to provide customer meaningful information for business decision and enhance competitive market advantages. Recent growth of our company necessitates the needs to design and develop data warehouse that will accommodate large volume of customer data.

Objective of this project is to design and develop the data warehouse for our company.

Importance of Data Warehousing for our Organization

Comprehensive portfolios of our business include Business, Market, and Financial research, Data processing services and Domain based analytics. While the relational database that our company is currently using provides a necessity for our current needs, however, data warehousing has become a strategy priority for our organization because of enormous amount of data that our company is required to analyze, which comes from various sources. If we continue using relational database to store our data, we will need to delete certain volume of data to make room for new data, and doing so, we will not be able to create historical data to assist our clients to make analytical processing from these data. With the volume of data that we need to store, our company will need to create multiple database to maintain historical data and such practice will not assist our company to implement centralized database that can be accessed by all staff, which consequently lead to data redundancy.

Data warehousing is a priority for our business because of the enormous volume of data that our organization will analyze and process. (Microsoft, 2012). Typically, data warehouse will assist our organization to organize data into multidimensional cubes using OLAP to rapidly summarize data for analytical queries. (Tera Data, 2012).

Rostek, (2010) argue that data warehouse stores, processes and integrates operational data to support an effective decision making process. Efficient analysis of data requires historical data to complete and data warehouse is the biggest known database that will assist our company to organize data...

Moreover, our organization will be able to overcome data latency with data warehouse. The data latency occurs when organizations take too much time necessary to collect, prepare analyze and transform data for an effective decision-making. The most valuation information that is not up-to-date may not deliver a significant benefit for management. The data warehouse will assist our company to overcome the data latency, which will assist us to classify, forecast and stimulate data for a decision making.
The main idea of data warehouse is to collect data from different sources in one base. Data warehousing supports business decision by consolidating, collecting and organizing data for analyzing and reporting using tools such as data mining and online analytical processing (OLAP). Although, our company is currently using relation database to analyze and process data, however, relation database will not be able to accommodate large amount of data received by our company that need immediate processing and analyzing to make an analytical decision.

By taking advantages of data warehouse, our company will enjoy the superior performances delivered by OLAP. Online analytical processing is the technology that is designed to deliver superior and intelligence performances to businesses. By integrating data warehouse into our business operation, our company will be able to use OLAP to operate efficiently with data organized in accordance with dimensional model.

Using a data warehousing to process data, our company will be able to deliver a maximum performance because the data warehouse will assist our company to process total sales income and quantity sold in various methods. The query of total sales income of a specific geographical location will be answered within few seconds regardless of hundred of million rows of data stored in our data warehouse. More importantly, our company will be able to enjoy superior performances delivered by OLAP because OLAP will assist our company to summarize information in analytical queries.

Similarly, our company will enjoy superior advantage delivered by data mining technology by integrating data warehouse for our data services. Data miming technology applies complex and sophisticated data analyzing technology used to assist information analysts in enhancing decision making. "Data mining is a natural extension and supplement of data warehouses creation, which means organization…