Question

Q1/ Differentiate between Descriptive and Prescriptive analytics.

Q2/ What is Data Mart? Differentiate between dependent data mart and independent data mart.

Answer 1

Solution:

The difference between Descriptive and prescriptive Analysis are as follows Descriptive Analysis Prescriptive Analvsis Analysis is done on the previous data, that is, Analysis is to find the possibility or chances to what ha earler resolve somethin It uses data mining and data aggregation on It uses optimization and simulation algorithm revious data It is a summary of the raw data. to get possible outcomes It provides reason for happening or mishappening as well as solution for a problem It is the newest form of analytics It is the oldest form of analvtics It is helpful to understand future outcomes. It is helpful in supply chain industry to better manage the things Data mart is the part of data ware house. It only focusses on single functional area such as marketing etc It is the subject-oriented database in which the single department of the organization deals with the information related to the single field of the data. It has limited size and scope as compare to data warehouse The benefits of data mart are same as data warehouse . * The difference between dependent data mart and independent data mart are as follows Dependent Data Mart Independent Data Mart It receives data from the central data It is stand-alone data mart warehouse It is a top down approach, data from data ware It does not depend on any organization house come to data Mart It increases security and performance of an Data is built in very short time and cost organization. effective. Example HR department