Duration
2 days
What you'll learn
- What Tableau is and the product suite
- The Tableau interface and its major functions
- Which data structures are suitable for Tableau
- How Tableau reads and categorizes data
- How to connect and manage data sources in Tableau
- How to build a view and different chart types in Tableau
- How to create a dashboard in Tableau
- How to publish and share a workbook
- How to use numeric, string, conditional, and analytical expressions/functions in Tableau
- How to use calculated fields in Tableau
- How to use Alteryx workflows to cut out repetitive tasks
- How to build visual workflows in Alteryx
- How to make the most of 'Favorite Tools' as core Alteryx building blocks
- How to filter data in Alteryx
- How to use the basic functions in Alteryx to match data
- How to parse data in Alteryx
- How to create reports in Alteryx that run on demand
Course Outline
Tableau Introduction
- Tableau Product Suite Introduction
- Business Intelligence introduction
- Exploring Tableau
- Tableau Data Concepts
- Connecting to Data Sources
- Data Sources in Tableau
- Tableau Workspace
- Creating a New View
- Using Multiple Data Sources
Tableau: Bringing Data to Life
- Selecting a Chart
- Building a View
- Designing Callout Numbers and Tables
- Histograms and Whisker Plots
- Scatter Plot and Correlation Matrix
- Spatial Charts
- Creating a Dashboard
- Presenting a Story
- Publishing & Sharing a Workbook
Tableau: Calculations and Expressions in Tableau
- Using Expressions in Tableau
- Numeric Expressions & Automatic Calculations
- String Expressions
- Conditional Expressions
- Analytical Functions
Alteryx: Introduction
Introduction
- Alteryx Essentials
- Data Types 101
- Components of the Alteryx Workflow
- Formatting data to create a more efficient workflow
- Basic Workflow Examples: Getting started with the tool palette
Alteryx: Data Blend & Prep
- Data filtering
- Intro to blending data
- Grouping Data with Alteryx
- Introduction to Basic Functions
Alteryx: Data Parsing
- Basic Parsing Methods
- Basic Parsing Methods with Dynamic Renaming
- Basic Vlookup and Append
- Working on Multiple Fields in Alteryx
- Build an Alteryx Workflow
Alteryx: Reporting
- Alteryx Best Practices - Visualizing Data
- Alteryx Best Practices - Visualizing Data with Texts and Charts
- Alteryx Best Practices - Layouts and Rendering
Alteryx: Analytic Apps
- Introduction to Analytic Apps
- Introduction to Macros
Alteryx: Analytics
- Introduction to Analytics
- Introduction to K-Centroid Clustering
- Introduction to K-Nearest Neighbor
- Introduction to Market Basket Analysis
- Introduction to Logistic Regression Analysis
- Introduction to Linear Regression Analysis
- Introduction to Tree-based Models
Programme scope, delivery arrangements and suitability are confirmed during enquiry.