Tableau prep up and running : self-service data preparation for better analysis
For self-service data preparation, Tableau Prep is relatively easy to use—as long as you know how to clean and organize your datasets. Carl Allchin, from The Information Lab in London, gets you up to speed on Tableau Prep through a series of practical lessons that include methods for preparing, clea...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media, Incorporated
2020.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631136606719 |
Tabla de Contenidos:
- Why self-service data prep?
- Part 1. Getting started. Getting started with Tableau prep builder
- Planning your prep
- Shaping data
- Connecting to data in files
- Connecting to a database
- Part 2. Data types. Dealing with numbers
- Dealing with dates
- Dealing with string data
- Dealing with boolean data
- Part 3. The shape of data. Profiling data
- Sampling data sets
- Pivoting columns to rows
- Pivoting rows to columns
- Aggregating in prep builder
- Joining data sets together
- Unioning
- Calculations
- Part 4. Output. Choosing an output
- Outputting to da database
- Getting started with Tableau
- Part 5. Cleaning data. Creating additional data
- Filtering
- Removing data during input
- Splitting data fields
- Cleaning by grouping data
- Dealing with nulls
- Using data roles
- Dealing with unwanted characters
- Deduplicating
- Using regular expressions
- Completing advanced joins
- Creating leveel of detail calculations
- Doing analytical calculations
- Part 6. Beyond the basics. Breaking down complex data preparation challenges
- Handling free text
- Using smarter filtering
- Managing conversion rates
- Scaffolding your data
- Connecting to programming scripts
- Handling prep builder errors
- Part 7. Managing your data. Documenting your data preparation
- Deciding where to prepare your data
- Managing data
- Storing your data
- Using identifiers and keys in data
- Keeping your data up-to-date
- Using history tables
- Evaluating whether you need prep builder at all
- Final thoughts.
