EBK USING MIS
10th Edition
ISBN: 9780134658919
Author: KROENKE
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
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...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Compare and contrast the Wiig KM model with the SECI model. Explain how they work together to support your solution. If not, would you consider adding any of the models' missing parts? For each of your suggestions, what are the most likely roadblocks, and what steps would you take to get through them?
Please answer fast
1.The difference between forecasting and prediction. Please provide a forecasting problem statement and a predictive problem statement regarding sales for next week.
2. The difference between operational and analytical reporting. Please provide an example of an operational report and an analytical report based on her database of information.
3. The difference between KPIs and metrics. Please provide her with an example of a KPI and a metric related to her business.
Explaion some of the major differences between GDPR and CCPA. You don't have to list them all. Be clear about the one you do mention.
answer has to be under 31 words.
Chapter 9 Solutions
EBK USING MIS
Ch. 9.3 - Prob. 1EGDQCh. 9.3 - Prob. 2EGDQCh. 9.3 - Prob. 3EGDQCh. 9.3 - Prob. 4EGDQCh. 9.6 - Prob. 1BFSQCh. 9.6 - Prob. 2BFSQCh. 9.6 - Prob. 3BFSQCh. 9.6 - Prob. 4BFSQCh. 9.9 - Prob. 1SGDQCh. 9.9 - Prob. 2SGDQ
Ch. 9.9 - Prob. 3SGDQCh. 9.9 - Prob. 4SGDQCh. 9.9 - Prob. 5SGDQCh. 9.9 - Prob. 9.1ARQCh. 9.9 - Prob. 9.2ARQCh. 9.9 - Prob. 9.3ARQCh. 9.9 - Prob. 9.4ARQCh. 9.9 - Prob. 9.5ARQCh. 9.9 - Prob. 9.6ARQCh. 9.9 - Prob. 9.8ARQCh. 9.9 - Prob. 9.9ARQCh. 9 - Prob. 9.1UYKCh. 9 - Prob. 9.2UYKCh. 9 - Prob. 9.3UYKCh. 9 - Prob. 9.4UYKCh. 9 - Prob. 9.5UYKCh. 9 - Prob. 9.6UYKCh. 9 - Prob. 9.7UYKCh. 9 - Prob. 9.8UYKCh. 9 - Prob. 9.9CE9Ch. 9 - Prob. 9.1CE9Ch. 9 - Prob. 9.11CE9Ch. 9 - Prob. 9.12CE9Ch. 9 - Prob. 9.13CE9Ch. 9 - Prob. 9.14CE9Ch. 9 - Prob. 9.15CE9Ch. 9 - Prob. 9.16CS9Ch. 9 - Prob. 9.17CS9Ch. 9 - Prob. 9.18CS9Ch. 9 - Prob. 9.19CS9Ch. 9 - Prob. 9.22MML
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- 76644 An intern in a marketing research organization found out that there was a high correlation between the sale of newspapers and the rise in temperature. Thus, he concluded that rise in the temperature caused increase in sale of newspaper. Identify two mistakes that he made during this analysis. What would have been your next course of action if you found such a correlation? What is the term used to denote such a correlation? Which data analysis technique would you use to establish cause and effect relationship?arrow_forwardIdentify variables of interest, “gather” fake data, and perform a mock correlational analysis.arrow_forwardIn the ER-Model, what are the guidelines for determining how to identify and build relationships between entities?arrow_forward
- Trust and Identity in your vertical Take the use-case and data flow and identify the areas where Trust and Identity are important . write one question.arrow_forwardModeling Answer: New Quick New New measure measure column table 2 Figure 3. (c) Describe the function of icon 1 to 4 in Figure 3.arrow_forwardYou are working with a client as a Chief Technology Officer, and you have produced a graph to help your client understand how each of the investment accounts will behave over time. Write your client a report outlining an investment forecast and recommending in which type of account they should invest. In your report, to support your claims you should use comparisons of the data and an explanation of the chart trendlines on the next tab. Address whether the client is looking to invest short term (five years or less) or long term (longer than five years). Which of the chart types on the following Excel page, titled “Chart Types” will be most useful for supporting your recommendations? Why?arrow_forward
- Compare and contrast the SECI model and the Wiig KM model. Show how they all fit together to help your answer. If not, would you think about adding any of the missing parts to the models? What are the most likely problems with each of your ideas, and how would you work around them?arrow_forwardController for Model Views (MVC) How are you going to implement MVC in the stock exchange industry? Assumptions must be fully expressed.arrow_forwardThe difference between EDA and hypothesis testing, as well as why analysts might prefer EDA during data mining .arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Management Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning