• Understand the core functionalities of Alteryx, including its user interface, data preparation tools, and the workflow design process for efficient data blending
• Master data cleansing, transformation, and manipulation techniques using Alteryx, ensuring that participants can create clean, usable datasets for analysis.
• Develop skills in navigating Tableau Desktop to create comprehensive visualizations, reports, and dashboards that effectively communicate data insights.
• Learn how to seamlessly integrate Alteryx with Tableau, enabling participants to prepare data in Alteryx and visualize it effectively in Tableau.
• Explore best practices for designing visualizations in Tableau, including choosing appropriate chart types, color schemes, and layouts to enhance the understanding of data.
• Learn how to build interactive dashboards in Tableau that allow users to explore data through filters, actions, and tooltips, creating a dynamic user experience.

Experience with Excel or other spreadsheet tools is helpful. Familiarity with SQL can be beneficial, especially when working with databases.

This training will equip you for the following job roles and career paths:

• Alteryx Developer
• Tableau Developer
• Data Analyst
• Business Intelligence Analyst
• Data Scientist
• Data Engineer

Alteryx: 

Module 1: Introduction to Alteryx

• Overview of Alteryx and its role in data analytics
• Key features and benefits of using Alteryx for data preparation and blending
• Understanding the Alteryx workflow and user interface

Module 2: Alteryx Designer

• Detailed walkthrough of Alteryx Designer interface
• Understanding tool palettes and their functions
• Creating and saving workflows

Module 3: File Input/Output

• Techniques for importing data from various file formats
• Exporting data to different formats and databases
• Best practices for data connectivity and management

Module 4: Modifying Fields

• Understanding field types and attributes in Alteryx
• Tools for modifying fields: renaming, changing types, and formatting
• Using the Select tool to manage field properties effectively

Module 5: Data Preparation and Cleansing

• Techniques for data cleansing: handling missing values, deduplication, and outlier detection
• Using tools like Data Cleansing, Imputation, and Filter to clean data
• Preparing datasets for analysis and visualization

Module 6: Joining Data from Different Sources

• Techniques for joining data from multiple sources, including inner joins, outer joins, and unions
• Utilizing the Join tool effectively for data integration
• Best practices for managing Key Fields

Module 7: Data Transformations

• Learning various data transformation techniques such as pivoting, transposing, and aggregations
• Using tools like Transpose, Cross Tab, and Summarize for effective transformations
• Understanding the importance of transformation for meaningful analysis

Module 8: Sorting

• Techniques for sorting data within Alteryx workflows
• Utilizing the Sort tool to organize datasets appropriately
• Importance of sorting in preparing data for analysis

Module 9: Expressions

• Introduction to using expressions in Alteryx for data manipulation
• Learning about Alteryx expression syntax and commonly used functions
• Creating custom calculations for enhanced data analysis

Module 10: Aggregations

• Understanding aggregation in data analysis
• Using the Summarize tool to perform group and aggregate functions
• How to create well-structured summary reports and insights

Module 11: Groups

• Techniques for creating groups and grouping data effectively
• Utilizing the Group By functionality in data processing
• Understanding when and how to use groups for better analysis

Module 12: Parsing the Data

• Learning how to parse and split data into usable formats using parsing tools
• Techniques for text manipulation and parsing entries for better data quality
• Practical applications of parsing in data preparation

Module 13: UI Elements in Alteryx

• Overview of user interface elements and their functions within Alteryx workflows
• Understanding the significance of UI design for creating user-friendly workflows

Tableau Section:

Module 14: Introduction to Business Intelligence

• Understanding the role of Business Intelligence in data analysis and decision-making
• Overview of the BI lifecycle and its significance in organizations

Module 15: Overview of Tableau Desktop

• Introduction to Tableau Desktop: layout, features, and purpose
• Understanding the Tableau interface and navigation

Module 16: Connecting to Data

• Techniques for connecting Tableau to various data sources, including relational databases and flat files
• Best practices for managing connections and understanding data refreshes

Module 17: Data Transformations

• Learning how to clean and transform data in Tableau before visualization
• Using Tableau Prep Builder for advanced data preparation tasks

Module 18: Calculations – Regular, Table Calculations, and LODs

• Introduction to calculations in Tableau, including basic calculations, table calculations, and Level of Detail (LOD) expressions
• Practical examples of using calculations to gain insights from data

Module 19: Using Filters and Sorting

• Implementing filters to refine data displays in Tableau visualizations
• Techniques for sorting data to enhance analysis and reporting

Module 20: Using Parameters

• Understanding parameters in Tableau and their applications
• How to create and implement parameters to enhance dashboard interactivity

Module 21: Groups, Sets, and Bins

• Learning how to create and use groups and sets in Tableau effectively
• Understanding bins and their role in data aggregation and analysis

Module 22: Maps

• Introduction to creating geographic visualizations using Tableau maps
• Techniques for displaying data on maps and understanding geospatial analysis

Module 23: Creating Visualizations

• Mastering various types of visualizations available in Tableau, such as bar charts, line graphs, scatter plots, and heat maps
• Best practices for effective data visualization design to communicate insights