liveBook · Manning

What you will learn in Effective Data Analysis

Hard and soft skills to accelerate your career

by Mona Khalil
Foreword by Barry McCardel

Chapter by chapter

Chapter 1: What does an analyst do?

1.1 What is analytics? · 1.1.1 Business intelligence · 1.1.2 Marketing analytics · 1.1.3 Financial analytics · 1.1.4 Product analytics · 1.1.5 How distinct are these fields? · 1.2 The data analyst’s toolkit · 1.2.1 Spreadsheet tools · 1.2.2 Querying language · 1.2.3 Programming languages for statistics · 1.2.4 Data visualization tools · 1.2.5 Adding to your toolkit · 1.3 Preparing for your role · 1.3.1 What to expect as an analyst · 1.3.2 What you will learn in this book · 1.4 Summary

What you learn in chapter 1 →

Chapter 2: From question to deliverable

2.1 The lifecycle of an analytics project · 2.1.1 Questions and hypotheses · 2.1.2 Data sources · 2.1.3 Measures and methods of analysis · 2.1.4 Interpreting results · 2.1.5 Exercises · 2.2 Communicating with stakeholders · 2.2.1 Guiding the interpretation of results · 2.2.2 Results that don’t support hypotheses · 2.2.3 Exercises · 2.3 Reproducibility · 2.3.1 What reproducibility is · 2.3.2 Documenting work · 2.3.3 Exercises · 2.4 Summary

What you learn in chapter 2 →

Chapter 3: Testing and evaluating hypotheses

3.1 Informing a hypothesis · 3.1.1 Collecting background information · 3.1.2 Constructing your hypothesis · 3.1.3 Quantifying your hypothesis · 3.1.4 Exercises · 3.2 Methods of gathering evidence · 3.2.1 Descriptions · 3.2.2 Correlations · 3.2.3 Experiments · 3.2.4 Types of study design · 3.2.5 Exercises · 3.3 Types of research programs · 3.3.1 Basic and applied research · 3.3.2 A/B testing · 3.3.3 Program evaluation · 3.4 Summary

What you learn in chapter 3 →

Chapter 4: Statistics you (probably) learned: T-tests, ANOVAs, and correlations

4.1 The logic of summary statistics · 4.1.1 Summarizing properties of your data · 4.1.2 Recap · 4.1.3 Exercises · 4.2 Making inferences: Group comparisons · 4.2.1 Parametric tests · 4.2.2 Exercises · 4.3 Making inferences: Correlation and regression · 4.3.1 Correlation coefficients · 4.3.2 Regression modeling · 4.3.3 Reporting on correlations and regressions · 4.3.4 Exercises · 4.4 Summary

What you learn in chapter 4 →

Chapter 5: Statistics you (probably) missed: Non-parametrics and interpretation

5.1 The landscape of statistics · 5.1.1 The evolution of statistical methods · 5.1.2 Choosing your approaches responsibly · 5.2 Non-parametric statistics · 5.2.1 Comparisons between groups on continuous or ordinal data · 5.2.2 Exercises · 5.2.3 Comparing categorical data · 5.2.4 Recap · 5.3 Responsible interpretation · 5.3.1 Statistical errors · 5.3.2 P-hacking · 5.4 Summary

What you learn in chapter 5 →

Chapter 6: Are you measuring what you think you’re measuring?

6.1 A theory of measurement · 6.1.1 Translating ideas into concepts · 6.1.2 Understanding common measurement tools · 6.2 Choosing a data collection method · 6.2.1 Types of measures · 6.2.2 Constructing self-report measures · 6.2.3 Interpreting available data · 6.2.4 Exercises · 6.3 Reliability and validity · 6.3.1 Reliability · 6.3.2 Validity · 6.3.3 Exercises · 6.4 Summary

What you learn in chapter 6 →

Chapter 7: The art of metrics: Tracking performance for organizational success

7.1 The role of metrics in decision-making · 7.1.1 Tracking performance · 7.1.2 Informing organizational strategy · 7.1.3 Promoting accountability · 7.1.4 Exercises · 7.2 The key principles of metric design · 7.2.1 Using the SMART framework · 7.2.2 Establishing baselines and targets · 7.2.3 Exercises · 7.3 Avoiding metric pitfalls · 7.3.1 Representation · 7.3.2 Visualization · 7.3.3 Exercises · 7.4 Summary

What you learn in chapter 7 →

Chapter 8: Navigating sensitive and protected data

8.1 Consent in research · 8.1.1 A brief history lesson · 8.1.2 Informed consent · 8.1.3 Exercises · 8.2 The current legal landscape · 8.2.1 Data protection regulations · 8.2.2 Bias in automated systems · 8.2.3 Exercises · 8.3 Analyzing sensitive data · 8.3.1 Data minimization · 8.3.2 Anonymizing and pseudonymizing data · 8.3.3 Preventing deanonymization · 8.3.4 Exercises · 8.4 Summary

What you learn in chapter 8 →

Chapter 9: The world of statistical modeling

9.1 The many faces of statistical modeling · 9.1.1 Classes of statistical models · 9.1.2 Model output and diagnostics · 9.1.3 Exercises · 9.2 The modeling process · 9.2.1 Exploratory analysis · 9.2.2 Fitting a model · 9.2.3 Exercises · 9.3 The statistical model and its value · 9.3.1 Explanatory models · 9.3.2 Predictive models · 9.3.3 Exercises · 9.4 Summary

What you learn in chapter 9 →

Chapter 10: Incorporating external data into analyses

10.1 Using APIs · 10.1.1 Retrieving data: API vs. browser interface · 10.1.2 Determining the value of using an API · 10.1.3 Exercises · 10.2 Web scraping · 10.2.1 Scraping the web for data · 10.2.2 Extracting the data we need · 10.2.3 Determining the value of web scraping · 10.2.4 Exercises · 10.3 Tapping into public data sources · 10.3.1 When did public data become so popular? · 10.3.2 Types of public data sources · 10.3.3 Accessing public data · 10.3.4 Exercises · 10.4 Summary

What you learn in chapter 10 →

Chapter 11: The magic of well-structured data

11.1 The analyst’s dilemma · 11.2 Data tools at a glance · 11.2.1 Data gathering · 11.2.2 Data storage · 11.2.3 Data processing · 11.2.4 Exercises · 11.3 Data management practices · 11.3.1 Data structure · 11.3.2 Data quality · 11.3.3 Using metadata · 11.3.4 Exercises · 11.4 Data for analytics · 11.4.1 Analytics engineering · 11.4.2 Modeling data in star schemas · 11.4.3 Exercises · 11.5 Summary

What you learn in chapter 11 →

Chapter 12: Tools and tech for modern data analytics

12.1 The evolution of data analytics · 12.2 Analysis and reporting tools · 12.2.1 Types of tools · 12.2.2 Libraries of analyses · 12.2.3 Exercises · 12.3 Self-service analytics · 12.3.1 Approaches to self-service · 12.3.2 Creating a strategy · 12.3.3 Exercises · 12.4 Artificial intelligence · 12.4.1 Generative AI · 12.4.2 Future directions · 12.4.3 Final thoughts · 12.4.4 Exercises · 12.5 Summary

What you learn in chapter 12 →

Concepts explained in this book

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.