Knowledge Base
Working with Data
How to clean, prepare, and profile your data for reporting and analysis. Includes tutorials on using the Calculate, Filter, Summarize, Combine and Join blocks.
[Desktop] – How to use the Data Profiler Block
Next >> << Prev Data Profiler Block – tutorial transcript Welcome to the Data Profiler Block tutorial. This tutorial aims...Examples of Using Functions
Next >>[Desktop] Frequently Used Functions
Next >>[Desktop] How to use the Calculate Block
Next >>[Desktop] How to use the Combine Block to Union or Merge data sets
Next >>[Desktop] How to use the Filter Block
Next >>[Desktop] How to use the Join Block
Next >>[Desktop] How to use the Mapped Combine Block
Next >>[Desktop] How to use the Pivot Block
Next >>[Desktop] How to use the Rank Block
Next >>[Desktop] How to use the Segment Block
Next >>[Desktop] How to use the Sort Block
Next >>[Desktop] How to use the Summarize Block
Next >>Introduction to Functions
Next >>[Desktop] – Organize your workflow with Sub-Canvases
Next >> << Prev Organize your workflow with Sub-Canvases – tutorial transcript Welcome to the Using Sub-Canvases tutorial. This is...[Desktop] – Run Buttons
Next >> << Prev Run Buttons – tutorial transcript Welcome to the Run Buttons tutorial. This tutorial aims to give...[Desktop] – Using Block Groups
Next >> << Prev Using Block Groups – tutorial transcript Welcome to the Using Block Groups tutorial. This is one...[Desktop] – How to perform calculations and transformations
Tutorial 3- Calculations and transformations (2:52)[Desktop] – How to use filter and segmentation blocks
Tutorial 5- Filters and Segmentation with a keyword segmentation example. (3:14)[Online] – How To Use The Data Profiler
How To Use The Data ProfilerProfiling data helps to identify data quality issues that will affect reporting and analysis. It...[Online] – How To Use The Filter Block
How To Use The Filter BlockThe filter block evaluates an expression as either True or False, then sorts the data...[Online] – How To Use The Calculate Block
How To Use The Calculate BlockThe Calculation Block allows you to: Perform column based calculations Add or remove columns from...[Online] – How To Use The Summarize Block
How To Use The Summarize BlockThe summarize block allows you to perform aggregations on the data depending on the data...[Online] – How To Use The Union Block
How To Use The Union BlockThe Union block, also known as the Combine block, simply appends data sets together (inserts...[Online] – How To Use The Join Block
How To Use A Join BlockIf you’re used to using spreadsheets, a join is similar to a Vlookup where you...[Online] – How to use the Sort block
How to use the Sort BlockSorting data can help the analyst to better understand the data in the data set....Smart Tables
What are Smart Tables in Analytics Canvas?Smart Tables are tables that are either created within Analytics Canvas Online using the Table...Need Support?
If you need any further help, don't hesitate to send a support request to our support team.
Contact Support