Bedankt voor uw aanvraag! Een van onze medewerkers neemt binnenkort contact met u op
Bedankt voor uw boeking! Een van onze medewerkers neemt binnenkort contact met u op.
Cursusaanbod
Introduction to Alteryx and the Designer Environment
- Overview of Alteryx Designer interface and workflow canvas
- Configuring workflows, tool palettes, and workflow properties
- Best practices for saving, documenting, and sharing workflows
Essential Data Preparation Tools
- Input Data and Output Data tools: connecting to CSV, Excel, and databases
- Select, Filter, Sort, and Browse for quick data inspection and pruning
- Practical exercises: cleansing a sample dataset
Basic Data Transformation
- Formula tool for calculated fields and conditional logic
- Data Cleansing: handling nulls, trimming, and standardizing values
- Text to Columns and parsing delimited fields
Simple Data Combination
- Join and Union for combining datasets
- Summarize for aggregation and roll-ups
- Hands-on: building an end-to-end ETL workflow
Advanced Data Blending and Parsing (Intermediate)
- Blending multiple data sources and file formats effectively
- Parsing semi-structured data: XML and JSON basics
- Techniques for validating and normalizing blended data
Basic Analytical Tools and Reporting
- Find Replace, Cross Tab, and Transpose for reshaping data
- Creating simple reports and exporting results
- Case study: generating a summarized operational report
Introduction to Macros and Reusability
- Types of macros: Standard Macros and when to use them
- Creating, testing, and packaging a reusable macro
- Deploying macros within workflows to simplify processes
Workflow Automation Best Practices
- Organizing workflows with containers and annotations
- Error handling, logging, and scheduling considerations
- Practical exercise: automating a recurring data preparation task
Summary and Next Steps
Vereisten
- An understanding of basic data concepts and spreadsheets
- Familiarity with CSV/Excel file formats
- Basic analytical thinking and problem-solving skills
Audience
- Data analysts and business analysts
- ETL practitioners and operations staff
- Users responsible for automating routine data tasks
14 Uren
Getuigenissen (3)
Deel voorbeeld van toepassing
Cursus - Alteryx for Data Analysis
Automatisch vertaald
Duidelijk gearticuleerd en uitgelegd
Harshit Arora - PwC South East Asia Consulting
Cursus - Alteryx for Developers
Automatisch vertaald
Lineaire regressie - het algoritme om de trend te voorspellen
Vincent Ko - UBS
Cursus - Data Preparation with Alteryx
Automatisch vertaald
