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.
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-1671, 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.
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-1671, 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.
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
