Answer the following problems.

Section-A

problem1) Describe relationship between OLAP and data mining. What are some of the major categories of data mining technologies? describe at least three of them.

problem2) What is the function of reporting tool in Business Intelligence product?  Describe why scorecards and dashboards are viewed as a special category of reporting.

problem3) describe OLAP and compare it to OLTP. describe the main characteristics and benefits of OLAP.

problem4) describe the three steps of the ETL process. Why is the ETL process so significant for data warehousing efforts?

Section-B

problem5) 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