Analytics Canvas Fundamentals

Learn the key concepts and get up to speed quickly with these short videos

Working with Data in Analytics Canvas

This course provides a foundation for marketers and analysts seeking to understand the core principles of data preparation and to improve business performance through data flow optimization.

Our free online training sessions are available whenever you are. Learn online at your own pace. If you can’t find the tutorial you’re looking for, write to us at or contact us through the site.

Analytics Canvas is a business intelligence software with data preparation capabilities and a big focus on Google Analytics. It falls into the category of ETL software, which stands for Extract, Transform, and Load.

Canvas allows anyone to extract detailed datasets from Google Analytics without writing code. It also connects to a number of other data sources, providing a single work-space for analyzing data from multiple sources and creating report workflows that are repeatable with the click of a button.

View Course Page



Getting Started with Data Preparation

The sheer volume of data combined with its high level of complexity, have made it challenging if not impossible to continue to rely on traditional data preparation tools, such as Excel spreadsheets, to make decisions.

The sheer volume of data and the importance of accurate, consistent, frequent reporting that does not involve IT has given rise to self-serve data preparation tools like Analytics Canvas.

View Course Page

Importing Data from Databases and Files

Importing data from APIs

An overview of connecting to your data in Google Analytics. This tutorial includes authorizing Canvas as well as selecting dimensions and metrics to import.

View Course Page
Connecting to internal and external data sources.

View Course Page
How to import data from Text and CSV files.

View Course Page

Data Exploration

An overview of the data exploration features in Analytics Canvas, including the Data Viewer, Data Profiler, and Data Chart. You won’t find these tools in Excel!

View Course Page
Functions allow you to transform data, perform calculations, clean data, and more. Learning how to use functions in Canvas will allow you to take full advantage of the various transformation blocks.

View Course Page
An in-depth overview of using various functions in Canvas, along with a discussion of when to use functions and the blocks that use them.

View Course Page
An overview of frequently used functions to help you quickly get up to speed.

View Course Page

Data Transformation

Perhaps one of the most powerful transformation blocks, the Calculate block allows you to add or remove columns from your data set and perform a wide variety of calculations on your data.

View Course Page
More than just finding the sum of a column, this powerful block can be used to remove duplicates, find max and min values in a date range and so much more.

View Course Page
Combine data from various tables into a single data set.

View Course Page

Exporting Data

The Run buttons allow you to preview your results and export them to databases and files.

View Course Page
Learn how to setup an Excel export block and how to drop data into specific ranges.

View Course Page


Automate routine and mundane data tasks, automate dashboards, automate incremental loads to databases. This tutorial shows you how to automate whatever it is you’ve designed your Canvas to do.

View Course Page

Tips for Beginners

A quick look at editing your SQL query.

View Course Page

Exercises & Course Conculsion

Suggested excercises to help familiarize yourself with the import procedure.

View Course Page