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 support@analyticscanvas.com 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

.

what-is-analytics-canvas

In this Course:

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
why-use-data-prep-tools

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
google-analytics
Connecting to internal and external data sources.

View Course Page
importing-data

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
data-exploration
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
using-functions

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
calculations
Combine data from various tables into a single data set.

View Course Page
combine

Exporting Data

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

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

View Course Page
export-to-excel

Automation

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
report-automation

Tips for Beginners

A quick look at editing your SQL query.

View Course Page
how-to-edit-an-sql-query

Exercises & Course Conculsion

Suggested excercises to help familiarize yourself with the import procedure.

View Course Page