TY - BOOK AU - Evans, James R. TI - Business Analytics, Global Edition SN - 9781292339047 U1 - 658.401 23 PY - 2020/// CY - United Kingdom PB - Pearson Education Canada KW - OCLC KW - Strategic planning N1 - Table of contents : Cover -- Half Title Page -- Title Page -- Copyright Page -- Brief Contents -- Contents -- Preface -- About the Author -- Credits -- Part 1: Foundations of Business Analytics -- Chapter 1: Introduction to Business Analytics -- Learning Objectives -- What Is Business Analytics? -- Using Business Analytics -- Impacts and Challenges -- Evolution of Business Analytics -- Analytic Foundations -- Modern Business Analytics -- Software Support and Spreadsheet Technology -- Analytics in Practice: Social Media Analytics -- Descriptive, Predictive, and Prescriptive Analytics Analytics in Practice: Analytics in the Home Lending and Mortgage Industry -- Data for Business Analytics -- Big Data -- Data Reliability and Validity -- Models in Business Analytics -- Descriptive Models -- Predictive Models -- Prescriptive Models -- Model Assumptions -- Uncertainty and Risk -- Problem Solving with Analytics -- Recognizing a Problem -- Defining the Problem -- Structuring the Problem -- Analyzing the Problem -- Interpreting Results and Making a Decision -- Implementing the Solution -- Analytics in Practice: Developing Effective Analytical Tools at Hewlett-Packard -- Key Terms Chapter 1 Technology Help -- Problems and Exercises -- Case: Performance Lawn Equipment -- Appendix A1: Basic Excel Skills -- Excel Formulas and Addressing -- Copying Formulas -- Useful Excel Tips -- Excel Functions -- Basic Excel Functions -- Functions for Specific Applications -- Insert Function -- Date and Time Functions -- Miscellaneous Excel Functions and Tools -- Range Names -- VALUE Function -- Paste Special -- Concatenation -- Error Values -- Problems and Exercises -- Chapter 2: Database Analytics -- Learning Objectives -- Data Sets and Databases -- Using Range Names in Databases Analytics in Practice: Using Big Data to Monitor Water Usage in Cary, North Carolina -- Data Queries: Tables, Sorting, and Filtering -- Sorting Data in Excel -- Pareto Analysis -- Filtering Data -- Database Functions -- Analytics in Practice: Discovering the Value of Database Analytics at Allders International -- Logical Functions -- Lookup Functions for Database Queries -- Excel Template Design -- Data Validation Tools -- Form Controls -- PivotTables -- PivotTable Customization -- Slicers -- Key Terms -- Chapter 2 Technology Help -- Problems and Exercises -- Case: People's Choice Bank Case: Drout Advertising Research Project -- Part 2: Descriptive Analytics -- Chapter 3: Data Visualization -- Learning Objectives -- The Value of Data Visualization -- Tools and Software for Data Visualization -- Analytics in Practice: Data Visualization for the New York City Police Department's Domain Awareness System -- Creating Charts in Microsoft Excel -- Column and Bar Charts -- Data Label and Data Table Chart Options -- Line Charts -- Pie Charts -- Area Charts -- Scatter Charts and Orbit Charts -- Bubble Charts -- Combination Charts -- Radar Charts -- Stock Charts -- Charts from PivotTables UR - http://classify.oclc.org/classify2/ClassifyDemo?owi=1088329440 ER -