The second assignment focuses on the agility of data warehouse developments, redesigning an existing dimensional model, and the use SSDT tools and techniques to generate business insights. Your ability to correctly apply these tools to a business use case will be assessed.
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.
Task 2: Dimensional model redesign
Study the given dimensional model to determine what is lacking in response to the business need. Identify potential improvements to the dimensional model. This can be in the form of new attributes, new dimensions, new measures or the use of dimension design techniques. Present your recommendations with supporting evidence and the new dimensional model.
Task 3: Demonstration of Analysis Tools
The data warehouse (ValeurDW) is accessible from the WB server.
Use the knowledge and experience gained from tutorials 7-10, to demonstrate each of the seven analysis
technique/tool – 1) SSAS, 2) Cube Features, 3) SSRS, 4) MDX, 5) SSDT Data mining, 6) Excel Power Pivot, and 7) PowerBI, by conducting a comprehensive analysis of customer behaviours and thereby potential sales and marketing opportunities.
It is anticipated that you will demonstrate your proficiency with advanced analysis approaches rather than simple and straightforward querying. Each demonstration should lead towards an insight/recommendation of business value. A minimum of seven demonstrations is expected, preferably in increasing complexity and increasing decision value.
We confidently assure you high-quality work. We engage a number of strategies in to guarantee top-level assignments. The projects go through a thorough system of control prior to being submitted to the customers. Studentscoursework.com guarantees that the assignments delivered are 100 percent plagiarism-free.
We never share or resell customer’s work. Therefore, once it is checked using our plagiarism software, the assignment will be original. In terms of assignment completion, we adhere to the guidelines given by you and assign the work to the most suitable writer. We assign our writers based on various factors such as academic qualification, previous customer feedback, etc.
First and foremost, we provide high-quality work. However, in case you require extra-brilliance, here is what you can do. First, select a top writer who is proficient in a certain discipline. Second, you can seek our editing services.
Our team of editors revises the assignments, checking them to ensure they comply with the standards of academic writings. Additionally, editing may entail refining the language, adding more reference material, and making sure the formatting part is properly done. The editors may also enhance papers completed by yourself in to meet your needs.
We guarantee the following quality in our work to you:
We use the following tools to crosscheck our assignments:
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more