Advancing Into Analytics

Preface
Learning Objective
Prerequisites
Technical Requirements
Technological Requirements
How I Got Here
'Excel Bad, Coding Good'
The Instructional Benefits of Excel
Book Overview
End-of-Chapter Exercises
This Is Not a Laundry List
Don't Panic
Conventions Used in This Book
Using Code Examples
O'Reilly Online Learning
How to Contact Us
Acknowledgments

Part I. Foundations of Analytics in Excel
1. Foundations of Exploratory Data Analysis
What Is Exploratory Data Analysis?
Observations
Variables
Demonstration: Classifying Variables
Recap: Variable Types
Exploring Variables in Excel
Exploring Categorical Variables
Exploring Quantitative Variables
Conclusion
Exercises

2. Foundations of Probability
Probability and Randomness
Probability and Sample Space
Probability and Experiments
Unconditional and Conditional Probability
Probability Distributions
Discrete Probability Distributions
Continuous Probability Distributions
Conclusion
Exercises

3. Foundations of Inferential Statistics
The Framework of Statistical Inference
Collect a Representative Sample
State the Hypotheses
Formulate an Analysis Plan
Analyze the Data
Make a Decision
It's Your World the Data's Only Living in It
Conclusion
Exercises

4. Correlation and Regression
'Correlation Does Not Imply Causation'
Introducing Correlation
From Correlation to Regression
Linear Regression in Excel
Rethinking Our Results: Spurious Relationships
Conclusion
Advancing into Programming
Exercises

5. The Data Analytics Stack
Statistics Versus Data Analytics Versus Data Science
Statistics
Data Analytics
Business Analytics
Data Science
Machine Learning
Distinct, but Not Exclusive
The Importance of the Data Analytics Stack
Spreadsheets
Databases
Business Intelligence Platforms
Data Programming Languages
Conclusion
What's Next
Exercises

Part II. From Excel to R
6. First Steps with R for Excel Users
Downloading R
Getting Started with RStudio
Packages in R
Upgrading R, RStudio, and R Packages
Conclusion
Exercises

7. Data Structures in R
Vectors
Indexing and Subsetting Vectors
From Excel Tables to R Data Frames
Importing Data in R
Exploring a Data Frame
Indexing and Subsetting Data Frames
Writing Data Frames
Conclusion
Exercises

8. Data Manipulation and Visualization in R
Data Manipulation with dplyr
Column-Wise Operations
Row-Wise Operations
Aggregating and Joining Data
dplyr and the Power of the Pipe (%>%)
Reshaping Data with tidyr
Data Visualization with ggplot2
Conclusion
Exercises

9. Capstone: R for Data Analytics
Exploratory Data Analysis
Hypothesis Testing
Independent Samples t-test
Linear Regression
Train/Test Split and Validation
Conclusion
Exercises

Paret III. From Excel to Python
10. First Steps with Python for Excel Users
Downloading Python
Getting Started with Jupyter
Modules in Python
Upgrading Python, Anaconda, and Python packages
Conclusion
Exercises

11. Data Structures in Python
NumPy arrays
Indexing and Subsetting NumPy Arrays
Introducing Pandas DataFrames
Importing Data in Python
Exploring a DataFrame
Indexing and Subsetting DataFrames
Writing DataFrames
Conclusion
Exercises

12. Data Manipulation and Visualization in Python
Column-Wise Operations
Row-Wise Operations
Aggregating and Joining Data
Reshaping Data
Data Visualization
Conclusion
Exercises

13. Capstone: Python for Data Analytics
Exploratory Data Analysis
Hypothesis Testing
Independent Samples T-test
Linear Regression
Train/Test Split and Validation
Conclusion
Exercises

14. Conclusion and Next Steps
Further Slices of the Stack
Research Design and Business Experiments
Further Statistical Methods
Data Science and Machine Learning
Version Control
Ethics
Go Forth and Data How You Please
Parting Words

Index
About the Author