Implementation of Data Warehouses

profilebanhkeovn
July19.pdf

Use the weekly reading as background information and then conduct a comprehensive literature search. It is important to keep in mind that there are very specific components that must be considered in the construction of a DW including:

• Data sourcing • Data conversion and extraction • Database management system • Administration • Intelligence tools • Metadata techniques

Identify three components and determine two or three efficient approaches to implementing the selected three components. For each component, you should provide at least two scholarly, peer-reviewed works that provide sufficient background for supporting your implementation view. Length: 4-5 pages, not including title and reference pages (APA) References: 6 scholarly references Readings: - Agile Data. (2013). A Disciplined Agile Approach to Data Warehousing (DW)/Business Intelligence (BI) Projects. (http://www.agiledata.org/essays/dataWarehousingBestPractices.html) - Kimball Group. (2016). Business intelligence and data warehouse articles. (https://www.kimballgroup.com/category/business-intelligence-and-data-warehouse- articles/) - AzureCAT. (2013, September 16). Top 10 best practices for building a large scale relational data warehouse (https://docs.microsoft.com/en-us/archive/blogs/sqlcat/top-10- best-practices-for-building-a-large-scale-relational-data-warehouse)