20211007 Emergency mgmnt

Meeting Details

Date/Time/Location

Date
 
Time11:00-11:30
Location

Attendees


Meeting Goals and Expected Preparation

Goals

  • Check in on reporting status

Expected Preparation

  • None

Agenda

TimeTopicOwnerNotes and Details
2mReview report in ws_emergency management
https://app.powerbi.com/groups/9c2a46a5-3ac5-43f3-ad30-f29a62e9d52e/list/dashboards







Discussion

Tedi reviewed the report and would like the following:

  • Control point filter (slicer)
  • Department name filter (slicer)
  • Row Level Security to be defined in identity 
  • mobile design 
  • Filter on student vs staff.
  • job codes that identify student:
    • 002280
      002290
      004126
      004922
      004927
      009920
  • Add a Remote, non remote column based on campus location.  If remote then remote is yes else no

Visuals 

  • show the hierarchy (org chart) of the position
  • show the hierarchy (org chart) of the people

Data

There is an employee entity in the payroll dataflow in ws_payroll https://app.powerbi.com/groups/2fcbdce9-6670-4dc7-bca5-b98ded13dd36/list


Action Items

  • Alyssa Keehan (Unlicensed) - add new requests
  • Ann Crawford (Unlicensed) - figure out why people like Victoria do not show up in the report, vacant position of Victoria does not show up in the org tree and therefore Jordan's position which report to the vacant position does not show as well. It is important to have vacant positions listed to make sure all the report