BUS5WB Agility of data warehouse developments

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:

  • Properly cited scholarly sources from assigned or outside reading and research.
  • No wordy, vague or poorly constructed sentences
  • Clearly written and structurally sound sentences, with no grammar, spelling and/or punctuation errors.
  • Assignments with proper syntax, which demonstrates mastery of the subject and with clear organization flow.
  • Strict adherence to requested citation styles (i.e. APA, MLA, HARVARD, CHICAGO/TURABIAN)
  • Proper page numbering, heading, spacing and margins.
  • Parenthetical citations are in the proper format, are properly punctuated and are used at appropriate points to document source material.
  • Plagiarism free guaranteed work.
  • Expert proofreading.

We use the following tools to crosscheck our assignments:

  • Turnitin
  • Grammarly



Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

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.

Money-back guarantee

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

Zero-plagiarism guarantee

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

Free-revision policy

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

Privacy policy

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

Fair-cooperation guarantee

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

Order your paper today and save 30% with the discount code HAPPY

Open chat
You can contact our live agent via WhatsApp! Via + 1 323 412 5597

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code HAPPY