Learning Goal: I’m working on a data engineering multi-part question and need an explanation and answer to help me learn.1. Design an appropriate dimensional model (in a graphical form) to support the business questions above. The granularity of the fact table(s) of the model should be at the level of the individual ATM transaction. Explain any assumptions made in your design. Provide a set of at least 2 sample rows of all table(s) of the proposed model. Where applicable, the rows you provide should use/include data from the operational data subset given to you.2. Design a second dimensional model (also in a graphical form) to support the business questions above. In the second model, the granularity of the fact table(s) should not be at the level of the individual ATM transaction. Moreover, the model should be optimal, in the sense that it should be at the appropriate granularity and include only the entities that are necessary in order to support the questions above. Therefore, you should not define a granularity or include other entities which are not required (marks may be deducted if you do so). Explicitly state the granularity of the fact table (or tables, if multiple) of your schema and include as many details as possible concerning the schemas’ attributes. Explain any assumptions made in your design. Provide a set of at least 2 sample rows of the fact tables of the proposed schema illustrating the respective data interrelationships. Where applicable, the rows you provide should use/include data from the operational data subset given to you.3. Design two suitable Cubes that show data corresponding to the following: ▪ Daily Number of Transactions, per card network type (Visa, Mastercard), per transaction type (withdrawal, deposit, etc.). ▪ Total Amounts of Daily Transactions per card type, per city, on Bank XYZ (“us”) terminals. Where applicable, the cubes should illustrate in their visible parts some corresponding data from the subset given to you (i.e. data for one day).4. Answer the following question: Apart from the identification of facts/measures, in order to be comprehensive on the proposed dimensional models, it is necessary to discuss and agree with the business stakeholders on at least one additional important aspect of the model. Identify this aspect and briefly explain its importance.
Requirements: As long as possible, i need a detailed explanation
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