Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

banner-img

Course Skill Level:

Foundational

Course Duration:

3 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    Big Data & Data Science

  • Course Code:

    LALTERL21E09

Who should attend & recommended skills:

Developers, business analysts, data analysts

Who should attend & recommended skills

  • This course is geared for experienced developers, analysts or others who wish to implement business intelligence solutions without any coding – by leveraging the power of the Alteryx platform.
  • Skill-level: Foundation-level Alteryx skills for Intermediate skilled team members. This is not a basic class.
  • Data analytics: Basic (1-2 years’ experience)

About this course

Alteryx, as a leading data blending and advanced data analytics platform, has taken self-service data analytics to the next level. Companies worldwide often find themselves struggling to prepare and blend massive datasets that are time-consuming for analysts. Alteryx solves these problems with a repeatable workflow designed to quickly clean, prepare, blend, and join your data in a seamless manner. This course will set you on a self-service data analytics journey that will help you create efficient workflows using Alteryx, without any coding involved. It will empower you and your organization to take well-informed decisions with the help of deeper business insights from the data. Starting with the fundamentals of using Alteryx such as data preparation and blending, you will delve into the more advanced concepts such as performing predictive analytics. You will also learn how to use Alteryx’s features to share the insights gained with the relevant decision makers. To ensure consistency, we will be using data from the Healthcare domain throughout this course. The knowledge you gain from this course will guide you to solve real-life problems related to Business Intelligence confidently. Whether you are a novice with Alteryx or an experienced data analyst keen to explore Alteryx’s self-service analytics features, this course will be the perfect companion for you.

Skills acquired & topics covered

  • Working in a hands-on learning environment, led by our Alteryx expert instructor, students will learn about and explore:
  • The power of codeless analytics using Alteryx, a leading Business Intelligence tool
  • Hidden trends and valuable insights from your data across different sources and make accurate predictions
  • Real-world examples to put your understanding of the features in Alteryx to practical use.
  • Creating efficient workflows with Alteryx to answer complex business questions
  • How to speed up the cleansing, data preparing, and shaping process
  • Blending and joining data into a single dataset for self-service analysis
  • Writing advanced expressions in Alteryx leading to an optimal workflow for efficient processing of huge data
  • Developing high-quality, data-driven reports to improve consistency in reporting and analysis
  • Exploring the flexibility of macros by automating analytic processes
  • Applying predictive analytics from spatial, demographic, and behavioral analysis and quickly publish, schedule
  • Sharing your workflows and insights with relevant stakeholders

Course breakdown / modules

  • Installation and setup
  • The Alteryx Designer architecture
  • Introduction to Alteryx Designer
  • An overview of the workflow configurations
  • Exploring the Tool Palettes
  • The Favorites tools

  • Resource optimization and speed processing
  • Performance Profiling
  • Connecting to data
  • Alteryx file types

  • Data preparation
  • Data cleansing
  • Filtering
  • Join and union

  • Formula
  • Multi-Row Formula
  • Multi-Field Formula

  • Transforming data
  • Summarizing and aggregating data
  • Running total
  • Weighted average

  • Text to columns
  • Converting strings to dates and dates to strings
  • Regular expressions

  • Data Table
  • Charting
  • Reporting layout
  • Sharing the report

  • Standard Macro
  • Batch Macro

  • Alteryx Server
  • Alteryx Analytics Gallery

  • The ultimate guide to workflow design
  • Tips and tricks