Answer the following questions.
Section-A
Question1) Describe relationship between OLAP and data mining. What are some of the major categories of data mining technologies? Explain at least three of them.
Question2) What is the function of reporting tool in Business Intelligence product? Describe why scorecards and dashboards are viewed as a special category of reporting.
Question3) Explain OLAP and compare it to OLTP. Explain the main characteristics and benefits of OLAP.
Question4) Explain the three steps of the ETL process. Why is the ETL process so significant for data warehousing efforts?
Section-B
Question5) As a Business Intelligence solution expert how would you convince a manufacturing organization to implement BI solution? Further create a plan for implementing BI solution for the same