Using MIS (9th Edition)
Using MIS (9th Edition)
9th Edition
ISBN: 9780134106786
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 9.9, Problem 9.4ARQ

Explanation of Solution

Five Basic Reporting Operations:

Reporting Application:

In order to produce Business Intelligence, a reporting application combines data from various sources and apply reporting operations to those data.

  • Reporting applies simple operations to reveal patterns in the data. The analysis of the data is modest.
  • Data are sorted and grouped, and simple totals and averages are calculated using operations such as reporting applications use of five basic operations:
    • Sorting – It arranges the data systematically as per requirement.
    • Filtering – It cleans the data by clearing the errors.
    • Grouping – It groups the data into data sets with a particular pattern.
    • Calculating – It performs all the required calculations to the data sets in order to extract knowledge.
    • Formatting- It formats all the calculated data in order to make the data ready for operational use.

Example of reporting:

The common examples of reporting is swimming, and totaling.

RFM analysis:

RFM stands for Recency, Frequency and Monetary. It is an analytical technique to determine which customers are best among all by checking recent purchase date (Recency), how often the customer purchases (frequency) and how much the customer spends (monetary).

A) Customers having a score of [5, 5, 5]

  • A customer in the following group has the highest points in recency, frequency and monetary. It shows that he or she is a loyal and very important customer and deserves highest level of service to reward his or her loyalty.

B) Customers having a score of [1, 5, 5]

  • A customer in the following group has the lowest points in recency, frequency and monetary and lies in the middle group. It shows that he or she is a loyal and very important customer and effort need to be made to find out the reasons for which he or she has not been a recent customer. Efforts need to be made to ask the customer for feedback for previous purchases and exclusive offer and combo deals for him or her can be send via email.

C) Customers having a score of [5, 5, 3]

  • A customer in the following group has best points in recency and best points in frequency and average points in monetary and lies in the next to top group. It shows that he or she is a loyal customer but likes to spend less. This type of customer is best for upselling and efforts should be made to have various lucrative combined deals and combined packages to entice him or her to buy higher value items...

Blurred answer
Students have asked these similar questions
D. S. Malik, Data Structures Using C++, 2nd Edition, 2010
Methods (Ch6) - Review 1. (The MyRoot method) Below is a manual implementation of the Math.sqrt() method in Java. There are two methods, method #1 which calculates the square root for positive integers, and method #2, which calculates the square root of positive doubles (also works for integers). public class SquareRoot { public static void main(String[] args) { } // implement a loop of your choice here // Method that calculates the square root of integer variables public static double myRoot(int number) { double root; root=number/2; double root old; do { root old root; root (root_old+number/root_old)/2; } while (Math.abs(root_old-root)>1.8E-6); return root; } // Method that calculates the square root of double variables public static double myRoot(double number) { double root; root number/2; double root_old; do { root old root; root (root_old+number/root_old)/2; while (Math.abs (root_old-root)>1.0E-6); return root; } } Program-it-Yourself: In the main method, create a program that…
I would like to know the main features about the following 3 key concepts:1. Backup Domain Controller (BDC)2. Access Control List (ACL)3. Dynamic Memory
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education