Agenda

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

Track: Technical and Reporting

Session Number: 9549
Date: Tue, Feb 28th, 2023
Time: 9:00 AM - 10:00 AM

Description:

Creating Unions in PSQuery can be an intimidating process, even for intermediate users. But it doesn't need to be. Once you know the rules, it's a matter of following a few simple steps. In the first session of this 2-part series, you will learn (in plain non-technical terms that even a Functional Analyst can understand): What is a query Union and what can it do for you? When should you use a Union rather than additional joins? Why not just write two separate queries and combine the reports in Excel? Basic rules for creating Unions (it's kinda like pipefitting, but less dirty.) Basic steps for creating your first Union in PSQuery. You CAN do this! I will show you how. How much Mtn. Dew the presenter consumes in one hour (hint: he's a Data Analyst) This session is intended for non-technical and semi-technical users. Specifically Functional Analysts, Operations Analysts/Techs, Managers, etc.

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

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