Project Deliverable 3 Database and Data Warehousing Design

Preview (4 of 13 Pages)

100%

Purchase to unlock

Loading page image...

Project Deliverable 3 Database and Data Warehousing DesignName:Instructor:Date of submission:As the Chief Information Officer (CIO) of a data collection company, you have been tasked withselecting a data warehouse vendor to enhance your company’s analytics operations. The company collectsa 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 thekeyrequirements for selecting a data warehousesolution. In your explanation, consider thefollowing aspects:oData integration across various systemsoThe need for advanced reporting and analyticsoKnowledge discovery and data miningoExecutive information systems and performance optimizationoData quality and cleansing process2.Database Schema and Design:Develop anEntity-Relationship (ER) diagramthat reflects theprimary entities and their relationships within the data warehouse. Include the following entitiesin your ER diagram:oPage, Visit, Client, Registered User, Payment, StatusCode, TimePeriodoEnsure that you define the primary and foreign keys for the entities and how they arelinked.oExplain theschemadesign for these tables.3.Data Flow Diagram:Create aData Flow Diagram (DFD)to represent how data flows throughthe system, starting from data collection through to its storage in the data warehouse. The DFDshould include the processes involved in data extraction, transformation, and loading (ETL), andhow data is ultimately made available for reporting and analysis.

Loading page image...

4.Challenges and Best Practices:In your report, outlinebest practices for data warehouseimplementation, including:oData acquisition and cleansing processesoMetadata design and managementoTraining requirements for staff on using the data warehouse and ensuring data privacyWord Count Requirement:2000-2500 words

Loading page image...

IntroductionThe 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 whenused in line with them, data warehouse turns out to be a huge help. Every moment, a single pagevisit generates thousands of records to be saved. Data may get outdated but it cannot be deletedas few months down the line, it will be used for analysis. This analysis generated futureprospects of business. And this analysis depends on-how the data is collected and howefficiently 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 ouranalytics operations.The Need for Data WarehousingA number of new concepts and tools have evolved and incorporated into a newtechnology called Data Warehousing. Simply put, A data warehouse is a storage facility to storeextremely large amount of information by an organization. Itis a relational database which isspecifically designed for query and analysis processing instead of transaction processing.It is awell-organized and well-structured and resourceful method of organizing, managing andreporting data which are otherwise non-uniform and scattered throughout the organization indifferent 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 containshistorical data which are derived from transactional data, but it can also include data from othersources as well. It helps an organization consolidate data from several sources by separatinganalysis workload from transactional workload. Additionally, a data warehouse environment

Preview Mode

This document has 13 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Notes CCNA

CCNA 200-301 Portable Command Guide 5th Edition 20

CCNA 200-301 Portable Command Guide 5th Edition 22

CCNA 200-301 Portable Command Guide 5th Edition 36

Foundations of Novell Networking Section 26

Modulo 7 DHCPv4

Build and troubleshooting Integration Challenge

Company

Explore

Study Tools