Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 11, Problem 11.29PAE
Program Plan Intro
The use of SAS Visual Analytics tool.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Predictive modeling:
Task: Ambulance Demand
Data Generating Process: for New York City
Dates of Coverage {Please identify the specific dates that will be used for this dataset in your modeling effort other than the City Health Department's Emergency Medical Services Division.
}
Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?}
Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police}
Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?}
Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.}
Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.}
Data…
You were shocked to see that Sunny Delight is a pretty small company given the number of unique analytics tools it has acquired. What potential effects may the many ownership changes at Sunny Delight have had on the kind and amount of business intelligence (BI) solutions used?- What are some of the trade-offs involved with a switch to an enterprise-level analytics solution for individual end users who are used to dealing with their own customized solutions for producing data?
If your future boss asks you to combine Power BI and Google Analytics together for use on an IT project, you would say:
Question 48 options:
a)
Google Analytics was created by Google Inc, while Power BI was created by Microsoft Inc, and there have inherent incompatibilities which would make such an implementation difficult
b)
Power BI would be excellent at importing and displaying data collected from Google Analytics, but not necessarily the reverse.
c)
Power BI would best be avoided at all costs since it only works on PC products, while Google Analytics is compatible with all sorts of hardware and software.
d)
Google Analytics would be best linking with XL spreadsheets of business sales data, and not to the cloud services available thru Power BI
Chapter 11 Solutions
Modern Database Management
Ch. 11 - Prob. 11.1RQCh. 11 - Prob. 11.2RQCh. 11 - Prob. 11.3RQCh. 11 - Prob. 11.4RQCh. 11 - Prob. 11.5RQCh. 11 - Prob. 11.6RQCh. 11 - Prob. 11.7RQCh. 11 - Prob. 11.8RQCh. 11 - Prob. 11.9RQCh. 11 - Prob. 11.10RQ
Ch. 11 - Prob. 11.11RQCh. 11 - Prob. 11.12RQCh. 11 - Prob. 11.13RQCh. 11 - Prob. 11.14RQCh. 11 - Prob. 11.15RQCh. 11 - Prob. 11.16RQCh. 11 - Describe the core idea underlying in-database...Ch. 11 - Prob. 11.18RQCh. 11 - Prob. 11.19RQCh. 11 - Prob. 11.20PAECh. 11 - Prob. 11.21PAECh. 11 - Prob. 11.22PAECh. 11 - Prob. 11.23PAECh. 11 - Prob. 11.24PAECh. 11 - Prob. 11.25PAECh. 11 - Prob. 11.26PAECh. 11 - Prob. 11.27PAECh. 11 - Problems and Exercises 11-22 through 11-28 are...Ch. 11 - Prob. 11.29PAECh. 11 - Prob. 11.30PAE
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
- 1. Is it surprising to you that a relatively small company like Sunny Delight could end up with so many differ-ent analytics tools? How might the fact that Sunny Delight has changed ownership multiple times have impacted the number and variety of BI tools being used? 2. What are some of the trade-offs of a move to an enterprise-level analytics solution for individual end users who might have grown accustomed to working with their own customized solutions for generating data? 3. According to a recent report by Gartner, most busi-ness 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 com-panies 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_forwardPredictive modeling: Task: Ambulance Demand Data Generating Process: NYC FDNY Emergency Medical Services Ambulance Calls data Asnwer the questions based on the NYC FDNY Emergency Medical Services Ambulance Call data? Dates of Coverage { NYC FDNY Emergency Medical Services Ambulance Calls data } Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?} Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police} Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?} Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.} Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.}…arrow_forwardHowever, only approximately 10% of firms will have effective data governance practises in place to avoid data discrepancies throughout the organisation, as predicted by Gartner. Despite the fact that self-service BI tools will become widely available to business users in the next years, this is still the case. Despite the importance of maintaining consistent data, why do you think firms continue to invest in analytics tools without also purchasing governance programmes?arrow_forward
- Discuss the concept of IoT edge analytics and its significance in real-time data processing. Provide a case study demonstrating its benefits.arrow_forwardWhen implementing a self-service analytics program, information systems staff and end users across an organization often must be willing to give up some control and autonomy in exchange for a cohesive data management strategy. Companies that effectively implement self-service analytics, however, usually find those trade-offs are outweighed by the competitive advantages gained for the organization as a whole. For Sunny Delight Beverages, a Cincinnati-based producer of juice-based drinks, the payoff from using selfservice analytics software has been significant. The company, which generates more than $550 million in annual revenue through sales of its SunnyD, Fruit20, and VeryFine brands, estimates that its newly implemented, self-service analytics program has resulted in a $195,000 annual reduction in staffing costs and a $2 million annual increase in profits. Getting to these results, however, has not been easy for Sunny Delight. Like many companies, it had developed a patchwork of…arrow_forwardI am conducting a reasearch project about the following reaserch question: "Can the use of big data and predictive analytics help real estate investors and developers identify promising investment opportunities and mitigate risks better than standard data?" I will focus my research on the specific applications predictive analytics such as property valuation and risk management. The potential variables I am considering on using to measure this are things like, Property condition: The condition of a property can affect its value and level of risk. Variables such as age of the property, maintenance and repair history, and structural integrity can be used to assess the condition of a property. Market trends: Market trends such as supply and demand, vacancy rates, and rent trends can be used to assess the value and level of risk of a property. Financing terms: The financing terms of a property, including interest rates and loan terms, can affect its value and level of risk. Economic…arrow_forward
- Predictive modeling: Task: Ambulance Demand Data Generating Process: NYC FDNY Emergency Medical Services Ambulance Calls data Dates of Coverage { NYC FDNY Emergency Medical Services Ambulance Calls data } Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?} Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police} Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?} Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.} Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.} Data Collector{Who collects the data? A dispatcher? A Census taker?} Triggering…arrow_forwardThe huge amount of data sets from Covid-19 such as number of cases, number of repeated cases, travel history, symptoms, severity of cases, and others, can be used to develop applications to manage Covid-19 pandemic. Provide One (1) application that uses big data technology to manage Covid-19, besides the one stated in the diagram above. Your explanation must include the following and must be in detail. Application and target group Data source (example: social media, surveillance system) used for the application Impact of the applicationarrow_forwardDescribe the concept of IoT data analytics and its role in extracting valuable insights from massive IoT data streams.arrow_forward
- Write a one-page project proposal for big data analytics on the Google Cloud Platform. Be specific on which dataset you are going to work on and what is the purpose of the project. Forexample, I will do analysis on Cyber data. I should be specific on whichaspect of the Cyber dataset I will explore and what I want to know about the dataset. The proposalshould be novel. That is, I cannot propose something that has already been done or somethingavailable in public domain. Show the source of the data and how you are going to obtain the data. You don’t need to be specific on which GCP services or tools to use. However, you can still mentionseveral options to choose from cheaper GCP services or tools to use.arrow_forwardPredictive modeling: Task: Ambulance Demand using data collected by the NYC Traffic Data Data Generating Process: Using the service data: The data is collected by the "NYC FDNY Emergency Medical Services Ambulance calls data” to answer the questions: Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?} Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police} Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?} Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.} Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.} Data Collector{Who collects the data? A…arrow_forwardAnalyze the ethical and legal considerations in Big Data analytics, particularly regarding data privacy, bias, and compliance with regulations like GDPR and HIPAA.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningManagement Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,