Opis ebooka: Tableau Prep: Up & Running
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, cleaning, automating, organizing, and outputting your datasets.
Based on Allchin’s popular blog, Preppin’ Data, this practical guide takes you step-by-step through Tableau Prep’s fundamentals. Self-service data preparation reduces the time it takes to complete data projects and improves the quality of your analyses. Discover how Tableau Prep helps you access your data and turn it into valuable information.
- Know what to look for when you prepare data
- Learn which Tableau Prep functions to use when working with data fields
- Analyze the shape and profile of your dataset
- Output data for analysis and learn how Tableau Prep automates your workflow
- Learn how to clean your dataset using Tableau Prep functions
- Explore ways to use Tableau Prep techniques in real-world scenarios
- Make your data available to others by managing and documenting the output
Wybrane bestsellery
-
Data has been a missing part of most academic curriculums for a long time, and we're all being affected. During challenging times, creating a data-informed culture can help you pivot quickly or prevent expensive missteps. Developing a data curious organization will take advantage of the burgeonin...(112.90 zł najniższa cena z 30 dni)
112.70 zł
169.00 zł(-33%) -
Data is a fantastic raw resource for powering change in an organization, but all too often the people working in those organizations don't have the necessary skills to communicate with data effectively. With this practical book, subject matter experts will learn ways to develop strong, persuasive...(186.71 zł najniższa cena z 30 dni)
186.21 zł
249.00 zł(-25%) -
Oddajemy w Państwa ręce kompendium wiedzy, które stanowi nieocenione źródło informacji dla wszystkich zainteresowanych zgłębianiem tajników uczenia maszynowego i głębokiego uczenia. Ta obszerna publikacja, licząca ponad 800 stron, jest prawdziwą skarbnicą wiedzy teoretycznej i praktycznej, staran...
-
W tym przewodniku opisano zagadnienia związane z podstawami nauki o danych. Wyjaśniono niezbędne elementy matematyki i statystyki. Przedstawiono także techniki budowy potrzebnych narzędzi i sposoby działania najistotniejszych algorytmów. Książka została skonstruowana tak, aby poszczególne impleme...(47.40 zł najniższa cena z 30 dni)
55.30 zł
79.00 zł(-30%)
Ebooka "Tableau Prep: Up & Running" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "Tableau Prep: Up & Running" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "Tableau Prep: Up & Running" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-920-7957-6, 9781492079576
- Data wydania ebooka:
- 2020-08-03 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 31.0MB
- Rozmiar pliku Mobi:
- 59.6MB
Spis treści ebooka
- Preface
- Why I Wrote This Book
- Who This Book Is For
- How This Book Is Organized
- Acknowledgments
- Conventions Used in This Book
- Using Code Examples
- OReilly Online Learning
- How to Contact Us
- 1. Why Self-Service Data Prep?
- A Short History of Self-Service Data Visualization
- Accessing the Right Data
- The Self-Service Data Preparation Opportunity
- Tableau Prep Up and Running
- Summary
- I. Getting Started
- 2. Getting Started with Tableau Prep Builder
- Where to Get Tableau Prep Builder
- How to Get a License for Prep Builder
- The Tableau Prep Builder Screen
- Basic Steps of Data Preparation
- Input Step
- Clean Step
- Output Step
- Saving a Flow
- Summary
- 3. Planning Your Prep
- Stage 1: Know Your Data
- Stage 2: Identify the Desired State
- Stage 3: Determine the Required Transitions from KYD to the Desired State
- Stage 4: Build the Workflow
- Summary
- 4. Shaping Data
- What to Look for in Incoming Data Sets
- What Shape Is Best for Analysis in Tableau?
- Changing Data Set Structures in Prep Builder
- Pivot
- Aggregate
- Join
- Union
- Applying Restructuring Techniques to the Ice Cream Example
- Step 1: Pivot Columns to Rows
- Step 2: Pivot Rows to Columns
- Summary
- 5. Connecting to Data in Files
- Files Upon Files Upon Files
- Spreadsheets
- Other File Types
- Files Upon Files Upon Files
- Where to Find Your Data Files
- How to Connect to Files in Prep
- Considerations for Saving Flows with File Inputs
- Summary
- 6. Connecting to a Database
- What Is a Database?
- How to Connect to a Database Within Prep Builder
- When to Avoid Connecting to a Database
- Summary
- II. Data Types
- 7. Dealing with Numbers
- What Do We Mean by Numbers?
- Types of Numbers
- Category or Measure?
- Aggregation
- Formatting Numbers
- Functions for Mastering Numerical Data
- Summary
- 8. Dealing with Dates
- Why Are Dates Important?
- Parts of a Date
- Date Lookup Tables
- Epoch Dates
- Excel Serial Number
- Entering Dates
- The makedate() Function
- The dateparse() Function
- Summary
- 9. Dealing with String Data
- What Do We Mean by Strings?
- How String Data Is Different
- Character Order
- Formatting Considerations
- Names
- Case sensitivity
- Addresses
- Spaces
- Poor or inconsistent spelling
- Common Functions for Preparing String Data
- Grouping and Replace Options for Working with String Data
- Summary
- 10. Dealing with Boolean Data
- What Is Boolean Data?
- Why Is It So Useful in Data Analysis?
- Functions Featuring Boolean Logic
- IIF()
- contains()
- IsDate()
- IsNull()
- IF/THEN
- CASE
- What Is Boolean Data?
- Summary
- III. The Shape of Data
- 11. Profiling Data
- What Is a Profile?
- Why Visualizing the Data Set Is Important
- Anscombes Quartet
- Visualizations Versus Data Tables
- How Prep Builder Profiles Data
- Generating Histograms and Mini-Histograms
- Selecting Summary Versus Detail Views
- Highlighting Values
- Viewing Dimension Counts
- Sorting
- Summary
- 12. Sampling Data Sets
- One Simple Rule: Use It All If Possible
- Sampling to Work Around Technical Limitations
- Volume of Data
- Velocity of Data
- Other Reasons for Sampling
- Reduce Build Times
- Determine What You Need
- Sampling Techniques
- Fixed Number of Rows
- Random Sample
- When Not to Sample
- Summary
- 13. Pivoting Columns to Rows
- When to Pivot in Tableau Prep Builder
- How to Pivot Columns to Rows
- Summary
- 14. Pivoting Rows to Columns
- When to Use a Rows-to-Columns Pivot
- How to Pivot Rows to Columns
- Summary
- 15. Aggregating in Prep Builder
- Comparing Calculations in Prep Builder and Desktop
- Which Calculations in Prep Builder Differ?
- Adding the Aggregate Step
- Wheres the Rest of My Data?
- Level of Detail Calculation Option
- Summary
- 16. Joining Data Sets Together
- How to Join Data Sets in Prep Builder
- Join Logic and Terminology
- Types of Join in Prep Builder
- When to Use Each Join Type
- Summary
- 17. Unioning
- What Is a Union?
- What If the Data Structure Isnt Identical?
- When to Union Data
- Monthly Data Sets
- Data Sets from Web Sources
- Company Mergers
- Multiple Tables and Wildcard Unions
- Summary
- 18. Calculations
- What Do Calculations Do in Data Preparation?
- Creating a Calculated Field
- Fundamentals of Calculations
- The Reference List
- Syntax
- Description
- Example
- Building the Calculation
- When Calculations Go Well
- When Calculations Go Poorly
- Editing Calculated Fields
- Recommendations
- Types of Calculations
- Numerical Calculations
- String Calculations
- Date Calculations
- Conditional Calculations with a Boolean Output
- Logical Calculations
- Type Conversions
- Level of Detail and Ranking Calculations
- Summary
- IV. Output
- 19. Choosing an Output
- Types of Output
- Publish to Files
- Hyper files
- TDE files
- CSV files
- Publish to Files
- Publish to Tableau Server
- Types of Output
- When to Output Data in Prep Builder
- Outputting Data in the Output Step
- Save to file
- Publish as a data source
- Outputting Data in the Output Step
- Previewing Output Data in Desktop
- Other Considerations for Output Data
- Summary
- 20. Outputting to a Database
- When to Write to a Database
- Clean Data
- Simplified Joins
- Staging and Reference Tables
- When to Write to a Database
- Setup for Writing to a Database
- What to Watch Out For
- Summary
- 21. Getting Started with Tableau Prep Conductor
- When to Use Prep Conductor
- How to Get Prep Conductor
- Loading a Flow to Prep Conductor
- Other Benefits of Using Prep Conductor
- Summary
- V. Cleaning Data
- 22. Creating Additional Data
- When Not to Create Data
- Dynamic Calculations in Desktop
- Duplicate Records from Joins
- When Not to Create Data
- Creating Additional Columns
- Using Calculations
- Pivoting Rows to Columns
- Joining Data Sets
- Creating Additional Rows
- Pivoting Columns to Rows
- Unioning Data Sets
- Scaffolding Data Sets
- Joining Data Sets
- Summary
- 23. Filtering
- What Is a Filter?
- Different Types of Filters
- Selection
- In the Profile pane
- In the Data pane
- From a data field
- Selection
- Calculation
- Wildcard
- Null Values
- When to Filter Out Columns
- When to Filter Out Rows
- Summary
- 24. Removing Data During Input
- Changing Your Data Set Before Loading It
- Slow Performance, Slow Build, Slow Output
- Removing Columns
- Removing Records
- Summary
- 25. Splitting Data Fields
- Basic Splits
- Advanced Splits: When Automatic Splits Dont Work as Intended
- When Not to Split Data
- Address Data
- No Clear Delimiter
- Summary
- 26. Cleaning by Grouping Data
- What Does Grouping Mean?
- Why Use Grouping
- Improving Accuracy
- Navigating the Data Hierarchy
- Smoothing Reorganizations
- Grouping Techniques
- Manual
- Calculations
- IF statements
- REPLACE() functions
- Built-in Functionality
- Summary
- 27. Dealing with Nulls
- What Is a Null?
- When Is a Null OK?
- How to Remove or Replace a Null
- ISNULL()
- ZN()
- Merge
- Summary
- 28. Using Data Roles
- How to Use Data Roles
- Custom Data Roles
- Summary
- 29. Dealing with Unwanted Characters
- What Is an Unwanted Character?
- Issues Caused by Unwanted Characters
- Removing Unwanted Characters
- Strings with Mistyped Characters
- Numbers with Unwanted Characters
- Dates with Mistyped Characters
- Summary
- 30. Deduplicating
- How to Identify Duplicates
- Causes of Duplicates
- System Loads
- Row per Measure
- Joins
- How to Handle Duplicates
- Aggregating: Technique 1
- Aggregating: Technique 2
- Pivoting Rows to Columns
- Summary
- 31. Using Regular Expressions
- What Are Regular Expressions?
- How to Use Regexes in Prep
- REGEXP_EXTRACT() and REGEXP_EXTRACT_NTH()
- REGEXP_MATCH()
- REGEXP_REPLACE()
- Regex Use Cases
- Replacing Common Mistakes
- Anonymizing Comments or Feedback
- Common Regex Commands
- Summary
- 32. Completing Advanced Joins
- Multiple Join Conditions
- Join Conditions Other Than Equals
- Filtering with a Join
- Joining by a Range
- OR Statements
- Summary
- 33. Creating Level of Detail Calculations
- What Is Appending?
- Exploring Appending Through LOD Calculations
- When to Use an LOD Calculation
- How to Write an LOD Calculation in Prep Builder
- What a Level of Detail Calculation Is Doing
- Step 1: Calculate the categorical sales
- Step 2: Join the aggregated results back to the original data set
- Summary
- 34. Doing Analytical Calculations
- What Is a Table Calculation?
- Applying Table Calculation Logic in Prep Builder
- Keywords
- Analytical Calculations
- The ranking functions
- The ROW_NUMBER() function
- Use Cases
- Filtering for the Top N
- Filtering Out a Percentage of Data
- Summary
- VI. Beyond the Basics
- 35. Breaking Down Complex Data Preparation Challenges
- The Challenge
- Where to Begin
- Logical Steps
- Making Changes
- Be Ready to Iterate
- Summary
- 36. Handling Free Text
- What Is Free Text?
- Why Is Free Text Useful?
- How to Analyze Free Text in Tableau
- Split the Strings
- Pivot Columns to Rows
- Clean Cases and Punctuation
- Use a Join to Remove Common Words
- Group the Remaining Values
- Summary
- 37. Using Smarter Filtering
- Calculations
- Boolean Calculations
- Logical Calculations
- Regex Calculations
- Calculations
- Join Ranges
- Percentage Variance
- Manual Entry: Level of Detail Calculations
- Reloaded Data: Join to Previous Output
- Aggregating the Average Production Cost per Type
- Joining the Data Sets Together
- Combining Techniques
- Summary
- 38. Managing Conversion Rates
- Challenges of Conversion Rates
- Applying Conversion Rates in Prep
- Step 1: Create a Consistent Granularity of Data for the Conversion
- Step 2: Join the Data Sets Together
- Step 3: Apply the Conversion Rate
- Long-Term Strategies for Conversion Rates
- Managing Frequency
- Maintaining History Tables
- Summary
- 39. Scaffolding Your Data
- What Is Scaffolding?
- Challenges Addressed by Scaffolding
- Challenges Created by Scaffolding
- The Traditional Scaffolding Technique
- Step 1: Input the Data Sets
- Step 2: Build the Join Calculations
- Step 3: Join the Two Data Sets Together
- Step 4: Filter Out Unnecessary Rows
- The Newer Scaffolding Technique
- Step 1: Input the Data Sets
- Step 2: Join the Data Sets
- Step 3: Add the Reporting Date
- Step 4: Remove the Scaffold Value
- The Result
- Summary
- 40. Connecting to Programming Scripts
- When to Use the Script Step in Prep
- Setting Up Your Computer to Use Scripts in Prep
- Using a Script Step
- Summary
- 41. Handling Prep Builder Errors
- Parameter Errors
- Blank Profile Panes or Data Panes
- Changing a Calculation or Removing a Data Field Downstream
- The Data Source Has Changed
- Errors Within a Calculated Field
- Incomplete Calculations
- Unsupported Functions
- Summary
- VII. Managing Your Data
- 42. Documenting Your Data Preparation
- Basic Documentation
- Folder Structure
- Filenames
- Data Sources
- Output
- Basic Documentation
- Step Names
- Clean Step
- Step Descriptions
- Color
- Joins
- Unions
- Summary
- 43. Deciding Where to Prepare Your Data
- Processes to Consider
- Data Preparation Versus Visual Analytics
- Data Literacy
- Organization Size
- Quality of Technological Hardware
- History of Data Investment
- Software Performance
- Sampling
- Functionality
- Documentation
- Summary
- 44. Managing Data
- What Is Sensitive Data?
- Public
- Confidential
- Strictly Confidential
- Restricted
- What Is Sensitive Data?
- Managing Data Based on Sensitivity
- Production Versus Development Environments
- Deleting Data
- When Data Becomes Outdated or Irrelevant
- When a Customer or Client Leaves
- Summary
- 45. Storing Your Data
- Inaccessibility
- Dont Break the Law
- Personally identifiable information
- The right to be forgotten
- Dont Break the Law
- Dont Delete Operational Data
- Do Grant Access to Data for the Experts
- Do Document Your Sources
- Inaccessibility
- Slow/Unresponsive Performance
- Overwriting Risks
- Grant Read-Only Access
- Train Before Publishing
- So, Where Do You Write That Output?
- Summary
- 46. Using Identifiers and Keys in Data
- What Is an Identifier?
- What Is a Key in a Database?
- Using Keys and Identifiers in Prep
- Creating Identifier Data Fields in Prep Builder
- Summary
- 47. Keeping Your Data Up-to-Date
- Refreshing Data
- Full Versus Incremental Refreshes
- Setting Up Different Types of Refresh
- Full Refresh
- Incremental Refresh
- What to Watch Out for When Refreshing Data Sources
- Changing Data Values
- Altering the Structure of Sources
- New Data, New Input
- Summary
- 48. Using History Tables
- Why Are History Tables Required?
- What to Consider When Creating History Tables
- Ability to Join to Live Data
- Relevance of Information
- Frequency of Updates
- Level of Granularity
- Performance
- Data Regulations
- An Example History Table
- Summary
- 49. Evaluating Whether You Need Prep Builder at All
- A History of Data Preparation in Tableau
- Where to Try Desktop First
- Simple Joins
- When to move simple joins to Prep
- Simple Joins
- Unions
- When to move unions to Prep
- Single Pivots
- When to move single pivots to Prep
- Where to Start with Prep Builder
- Summary
- 50. Final Thoughts
- Index
O'Reilly Media - inne książki
-
Large language models (LLMs) and generative AI are rapidly changing the healthcare industry. These technologies have the potential to revolutionize healthcare by improving the efficiency, accuracy, and personalization of care. This practical book shows healthcare leaders, researchers, data scient...(149.94 zł najniższa cena z 30 dni)
149.89 zł
199.00 zł(-25%) -
With hundreds of tools preinstalled, the Kali Linux distribution makes it easier for security professionals to get started with security testing quickly. But with more than 600 tools in its arsenal, Kali Linux can also be overwhelming. The new edition of this practical book covers updates to the ...(162.32 zł najniższa cena z 30 dni)
162.21 zł
209.00 zł(-22%) -
Learn how to implement and manage a modern customer data platform (CDP) through the Salesforce Data Cloud platform. This practical book provides a comprehensive overview that shows architects, administrators, developers, data engineers, and marketers how to ingest, store, and manage real-time cus...(185.89 zł najniższa cena z 30 dni)
185.84 zł
249.00 zł(-25%) -
Real-time applications are becoming the norm today. But building a model that works properly requires real-time data from the source, in-flight stream processing, and low latency serving of its analytics. With this practical book, data engineers, data architects, and data analysts will learn how ...(210.70 zł najniższa cena z 30 dni)
210.20 zł
279.00 zł(-25%) -
Methods of delivering software are constantly evolving in order to increase speed to market without sacrificing reliability and stability. Mastering development end to end, from version control to production, and building production-ready code is now more important than ever. Continuous deploymen...(172.22 zł najniższa cena z 30 dni)
171.72 zł
229.00 zł(-25%) -
As the transformation to hybrid multicloud accelerates, businesses require a structured approach to securing their workloads. Adopting zero trust principles demands a systematic set of practices to deliver secure solutions. Regulated businesses, in particular, demand rigor in the architectural pr...(153.98 zł najniższa cena z 30 dni)
153.48 zł
209.00 zł(-27%) -
This concise yet comprehensive guide explains how to adopt a data lakehouse architecture to implement modern data platforms. It reviews the design considerations, challenges, and best practices for implementing a lakehouse and provides key insights into the ways that using a lakehouse can impact ...(181.73 zł najniższa cena z 30 dni)
181.63 zł
249.00 zł(-27%) -
In today's fast-paced world, more and more organizations require rapid application development with reduced development costs and increased productivity. This practical guide shows application developers how to use PowerApps, Microsoft's no-code/low-code application framework that helps developer...(151.27 zł najniższa cena z 30 dni)
150.77 zł
209.00 zł(-28%) -
Welcome to the systems age, where software professionals are no longer building software&emdash;we're building systems of software. Change is continuously deployed across software ecosystems coordinated by responsive infrastructure. In this world of increasing relational complexity, we need t...(141.24 zł najniższa cena z 30 dni)
141.04 zł
209.00 zł(-33%) -
This book provides an ideal guide for Python developers who want to learn how to build applications with large language models. Authors Olivier Caelen and Marie-Alice Blete cover the main features and benefits of GPT-4 and GPT-3.5 models and explain how they work. You'll also get a step-by-step g...(143.43 zł najniższa cena z 30 dni)
143.33 zł
209.00 zł(-31%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
Oceny i opinie klientów: Tableau Prep: Up & Running Carl Allchin (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.