Monday, March 14
Understanding Query Security
Session Description: “This presentation is designed to provide basic information on how query security works. It is not only for security administrators, but for all users of PeopleSoft Query. It is intended to give a high level overview to help achieve a solid foundational understanding of how queries are locked down by role. This session is part of the Back to Basics Pathway.”
Presenter: Paula McDaniel, Washington State Board for Community and Technical Colleges
Session: 8688
Time: 8:30-9:30 AM
Outer Join Schoumter Join ... Demystifying the Left Outer Join
Session Description: “Outer Join Schoumter Join … Demystifying the Left Outer Join
- For sanity sake … am going to refer to is as an outer join (this is an apolitical presentation)
- What is an outer join?
- When to choose the outer join?
- The On Clause v. the Where Clause
- An effective date criteria has been automatically added for this effective dated record….
- Optional prompts and the outer join
- Hey this is cool … the Yes/No Table Prompt and the outer join
- “Error in running query because of SQL Error, Code=904” …. UGGGGGGGHHHHH!!!!
- Sub queries on the on clause
- Is null / Is not null (what’s the goal !!!!)
- What is null, anyway???
- Got the perfect query then realize that my outer join should have been a standard join … any options???
- Got the perfect query then realize that my standard join should have been an outer join … any options??? (Hint … maybe a glass of wine). This session is part of the Back to Basics Pathway.”
Presenter: Robert Fogarty, The Pennsylvania State University
Session: 8561
Time: 10:00-11:00 AM
Get Started with Microsoft Power BI Desktop - Build Your First Visualization
Session Description: “Microsoft Power BI Desktop is a free application that lets you connect to, transform, and visualize your data. In this presentation, I will walk you through how to download and install Power BI Desktop, use Power Query to connect data from various sources, clean, transform and reshape data in order to meet our data analysis needs. Power Query works across several Microsoft products, so whatever you learn for Power Query in Power BI can be applied to Excel and other products. So, it is good to know Power Query. There will be a live demonstration to show you step by step to create a report and a dashboard for data visualization. How excited you will be to create your first visualization using Power BI Desktop - a powerful business intelligence tool to visualize and analyze your data!”
Presenter: Yau Lau, UW Extended Campus
Co-Presenter: Bobbie Jo Weber, University of Wisconsin - Milwaukee
Session: 8654
Time: 10:00-11:00 AM
Become a Connected Query & BI Publisher Expert in a Flash - PART 1
Become a Connected Query & BI Publisher Expert in a Flash - PART 2
Session Description: “Connected Query and BI Publisher in PeopleSoft are very powerful technologies for generating reports, but it's not easy to know where to get started. Have you harnessed the power of either technology yet? In this two-part presentation, we'll explain the purpose of each technology, and then go through live demonstrations on how to relate child queries to their parent query in Connected Query, design report templates in Microsoft Word, run BI Publisher reports, when to use programming code for more powerful reports, and other tips and tricks learned over the years. Whether you are a beginner or intermediate user, functional or technical, it doesn't matter -- this presentation is geared for everyone to put you on the path to becoming an expert in no time. More specifically, these are some of the topics that will be covered:
- Showing the final version of a BI Publisher report covered in the deep dive so the audience can see the result, and then later understand how the report was developed
- The concept of parent/child queries
- Relating these queries to each other in Connected Query
- Using the XML output from the Connected Query as sample data when designing the report template
- Designing the report template in Microsoft Word, including inserting individual fields, handling fields with multiple rows, formatting the template, etc.
- Defining and running the BI Publisher report in PeopleSoft
- Basic programming that can be used for things like storing variables, performing calculations on variables, and using if-then-else logic
- Additional tips and tricks based on frequently asked questions users have inquired about in the past
Attendees are encouraged to bring a laptop so they may work hands-on with one or more of the demonstrations. However, attendees can also choose to just follow the presenters' live demonstrations. This is a 2-part series session: Part 1 (8510) and Part 2 (8967).”
Presenter: Christopher Pokorny, Cleveland State University
Session: 8510, Part 1
Time: 2:00-3:00 PM
Session: 8967, Part 2
Time: 3:30-4:30 PM
Don’t be (Visual) Basic, Excel at the Macro-level
Session Description: “Do your Excel Spreadsheets look like they've been through a twister? Are you crushed underneath the house of manual adjustments? Somewhere over the rainbow, there must be a better way! It turns out, you've always had the power…you have to learn it for yourself. Travel to the Emerald City and take a peak behind the curtain at what wizardry Excel Macros and Visual Basic can reveal. If you're anything like me, you currently have at least a dozen Excel documents open on your computer. Whether from a PS Query output, SQL export, dashboard data extract, or any of a myriad other sources, Excel continues to be one of the primary ways we interact with data. Make the most of it by leveraging one of Excel's most powerful tools to its fullest. We'll address not just how to create a macro, but how to generalize and extend their functionality. This session is part of the Life Hacks Pathway.”
Presenter: Scott Nishizaki, Azusa Pacific University
Session: 8669
Time: 2:00-3:00 PM
Haiku: Query App Engines, Empower Your Functionals, Free Your Technicals (a PeopleSoft to Canvas story)
Session Description: “Come see how Washington State University uses App Engines with logic powered by PeopleSoft Queries to transform a complex, inflexible, and untrustworthy integration into a simple, flexible, and reliable solution that catapulted our Canvas LMS integration into a rock-solid production process. Limited technical resources are often a bottleneck. There are always more projects than developers. Using Queries driven by an App Engine, with log tables that enable functional troubleshooting, is a proven strategy that has freed up our tech team from countless hours of logic adjustments. We will demonstrate how to remove core logic and criteria from programming objects that require a developer, and put them into queries that functional staff and end users can build and maintain, thus freeing up tech resources for other projects. Developers build the app engine and log table framework on the front end, but are rarely involved in future logic changes. You will come away with both a high level understanding of increasing the power of queries with app engines, and detailed code examples of how to implement this simple but powerful strategy at your institution. As a bonus we will give three different REST web service solutions for syncing grades between Canvas and PeopleSoft with a push method from Canvas to PeopleSoft, and two pull methods from inside the PeopleSoft grade roster, using both enrollments and assignment submissions from the Canvas API.”
Presenter: Chad Jeffreys, Washington State University
Co-Presenter: Anden Lewis, Washington State University
Session: 8679
Time: 3:30-4:30 PM
Hakuna Kibana - Exploring Kibana Dashboards
Session Description: “Kibana is an open-source analytics and visualizations platform, to monitor and provide analysis on Search Framework and Elasticsearch. Kibana is being delivered with the Elasticsearch in the ELK stack DPK. Kibana is a Web application and works with Elasticsearch. Kibana provides visual reports in the form of charts, tables, etc. based on queries that you set up on Elasticsearch indexes. This session will start with an introduction of Kibana and how it ingests data from Elasticsearch indexes. We will dive into Installation, setup and Accessing Kibana Dashboards. We would Setup Applications Visualizations that are delivered with Oracle. As a bonus to the users will also go through creating new Application visualizations..”
Presenter: Gaurav Krishan Ohri, University of Texas at Arlington
Session: 8503
Time: 3:30-4:30 PM
Tuesday, March 15
Smells like Tuition Setup; Verify using Connected Query & BI Publisher
Session Description: “The main goal of this presentation is to illustrate ways that may be used for visual data analysis to help the audience to develop a strong foundation on information visualization. The FIRST PART of the presentation will cover the VOCABULARY and the basics of VISUAL ENCODING. The first objective of any visualization that is based on data is to provide the audience with the “vocabulary” to describe visualizations. Knowing the vocabulary is the necessary start for attempting to discern which designs are appropriate for answering a given question or solving a problem. The presenter will go over some of the most foundational of charts and graphs. This will serve to answer questions like: what charts are there, which charts are popular, which charts to use - why and when? Recommendations for embedding user-friendly tips and instructions for navigating dashboards will also be made. Please note that the tool the examples and simulations are based on is Tableau, but the principles may be applied across other data visualization applications. This is a 2-part series session: Part 1 (8538) and Part 2 (8968) This session is part of the Back to Basics Pathway.”
Presenter: Sarah Hoegger, University of Minnesota
Session: 8722
Time: 8:30-9:30 AM
The Basics of developing effective Information Visualizations - PART 1
The Basics of developing effective Information Visualizations - PART 2
Session Description: “The main goal of this presentation is to illustrate ways that may be used for visual data analysis to help the audience to develop a strong foundation on information visualization. The FIRST PART of the presentation will cover the VOCABULARY and the basics of VISUAL ENCODING. The first objective of any visualization that is based on data is to provide the audience with the “vocabulary” to describe visualizations. Knowing the vocabulary is the necessary start for attempting to discern which designs are appropriate for answering a given question or solving a problem. The presenter will go over some of the most foundational of charts and graphs. This will serve to answer questions like: what charts are there, which charts are popular, which charts to use - why and when? Recommendations for embedding user-friendly tips and instructions for navigating dashboards will also be made. Please note that the tool the examples and simulations are based on is Tableau, but the principles may be applied across other data visualization applications. This is a 2-part series session: Part 1 (8538) and Part 2 (8968) This session is part of the Back to Basics Pathway.”
Presenter: Anna Kourouniotis, Duke University
Session: 8538, Part 1
Time: 8:30-9:30 AM
Session: 8968, Part 2
Time: 10:00-11:00 AM
Query your query quarry quickly: Fun with PeopleSoft metadata tables
Session Description: “Much of the PeopleSoft application is stored in database tables, just like the data itself. A query writer can learn a lot of what's under the hood by learning what PeopleTools tables exist and how to use them. We'll look at a bunch of PeopleTools tables and some query examples illustrating how we can benefit from understanding them. Finally, we'll talk about the tables that store PS Queries themselves and what limitations there are to querying them. I'll share an example of how the metadata is probably a bit too "meta" for query research alone, and what we did about it.”
Presenter: Scott Douglas, Azusa Pacific University
Session: 8648
Time: 10:00-11:00 AM
Restructuring the Academic Advising Report for Effective Querying
Session Description: “Boise State has been unable to pull accurate data from the AAR tables/Analysis database due to the structure of our AAR setup. We have found how to restructure the AAR setup to be able to correctly connect the requirements and requirement groups to a student’s catalog to be able to then accurately pull that data from the database. This has been an on-going struggle since the implementation of the AAR at Boise State. This presentation will show how we originally structured the AAR, how we restructured the AAR, and how we can subsequently query the Analysis Database to see what requirements are fulfilled or not fulfilled per program, requirement, and student.”
Presenter: Susan Dennis, Boise State University
Session: 8621
Time: 11:30 AM-12:30 PM
Wednesday, March 16
Empower users to run their own queries with Delivered PeopleSoft Pagelets
Session Description: “Do your users want to run their own queries? Does it make you feel uneasy to open up Query Manager? Let's be honest - they may create the perfect Cartesian join to bring down the whole system! Well, this session is for you. This Quick Tip session will cover how The University of North Carolina at Chapel Hill has implemented a Query Workcenter using delivered PeopleTools functionality. 1) Users are empowered to run the queries they want... no more, no less. Business Analysts can maintain the setup and security from a simple configuration page. Join the session to get a step-by-step walk through and leverage what we learned!”
Presenter: Rajani Day, University of North Carolina at Chapel Hill
Session: 8540
Time: 10:45-11:15 AM
Using BI Publisher and Query to Create a Dynamic Award Letter
Session Description: “In this session attendees will learn how to create a letter using columns, tables and sums with BI Publisher along with utilizing queries to create dynamic fields that will no longer require yearly updates..”
Presenter: Alina Longoria, University of Houston System
Session: 8768
Time: 12:45-1:45 PM