- Preface
- 1. Why Self-Service Data Prep?
- I. Getting Started
- 2. Getting Started with Tableau Prep Builder
- 3. Planning Your Prep
- 4. Shaping Data
- 5. Connecting to Data in Files
- 6. Connecting to a Database
- II. Data Types
- 7. Dealing with Numbers
- 8. Dealing with Dates
- 9. Dealing with String Data
- 10. Dealing with Boolean Data
- III. The Shape of Data
- 11. Profiling Data
- 12. Sampling Data Sets
- 13. Pivoting Columns to Rows
- 14. Pivoting Rows to Columns
- 15. Aggregating in Prep Builder
- 16. Joining Data Sets Together
- 17. Unioning
- 18. Calculations
- IV. Output
- 19. Choosing an Output
- 20. Outputting to a Database
- 21. Getting Started with Tableau Prep Conductor
- V. Cleaning Data
- 22. Creating Additional Data
- 23. Filtering
- 24. Removing Data During Input
- 25. Splitting Data Fields
- 26. Cleaning by Grouping Data
- 27. Dealing with Nulls
- 28. Using Data Roles
- 29. Dealing with Unwanted Characters
- 30. Deduplicating
- 31. Using Regular Expressions
- 32. Completing Advanced Joins
- 33. Creating Level of Detail Calculations
- 34. Doing Analytical Calculations
- VI. Beyond the Basics
- 35. Breaking Down Complex Data Preparation Challenges
- 36. Handling Free Text
- 37. Using Smarter Filtering
- 38. Managing Conversion Rates
- 39. Scaffolding Your Data
- 40. Connecting to Programming Scripts
- 41. Handling Prep Builder Errors
- VII. Managing Your Data
- 42. Documenting Your Data Preparation
- 43. Deciding Where to Prepare Your Data
- 44. Managing Data
- 45. Storing Your Data
- 46. Using Identifiers and Keys in Data
- 47. Keeping Your Data Up-to-Date
- 48. Using History Tables
- 49. Evaluating Whether You Need Prep Builder at All
- 50. Final Thoughts
- Index
Praise for Tableau Prep: Up and Running
It has never been more important for analysts to take control of their
data preparation, and—thanks to Allchin—it has also never been easier.Ryan Sleeper, Founder of Playfair Data and Author of Practical Tableau and Innovative Tableau
Years of experience in data preparation packed into an accessible
how-to guide for users of all-levels. Essential reading for Tableau users!Kimberly Bolch, University of Oxford Tableau Student Ambassador
Carl has used his years of consulting and training experience to produce a compelling and thorough overview of Tableau Prep Builder’s functionality and the thought processes required to successfully clean, manipulate and enhance data. This is an invaluable guide for budding data preppers!
Luke Stoughton, The Information Lab
-
No Comment