Too Much Data, Not Enough Strategy: How to Pivot Analyses From Interesting to Useful
The higher education space has gained easy access to a substantial amount of data, but tapping into a wealth of information is only half the battle. The other half involves creating a strategy for how it should be used. This intelligence surplus has the potential to drive a trend of creating simply because it’s possible, producing analyses that are far more interesting than they are useful. They arm stakeholders with fast facts but not with anything they can act on.
The shift to actionability doesn’t happen by accident but rather by planned execution. It takes deliberate effort, so let’s get started.
Start with a Conversation, Not a Work Order
As the guiding fictional example, let’s consider the common ask where a campus colleague is interested in having a dashboard created on a segment of the student body (graduate students, professional students, transfer students, etc.). If this project is relayed to you as a secondhand work order, start by converting it to a firsthand request. Meet with the client for yourself, using the information you were given to frame potential discovery questions in advance. In this initial meeting, don’t let the client do all the talking. Silence signals that you’re an order-taker instead of an expert and thought partner in the engagement. Consultants drive project requests by asking questions that the client has yet to consider. So, if you want to be treated as an advisor, you must maneuver like one.
I Don’t Know What to Ask
The good news is you don’t have to. Below are several key questions that will get you started. They’re all geared toward figuring out if the ask leans more toward interesting or useful and how to pivot if it favors the former over the latter.
- What’s the so what? This gets to the heart of the why behind the ask. It’s where you, as the data steward, have to protect analyses from incorporating information just because there’s plenty of it. To whom much data is given, much is required, so ensure there’s a clear need for the requested intel that connects back to the why. Likewise, the so what speaks to the origin of the request, which can provide clues on how to make it operationally useful. If the client responds by saying that someone in management asked them to do this, take that as a signal that they may not fully be aware of the mission behind it. That’s where you’ll dig deeper, challenging them to gain insight into the action items that are on the horizon as a result of this completed project.
- Do you expect year-over-year changes to be roughly flat? If the campus environment changes, but the data is expected to show strong stability, it might be an indicator that the data isn’t at a decision-oriented level. Insignificant yearly variations are often mistakenly taken as a sign that all is well, leading to a hands-off approach. Keep in mind that stability isn’t necessarily favorable, and even if it is, just because business is booming doesn’t mean the attention should be turned elsewhere. More than one of the business consulting projects I was placed on was centered on some of the most lucrative product lines the company produced. I was asked to investigate why they performed so well. Is it because other companies don’t recognize the opportunity or because they aren’t positioned well enough to take advantage of it? Recycling this approach in IR will lead to similar questions. If the data is expected to be stable, is there underlying variance that leads to something more influential? If the students being studied are successful by all measures, what’s driving that? This is where you challenge the client on their interpretation of business as usual and continuously guide them in sharpening the tool.
- What’s the actionable insight associated with each part of the requested dashboard? If knowing the breakdown of students by factors such as sex or race can’t be connected back to a practical result, it’s worth having an extended conversation around why such an analysis is necessary. Treat the project like precious real estate. Executive decisions have to be made on which aspects of the study make the cut. Each part has to earn its spot. The way it does this is by being more aligned with useful outcomes than interesting ones.
- How will this project help you figure out who’s doing well and who isn’t? This puts the client in the driver’s seat. It challenges them to define and articulate what good looks like and the key performance indicators that are associated with it. The better they can do this, the better you can advise them. This will go a long way toward molding the project around critical information. Like going to the doctor for a checkup and having measurements taken on blood pressure, temperature, and weight, it establishes a baseline for the health of the student population being studied that should spur quick action if it strays from an acceptable range.
This list isn’t what consultants call mutually exclusive and collectively exhaustive (MECE). It’s just a start, but that’s all you need. Questions are contagious. One asked and answered has a way of bringing many more to your attention. Add to this as you gain experience. Just be careful to make actionable inquiries as you steer the engagement toward actionable outcomes.
I Did What You Said, but They’re Sticking to Their Original, Unactionable Ask
If this happens, it’s likely driven by political or cultural headwinds like my boss’s boss’s boss asked for this or I usually just tell IR what I want, and they send back what I need. Although these factors are outside of your control, that doesn’t mean they’re outside of your influence. The following are some ways to pivot such a nonideal situation into one with more upside.
- Add some actionable elements to their original ask: Just because the entire dashboard isn’t actionable doesn’t mean parts of it can’t be. Look for ways you can demonstrate the power of a practical analysis while still fulfilling their original request. This can serve as a proof of concept to highlight the divide between interesting and useful. In doing so, be sure to provide a full breakdown of how you went from analytical curiosity to action item. For example, the average GPA of all students being analyzed may show an increasing trend from their first to last year. That’s generally seen as a positive outcome, but it isn’t where the analysis should end. Stopping there leaves the opportunity to implement change on the table. Deeper investigation may reveal that there’s a subset of students that follow this trend, although their GPAs are below the average. A notable pattern among this group may be that they tended to take General Chemistry I and Engineering I in their first semester. Such a finding leaves the client with the action item of gathering anecdotal data to figure out what has led so many students to take two extremely rigorous courses early in their academic journeys. One possible explanation, to be confirmed with students and advisors, is that they’re on a premedical track with intentions of creating medical devices in the future. So, they plan to simultaneously take the hard sciences needed to apply to professional health programs and the engineering courses required for a major or minor. This narrative can then be used as a tool, arming the client with data that drives more intentional advising to fuel better academic outcomes. Taking them on such a journey, although it isn’t what they asked for, gives them a taste of the limitless potential of actionable work. Once they see the power of intelligent insight, they’re likely to come back for more.
- You gained experience: Even if you gain no traction with the client in getting them to pivot from interesting to useful analyses, you aren’t at a total loss. You’ve gained valuable experience in taking this journey that you can put to work on future engagements. That by itself is a win. Each iteration of this process continues to shift who you are as an IR professional, moving you from operational to strategic.
I’m Nervous to Give This a Try
I would be concerned if you weren’t. Consulting is a difficult discipline. Every engagement has a way of feeling like the first day on a new job. You have to lead others on a journey that you haven’t traveled yourself. When you feel like you’re getting lost in the process, ask more questions. Use this as a tool to bring order to chaos throughout the collaboration. You don’t have to be perfect to do this. You just have to practice—and there’s no better time to start than in the present.
Janay A. Williams is a Data Analyst in the Office of Institutional Research at Wake Forest University, working on Integrated Postsecondary Education Data System (IPEDS) submissions and organization-level analyses. Previous experience includes Fortune 500 business and enterprise consulting, corporate strategy, and data analytics.
