Tableau Certified Data Analyst Certification Guide : Ace the Tableau Data Analyst Certification Exam with Expert Guidance and Practice Material

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...

Descripción completa

Detalles Bibliográficos
Otros Autores: Cooney, Harry, author (author), Jones, Daisy, author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Birmingham, England : Packt Publishing [2024]
Edición:First edition
Materias:
Tableau (Computer file) > Examinations > Study guides.
Information visualization > Computer programs > Examinations > Study guides.
Visual analytics > Data processing > Examinations > Study guides.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009835405706719
Tabla de Contenidos:
  • 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
  • Connecting to Tableau Server or Tableau Cloud
  • Connecting to a File
  • CSV and Excel Files
  • .hyper or .tde Files
  • JSON
  • PDF
  • 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
  • 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
  • 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
  • Calculated Fields
  • Aggregated Calculated Fields
  • Measure Aggregation
  • Using the SUM and MIN Functions
  • Math Functions
  • Using the MEDIAN and STDEV Functions
  • Fixed Level of Detail Calculations
  • Creating a Fixed Level of Detail Calculation
  • Numeric Calculated Fields
  • Transformational Mathematical Functions
  • Using the SQUARE and SQRT Functions
  • Field Format Functions
  • Using the ROUND and ABS Functions
  • Trigonometry
  • Using the SIN and RADIANS Functions
  • String Calculated Fields
  • Positional Functions
  • Using the RIGHT, LEFT, and MID Functions
  • Searching
  • Using the CONTAINS, STARTSWITH, and REPLACE Functions
  • Case
  • Using the UPPER and LOWER Functions
  • Other
  • Using the SPLIT and LEN Functions
  • Date Calculated Fields
  • Date Parts.
  • Using the YEAR, MONTH, DAY, and DATEPART Functions
  • Date Logic
  • Using the DATETRUNC and DATEADD Functions
  • Using the DATEDIFF and TODAY Functions
  • Type Conversion
  • Data Types
  • Using the STR and MAKEDATE Functions
  • Boolean Calculated Fields
  • Boolean Functions
  • Using the IN Function
  • IF Logic
  • Using the IIF Function and Creating an IF Statement
  • CASE Statements
  • Writing a CASE Statement
  • Table Calculations
  • Building a Table Calculation
  • Moving Calculations
  • Percent of Total
  • Running Sum
  • Difference and Percent of Difference
  • Percentile
  • Custom Table Calculations
  • INDEX
  • Rank
  • First-and Last
  • Summary
  • Exam Readiness Drill - Chapter Review Questions
  • Chapter 4: Grouping and Filtering
  • Introduction
  • Data Grouping
  • Sets
  • Creating a Fixed Set and Filtering Data
  • Creating a Top N Set
  • Creating a Conditional Set
  • Combining Sets for Advanced Analysis
  • Groups
  • Creating a Group from Data Points in a View
  • Editing the Group
  • Hierarchies
  • Creating a Product Hierarchy
  • Using a Hierarchy in a View
  • Bins
  • Creating a Sales Bin and Counting the Customers in Each
  • Filtering
  • Types of Filters
  • Filtering Directly from the View
  • Filter Configuration
  • Creating a Wildcard Filter
  • Creating a Conditional Filter
  • Creating a Top N Filter
  • Creating a Date Filter
  • Creating a Table Calculation Filter
  • Applying Filters to Single or Multiple Sheets
  • Applying a Filter to Multiple Worksheets
  • Filtering and the Order of Operations
  • Creating a Data Source Filter
  • Context Filtering Exercise
  • Parameters
  • Parameter Creation
  • Creating a String Parameter from an Existing Field
  • Creating an Integer Parameter
  • Creating a Date Parameter
  • Parameters in Calculated Fields
  • Using a Parameter in a Calculated Field
  • Filtering with Parameters
  • Filtering with a Parameter.
  • Customizing Reference Lines Using Parameters
  • Customizing a Reference Line Using a Parameter
  • Summary
  • Exam Readiness Drill - Chapter Review Questions
  • Chapter 5: Charts
  • Introduction
  • Area Chart
  • Bar Chart
  • Box Plot
  • Bullet Graph
  • Heatmap
  • Gantt Chart
  • Highlight Table
  • Histogram Table
  • Line Chart
  • Packed Bubble Chart
  • Pie Chart
  • Scatter Plot
  • Text Table
  • Treemap
  • Combination Chart
  • Geographic Charts
  • Symbol Maps
  • Creating a Symbol Map in Tableau
  • Density/Heat Maps
  • Creating a Density Map in Tableau
  • Filled Maps
  • Creating a Filled Map in Tableau
  • Analytics
  • Totals and Subtotals
  • Creating Totals and Subtotals
  • Reference Lines and Average Lines
  • Creating a Constant and Average Reference Line in Tableau
  • Reference Bands and Distribution Bands
  • Creating a Reference Band and a Distribution Band
  • Box Plots
  • Creating a Box Plot
  • Trend Lines
  • Adding a Trend Line to a Chart in Tableau
  • Forecasting
  • Creating and Customizing a Forecast in Tableau
  • Predictive Models
  • Creating a Predictive Model in Tableau
  • Summary
  • Exam Readiness Drill - Chapter Review Questions
  • Chapter 6: Dashboards
  • Introduction
  • Dashboard Creation
  • Dashboard Objects
  • Sheets
  • Containers
  • Text
  • Image
  • Blank
  • Buttons
  • Web Page
  • Extensions
  • Ask Data
  • Data Story
  • Workflow
  • Creating a Dashboard and Adding a Sheet and a Title
  • Adding a Container and Another Sheet to the Dashboard
  • Adding Buttons to the Dashboard
  • Layout Options
  • Dashboard Sizing/Device Layouts
  • Floating versus Tiled
  • Adding Tiled Objects and Floating Objects to a Dashboard
  • Resizing the Default Canvas and Updating the Phone Layout
  • Dashboard Interactivity
  • Dashboard Actions
  • Filter Actions
  • Highlight Actions
  • URL actions
  • Adding Filter Actions to the Dashboard.
  • Adding a Highlight Action to the Dashboard
  • Adding a URL Action to the Dashboard
  • Adding User-Guiding Sentences to Improve the End-User Experience
  • Filtering Multiple Sheets
  • Adding a Filter to the Dashboard and Applying it to All Sheets
  • Sheet Swapping
  • Creating a Sheet Swapper and Applying it to the Dashboard
  • Dashboard Best Practices
  • Stories
  • Creating a Story
  • Summary
  • Exam Readiness Drill - Chapter Review Questions
  • Chapter 7: Formatting
  • Introduction
  • Applying Color, Font, Shapes, and Styling
  • Color
  • Font
  • Alignment
  • Tooltips
  • Shapes
  • Adding Custom Shapes and Color Palettes
  • Adding annotations
  • Adding tooltips
  • Applying padding
  • Removing Gridlines, Row-Level and column-Level Bands, and Shading
  • Summary
  • Exam Readiness Drill - Chapter Review Questions
  • Chapter 8: Publishing and Managing Content
  • Introduction
  • Sharing Tableau Content
  • Publishing Workbooks
  • Publishing a Tableau Workbook
  • Publishing Data Sources
  • Publishing a Data Source
  • Exporting Content
  • Exporting to PDF
  • Cross-Tab Selected Data to Excel
  • Scheduling Data Updates
  • Extract Refreshes
  • Scheduling an Extract Refresh
  • Tableau Prep Flows
  • Managing Published Workbooks
  • Alerts
  • Creating a Data-Driven Alert
  • Subscriptions
  • Creating a Subscription
  • Summary
  • Exam Readiness Drill - Chapter Review Questions
  • Chapter 9: Accessing the Online Practice Resources
  • Index
  • Other Books You May Enjoy.

Ejemplares similares