Question:
(a) Explain what is meant by Dimensional Modeling as used in Business Intelligence (BI) solutions.
(b) There has been a request from the Managing Director of an Insurance company to analyze loans information by product, city, time, branch and loan officer.
(i) Identify the fact table and draw a sample star schema diagram that would allow the director to analyze the information.
(ii) Using the above example, distinguish between business meta data and technical meta data. Illustrate your answer in a table and column created.
(c) What are the benefits of using BI Dashboards?