Introduction 1
Book 1: Learning Data Analytics & Visualizations Foundations 7
Chapter 1: Exploring Definitions and Roles 9
Chapter 2: Delving into Big Data 19
Chapter 3: Understanding Data Lakes 41
Chapter 4: Wrapping Your Head Around Data Science 51
Chapter 5: Telling Powerful Stories with Data Visualization 81
Book 2: Using Power BI for Data Analytics & Visualization 107
Chapter 1: Power BI Foundations 109
Chapter 2: The Quick Tour of Power BI 123
Chapter 3: Prepping Data for Visualization 141
Chapter 4: Tweaking Data for Primetime 167
Chapter 5: Designing and Deploying Data Models 183
Chapter 6: Tackling Visualization Basics in Power BI 203
Chapter 7: Digging into Complex Visualization and Table Data 227
Chapter 8: Sharing and Collaborating with Power BI 247
Book 3: Using Tableau for Data Analytics & Visualization 265
Chapter 1: Tableau Foundations 267
Chapter 2: Connecting Your Data 285
Chapter 3: Diving into the Tableau Prep Lifecycle 313
Chapter 4: Advanced Data Prep Approaches in Tableau 337
Chapter 5: Touring Tableau Desktop 351
Chapter 6: Storytelling Foundations in Tableau 371
Chapter 7: Visualizing Data in Tableau 391
Chapter 8: Collaborating and Publishing with Tableau Cloud 425
Book 4: Extracting Information with SQL 443
Chapter 1: SQL Foundations 445
Chapter 2: Drilling Down to the SQL Nitty-Gritty 455
Chapter 3: Values, Variables, Functions, and Expressions 487
Chapter 4: SELECT Statements and Modifying Clauses 513
Chapter 5: Tuning Queries 539
Chapter 6: Complex Query Design 557
Chapter 7: Joining Data Together in SQL 591
Book 5: Performing Statistical Data Analysis & Visualization with R Programming 605
Chapter 1: Using Open Source R for Data Science 607
Chapter 2: R: What It Does and How It Does It 623
Chapter 3: Getting Graphical 651
Chapter 4: Kicking It Up a Notch to ggplot2 671
Book 6: Applying Python Programming to Data Science 689
Chapter 1: Discovering the Match between Data Science and Python 691
Chapter 2: Using Python for Data Science and Visualization 703
Chapter 3: Getting a Crash Course in Matplotlib 721
Chapter 4: Visualizing the Data 739
Index 761
