Join us for our first crossover event - newcomers and mid career professionals are invited to meet one another and discuss topics from the perspectives of both roles. more info...
This workshop will discuss how to develop a dashboard template in Tableau. We will discuss how the University of Maryland, College Park designed its campus report template, built the template, and administers it across campus. The University has developed over 100 reports with this template, ranging from simple tables to more complex, interactive dashboards. Attendees will leave the session with guidelines on how to approach designing their own Tableau dashboard template. This session is geared towards intermediate Tableau users and adventurous beginners. Presenters: Danielle Glazer (University of Maryland), Tom Dobrosielski (University of Maryland)
Much of the data-related work in institutional research involves data manipulation, data visualization, and repeated reporting. R, a free and open-source programming language, handles all of these tasks with ease and allows you to streamline and automate your entire project. R can help develop a robust data infrastructure by codifying everything from common presentation graphics to reporting requirements and definitions. No previous experience with R is necessary for this workshop, which will introduce R's capabilities and demonstrate how it can be used to create reproducible workflows for common institutional research tasks, such as preparing submissions for federal and consortial reporting. Presenter: Meghan Hall, Brown University
Are you looking for an automated way to clean and update data? If yes, Microsoft Access could be the solution. Microsoft Access is a powerful tool to review, clean, update, and manipulate data without needing to write code. When working with data that needs cleaned and analyzed regularly, spending time now creating the processes in Access has the potential to save hours of work later. By the end of the workshop, participants will have the knowledge to import data to Access, review a field of data for inconsistencies, update the data using append and update action queries, and create a form with buttons to run the queries and document the processes. Both an Access and Excel file with dummy data will be available to participants to create the tables, queries, and form during the session, if desired. A general understanding of tables, table relationships, and querying is suggested to get the most out of the workshop. Software Requirements: Microsoft Access, preferably 2019
Presenter: Christy King, PA State GEAR UP, Shippensburg University/PA State System of Higher Education more info...
