Agenda
Aggregate and Analytic Expressions in PS Query
Track: Technical and Reporting
Session Number: 9770
Date: Mon, Feb 27th, 2023
Time: 4:00 PM - 5:00 PM
Description:
In this presentation we will look at aggregate and analytic expressions in PS Query. We will cover basic aggregates as well as LISTAGG. Analytic expressions provide a wealth of possibility. We will look at OVER, PARTITION BY, ORDER BY, ROW NUMBER, RANK and DENSE RANK and see the possibilities provided by PS Query are more than just lists.
Sub-Categorization: User Experience
Session Type: Presentation
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1598
ERP Systems: PeopleSoft
Platform Type: Cloud
Target Audience: Technical
Knowledge level: Intermediate
Tell us about you!: As the Data Analytics Instructor for the Washington State Board for Community and Technical Colleges it is my job to ensure that our college query developers have the knowledge, skills and tools they need to create amazing queries. I have been a software instructor/instructional designer for over 20 years working for companies such as SAP, Citrix, Emerson Network Power and Providence Health and Services before taking my current position with the State Board. I have worked with many different ERP platforms and have 5 years experience as a Business Analyst in addition to my training background. I thrive on helping others achieve the highest level of success in their jobs and in helping to make those jobs easier!
Sub-Categorization: User Experience
Session Type: Presentation
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1598
ERP Systems: PeopleSoft
Platform Type: Cloud
Target Audience: Technical
Knowledge level: Intermediate
Tell us about you!: As the Data Analytics Instructor for the Washington State Board for Community and Technical Colleges it is my job to ensure that our college query developers have the knowledge, skills and tools they need to create amazing queries. I have been a software instructor/instructional designer for over 20 years working for companies such as SAP, Citrix, Emerson Network Power and Providence Health and Services before taking my current position with the State Board. I have worked with many different ERP platforms and have 5 years experience as a Business Analyst in addition to my training background. I thrive on helping others achieve the highest level of success in their jobs and in helping to make those jobs easier!
Speakers
Primary Presenter
Paula McDaniel
Data Analytics Education and Learning Instructor
Washington State Board for Community and Technical Colleges
