1. Course Introduction


In this lesson, we'll get a brief introduction into what we'll be covering in this course.

To explore more Kubicle data literacy subjects, please refer to our full library.


  1. Inputting and Outputting Data (00:15)

    This course focuses on different ways we can bring data into our workflow and ways we can export that data out of Alteryx. We covered the basics of this in other courses, but we’ll focus on more specialized methods in this course.

  2. Course Structure (00:25)

    This course has 4 main components.

    In the first part, we learn how to use the Dynamic Input tool to input and unions multiple files or Excel sheets at once. This is useful when we have a large number of files or sheets or when we have data that gets regularly added to.

    The second part covers the Alteryx gallery. This is a place where we can share our workflows with the wider Alteryx community. Organizations can also have their own private galleries where solutions are centralized into one space.

    In the third part, we learn how to use Alteryx’s reporting tools. These tools can be used to quickly generate reports that can be produced at scale.

    In the fourth part of this course, we learn how to output our data into a format that can be used more effectively with Tableau and Power BI.


In this course, we'll focus on varying tools and techniques that can be applied both at the beginning and end of an Alteryx workflow.

This includes ways to input data at the beginning stage of an Alteryx workflow, to methods to complete our workflow, and then save it.

In addition, we'll demonstrate ways in which Alteryx is compatible with other tools, such as Tableau and Power BI.

This course will start with a focus on inputting data at scale. This is useful when we need to connect to a large volume of separate data sets. We'll then move on to interacting with the Alteryx Gallery. This is an online repository we will use to both download workflows hosted in the gallery and share our work with colleagues and collaborators. We'll then shift our focus to generating reports. We'll use Alteryx's reporting tools to create a document that can be updated almost as quickly as our data is.

Finally, we'll move on to specialized tools for connecting to Tableau and Power BI. These tools allow for a seamless integration of Alteryx with two of the most commonly used BI applications.

We'll start in the next lesson by learning how to connect to a directory.