Skip to main content

Enterprise Analytics

MIEA > Enterprise Analytics > About EA > QlikView Application List

QlikView Application List

Application

Owner

Description

Absence Balance Application Mohseni, Mina This application displays details of absence balances, earned balances, and days taken off.
Academic Analytics Dashboard* Schuette, Matthew This application is a PhD program analysis using Faculty Scholarly Productivity data and metrics as computed by Academic Analytics, Inc. (AA) using rosters of our faculty vetted and submitted by us annually.  The Dashboard provides yearly trends on various metrics for each PhD unit within their program taxonomy as well as replicating AA graphics such as productivity radar, productivity gauge, and program box plots available in their own BI portal.
Accounts Receivable Application Long, Brett This application provides reporting on both aging of current receivables and transactions in queue to run through the monthly billing process.  The associated transactional information is also available in the application.
ACE Student Dashboard Long, Brett This application shows both the pre-admission information (MCAT Scores, GPA, etc.) and post-admission information (course grades, exam scores, etc.) for MD students.  The application also shows how students compare to other groups of students (based on start year, grad year, campus, etc).
Cash Flow Application Long, Brett This application shows both the current Fiscal Year financial reporting and projected year-end balances for all speedtypes within area, sub-area or department.  Note: This application only available to those groups who have signed up for and are using the associated Excel tool (Monetary Forecasting Tool) created by Enterprise Analytics.
CT - Executive Disclosure Lookup This application tracks all disclosures the IRB department manages, searchable by disclosure responsibilities and relationships within the disclosure.
CT - IRB & COI Detail Mohseni, Mina This application is an IRB Project lookup with details on IRB studies, including information regarding study team members, funding sources, associated drugs and devices involved in all IRB studies.
CT - Overall Review This application tracks clinical trial details and statuses, as well as monitor timelines associated with each step from the initial notice of study received thru the closing of the clinical trial.
Employee Engagement Survey Applications Long, Brett These applications analyze the results of the FY14 vand FY15 Employee Engagement Surveys.
Employee Position Application Long, Brett This application has 4 main views showing both current and historical information at the employee or position level:  1) Position Information (Dates, Department, Title, FTE, Salary);  2) Permanent Budget Information by Speedtype;  3) Payroll Information by Speedtype;  4) Annual Compensation History.
EVC Monthly Financials* Long, Brett This application provides current Fiscal Year financial reporting for both Controlled Funds and Self-Funded Speedtypes.  The application also provides access to the transactional level detail behind the reporting (with the ability to explore and filter it).
Facilities Management Bushaw, MariLynne This application provides detailed reporting of budget and actual transactions of the Facilities Management (FM) organization by customized expenditure categories (defined by FM).
Faculty Affairs Schuette, Matthew This application shows current and historical faculty rosters based on data currently available in HR PeopleSoft, including education and tenure data.  There is also a page showing active faculty counts.
Grant Forecasting Tool Long, Brett This application shows both the current financial reporting and projected project-end balances for all GRANT speedtypes within area, sub-area or department.  Note: This application only available to those groups who have signed up for and are using the the associated Excel tool (Grant Forecasting Tool) created by Enterprise Analytics.
JayDocs Novak, Tim This application provides detailed level view of all events that have been captured within Jaydocs back through 2011.  As the OME transitions to OASIS in 2017, we will incorporate the two data streams to provide consistent data going forward.
KUMC Analytics Bushaw, MariLynne This is Enterprise Analytics oldest and most used application.  The application includes the following content:  1) Replicates PeopleSoft AM90/91 reports identifying speedtype budget, revenue/expense charges, open encumbrances, and available balance;  2) Employee level payroll reporting;  3) Access to KUEA transactions and account balances;  4) Access to SOM commitments and associated fulfillment transactions;  5) Summary grant reporting (counts and dollars) by year and funding source.  Research proposal lists with key personnel, award periods, amounts, and effort.
KUMC Billing Analytics Novak, Tim This application provides breakdown of invoices for both internal and outside billing.
KUMC Enroll and Pay Bushaw, MariLynee This application tracks student and corporate payments and refunds.  In addition, it captures Campus fee collections and their department allocations.
KUMC Parking Garage Novak, Tim This application provides analytics for the paid parking garages.  It includes breakdowns by attendant, coupon type, and occupancy rates for ticket counts/revenue.
KUMC Research Efforts - Other Support Schuette, Matthew This application can be used to produce and export "Just-in-Time" reporting for research investigators.  It also has tabular data on investigator research effort, current and pending, as well as a separate historical view of projects by investigator that would show past awards or unfunded projects.
KUMC Space Facilities* Bushaw, MariLynne This application contains Mapcom building and room information merged with PeopleSoft financials, Maximo work orders, and unit cost estimates/factors to calculate campus facility rates. 
KUMC Space Research Bushaw, MariLynne This application captures Mapcom building and room information in addition to research proposal awards and expenditures in an effort to analyze research productivity.
KUMC Space Rooms Bushaw, MariLynne This application contains Mapcom building and room information in addition to Audit reports of Mapcom data entry.
KUMC_Student_Enrollment Schuette, Matthew This application tracks student enrollment, with reports for grades, instructor information, student and class details, and access to the 20th day report information.
NIH Ranks Schuette, Matthew This application uses frozen annual data from NIH RePORT post-data validation from Blue Ridge Institute for Medical Research to calculate overall rankings on NIH funding to schools of medicine, nursing, and allied health, and various departments within medical schools.  Public rankings created by Enterprise Analytics are provided in the application.  Also included are various tables and charts showing award totals, funding amounts, and rankings. 
Parking Survey Mohseni, Mina This application displays the results of the Parking Survey administered in Summer 2016.
Payroll Trending Application Mohseni, Mina This application examines payroll trends (average earnings, newly paid employees, employees falling off payroll, etc.).
Permanent Budget Application Long, Brett This application shows both the permanent budget summary and the transactional detail behind it.  It is drillable down to the speedtype or position level.
Research Institute Bushaw, MariLynne This application provides summary and detail reporting of RINST administration (and subsidiary) revenues and expenses as found in Sage/MIP.
Research Institute KUIC Bushaw, MariLynne This application provides Sage/MIP transaction detail of the University of Kansas Innovation and Collaboration (KUIC) center.
Training And Compliance Review Novak, Tim This application reviews training by employee for data contained in TLC, CITI, Compliance and Blackboard.
* Application still in development or distribution process.
Last modified: Sep 20, 2018
ID=x29049