TREFIS: FEATURED USE CASE

Answering “What-Ifs” Right Away Matters for Marketing, Finance, and Product Teams Intent on Delivering Their Launch Forecast!

Readiness in tackling surprises is everything.
Go right from your Excel models/data into a business dialog on Trefis Interactive Dashboard.
Join the winners!

Who Inspires Us?

“Members of regional vs global teams each have a different perspective on the market potential and what it might take to accomplish it. I like the idea of a dashboard that shows our target, and the consensus view, while we have an eye on the variety of opinions - that aren’t squashed. It helps us as a team be more aware of the risk-reward, and when things do come up, be better prepared to address challenges.”

AllanGlobal marketing head, $400m business unit of a Fortune 100 company

“I started with the forecasts that are most important to our team, focusing on the main products in our launch portfolio. I took the existing Excel model, and uploaded it onto Trefis – within a few minutes I was able to then pull in the inputs and outputs we were interested in, to finalize the dashboard and share link with my colleagues. Folks on the team were able to then quickly create their own scenarios and brainstorm live.”

MichaelMarket Intelligence manager, Large Technology company

You just can’t do this on Tableau or Qlik. We want to not just see the historical data, our focus is on our launch forecasts and how month-to-month operational developments for key launch products influence team members’ view on forecasts. We want everyone to see how these operational developments may impact financial forecasts and our P&L. ”

StephenFinance director, divisional FP&A for a healthcare giant

“When there is uncertainty, there is a general feeling of malaise – once you quantify it, and look at possible impact of disruption, you transform the vibe into an objective measure and into something that triggers problem solving. Its powerful stuff!

MichelleGlobal Product owner, Insurance industry

One tool. Incredibly simple.
Designed by MIT engineers.
Used by a million users.

How it works

Step 1
Load your Excel data, transform into an interactive dashboard in minutes.

Step 2
Test risk-reward, modify assumptions, Capture team’s expectations. See the consensus, but preserve the variety of opinions.

Step 3
Readily draw on the richness of different ideas to be better planned in the face of shocks.

Why it works

What happens to your launch forecast when faced with a regulatory challenge?
An operational surprise – an unexpected supply chain issue, a manufacturing glitch, or disruption in distribution?

What do the best leaders, managers do?
We’ve learned that it is in these situations that the team awareness matters. Alignment matters. Differences in opinion matter. A dashboard that allows teams to quickly see the different possibilities, test risk-reward, and reach alignment quickly – matters!

We’ve learned from the practices of the best and simply made it possible for everyone to plan consistently. Real-time. Like the best.

There is no magic. Just good people – and smart tools!

Solutions Summary

Correct, you just can’t do this on Tableau or Qlik.

  • Modify forecasts, see impact on financial metrics in real-time
  • Compare different opinions visually
  • Eliminate “number crunching” latency
  • Ask more what-ifs without having to schedule follow up meetings

Upload Excel model directly from desktop. Convert into a dashboard in minutes

Trefis is Excel model plug-and-play

  • No Excel templates
  • No IT deployments
  • No integration consultants

Trefis transforms your Excel models in a matter of minutes.

  • Don’t just meet, or guess the impact, instead see impact of opinions on financials and metrics that matter.
  • All opinions and charts in one place. Lose nothing.
  • Preserve the alternatives. Pick up exactly where you left.
  • Revisit regularly or as needed.
  • Present scenarios as strategic options for executive consideration, accelerate buy-in and richer dialog.
  • Modify as many forecasts and create as many scenarios as you wish.
  • Provide team members with secure access to your interactive models and scenarios.
  • Control the default view for your forecasts.
  • Allow collaborators to change views on the fly.
  • Put forecast discussions in context by pulling in relevant data from other models or databases.
  • Conveniently access data via search.
  • Plot data on forecast inputs or outputs.

Editorial curation built into Trefis so you can control the narrative.

  • Decide which forecasts and data are accessible via Trefis as easily as drag and drop.
  • Hide or exclude forecasts or results that aren’t core.
  • Add headings, commentary or takeaways to provide context.
  • Skip the charting in Excel, pasting into PowerPoint for discussion process entirely in some cases.

Sounded crazy when we first heard clients say it.
Now people have become used to it.

  • Download forecast changes and scenarios made via Trefis back into Excel.
  • Re-upload in minutes revisions made in Excel to Trefis and see your changes reflected.

Whether internal work-sessions, or executive meetings – we are passionate about how clients are using Trefis in new and creative ways for their business dialog to:

  • Answer what-ifs real-time.
  • Compare differences in opinion and assumptions, instantly see impact on finances.
  • Record the differences, without losing the consensus.

Ultimately – Break The Iterative Cycle!

  • Reduce repetition & friction.
  • Meet less. Produce more.
  • Align better.

Excel. PowerPoint. Meetings.
Excel. PowerPoint. Meetings.
Repeat.
Loop.
Is this a familiar iterative cycle?

1. See examples.
2. Create a dashboard & collaborate.