Report Catalog
The report catalog provides authoritative data to support the Factbook and annual Impact Reports. The reports found in this catalog ensure data consistency, integrity, transparency and the ability to perform ad-hoc analysis through the use of the Tableau data visualization tool. These data are refreshed regularly and are managed by the Office of Organizational Effectiveness, Planning and Assessment as part of the “Operation Clarity” initiative that launched in the Spring of 2021. Reports are permission based. To access a report click on the View Report link in the Report Access column and follow the instructions.
as of Sept. 6, 2022
| Report Name | Status* | Years of Data | Report Access |
|---|---|---|---|
| Teaching Effort Guidelines | 9 - Diagnostic Review | 1.5 (2021 to Spring 2023) | View Report |
| Course Evaluations | 9 - Diagnostic Review | 5 (2018 to Present) | View Report |
| Course Delivery Efficiency | 9 - Diagnostic Review | 1.5 (2021 to Present) | View Report |
| Assessment Calendar (PharmD) | 9 - Diagnostic Review | 4 (2019 to Present) | View Report |
| Curriculum Topic Mapping (PharmD) | 7 - Stakeholder Review | 4 (2019 to Present) | Expected Q3 of 2023 |
| Survey Calendar | 3 - Exploration | 2 (2021 to Present) | Expected Q1 of 2024 |
as of Sept. 6, 2022
| Report Name | Status* | Years of Data | Report Access |
|---|---|---|---|
| Faculty Activity Planned Effort | 9 - Diagnostic Review | 2018 to Present | View Report |
| Externally Funded Proposals and Awards | 9 - Diagnostic Review | 2016 to Present | View Report |
| Faculty Salary Offset | 9 - Diagnostic Review | 2017 to Present | View Report |
| Publications and Citations | 9 - Diagnostic Review | 2018 to Present | View Report |
| Instructional Assignments and Effort | 9 - Diagnostic Review | 2021 to Present | View Report |
| Educator Evaluations | 9 - Diagnostic Review | 2018 to Present | View Report |
| Graduating Student Placement (PharmD) | 9 - Diagnostic Review | 2019 to Present | View Report |
| CBMC FY23 Budget vs. Actual Report | 9 - Diagnostic Review | July to Present | View Report |
| DPET FY23 Budget vs. Actual Report | 9 - Diagnostic Review | July to Present | View Report |
| DPMP FY23 Budget vs. Actual Report | 9 - Diagnostic Review | July to Present | View Report |
| DPOP FY23 Budget vs. Actual Report | 9 - Diagnostic Review | July to Present | View Report |
| PACE FY23 Budget vs. Actual Report | 9 - Diagnostic Review | July to Present | View Report |
| Translation and Commercialization | 6 - Initial Visualization | 2015 to Present | Expected Q3 of 2023 |
| Internally Funded Proposals and Awards | 6 - Initial Visualization | 2018 to Present | Expected Q3 of 2023 |
| PharmD Assessment Load | 7 - Stakeholder Review | 2019 to Present | Expected Q3 of 2023 |
as of Sept. 6, 2022
| Report Name | Status* | Years of Data | Report Access |
|---|---|---|---|
| Incoming Student Headcount | 9 - Diagnostic Review | 4 (2019 to Present) | View Report |
| Enrolled Student Headcount | 9 - Diagnostic Review | 4 (2019 to Present) | View Report |
| Degrees Conferred | 9 - Diagnostic Review | 4 (2019 to Present) | View Report |
| Employee Professional Development | 9 - Diagnostic Review | 5 (2018 to Present) | View Report |
| Internal Service Assignments | 9 - Diagnostic Review | 3 (2020 to Present) | View Report |
| Workforce Headcount Report | 9 - Diagnostic Review | 6 (2017 to Present) | View Report |
| Faculty Salary Equity | 9 - Diagnostic Review | 5 (2018 to Present) | View Report |
| Faculty Salary OSR Offset | 9 - Diagnostic Review | 6 (2017 to Present) | View Report |
| Well-Being Baseline Assessment | 9 - Diagnostic Review | 1 (2021) | View Report |
| PharmD Admissions Cycle | 9 - Diagnostic Review | 8 (2015 to Present) | View Report |
| PharmD Student Grade Performance | 6 - Initial Visualization | 2 (2021 to 2022) | Expected Q3 of 2023 |
as of Sept. 6, 2022
| Report Name | Status* | Years of Data | Report Access |
|---|---|---|---|
| Admissions/Recruitment FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Asheville FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| CAO - Office of the Dean FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| CIPhER FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Eastern NC FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Facilities FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Finance FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Global Engagement FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| HR FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Marcom FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| ODI FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| OE FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Office of the Dean FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| OSA FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Professional Education FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Research FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Experiential Programs FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| MS HSPA FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Operations FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| PSM FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| Curricular Affairs FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| TAs (R0174) FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| IET FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
| IET (RXET1) FY23 Budget vs. Actual Report | 7 – Stakeholder Review | 1 (July to June) - FY 23 | View Report |
as of Sept. 6, 2022
| Data Readiness Status | Explanation |
|---|---|
| 1 - Needs Assessment | Key stakeholders are consulted regarding data needs and authoritative data locations |
| 2 - SME Request | Data Subject Mater Experts (SMEs) are identified and meetings are conducted to discuss data access and data models |
| 3 - Exploration | Data is explored for completeness and usability |
| 4 - Validation | Data is validated to answer key questions and desired visualizations |
| 5 - Prototype | Data is prototyped into Tableau reports to establish dimensions and filters |
| 6 - Initial Visualization | Report requirements are transformed into initial reporting views |
| 7 - Stakeholder Review | Tableau report is reviewed for specific stakeholder feedback |
| 8 - DST Review | Report is sent to the Data Strategy Team (DST) for directional feedback |
| 9 - Diagnostic Review | Summary “Metrics that Matter” are explored as part of data diagnostics to assess data gaps and help establish final use cases |
| 10 - Published | Report demonstration is finalized, stakeholder groups are identified, notified and trained. Report permissions are finalized |
as of Feb. 03, 2022
| Principle | Essential Guidance |
|---|---|
| 1. Data Evolution / Not Revolution | • The Tableau dashboards are a work-in-progress and provide access to more data than we have ever had at our fingertips. • Dig in, utilize the filters, and explore how the data can be useful to you. Having access to this much data is new for the School and can be overwhelming. • Please view this as a journey towards increased use of data to inform the work we all do. This is an iterative process and refinements will continue to be made over time. Your input is important and essential to creating usefulness for each group of stakeholders. |
| 2. Data Exploration – Seeking Usefulness | • At any time, please reach out to the Office of OE with any questions or discrepancies you note. • Time can be set aside to help stakeholders to navigate the data, better understand its utility, and identify opportunities for refinement and improvement. • Providing insight and feedback into additional data needs, raising questions, and identifying creative approaches to use of the data are encouraged and valued. |
| 3. Building a Data Culture | • Use the data in context with all sources of information, including important qualitative input. Rich insights typically are found at the intersection of the quantitative and qualitative. • Importantly, it is key to understand what the data are showing, how it can be used in the context of other data points, and where it may fall short in answering specific questions. • Questioning data and prioritizing answers and needs should be a collegial and transparent activity. Providing data is about aligning to our WE CARE values to help ensure continued excellence, commitment, accountability, and respect, while maintaining an equitable workplace. |
as of Apr. 19, 2023
Creating a data-driven culture is the result of thoughtful and consistent planning by leaders who understand where they want to be in the future and then effectively use data (quantitative and qualitative) in order to make the case for change. At the Eshelman School of Pharmacy, our data strategy consists of 6 concurrent phases and is guided by the following philosophy and core principles:
| Core Principles | Principles in Action |
|---|---|
| “Impact Matters” | The numbers in the ESOP Annual Impact Report are the starting point. |
| “Relationships Matter” | Actively participate in all UNC ITS data security and governance policies. |
| “Experience Matters” | Seek to learn from and gain guidance from internal UNC resources deployed for similar projects. |
| “Transparency Matters” | Create transparency around “data deserts” and “data silos” to create a complete understanding of the situation and evaluate pros and cons of change. |
| “Awareness Matters” | Streamline data collection in important educational areas for longitudinal study and bring visibility and awareness to data collection efforts. |
| “Champions Matter” | Develop data champions who own the data and use it to inform decision making and continuous quality improvement. |
The data strategy has the following concurrent phases, key actions and outcomes.
| Phase | Key Actions | School Value and Impact |
|---|---|---|
| Inventory | • Catalog data systems, models, maturity, and governance structures. • Identify subject matter experts • Prioritize targets for deeper analysis. | Prioritization of data to support effective and consistent reporting for the annual ESOP Impact Report, Factbook and Accreditation. |
| Infrastructure | • Leverage existing UNC data systems, visualization tools and support structures. • Understand and comply with all data governance policies and standards. | Partnership with UNC Office of Institutional Research and Assessment (OIRA), ITS Datamart and UNC Systems Office / HelioCampus for Insight Data in the core areas of Human Resources Datamart (HRDM), Finance Datamart (FDM) and Student Datamart (SDM). |
| Illumination | • Worked collaboratively with key data Subject Matter Experts and key stakeholder to visualize data and key trends. • Utilized UNC Tableau infrastructure to create dozens of dashboards reports. • Established base permission model for data access and data refresh cycles. | Development, launch and maintain the School’s Report Catalog. |
| Insights | • Partner with accountable units and committees to develop deeper understanding of “where we have been” in order to develop key driver insights. | Summary insights reports are presented to the Dean’s Council quarterly after a thorough “closed-loop” process to ensure all stakeholders can weigh-in on the data and potential continuous improvement initiatives. |
| Indicators | • Partner with accountable units and committees to establish and track key indices. • Discuss and establish targets (needs improvement, target range, worthy of recognition) for future index performance that is aligned to the School and unit’s strategic goals and culture. | An example of a useful index would be the PharmD Application Yield. The key question is – What % of our students accept admission to the School (Yield) and how is this trending over time? What are the most important drivers of Yield and how are those drivers influenced to achieve the Yield % outcomes we desire? |
| Improvement | • Partner with accountable units and committees to develop and track CQI initiatives to help “move the needle” towards their desired target index. | Ensure that all improvement initiatives and targets are properly aligned to the Core Values of the School. |
as of Apr. 19, 2023
| Phase and Activity | Responsible Team | Typical Duration |
|---|---|---|
| Phase I - Statement of Work Phase Identify project scope, goals, project contacts, types of analyses, deliverables, and opportunities to collaborate | • OE – Lead Consultant | ~1 week |
| Phase II – Discovery Phase Identify and validate specific data to be analyzed and identify reliable data sources | • OE – Lead Consultant • Senior Data Analyst | ~1 week |
| Phase III – Prototype Phase Construct initial visualization strategy “wireframes” in consultation with domain experts | • OE – Lead Consultant • Senior Data Analyst • Data Subject Matter Expert(s) | ~1 week |
| Phase IV – Data Transformation Phase Retrieve and prepare data | • OE – Lead Consultant • Senior Data Analyst | ~1 – 2 weeks |
| Phase V – Visualization Phase Run analyses; produce visualizations; validate visualizations | • OE – Lead Consultant • Senior Data Analyst | ~1 week |
| Phase VI – Findings Review and Refine Phase Share initial analyses with data SME for input / gain approvals | • OE – Lead Consultant • Senior Data Analyst | ~2 days |
| Phase VII – Report Production Phase Establish permission model, publish final report to Tableau site and create data refresh procedures | • OE – Lead Consultant • Senior Data Analyst | ~1 week |