Database Data Warehouse Design Our Company Data Essay

Download this Essay in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Essay:

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 in the centralized manner to deliver analytical information. 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…[continue]

Cite This Essay:

"Database Data Warehouse Design Our Company Data" (2013, November 07) Retrieved December 1, 2016, from

"Database Data Warehouse Design Our Company Data" 07 November 2013. Web.1 December. 2016. <>

"Database Data Warehouse Design Our Company Data", 07 November 2013, Accessed.1 December. 2016,

Other Documents Pertaining To This Topic

  • Data Warehouse a Strategic Weapon of an Organization

    Growth Aided by Data Warehousing Adaptability of data warehousing to changes Using existing data effectively can lead to growth Uses of data warehouses for Public Service Getting investment through data warehouse Using Data Warehouse for Business Information Ongoing changes in Data Warehousing The Origin of Data Warehousing and its current importance Relationship between new operating system and data warehousing Developing Organizations through Data Warehousing Telephone and Data Warehousing Choose your own partner Data Warehousing for Societal Causes Updating inaccessible data Data warehousing for investors Usefulness

  • Data Warehousing

    Data Warehousing Data Warehouse technology has changed the way that global organizations conduct business. Many have found it impossible to create a business strategy without a data warehouse. The purpose of this discussion is to research and explain the importance of data warehouse management. We will begin by defining data warehouse and describing the business uses for the technology. Our discussion will then focus of data warehouse management. We will examine the

  • DBMS and Data Warehouses 1 in This

    DBMS and Data Warehouses (1) in this writing assignment, you will create a brochure advertising your services as a data repository. Powered By Excellence Data Repository Service Powered By Excellence is the only data repository service with globally-located data centers across each continent, each with specific security, reliability and fault redundancy systems in place. Our staff includes world-class experts on the following platforms: IBM, Microsoft, Oracle, MySQL, Informix, Sybase, Teradata and SAS expertise in-house as

  • CRM Using Data Warehousing at

    It is important to realize that the level of technology investment at present is sufficient for the current project; this proposal does not necessarily advocate any additional spending on pure technology. What this analysis pinpoints as a major area of concern is the slow and very gradual transformation of FAC when it needs to move much faster towards its customer goals. The lack of speed and urgency in the shift

  • Evolution of Database Systems

    Databases and Information Management Use of Databases in an organization The evolution of databases in business and organizations has created subtle and substantial changes in the business environment. From the introduction of PC-based contact management software, to integrating complete sales and contact information on company intranets, the availiability of information has made customizable solutions to individual customer problems possible. No longer is a business limited to a one size fits all approach

  • Transition of Traditional Relational Database

    They in short link and map ideas that already exist, creating real time answers to questions as they are applied to new and archived knowledge or action plans. According to IDC reports, most data warehouses will be stored in a columnar fashion and not in rows, reporting and data collection problems will be solved with databases that have no formal schema at all, horizontal scalability through clustering will be achieved

  • Delphi Study Influence of Environmental Sustainability Initiatives...

    Delphi Study: Influence of Environmental Sustainability Initiatives on Information Systems Table of Contents (first draft) Green IT Current Methods and Solutions Green IT and energy costs Green It and Email Systems Green IT and ICT Green IT and ESS Green IT and TPS Green IT and DSS Green IT and other support systems Green IT and GHG reduction Green IT and the Government Sector Green IT and the Corporate Sector Future Prospects of Green IT in the software industry The paper focuses on how the

Read Full Essay
Copyright 2016 . All Rights Reserved