EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter A3, Problem 5PE
Use PivotCharts to create a useful dashboard for the data in the Excel file President’s Inn Guest Database. Explain why you chose the elements of the dashboard and how a manager might use them.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Netflix decided to distribute the show "Orange is the New Black". This decision was because the show 'Weeds', performed very well on Netflix in terms of viewership and engagement. Both shows have the same writers/creative teams. Data shows that viewers enjoy shows by the same writers/creative teams.
This is an example of Netflix relying upon which type of data analytics
Question 4 options:
a)
Descriptive
b)
Diagnostic
c)
Predictive
d)
Prescriptive
As a small business owner, Emil understands the importance of sales forecasting to entrepreneurial success. Which of the following is correct regarding a sales forecast? Organizations rely on correlation analyses as their exclusive sales forecasting method. It is an estimate of the amount of a product that an organization expects to sell during a certain period of time. The accuracy of a sales forecast is not important. It is based on an unspecified level of marketing effort. 4
You manager gave you February 2021 actual sales and sales forecast. This is the only raw data you have access to.
Which of the following is the most appropriate technique for forecasting March 2021's sales?
a.Simple moving average
b.Exponential smoothing
c.Causal relationship forecasting
d.Simple linear regression
e.Weighted moving average
Chapter A3 Solutions
EBK BUSINESS ANALYTICS
Ch. A3 - Create a treemap for the regions, items, and units...Ch. A3 - Create a sunburst chart for the regions, items,...Ch. A3 - Use PivotTables to find the number of loans by...Ch. A3 - Use PivotCharts to create a useful dashboard for...Ch. A3 - Prob. 6PECh. A3 - Use PivotCharts to create a useful dashboard for...Ch. A3 - Prob. 9PE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- How does predictive analytics benefit CRM? Give examples of predictive analytics models used in CRM for sales forecasting or customer churn prediction.arrow_forwardAssume that Young Corporation is introducing a new heartburn relief medication as an over the counter treatment. Young's marketing team used data to determine how to meet the minimum sales goals. The team determined that switching to an online marketing plan would be the best to maximize sales. This is an example of using Question 8 options: a) descriptive analytics b) diagnostic analytics c) predictive analytics d) prescriptive analyticsarrow_forward1) Define CRM and SCM systems by describing their characteristics and components, explain each of the two main types of data analytics that exist – descriptive and predictive – including how each works. Critically evaluate how, and for which purposes, data analytics can be applied in conjunction with CRM and SCM systems. Refer to concepts learned in class and use examples to illustrate your arguments.arrow_forward
- If Mr. Ishaq is the Director of Lexus Company in Nizwa, what does he need to do to predict customer sales or product demand? a. Forecasting b. Marketing c. Production d. Coordinationarrow_forwardwhat are the benefits of running a markerting analysis?arrow_forwardWhich type of analytics is used to know the effect of product price on sales. OA) predictive OB) forecast C) prescriptive D) descriptivearrow_forward
- What type of analytics seeks to recognize what is going on as well as the likely forecast and make decisions to achieve the best performance possible? domain predictive prescriptive descriptive What does the robustness of a data mining method refer to? its ability to construct a prediction model efficiently given a large amount of data its speed of computation and computational costs in using the mode its ability to overcome noisy data to make somewhat accurate predictions its ability to predict the outcome of a previously unknown data set accuratelyarrow_forwardBusiness analytics can be of three types: descriptive, predictive, and prescriptive. Describe each of those. Imagine you are a data analyst in FedRetail, an online retail shop. Your manager wants a forecast of the sell in the upcoming Christmas season. What kind of analysis you should do to find out your manager's query? Explain.arrow_forwardK Display the data to the right in a Pareto chart. Describe the difference in how the pie chart and the Pareto chart show patterns in the data. www. Choose the correct bar graph below. OA. Favorte Season hu B. Favorite Season 50₂ C. (b) Describe the difference in how the pie chart and the Pareto chart show patterns in the data. Choose the comect answer below OA. The pie chart shows the individual responses. The Pareto chart shows the distribution of the seasons. B. The pie chart shows the percentages as parts of the whole. The Pareto chart shows the rankings of the seasons Favorite Season OD. Summer 37 Fall 22% Spring 24% Winter 17% Favorite Seasonarrow_forward
- MIS provides a variety of information products to managers. Discuss the major reporting alternatives provided by MIS to assist managers in better decision making. Illustrate your answer with examplesarrow_forwardPrompt 1: In the healthcare industry, everything is measured. From drip rates to dosages, it seems as though numbers are everywhere. But how does this reflect the care given to the patients? Which type of data (qualitative or quantitative) do you think yields the most information? Why? Which type of data (qualitative or quantitative) is most effective for forecasting future trends? Why? Which practices can a healthcare manager use to ensure that the data used for forecasting trends is accurate? Provide examples of data evaluation in different types of facilities. Provide examples of data evaluation for different types of issues, such as billing or loss of revenue.arrow_forwardContrast the planning approach when dealing with data certainty verses uncertaintyarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage Learning
Accounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Matrix Operations Full Length; Author: ProfRobBob;https://www.youtube.com/watch?v=K5BLNZw7UeU;License: Standard YouTube License, CC-BY
Intro to Matrices; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=yRwQ7A6jVLk;License: Standard YouTube License, CC-BY