Conduct a critical evaluation of the dimensional models that you designed in assignment 01 to...
Task 1: Agile data warehouse development approach
Conduct a critical evaluation of the dimensional models that you designed in assignment 01 to formulate
an agile development approach for the corresponding data warehouses. The lecture on data warehouse
lifecycle provides a basis for this formulation but you are required to reference external reading on agile
and cloud data warehouse solutions (preferably Azure) to determine the critical components that will
address the business needs with agile delivery.
The following business case applies to Tasks 2 and 3: The CIO of Valeur, a large national
supermarket/retail store chain has recently introduced a loyalty card program and keen to gain a more
comprehensive understanding of the organisation’s customer base through traditional transactional data
as well as the newer and effective demographic analysis techniques. The customer relationship
management (CRM) team working under her supervision have already put together a summarised data
warehouse containing some transaction data and customer demographics. Although the data is accurate
and complete, the CIO believes the structure is not. She feels there’s more information that can be
captured by the warehouse. She has two main business problems in mind. Firstly, improving the current
dimensional model/ warehouse to capture all relevant information that applies to customers, such as
demographics. Secondly, using current data in the warehouse to better understand the customer base by
identifying customer behaviours and thereby potential sales and marketing opportunities.