Campus Events Report

Table of contents

Introduction

The Campus Events Report is a collaborative effort between T&I, the College Union, and the Special Events Office. The report pulls its data from the EMS database and provides a high-level overview of events taking place around campus. This is designed to help employees see periods of high activity or special holidays that may affect their planning or the availability of certain spaces.

For example, an employee seeking to reserve spaces for a conference needs to be aware if it overlaps with Orientation Weekend, which drastically reduces the number of available spaces on campus. Or they may want to know whether a men's basketball game is scheduled on the same day, as that will affect the availability of parking around the Baker Sports Complex. The Campus Events Report is designed to make these sorts of scheduling complications easy to find so EMS users can plan accordingly.

 

CampusEventsReportinEMS_Play-01.png

Accessing this report

The Campus Events report is published to data.davidson.edu and is visible on the Home page, under the section labeled "Power BI Reports."

mceclip0.png

It can also be accessed from within the EMS application by clicking "Campus Events Report" under the LINKS section on the left-hand navigation panel.

mceclip1.png

How to use this report

The Campus Events report consists of two pages:

  • The Summary page provides an overview of the events scheduled to take place in a given period, as well as upcoming holidays and "critical dates" that may impact your planned EMS reservations.
  • The Detail page has a data table which lists the events scheduled to take place within a given set of search parameters.


Drillthrough navigation

Users can navigate from the Summary page to the Detail page using a button on the left-hand side of the Summary page, which will become enabled when making a selection from the among the visuals displayed on the page.

For example, a user can left-click on the "Rehearsal" row in the matrix visual to select that event type, which will enable the navigation button, causing it to turn green. At this point, the user can left-click on the button to drill through into the Detail page, where they can see all events classified as rehearsals.

 

2021-09-10_9-45-02.gif


Dataset

Data source(s)

Data source Data source type Connection mode
EMS Microsoft SQL Server Import


Refresh schedule

The data for this report refreshes hourly every day (Sunday thru Saturday), between the hours of 8:00 AM and 5:00 PM (ET).


Filters

Not all EMS events are visible in the Campus Events report. The following is a description of the ways in which the data in this report is filtered:

  • Cancelled events are excluded. EMS events with a status of "Cancelled" or "Web Cancellation" will not appear in the report.
  • Classes, private meetings, and athletic practices are excluded. EMS events with an Event Type of "academic class," "meeting - private", "practice - intercollegiate," or "practice - other" will not appear in the report.

 

Data governance

Data classification

The data in this report is classified as Internal use only. It may be freely shared with other Davidson users, but should only be shared with external or users or vendors with permission from a manager.


Security

This report is visible to all Davidson employees.


Helpful links

Exporting Data from Power BI Reports

Request Help