فهرست مطالب
Cover
Title
Copyright
Dedication
Contents
Preface
Chapter 1 Shaping and Cleaning Data
Analysis Case 1.1 – Shaping the Data File
Analysis Case 1.2 – Cleaning the Data File
Chapter 2 Installing the Analysis Toolpak
Analysis Case 2.1 – Excel Analysis ToolPak
Installation and Activation
Chapter 3 Descriptive Statistics
Analysis Case 3.1 – Descriptive Statistics
Five-Point Summaries
Analysis Case 3.2 – Additional Analysis Case Using the ORDERS File
Analysis Case 3.3 – Descriptive Statistics
Tabulation and Pivot Tables
Analysis Case 3.4 – Additional Case Using Titanic Data
Analysis Case 3.5 – Additional Case Using SFO Airport Survey Data
Chapter 4 Histograms
Analysis Case 4.1 – Histograms
Frequency Distributions
Analysis Case 4.2 – Additional Case Using Titanic Data
Chapter 5 Pareto Analysis
Analysis Case 5.1 – Pareto Analysis
Which Are the Most Important?
Analysis Case 5.2 – Additional Case Using MOVIES Data
Analysis Case 5.3 – Additional Case Using ORDERS
Analysis Case 5.4 – Additional Case Using SFO Airport Survey Data
Chapter 6 Scatter Plots
Analysis Case 6.1 – Scatter Plots and 2x2 Analysis
Which Are the “Best”?
Analysis Case 6.2 – Additional Case Using World Bank Data
Analysis Case 6.3 – Additional Case Using SFO Airport Survey Data
Chapter 7 Correlation and Linear Regression
Analysis Case 7.1 – Correlation and Linear Regression
How Are the Variables Related?
Analysis Case 7.2 – Additional Case Using ORDERS
Analysis Case 7.3 – Additional Case Using SFO Airport Survey Data
Chapter 8 Multivariate Regression
Analysis Case 8.1 – Multivariate Regression
Predictive Modeling
Analysis Case 8.2 – Additional Case Using SFO Airport Survey Data
Chapter 9 Forecasting and Time Series
Analysis Case 9.1 – Forecasting and Time Series
Predicting Trends and Future Values
Analysis Case 9.2 – Additional Case Using ORDERS
Analysis Case 9.3 – Additional Case Using MOVIES
Analysis Case 9.4 – Additional Forecasting Case Study
Chapter 10 Inferential Statistics
Analysis Case 10.1 – Assurance of Results
Inferential Statistics
Analysis Case 10.2 – Additional Case Using FOOTBALLTRIALS
Analysis Case 10.3 – Additional Exercise Using SFO Airport Survey Data
Chapter 11 Contingency Analysis
Analysis Case 11.1 – Contingency Analysis and Chi-Squared
Test of Variable Independence
Analysis Case 11.2 – Additional Case Using SFO Airport Survey Data
Chapter 12 A/B Testing
Analysis Case 12.1 – Design and Analysis of Trials
A/B Testing
Analysis Case 12.2 – Additional Case Using ORDERS
Analysis Case 12.3 – Additional Case Using SFO Airport Survey Data
Analysis Case 12.4 – Additional Analysis Cases Using Titanic Data
Chapter 13 Text Analytics
Analysis Case 13.1 – Unstructured Text Analysis I
Analysis Case 13.2 – Unstructured Text Analysis II
Using Excel for Sentiment Analysis
Chapter 14 Analyzing Big Data Sets
Analysis Case 14.1 – Big Data Analysis
Using Sampling to Work with Large Data Files
Analysis Case 14.2 – Additional Case Using the BankComplaints Big Data File
Chapter 15 Data Visualization
The Case
The Analysis Template
Analysis Case 15.1 – Story
Create a Visual Story − Is the point of the visual very clear?
Make It a Prop − Has the visual has been simplified and focused?
Emulate Legendary Storytellers − Are past masters and the basic charts that they pioneered emulated?
Case Analysis
Analysis Case 15.2 – Signs
Give Them a Sign − Is the use of signs and symbols appropriate?
It’s Like a Communication System − Is the signal-to-noise ratio high?
Design for Function − Is the chart functionally informational rather than beautiful art?
Case Analysis
Analysis Case 15.3 – Purpose
Consider the Information Need – Does the chart fulfill organizational information needs?
Consider the Audience – Does the chart allow for audience biases, needs, and journeys?
Answer Well-Framed Analytical Questions – Does the visual answer a well-framed analytical question?
Case Analysis
Analysis Case 15.4 – Perception
Use the Eye-Brain System of Seeing – Does the eye of the viewer focus on the most important point being made?
Employ the Gestalt Principles of Perception – Have the principles of the Gestalt psychology of perception been thoughtfully employed in the visual?
Design with Quality – Does the visual inform the viewer and dispel his ignorance?
Case Analysis
Analysis Case 15.5 – Method
Use Color Effectively – Is color used judiciously and sparsely?
Remove All Chart Junk – Is the visual is clear of unnecessary visual elements not leading to a clear point being made?
Tell the Story with the Title – Does the title of the chart convey the point being made with the chart?
Case Analysis
Analysis Case 15.6 – Charts
Use the Right Chart – Does the type of chart being used match the level of judgment required?
Select the Chart Type Effectively – Does the chart type used match the business question being answered?
Enhance Table Data for Emphasis – Are referenceable visuals (tables) readable with appropriate conditional formatting and thumbnail graphs used for emphasis?
Case Analysis
Analysis Case 15.7 – Putting It All Together
A Possible Solution
Chapter 16 Summary of Analysis Techniques
Business Questions and Analysis Techniques for Addressing Them
Data Sources
Index
Title
Copyright
Dedication
Contents
Preface
Chapter 1 Shaping and Cleaning Data
Analysis Case 1.1 – Shaping the Data File
Analysis Case 1.2 – Cleaning the Data File
Chapter 2 Installing the Analysis Toolpak
Analysis Case 2.1 – Excel Analysis ToolPak
Installation and Activation
Chapter 3 Descriptive Statistics
Analysis Case 3.1 – Descriptive Statistics
Five-Point Summaries
Analysis Case 3.2 – Additional Analysis Case Using the ORDERS File
Analysis Case 3.3 – Descriptive Statistics
Tabulation and Pivot Tables
Analysis Case 3.4 – Additional Case Using Titanic Data
Analysis Case 3.5 – Additional Case Using SFO Airport Survey Data
Chapter 4 Histograms
Analysis Case 4.1 – Histograms
Frequency Distributions
Analysis Case 4.2 – Additional Case Using Titanic Data
Chapter 5 Pareto Analysis
Analysis Case 5.1 – Pareto Analysis
Which Are the Most Important?
Analysis Case 5.2 – Additional Case Using MOVIES Data
Analysis Case 5.3 – Additional Case Using ORDERS
Analysis Case 5.4 – Additional Case Using SFO Airport Survey Data
Chapter 6 Scatter Plots
Analysis Case 6.1 – Scatter Plots and 2x2 Analysis
Which Are the “Best”?
Analysis Case 6.2 – Additional Case Using World Bank Data
Analysis Case 6.3 – Additional Case Using SFO Airport Survey Data
Chapter 7 Correlation and Linear Regression
Analysis Case 7.1 – Correlation and Linear Regression
How Are the Variables Related?
Analysis Case 7.2 – Additional Case Using ORDERS
Analysis Case 7.3 – Additional Case Using SFO Airport Survey Data
Chapter 8 Multivariate Regression
Analysis Case 8.1 – Multivariate Regression
Predictive Modeling
Analysis Case 8.2 – Additional Case Using SFO Airport Survey Data
Chapter 9 Forecasting and Time Series
Analysis Case 9.1 – Forecasting and Time Series
Predicting Trends and Future Values
Analysis Case 9.2 – Additional Case Using ORDERS
Analysis Case 9.3 – Additional Case Using MOVIES
Analysis Case 9.4 – Additional Forecasting Case Study
Chapter 10 Inferential Statistics
Analysis Case 10.1 – Assurance of Results
Inferential Statistics
Analysis Case 10.2 – Additional Case Using FOOTBALLTRIALS
Analysis Case 10.3 – Additional Exercise Using SFO Airport Survey Data
Chapter 11 Contingency Analysis
Analysis Case 11.1 – Contingency Analysis and Chi-Squared
Test of Variable Independence
Analysis Case 11.2 – Additional Case Using SFO Airport Survey Data
Chapter 12 A/B Testing
Analysis Case 12.1 – Design and Analysis of Trials
A/B Testing
Analysis Case 12.2 – Additional Case Using ORDERS
Analysis Case 12.3 – Additional Case Using SFO Airport Survey Data
Analysis Case 12.4 – Additional Analysis Cases Using Titanic Data
Chapter 13 Text Analytics
Analysis Case 13.1 – Unstructured Text Analysis I
Analysis Case 13.2 – Unstructured Text Analysis II
Using Excel for Sentiment Analysis
Chapter 14 Analyzing Big Data Sets
Analysis Case 14.1 – Big Data Analysis
Using Sampling to Work with Large Data Files
Analysis Case 14.2 – Additional Case Using the BankComplaints Big Data File
Chapter 15 Data Visualization
The Case
The Analysis Template
Analysis Case 15.1 – Story
Create a Visual Story − Is the point of the visual very clear?
Make It a Prop − Has the visual has been simplified and focused?
Emulate Legendary Storytellers − Are past masters and the basic charts that they pioneered emulated?
Case Analysis
Analysis Case 15.2 – Signs
Give Them a Sign − Is the use of signs and symbols appropriate?
It’s Like a Communication System − Is the signal-to-noise ratio high?
Design for Function − Is the chart functionally informational rather than beautiful art?
Case Analysis
Analysis Case 15.3 – Purpose
Consider the Information Need – Does the chart fulfill organizational information needs?
Consider the Audience – Does the chart allow for audience biases, needs, and journeys?
Answer Well-Framed Analytical Questions – Does the visual answer a well-framed analytical question?
Case Analysis
Analysis Case 15.4 – Perception
Use the Eye-Brain System of Seeing – Does the eye of the viewer focus on the most important point being made?
Employ the Gestalt Principles of Perception – Have the principles of the Gestalt psychology of perception been thoughtfully employed in the visual?
Design with Quality – Does the visual inform the viewer and dispel his ignorance?
Case Analysis
Analysis Case 15.5 – Method
Use Color Effectively – Is color used judiciously and sparsely?
Remove All Chart Junk – Is the visual is clear of unnecessary visual elements not leading to a clear point being made?
Tell the Story with the Title – Does the title of the chart convey the point being made with the chart?
Case Analysis
Analysis Case 15.6 – Charts
Use the Right Chart – Does the type of chart being used match the level of judgment required?
Select the Chart Type Effectively – Does the chart type used match the business question being answered?
Enhance Table Data for Emphasis – Are referenceable visuals (tables) readable with appropriate conditional formatting and thumbnail graphs used for emphasis?
Case Analysis
Analysis Case 15.7 – Putting It All Together
A Possible Solution
Chapter 16 Summary of Analysis Techniques
Business Questions and Analysis Techniques for Addressing Them
Data Sources
Index
