Program Level: Advanced 

This Kinetic course showcases Business Activity Query (BAQ) features that go beyond building simple queries. Create Intercept and Except queries that determine differences between two sets of data. Learn how to aggregate data into row and column matrices using the Advanced Group By and PIVOT features and generate hierarchical data using a Common Table Expression (CTE) subquery with recursion. Then pull data from outside Kinetic by creating an External Business Activity Query. The course is designed for learners who are familiar with BAQs and want to explore developing more powerful queries. 

Note: This session includes both Kinetic and Classic content. 

Cost: There is an additional $350 fee to attend this session. 

Objectives: 

• Create an Except business activity query 

• Create an Intercept business activity query 

• Create a query that uses an Advanced Group By clause 

• Understand how to use PIVOT table functionality 

• Use the Common Table Expression to display hierarchal data 

• Create an external business activity query that displays data outside of Kinetic 

Audience: 

• System Administrator 

• IT/Technical Staff 

Prerequisites: 

• Understanding of Business Activity Queries (BAQs)