Tableau Certified Data Analyst Certification Guide Ace the Tableau Data Analyst Certification Exam with Expert Guidance and Practice Material
The Tableau Certified Data Analyst certification validates the essential skills needed to explore, analyze, and present data, propelling your career in data analytics. Whether you're a seasoned Tableau user or just starting out, this comprehensive resource is your roadmap to mastering Tableau a...
| Main Authors: | , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Birmingham
Packt Publishing, Limited
2024
|
| Edition: | First edition |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Replacing Data Sources
- Notes, Caveats, and Unsupported Data Sources
- Web-Based Data Access: Drivers and APIs
- Multidimensional Systems
- Summary
- Exam Readiness Drill
- Chapter Review Questions
- Chapter 2: Transforming Data
- Introduction
- Types of Fields in Tableau
- Data Types
- Data Type Conversion
- Dimensions and Measures
- Dimensions and Measure Field Conversion
- Discrete and Continuous
- Dimension, Measure, Discrete, and Continuous Combinations
- Discrete and Continuous Color Legends
- Cleaning Data
- Assessing Data Quality
- Cleaning data on Tableau Desktop
- Duplicating and Renaming a Field Updating the Aliases
- Updating the Default Properties of Fields
- Data Interpreter
- Using Data Interpreter in Tableau Desktop
- Organizing the Data Source
- Creating a Folder
- Cleaning Data in Tableau Prep
- Using Tableau Prep's Data Cleaning Functionality
- Transforming Data
- Tableau Desktop Transformations
- Splitting a Field in Tableau Desktop
- Pivoting Fields in Tableau Desktop
- Aggregating Data in Tableau Prep
- Aggregating Data
- Pivoting Data in Tableau Prep
- Pivoting Rows to Columns in Tableau Prep
- Cover
- FM
- Copyright
- Contributors
- Table of Contents
- Preface
- Chapter 1: Connecting to Data
- Introduction to Data
- Making the Most Out of This Book
- Your Certification and Beyond
- Connecting to Sources
- Data Structure
- Choosing an Appropriate Data Source Type
- Content and Quality
- Level of detail: Dimensions and Measures
- Data Quality
- Technical Requirements
- Performance: Data Size and Structure
- Microsoft Excel (.xlsx) and Comma-Separated Values (.csv) Types
- Relational Databases
- Initial Data Connections
- Pivoting Columns to Rows in Tableau Prep
- Combining Data
- Tableau Desktop Joins
- Creating a Join in Tableau Desktop
- Tableau Desktop Unions
- Creating a Union in Tableau Desktop
- Relationships
- Creating a Relationship in Tableau Desktop
- Blending
- Creating a Blend Relationship in Tableau
- Primary versus Secondary Data Source Choice
- Tableau Prep Joins
- Creating a Join in Tableau Prep
- Tableau Prep Unions
- Creating a Union in Tableau Prep
- Summary
- Exam Readiness Drill
- Chapter Review Questions
- Chapter 3: Calculations
- Introduction
- Defining Calculations
- Connecting to Tableau Server or Tableau Cloud
- Connecting to a File
- CSV and Excel Files
- .hyper or .tde Files
- JSON
- Spatial Files
- Statistical Files
- Connecting to Databases and Cloud Services
- Default Server Connectors
- Custom SQL Queries
- Introduction to SQL and Custom Queries in Tableau
- Live versus Extract Connections
- Live Connections
- Data Extracts
- Other Factors Affecting Performance
- Connection Management: the Datasource Pane and Data Tab
- The Datasource Window
- The Data Tab
- Making New Connections in Existing Workbooks