Evans, James R.
Business Analytics, Global Edition / James R Evans. - 3rd ed. - United Kingdom : Pearson Education Canada ; 2020. - 705 p.
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
9781292339047
Strategic planning
658.401
Business Analytics, Global Edition / James R Evans. - 3rd ed. - United Kingdom : Pearson Education Canada ; 2020. - 705 p.
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
9781292339047
Strategic planning
658.401