Tips & Insights provides advice on and examples of technology used to simplify and streamline IR activities, as well as real world examples of visual displays of data (e.g., charts, graphs, maps, tables, pictures). These eAIR features are developed by members.
-
Analyzing Academic Program Fiscal Performance
Understanding the financial viability of academic programs is increasingly at the forefront of discussions at small colleges and universities. However, a simple analysis of direct gross profits can be misleading if not p...Read Moreabout: Analyzing Academic Program Fiscal Performance -
Using the Criteria Field in Microsoft Access
Many of us use Microsoft Access to extract data from Banner or other enterprise systems, or to store data that doesn’t fit in our enterprise system. This tip provides an overview of the criteria field in Access que...Read Moreabout: Using the Criteria Field in Microsoft Access -
Tip for Tableau Users
Analysts use visualizations to deliver complicated information in an easy to understand way. Dual axis function in Tableau helps users to be efficient with a message of visualization. Another name for a chart with a dual...Read Moreabout: Tip for Tableau Users -
Creating a Clear Slicer Button in Excel
Scenario: You are developing an Excel dashboard based off a Pivot table or tables and you have multiple slicers to allow different combinations of data disaggregation, as in the image below. Everyone oohs and ahs un...Read Moreabout: Creating a Clear Slicer Button in Excel -
Graduating Student Survey Results Dashboard
Sharing results from our Graduating Student Survey typically meant sending or posting Excel or PDF files. Now, we're able to post interactive results in one location, allowing users to view results by year. Fro...Read Moreabout: Graduating Student Survey Results Dashboard