Include Index.

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