Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 9, Problem 9.3UYK
Explanation of Solution
Query results do not show promise for selling of these part designs:
The sales analysis team created a query that connected the selected part with their past sales data, which is represented in a table called Sales history for selected parts.
It is observed that these query results do not show promise of selling these part designs.
This is mainly due to:
- There seems to be little revenue potential in selling designs for these parts.
- As the company will earn minimal revenue from the parts themselves, they can set the price of the 3-D designs considerably lower. It would be a problem, as it would generate almost no revenue...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Discuss the benefits of in-memory analytics in data warehousing and its impact on query performance.
Describe in your own words the basic elements of an analytics project strategy using pivot tables. What are important factors to consider when evaluating the results of a pivot table? Why is it important to understand the problem statement/objective before implementing a solution with pivot tables?
Which data model does not allow many-to-many relationships? Describe the model's benefits and drawbacks. What is a business rule and how does it relate to data modelling?
Chapter 9 Solutions
Using MIS (10th Edition)
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
- Using data from the "Past Events" worksheet, the "Input Analysis" component of the spreadsheet model computes the average number of attendees and sales for each product category.arrow_forward. According to a recent report by Gartner, most business users will have access to some sort of self-service BI tool within the next few years; however, Gartner estimates that less than 10 percent of companies will have sufficient data governance practices in place to prevent data inconsistencies across the organization. Why do you think so many companies continue to invest in new analytics tools without implementing governance programs that ensure data consistency?arrow_forwardHow can data validation techniques enhance the quality of processed data for analytics?arrow_forward
- In a Hadoop environment, there are many capabilities which allow for Hadoop to be integrated as an integral part of a warehouse/analytics ecosystem. There are both open source options and proprietary options for most. For each of the following tasks, list an open source and a proprietary option for accomplishing, if they exist. i. Dealing with data in motion within a Hadoop environmentj. Administration and Management of a Hadoop environmentarrow_forwardDatamining question: Why do we need to analysis the correlation between two attributes? And in which step of CRISP-DM should we do this analysis?arrow_forwardAccording to a recent Gartner report, most business users will have access to some sort of self-service BI tool within the next few years; however, Gartner estimates that only about 10% of companies will have adequate data governance practices in place to prevent data inconsistencies across the organization. Why do you believe so many businesses continue to invest in new analytics tools without putting in place data governance programs?arrow_forward
- However, Gartner expects that just 10% of firms will have appropriate data governance policies to avoid data discrepancies throughout the enterprise. Despite the fact that most company users will soon have self-service BI tools. Why do you think companies keep purchasing analytics tools without data governance programs?arrow_forwardDiscuss the concept of data cubes in data warehousing. How are they used for multidimensional analysis, and what benefits do they offer?arrow_forwardI tried to understand this question. it says: An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly? Can someone help me with this problem?arrow_forward
- Does your healthcare institution routinely use Microsoft Excel in at least three of its departments for the purposes of data collection and tabulation? If one is going to make an assertion, wouldn't it be better to have evidence to back up that claim?arrow_forwardConsider the data requirements of your institution or high school's student-run publication. In what ways does this company's data differ from other businesses? Make a list of all the things and explain what they do. After that, create a business data model that depicts these entities and their key connections.arrow_forwardDescribe the concept of data warehousing and its role in data modeling. What are some key considerations when designing a data warehouse schema for business intelligence and analytics?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning