-
Using HTML Widgets for R to Create Interactive Reports
Institutional researchers are often tasked with synthesizing large amounts of data, perhaps by visualizing it in charts or summarizing it in tabular format. Allowing users to interact with these charts or tables by sorti...Read Moreabout: Using HTML Widgets for R to Create Interactive Reports -
Seeing Is Believing: Using Power BI to Visualize Alumni Earnings
As higher education institutions continue to recover from challenges presented by the pandemic, they are forced to grapple with persistent nationwide enrollment declines as well as student perceptions regarding the value...Read Moreabout: Seeing Is Believing: Using Power BI to Visualize Alumni Earnings -
The Versatility of the XLOOKUP
LOOKUP, launched in 2019 by Microsoft, combines the functionality of multiple functions, including VLOOKUP and HLOOKUP, into a single source. It also offers the option to select a customized variable if no data are retur...Read Moreabout: The Versatility of the XLOOKUP -
Walking Through an Enrollment Forecasting Example
A key development in higher education over the past several decades is the growth of institutional research offices that function under the core principles of explaining what is happening now and attempting to shed light...Read Moreabout: Walking Through an Enrollment Forecasting Example -
Mapping in Tableau
Visualizing geographic information helps data consumers quickly and easily derive insights and meaning. Institutional researchers, for example, may want to map students' home states or countries to help campus administra...Read Moreabout: Mapping in Tableau -
Come on and Zoom! 15 Time- and Reputation-Saving Zoom Hacks
“I have a Zoom call at 3, so make sure you only enter my office if it is an emergency AND you are fully dressed.” A little less than a year ago, at the beginning of the pandemic, when people were talking a...Read Moreabout: Come on and Zoom! 15 Time- and Reputation-Saving Zoom Hacks -
Combining Data from Multiple Sources Using R
Gathering the Data A common request of our institutional research office is to combine data from multiple sources and varying formats. For example, we keep our demographic and academic information about our students in a...Read Moreabout: Combining Data from Multiple Sources Using R -
Using Images as Data Points in Excel Column Charts
There are many features in Microsoft Excel that go unnoticed. One of these features allows you to add flair to your data visualization with relative ease. When creating column charts in Excel, we often utilize the defaul...Read Moreabout: Using Images as Data Points in Excel Column Charts -
“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 -
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 -
Creating Animations in R
If you’re looking for an excuse nowadays to spend more time inside on a computer, I recommend visiting the subreddit r/dataisbeautiful. Users submit all kinds of visualizations along with details of how they were c...Read Moreabout: Creating Animations in R -
Power up Excel
Whether you're new to Excel or breathe advanced formulae, there are always shortcuts and useful features to be discovered. Have you ever wanted a distinct count in pivot tables or an easier way to format complex workbook...Read Moreabout: Power up Excel -
Using Slicers to Update Pivot Tables
For information where online dashboards are not available, my office frequently uses pivot tables to visualize large sets of data for our stakeholders. Often times, we use the same data set for multiple visualizations li...Read Moreabout: Using Slicers to Update Pivot Tables -
Excel Power Query Saves Time
In Microsoft Excel, you’ve probably seen Power Pivot and Data Model, but have you discovered Power Query? Power Query is a tool introduced in 2013, which is available to all users who have Excel 2016 or later and/o...Read Moreabout: Excel Power Query Saves Time -
Creating Quick, Easy, and Cheap Video Tutorials for Data Consumers
Eight years ago, the Association of Schools and Programs of Public Health (ASPPH) launched on online system of annual reporting and analytics for our member graduate schools and programs. Members were eager to stop repor...Read Moreabout: Creating Quick, Easy, and Cheap Video Tutorials for Data Consumers -
Using the Excel Time Function
I have been working on planning a conference for an organization and need to create a daily agenda. In the past, this task would be achieved by using some combination of cutting, pasting, and filling within Excel. Recent...Read Moreabout: Using the Excel Time Function -
Excel MEDIAN IF Array Formula
A MEDIAN IF array formula in Excel will identify the middle number of values that meet certain criteria. An array formula performs an operation on multiple values instead of a single value. In this array formula, we esse...Read Moreabout: Excel MEDIAN IF Array Formula -
Side-by-Side Comparison Charts
Figure 1. Ethnicity Table The columns I used for the chart were Ethnicity, Georgia Percentage Positive, Georgia Percentage, and College Percentage (Figure 2). Excel 2016 is the software used to construct the chart. The ...Read Moreabout: Side-by-Side Comparison Charts -
Using the INSERT Command in SPSS Syntax
There are usually some of the same variables (gender, birthdate, etc.) included in multiple data files that your office collects or maintains. Instead of duplicating the syntax in the syntax file for each data file, a sm...Read Moreabout: Using the INSERT Command in SPSS Syntax