Fix the Pitch

How to craft compelling, dazzling pitchbooks. Thoughts, ideas, and inspiration to help construct advanced financial analysis, build stunning data visualizations and tips for mastering client meetings.

Fix your pitchbook

Join the Fix the Pitch newsletter

Popular tags

Introducing the Data Hub

Patrick RyanPatrick Ryan

It’s 2 a.m. and you’re close to wrapping up your pitchbook for tomorrow morning’s meeting. One chart left to go. You open the spreadsheet, and...wait...what’s that? Where has that number come from? That’s not the number you’ve been using in the other charts. Is it new? How was it calculated? You try to call Jim, Jim will know, he was the last person to run the data. But Jim isn’t there. And your meeting is in six hours. What do you do?


We know this scenario all too well. You need to produce content with a specific set of data and the numbers don’t tie-out. You’ve gone from being nearly finished to having to possibly recreate everything. People are pinged, emails sent, calls are made in a frantic effort to track down the latest numbers and figure out what changed.

Urgh. You have a million other things to worry about. Let us take this off your plate.

Meet Pellucid’s Data Hub

Born of the need for bankers to audit, edit, store, and share numbers, the Data Hub is an integrated platform for all your data requirements. It gives a global view of your numbers so you can see each and every value, know where it came from, and review how it was calculated. It powers content created in the Pellucid platform, so the plottable data of every single chart, page, or book is to your specifications.

The Data Hub is built to be powerful, yet flexible, acting as a centralized data repository for you and your group. It connects to your preferred data provider and makes it easy to see, change, and understand what you have without having to use multiple spreadsheets or tools. It’s always transparent and always accessible. Even at 2 a.m.

There are three main areas of the Data Hub:


The first stop in the “where did that data come from?” tour. The Data Hub is connected to your data, be it a feed from your provider or your own proprietary data, and gives immediate transparency into the source, the data is then given a structure and hierarchy, based on how you want it organized.

Pellucid's Data Hub showing full transparency with Sources

There is a whole list of the source items that, once you’ve selected a subject company, can be downloaded and opened in Excel for auditing and comparison to the original data sources, making it easy to see for yourself that Pellucid’s data is your data.

Once clear on where your data is coming from, it’s time to see how it is used.


Answering, “How is that ratio calculated?” becomes straightforward and clear by inspecting the item in the Data Hub’s Definitions section. Similar to Sources, Definitions includes an organized list of common metrics used in visualizations. The resulting calculations can be then audited for any available company:

Pellucid's Data Hub showing data Definitions

This shows the underlying figures and the calculation methodologies, which can be modified if you want to use a different definition. Take EBITDA for example. Looking in Definitions, you can see which components make up its definition.

And there are actually two definitions, which is really important. The first definition is applied by default, but the second, the fallthrough, kicks-in if something is missing from the first. That is, the definition falls through, similar to how IFERROR() works in Excel. As many fallthroughs can be added as you need.

If you want a different definition this can also be changed. You can add, remove, or change completely the components of EBITDA.

Definition Editor in Pellucid's Data Hub

Also, any changes will automatically apply to other calculations that rely on EBITDA, such as EBITDA/margin, again, mirroring the actions you’re used to performing in Excel.


What about when you just need to update a single number? In the Data Hub you can override any value, regardless of its definition or relationship to the rest of the data.

Override definition editor in Pellucid's Data Hub

The override can be hardcoded, meaning it’s static in absolute terms, or applied as a delta, which changes relative to the underlying source value. It’s like just typing over a value in Excel, but with additional features and it feeds straight into plottable content to make your life easier.

And, just in case in six months time Jim comes to your desk to ask where a particular override came from, you can add a comment and a link so it’s easy to remember.

And if Jim doesn’t like it? Just delete the override and the value will change to its calculated definition.

So, you get complete control and transparency into your numbers, we get to make you great content powered by your own plottable data, and Jim stops getting calls at 2 a.m. asking where a number came from. Everyone wins.

Drop me an email at to see it live.

Great content begins with flawless data. Take control of your numbers with Pellucid. Visit

Patrick Ryan

Patrick Ryan

Chief Product Officer at Pellucid Analytics. Explanatory designer and builder of financial products and tools. Builds own skis. Filling the gap between ideas and execution.