Alteryx & Tableau

• Explain the complete data analytics lifecycle

• Identify where data preparation fits in analytics workflows

• Understand the role of Alteryx in data preparation

• Explain Tableau’s role in analysis and visualization

• Recognize how data preparation and visualization tools work together in real-world analytics projects

• Navigate the Alteryx Designer interface

• Understand tool palettes and workflow canvas

• Create and organize Alteryx workflow

• Manage workflow files and project structures

• Connect to CSV, Excel, and other data sources

• Import datasets into Alteryx workflows

• Export prepared data outputs

• Apply best practices for data connectivity and data flow management

• Interpret field metadata and data types

• Rename and format data fields

• Convert and standardize field types

• Use the Select tool to manage fields within workflows

• Handle missing or incomplete values

• Remove duplicate records

• Identify and manage outliers

• Standardize inconsistent data

• Perform joins using common keys

• Apply inner and outer joins

• Union multiple datasets with similar structures

• Validate integrated data outputs

• Pivot and transpose datasets

• Apply transformation logic within workflows

• Prepare datasets for aggregation and analysis

• Understand when transformations are required in data preparation pipelines

• Sort datasets for analytical clarity

• Group data based on business rules

• Apply aggregation techniques using the Summarize tool

• Generate summary outputs for analysis

• Write expressions for custom calculations

• Apply common expression functions

• Parse and split text fields

• Improve data quality through text manipulation

• Use UI tools to create interactive workflows

• Build parameter-driven workflows

• Design reusable workflow structures

• Apply usability best practices for workflow design

• Explain the role of Business Intelligence in organizations

• Navigate the Tableau Desktop interface

• Understand Tableau’s analysis-first approach

• Identify common BI use cases solved with Tableau

• Connect Tableau to files and databases

• Manage data sources and refreshes

• Apply basic data cleaning techniques in Tableau

• Understand the role of Tableau Prep Builder

• Create calculated fields

• Apply table calculations

• Use Level of Detail (LOD) expressions

• Build analytical metrics for dashboards

• Apply filters and sorting techniques

• Use parameters for dynamic analysis

• Segment data using groups, sets, and bins

• Design flexible analytical views

• Create geographic maps and spatial visualizations

• Build charts and analytical views

• Design dashboards for business reporting

• Apply visualization best practices

Prepare, transform, and visualize real-world business data using Alteryx workflows and Tableau dashboards to deliver actionable business insights.