quilliup - Alpha to Omega
4.0 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
852 students enrolled

quilliup - Alpha to Omega

If you do not validate your data, you cannot treat it as an asset.
4.0 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
852 students enrolled
Last updated 8/2018
English
English [Auto-generated]
Price: Free
This course includes
  • 2.5 hours on-demand video
  • 22 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What you'll learn
  • Business users will be able to validate data and share results.
  • Capable data engineers will be able to automate testing and administer quilliup.

Requirements
  • An installation of quilliup is required.
  • An understanding of data and validations is required.
Description

quilliup is a data quality platform, running as a web application, which comprises multiple modules. Quality Gates, the main module, will be the focus of this course. Quality Gates increases and maintains data quality, decreases cycle time, and automates manual processes. Quality Gates has advanced alerting features and can integrate with any ecosystem, including those using other monitoring platforms like Splunk. The Quality Gates validation methodology consists of three steps: test, automate, alert. This course will guide you through every aspect of Quality Gates.

Future sections will illuminate the other modules in quilliup.

Who this course is for:
  • Business users, both technical and non-technical, interested in validating data.
  • Capable data engineers as part of their onboarding process.
Course content
Expand all 90 lectures 02:36:49
+ Introduction
6 lectures 09:54
Introduction to quilliup
00:47
Common pain points
03:43
Introduction to tests
00:51
Introduction to sources
01:18
Introduction to automation
01:21
Introduction to alerting
01:54
+ Quality Gates - Business User
17 lectures 44:42
Logging in and out of quilliup
00:57
Navigating
03:12
Understanding tests - the basic units of Quality Gates
00:57
Understanding test results
01:19
Sharing test results via email
04:11
Viewing email results
01:26
Exporting test results to Excel
00:40
Reviewing test results from prior executions
00:56
Understanding datasets
02:32
Creating datasets - relational or RDBMS based
01:57
Adding filters to datasets
01:41
Creating test metadata
02:54
Understanding data validation tests
03:19
Creating data validation quick rules
02:46
Creating data validation user-defined rules
05:01
Understanding data validation data profiling
01:21
Creating Data Validation tests
09:33
+ Quality Gates - Developer
41 lectures 01:22:47
Understanding tags
01:07
Understanding variables
03:41
Creating fixed variables
01:37
Creating dynamic variables - basic
04:26
Creating dynamic variables - intermediate 1
04:30
Creating dynamic variables - intermediate 2
03:19
Creating custom SQL datasets - relational or RDBMS based
01:12
Understanding Library VS Ad hoc (on the fly) datasets
03:53
Creating MongoDB datasets
00:00
Understanding test types
02:20
Understanding tests - intermediate
00:00
Creating custom tests
04:01
Understanding one way thresholds
03:24
Understanding thresholds - number of rows
01:44
Creating two way thresholds
02:30
Understanding Compare tests
06:03
Creating Aggregation tests
00:00
Updating test toolbox settings
03:16
Creating Raw Compare tests (Row level)
00:00
Logging results to a database catalogue table
03:21
Understanding summary and detail log tables
03:02
Creating Data Integrity tests (Referential Integrity)
00:00
Sharing test results via Slack
00:00
Creating KPI Range tests
02:39
Sharing test results via Splunk
01:37
Creating KPI Snapshot tests
00:00
Understanding versioning
01:53
Creating execution flow dependencies
01:40
Understanding execution flows
01:06
Creating execution flow loops (circularity)
01:37
Scheduling execution flows
01:47
Creating execution flow notes
01:08
Understanding scripts
01:01
Creating scripts - CMD in Windows
02:26
Creating scripts - CMD in Linux
01:20
Creating scripts - SQL Execute
02:01
Creating scripts - SQL Query
01:18
Understanding the monitor sidebar
00:51
Understanding the full monitor
04:14
Understanding the URL
01:22
Creating authentication tokens
01:20
+ Quality Gates - Administrator
9 lectures 09:54
Understanding data sources
01:06
Creating RDBMS data sources
02:35
Creating file data sources
01:51
Creating QlikView and Qlik Sense data sources
00:00
Creating API sources
00:00
Understanding projects
01:24
Creating roles
01:28
Managing project permissions
00:00
Creating tags
01:30
+ quilliup - Administrator
12 lectures 09:28
Understanding users - User Management
02:28
Creating groups - User Management
01:32
Creating application users - User Management
01:22
Understanding environments
00:00
Creating environments
00:00
Managing email settings
00:00
Managing email templates
00:00
Managing Slack settings
00:00
Managing Slack templates
00:00
Managing Splunk settings
00:00
Managing system properties
02:31
Creating network locations
01:34
+ Quality Gates - Completionist
5 lectures 00:01
Understanding the dashboard
00:00
Understanding the business dashboard
00:00
Creating data validation user-defined rules using JavaScript
00:00
Creating data validation SQL calculated columns
00:00
Understanding library rules
00:00