Agenda

UNION MADE! - A Step-By-Step Guide to Writing Your First Union in PSQuery - PART 2

Track: Technical and Reporting

Session Number: 9887
Date: Tue, Feb 28th, 2023
Time: 10:30 AM - 11:30 AM

Description:

PSQuery’s Union rules can be extremely frustrating, even for intermediate users. But most of them can be circumvented or overcome once you learn the tricks. In the second session of this 2-part series, you will learn (in plain non-technical terms that even a Functional Analyst can understand): How to create queries with multiple Union levels
The common PSQuery Error messages you’ll see, and what they mean
The importance of aligning your fields
How to cheat, uh.. work around PSQuery’s rules and make that Union work for YOU!
Expressions: The Shop Stewards of Union-ized queries can be VERY useful
SQL operators <OR> what to do when PSQuery goes on strike
How much Mtn. Dew the presenter consumes in two hours (hint: he's a Data Analyst)
This session is intended for non-technical and semi-technical users. Specifically Functional Analysts, Operations Analysts/Techs, Managers, Junior Data Analysts, etc.

This is Part 2 of a two-part series. Part 1 is session #9549.

This session is part of the Back to Basics Pathway.
Sub-Categorization: Best Practices, Automation, Dev Ops
Session Type: Presentation

Session Length: Two-Part Series (2-60 min)
Cross Listed Areas: trk-1596, trk-1595, trk-1597, trk-1599, trk-1592, trk-1593
ERP Systems: PeopleSoft
Platform Type: Hybrid
Target Audience: All
Knowledge level: Intermediate
Tell us about you!: Current Position:
Data Analyst-Human Resource Information Systems (I primarily support the FAs with large or time-sensitive projects)

Education:
B.A., Business Administration & Behavioral Science, Oglethorpe Univ., 1994
HEUG Presenter Certification: 1 of 4 completed so far
CompTIA Data+: actively pursuing certification

Side Projects:
I build parade floats, holiday lights displays, and animatronics. Past works include a self-erecting "Ice Palace" parade float with over 10,000 choreographed lights, and a 30 ft long, 1350 lb, dragon-themed tricycle named SMOG. I also create step-by-step videos on YouTube. One of my videos has exceeded 175,000 views.
Sub-Categorization: Best Practices, Automation, Dev Ops
Session Type: Presentation

Session Length: Two-Part Series (2-60 min)
Cross Listed Areas: trk-1596, trk-1595, trk-1597, trk-1599, trk-1592, trk-1593
ERP Systems: PeopleSoft
Platform Type: Hybrid
Target Audience: All
Knowledge level: Intermediate
Tell us about you!: Current Position:
Data Analyst-Human Resource Information Systems (I primarily support the FAs with large or time-sensitive projects)

Education:
B.A., Business Administration & Behavioral Science, Oglethorpe Univ., 1994
HEUG Presenter Certification: 1 of 4 completed so far
CompTIA Data+: actively pursuing certification

Side Projects:
I build parade floats, holiday lights displays, and animatronics. Past works include a self-erecting "Ice Palace" parade float with over 10,000 choreographed lights, and a 30 ft long, 1350 lb, dragon-themed tricycle named SMOG. I also create step-by-step videos on YouTube. One of my videos has exceeded 175,000 views.

Speakers

Primary Presenter
Scott D Frey
Data Analyst - Human Resource Information Systems
University of Colorado