Data Analytics & Visualization All-in-One For Dummies

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

This All-in-One draws on the work of top authors in the For Dummies series who've created books designed to help data professionals do their work. The experts are Jack Hyman, Luca Massaron, Paul McFedries, John Paul Mueller, Lillian Pierson, Jonathan Reichental PhD, Joseph Schmuller PhD, Alan Simon, and Allen G. Taylor.