Answer & Explanation:see the question below
design_of_a_dimensional_model_schema.docx
Unformatted Attachment Preview
Design of a Dimensional Model Schema
• Provide correct measures by providing relevant sales ratios, attributes and dimensions in your
new Dimensional Model Diagram.
• Please provide an explanation for your design model.
• Provide the data dictionary for your transformation at the ETL layer
Query: Produce a query which can be executed in an Adhoc manner. Please provide explanation
to your query, regarding its execution and of the query you have written
Case study
Description of CEO’s Requirements: Sony wants to dominate the DSLR market. The companies’
executives are on an ambitious plan to revive sales of their brand. Traditionally Canon and Nikon
are the two serious competitors these brands have established themselves by selling proprietary
lenses which have a specific mount, for example Canon has a canon mount and Nikon has a
Nikon mount. In the current market 1 out of five cameras sold are Sony Dslr. The ceo wants
sales for the Sony brand sales ratio to be at least 4 out of every 5 cameras. After market analysis
by Sony the company found out that they could tap into this market by persuading Canon and
Nikon users to use their glass on a Sony DSLR. Provide correct measures by providing attributes
and dimensions in your new Dimensional schema. How do you think 4:5 (4 out of 5) sales target
could be achieved? The CEO wants to know the reason why people prefer brands. What do they
offer. If the customer chooses to buy any other brand including Sony, the ceo wants to know why
the customer chose to purchase that camera. The ceo also likes to know possitive feedback and
negative feedback from the customers, if it can be captured or modelled.
…
Purchase answer to see full
attachment
