Skip to content
Solved Assignments

Project Deliverable 3 Database and Data Warehousing Design

Design principles for databases and data warehousing solutions.

Preview 4 of 13 pages

See the first 4 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Project Deliverable 3 Database and Data Warehousing Design Name: Instructor: Date of submission : As the Chief Information Officer (CIO) of a data collection company, you have been tasked with selecting a data warehouse vendor to enhance your company’s analytics operations. The company collects a vast amount of data from various sources such as page visits, user feedback, status codes, and more. This data is critical for future business analysis and decision - making. 1. Data Warehouse Requirements: Based on the company’s data needs, explain the key requirements for selecting a data warehouse solution. In your explanation, consider the following aspects: o Data integration across various systems o The need for advanced reporting and analytics o Knowledge discovery and data mining o Executive information systems and performance optimization o Data quality and cleansing process 2. Database Schema and Design: Develop an Entity - Relationship (ER) diagram that reflects the primary entities and their relationships within the data warehouse. Include the following entities in your ER diagram: o Page, Visit, Client, Registered User, Payment, StatusCode, TimePeriod o Ensure that you define the primary and foreign keys for the entities and how they are linked. o Explain the schema design for these tables. 3. Data Flow Diagram: Create a Data Flow Diagram (DFD) to represent how data flows through the system, starting from data collection through to its storage in the data warehouse. The DFD should include the processes involved in data extraction, transformation, and loading (ETL), and how data is ultimately made available for reporting and analysis.

  2. Page 2
  3. Page 3
    Read page 3 as text

    4. Challenges and Best Practices: In your report, outline best practices for data warehouse implementation , including: o Data acquisition and cleansing processes o Metadata design and management o Training requirements for staff on using the data warehouse and ensuring data privacy Word Count Requirement: 2000 - 2500 words

  4. Page 4
    Read page 4 as text

    Introduction The data collection company has a huge collection of data generally goes into terabytes. Data warehouse is the only option though not much structured like relational databases but when used in line with them, data warehouse turns out to be a huge help. Every moment, a single page visit generates thousands of records to be saved. Data may get outdated but it cannot be deleted as few months down the line, it will be used for analysis. This analysis generated future prospects of business. And this analysis depends on - how the data is collected and how efficiently it be arranged to give clear picture for analysis. Being a CIO of the company I had to look for data warehouse vendor which can enhance our analytics operations. The Need for Data Warehousing A number of new concepts and tools have evolved and incorporated into a new technology called Data Warehousing. Simply put, A data warehouse is a storage facility to store extremely large amount of information by an organization. It is a relational database which is specifically designed for query and analysis processing instead of transaction processing. It is a well - organized and well - structured and resourceful method of organizing, managing and reporting data which are otherwise non - unifor m and scattered throughout the organization in different systems. The prominent features of a data warehouse are that it enables recording, collecting and filtering of data to different systems at higher levels. Normally it contains historical data which are derived from transactional data, but it can also include data from other sources as well. It helps an organization consolidate data from several sources by separating analysis workload from transactional workload. Additionally, a data warehouse environm ent

9 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.