Köszönjük, hogy elküldte érdeklődését! Csapatunk egyik tagja hamarosan felveszi Önnel a kapcsolatot.
Köszönjük, hogy elküldte foglalását! Csapatunk egyik tagja hamarosan felveszi Önnel a kapcsolatot.
Kurzusleírás
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
Követelmények
- 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 Órák
Vélemények (3)
Ossza meg az alkalmazási példát
Kurzus - Alteryx for Data Analysis
Gépi fordítás
Teljesen világosan kifejezve és magyarázva
Harshit Arora - PwC South East Asia Consulting
Kurzus - Alteryx for Developers
Gépi fordítás
Lineáris regresszió - az algoritmus a trend előrejelzéséhez
Vincent Ko - UBS
Kurzus - Data Preparation with Alteryx
Gépi fordítás
