What is OLAP? Explain its features
What will be an ideal response?
Online analytical processing (OLAP) is an important reporting application. It is more generic than RFM. OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data. The remarkable characteristic of OLAP reports is that they are dynamic. The viewer of the report can change the report's format, hence the term online. An OLAP report has measures and dimensions. A measure is the data item of interest. It is the item that is to be summed or averaged or otherwise processed in the OLAP report. Total sales, average sales, and average cost are examples of measures. A dimension is a characteristic of a measure. Purchase date, customer type, customer location, and sales region are all examples of dimensions. With an OLAP report, it is possible to drill down into the data. This term means to further divide the data into more detail.
You might also like to view...
Answer the following statements true (T) or false (F)
1. A green workplace is not important in retaining employees in a tight labour market. 2. Approximately 50% of corporations have environmentally friendly workplace policies. 3. Environmental issues have added complexity to supply chains. 122 4. The volume of garbage in Canada is growing faster than the Canadian population. 5. Corporate social responsibility measures do not apply to environmental sustainability reporting.
A client that treats a material lease transaction as an operating lease when it is in fact a capital lease has deviated from GAAP and will receive a qualified or adverse opinion
a. True b. False Indicate whether the statement is true or false
Which of the following is NOT an accurate statement about non-media connectors?
A) NMCs can be ordinary people. B) The Internet has spurred a rise in the number of NMCs. C) All NMCs are industry professionals or celebrities. D) NMCs spread a marketer's message voluntarily. E) NMCs drive consumer-generated marketing.
Alex has found that both commercial and residential real estate buyers respond positively to his marketing communication message. Alex has identified different ________ that respond similarly to his marketing efforts.
A. geodemographic segments B. self-concept customers C. market segments D. geographic segments E. mass customization consumers