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.
-
The Story Behind the Stony Brook University COVID-19 Dashboard
In summer 2020, Stony Brook University’s Senior Executive team requested the development and launch of a public-facing dashboard to display information about COVID-19 on the campus. The Office of Institutional Rese...Read Moreabout: The Story Behind the Stony Brook University COVID-19 Dashboard -
“Ctrl” Excel and Word
Did you know there are many keyboard shortcuts built into Microsoft Office that can save you time and make your life easier? It’s time to get friendly with your Control key! Here are 25 “Ctrl&n...Read Moreabout: “Ctrl” Excel and Word -
Exploring Data Using Excel’s Power Query Editor
While I primarily use Microsoft Excel’s Power Query Editor to put together a complicated table or report in a short period of time, I’ve learned that you can also use it to explore any data set. Here are the ...Read Moreabout: Exploring Data Using Excel’s Power Query Editor -
Improving Transparency With Applicant Public Access Portals
The Chilean Ministry of Education, through the Sub-secretariat for Higher Education, has instructed the universities to set up public access portals for applicants as a way to improve transparency in information and the ...Read Moreabout: Improving Transparency With Applicant Public Access Portals -
SAS Enterprise Guide: Reading, Importing, and Appending Multiple Text Files
In many circumstances, different text files are created with the same formats representing different groups or time periods. When multiple text files are held in a specific location, whether they are on a server, cloud, ...Read Moreabout: SAS Enterprise Guide: Reading, Importing, and Appending Multiple Text Files