Performance optimization

Data Manipulation in Alteryx

Behrang Behjoo

Business Intelligence (BI) Leader

What is performance optimization?

$$$$

  • Efficiency and speed of workflows
  • Reduce processing time and resource consumption
  • Identify bottlenecks

$$$$

man running in gears

Data Manipulation in Alteryx

Performance bottlenecks

$$$$ Points in flow that cause delays:

  • Large datasets
  • Complex calculations
  • Inefficient design

$$$$

traffic lights and analysis illustration

Data Manipulation in Alteryx

How to spot bottlenecks

$$$$

  • Data volume
    • Long data load times.
  • Tool-specific
    • Overuse of resource-intensive tools.
  • Workflow design
    • Areas with excessive branching or complex tool sequences.
  • Resource management
    • Monitor system resource usage during workflow runs.

man with magnifying glass following trail

Data Manipulation in Alteryx

Data volume optimization

piechart made out of poeple

Data Manipulation in Alteryx

Data volume optimization

table and alteryx filter tool

Data Manipulation in Alteryx

Data volume optimization

two tables with alteryx filter and select tools

Data Manipulation in Alteryx

Tool selection and optimization

$$$$

Selecting the right tool for the job

  • Most efficient tool for the job (e.g. join tool for combining data on key)

  • Combining multiple calculations in one tool (e.g. summarize tool for multiple aggregations)

$$$$ different tools on a table

Data Manipulation in Alteryx

Workflow design best practices

$$$$

Best practices to adopt

  • Minimize number of tools
  • Logical data flow
  • Consolidate tasks

$$$$

man and woman processes mapping

Data Manipulation in Alteryx

Resource and network management

$$$$

  • Balancing usage of memory, CPU, and disk resources
  • Leveraging cloud computing resources
  • Using Alteryx proprietary format (e.g .yxdb)
  • Caching data locally

$$$$

working in a lab

Data Manipulation in Alteryx

Let's practice!

Data Manipulation in Alteryx

Preparing Video For Download...