Skip to main content
Engineering LibreTexts

12.10: Summary

  • Page ID
    94984
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)

    ( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\id}{\mathrm{id}}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\kernel}{\mathrm{null}\,}\)

    \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\)

    \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\)

    \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    \( \newcommand{\vectorA}[1]{\vec{#1}}      % arrow\)

    \( \newcommand{\vectorAt}[1]{\vec{\text{#1}}}      % arrow\)

    \( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vectorC}[1]{\textbf{#1}} \)

    \( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)

    \( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)

    \( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)

    \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    Key Takeaways

    • Big data is voluminous and complex and difficult for systems to process and analyze.
    • Big data is categorized by the three V’s: Volume (size), Variety (# of data types), and Velocity (processing speed).
    • Decision makers should use a systematic process for making decisions.
    • An organization has a wide variety of decisions to make, ranging from highly structured decisions to unstructured decisions.
    • A decision support system (DSS) helps managers make decisions using interactive computer models that describe real-world processes. An  executive information system (EIS) is customized for an individual executive.
    • An expert system gives managers advice similar to what they would get from a human consultant.
    • Business intelligence describes the process that organizations take to collect and analyze data in the hopes of obtaining a competitive advantage. It is an organizational process as well as technology.
    • Data Science is the analysis of large data sets to find new knowledge, and data analytics looks at the past data to try and understand what happened and can also make predictions for the future.
    • Legacy systems often limit data utilization because they were not designed to share data, aren’t compatible with newer technologies, and aren’t aligned with the firm’s current business needs.
    • Most transactional databases aren’t set up to be simultaneously accessed for reporting and analysis. In order to run analytics the data must first be ported to a data warehouse or data mart.
    • There are many different ways to present data findings. Data visualization is the graphical representation of information and data.
    • A data warehouse is a set of databases designed to support decision making in an organization and a data mart is a database focused on addressing the concerns of a specific problem or business unit.
    • Data privacy is huge concern today, especially with the growth in the amount of digital data being created and stored.

    Review Questions

    1. What are the benefits and concerns of big data?
    2. What are some typical problems faced by businesses? Can these problems be helped by systems?
    3.  List and describe the phases of the decision making process.
    4. What is the difference between a structured, semi-structured, and unstructured decision?
    5. What is data analytics, and why are many companies using it?
    6. What is the difference between business intelligence, data analytics and data science?
    7. What are some of the tools used to convert data into information?
    8. What is the difference between  canned reports and ad hoc reporting?
    9. How do reports created by OLAP differ from most conventional reports?
    10. List the key areas where businesses are leveraging data mining.
    11. For data mining to work, what two critical data-related conditions must be present?
    12. List the three critical skills a competent business analytics team should possess.
    13. What is the difference between a data mart and data warehouse?

    Assignment

    Overview
    This assignment provides the opportunity to work with the pivot table function in Excel to summarize data for analysis.

    Assignment

    1. Go to the Intro to PivotTables tutorial on GCF LearnFree.org and download the practice workbook and work through the tutorial.
    2. How can the pivot table function be used to support decision making?
    3. What are some other questions that can be asked of this data?
    4. Create a visualization based on your question for the data.

    Share your findings and visualization with the class.

     

    Chapter 12 Attributions

    Business Computer Information Systems: 6.3 The Business Intelligence Toolkit by Emese Felvegi; Barbara Lave; Diane Shingledecker; Julie Romey; Noreen Brown; Mary Schatz; OpenStax; Saylor Academy; University of Minnesota Libraries; and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

    Information Systems – A Manager’s Guide to Harnessing Technology: 11.5 Data Warehouses and Data Marts and 11.4 Data Rich, Information Poor by Minnesota Libraries  is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

    Information Systems for Business and Beyond (2019)-Chapter 4 and Chapter 7 by David Bourgeois is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

    Information Systems: No Boundaries! Chapter 3 Data Analytics by Shane M Schartz is licensed under Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted

    Introduction to Business-6.8 Trends in Management and Leadership and 3.3 Management Information Systems by OpenStax – Rice University is licensed under Creative Commons Attribution 4.0 License

    Maritime Management: Micro and Small Businesses-Chapter 15 by Matthew Pauley is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

    Organizational Behavior 11.2 Understanding Decision Making is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

    Principles of Management – Chapter 2 Managerial Decision Making by OpenStax is licensed under Creative Commons Attribution 4.0 License

     


    12.10: Summary is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?