Business Driven Technology
7th Edition
ISBN: 9781259567322
Author: Paige Baltzan Instructor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 6, Problem 2MBD
Explanation of Solution
Use of Access over Excel:
Limitations of Excel:
Some of the limitations of excel are mentioned below:
- Excel is limited in the amount of data it could store and analyze.
- Excel has inability to handle simultaneous access by two or more people.
- Excel has inability to deal with relational data tables.
- In Excel, memory and CPU usage can be cumbersome, especially in formulas that recalculate a large number of cells.
- Excel is not reusable and is not designed to handle its semi-structured and unstructured counterparts.
Benefit of Access:
Some of the benefits of access are:
- Access is quick and easy to create
database systems as it includes various wizards to speed up the process of creating a database application, and a vast array of readily available functionality. - Microsoft Access produces very user-friendly applications through its comprehensive
programming language called VBA...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Is it strange to you that a business as tiny as Sunny Delight could wind up with so many distinct analytics tools? How has the fact that Sunny Delight has changed ownership many times influenced the quantity and diversity of BI tools used? What are some of the drawbacks of migrating to an enterprise-level analytics system for individual end users who may have become used to dealing with their own bespoke data generation solutions? According to a recent Gartner report, most business users will have access to some type of self-service BI tool within the next few years; however, Gartner estimates that less than 10% of companies will have adequate data governance practices in place to prevent data inconsistencies across the organization. Why do you believe that so many businesses continue to invest in new analytics technologies while failing to establish governance processes that guarantee data consistency?
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
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
- Do you think it's odd that a tiny firm like Sunny Delight could have so many different analytics tools? How has the fact that Sunny Delight's ownership has changed several times influenced the quantity and type of BI tools used? What are some of the trade-offs for individual end users who have gotten accustomed to dealing with their own bespoke data generation systems while moving to an enterprise-level analytics solution? According 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 practises in place to prevent data inconsistencies across the organisation. Why do you believe so many businesses continue to invest in new analytics technologies without putting in place data governance programmes?arrow_forwardWhat makes an Excel spreadsheet's Excel table different from raw data?arrow_forwardIs it surprising that a small company such as Sunny Delight could end up with so many different analytics tools? How did Sunny Delight end up with so many analytics tools? What are the trade-offs of moving to an enterprise-level analytics solution for individual employees who may have grown accustomed to working with their own customized solutions for generating data? Gartner reported that most businesses will have access to some sort of self-service BI tool within the next few years. However Gartner estimated that less than 10% will have sufficient data governance practices in place to prevent data inconsistencies across the organization. Why do you think so many companies invest in BI solutions while ignoring governance programs to ensure data consistency?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_forwardIn today's business world, "big data" describes a feature of any company's IT infrastructure. What are the pros and cons of using it in one's career?arrow_forwardWhat shocked you about Sunny Delight's purchase of so many unique analytics tools is the company's small size. How can the fact that Sunny Delight's ownership has changed many times have an effect on the amount and variety of business intelligence (BI) solutions used?- What are some of the trade-offs involved with a migration to an enterprise-level analytics solution for individual end users who have become used to dealing with their own customized solutions for data generation?arrow_forward
- Is it surprising to you that a relatively small company like Sunny Delight could end up with so many different 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? 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? 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_forwardQuestion: Give suggestions and feedback to others on the elevator pitch as per below details. Tailor your elevator pitch to this job. In particular, a few areas to consider including are why do you want to get a job as a data scientist/why do you want to go into data science or change careers, why are you interested in the company or position. What skills and experiences do you bring to the position? Try to highlight what makes you uniquely valuable instead of using generalizations that anyone could say. Note: Highlighted one is question and remaining part is supporting materials only. Please need short answers in bullet points or in paragraph. We need short answers in 4/5/ sentences.arrow_forwardIf Excel is so great at organizing data, then why is Microsoft Access so much better?arrow_forward
- That's the main difference between BI and analytics, and it's what sets them apart.arrow_forward- Is it surprising to you that a relatively small company like Sunny Delight could end up with so many different 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? - 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?arrow_forwardRufla Bhd was founded in 2011, based in New York and Cambridge, Massachusetts. Rufla Bhd is a financial data platform designed for detailed fundamental research. The organization was created by former analysts and supported by a team of financial experts with serious credentials in Finance, Accounting, and Applied Mathematics. Mr Pranav and Mr Alex are the co-founders of Rufla Bhd where Mr Pranav is the CEO while Mr Alex is the CTO. Rufla helps analysts looking to go a level deeper become more productive and accurate in their financial analysis. With Rufla, analysts can systematically access all the data both in numbers and text in financial statements, including the details hidden within the footnotes. The main clients of Rufla Bhd are the equity analyst, corporate finance companies, auditors and academicians. In today’s world, information technology is important in our lives because it helps to deal with every day’s dynamic things. Technology offers various tools to boost…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 Learning
Management 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
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,