Data Prep Tools for Data Analysts
Connect to data, explore it, clean it, create data sets, and automate data pipelines.
Industrial Strength Google Analytics Connector
Made for those serious about Google Analytics.
Get all of your data from the Google Analytics and Google Analytics 360 APIs through a graphical user interface – no coding required!
- Eliminate both forms of Google Analytics data sampling
- Combine data from multiple accounts, properties and views
- Load Google Analytics data into local databases and cloud data warehouses
- Automate Google Analytics downloads to Excel
Data connectors for APIs, files, and Databases
Connect to multiple data sources for routine reporting or ad-hoc analysis. Canvas lets you read from and to the most popular data sources, including Google Analytics, Google AdWords, Google Search Console, Bing Ads, Excel, Access, CSV, Microsoft SQL Server, Oracle, MySQL, PostgreSQL, Google BigQuery, Google Sheets, and more.
Data workflow builder
Design your workflow visually with a drag-and-drop editor that makes your reports easy to follow and easy to audit.
Add steps for extracting raw data, combining data sets with simple unions or cross-database joins, performing calculations, rank operations, data profiles, and various other data transformation tasks, then define your exports.
When your jobs are run, Canvas will apply the same business rules each time, ensuring your reports are consistent and free from human errors.
Self-serve data prep tools
Clean and repair data to eliminate incorrect information and data quality problems in Google Analytics and other data sources. Enrich data sets by combining them together, joining with reference tables, and quickly creating logical groups or segments to help with your analysis.
Move beyond the spreadsheet with software specifically designed for data analysts.
Publish to Tableau
Generate or append to Tableau Data Extracts, create fully packaged TWBX files, and publish datasets to Tableau server or online.
Canvas helps you automate your routine data tasks so that your Tableau dashboards are always up to date.
Email dashboards and datasets
Automate from end-to-end by emailing any file generated with Canvas, including dashboards and datasets, to colleagues and clients when a job is run.
Automate dashboards and reports
Eliminate repetitive processes and mindless cut and paste. Simply refresh your databases and run your reports with the click of a mouse or on a schedule you define.
Command line automation
Whether you’re loading historic data from hundreds of accounts to your SQL Server database, or churning out multiple instances of a report for various websites, Canvas lets you perform advanced automation tasks to eliminate repetitive tasks and enhance your productivity.
Trigger Canvas from your favourite scheduling app or from another ETL tool for seamless integration into your existing BI infrastructure.
Secure connections to your data
On-site, desktop installation with secure connections to internal systems and Google Analytics keeps your data in-house and satisfies the strictest of IT standards.
Unlike our competitors, with Canvas, your data does not pass through our servers and is never seen or stored by us.