Babel No More–Consolidating Data So Everyone Speaks the Same Language

Post date:
Post views: 2,569

Sometimes when you go into a meeting, it’s like entering the Tower of Babel. It seems everyone is speaking a different language or, at least, using different sets of numbers. The Inventory Manager starts his PowerPoint presentation, showing colorful charts on the screen.  The Controller pulls out a packet of papers and the frown on her face says she has completely different figures.  The Regional Sales Director pulls up some charts on his iPhone and looks ready to jump into the ring.  And the Product Manager pulls out a napkin and objects outright to the results being presented.  For the next half hour, all four are trying to prove they have the correct numbers and for a half hour after that, they try to reconcile their numbers to the others’.  The meeting breaks up, nothing gets done, and everyone is a little hot under the collar.  Sound familiar?

BabelCompanies often have silos of data and everyone thinks his or her numbers are Gospel.  So who is right?  Maybe they all are.  When Jane, the Controller, says sales for the month are $x, maybe she is referring to total gross sales.  But maybe John, the Regional Sales Director, is referring to commissionable revenue, net of discounts.  Alex, the Inventory Manager, may be talking about sales net of cost of goods sold and Tory, the Product Manager, might not be including beta product revenue.

It’s important that these managers are on top of the revenue figure that they are each responsible for, and no one wants to give up a “good” departmental system that is working and everyone is familiar with.  What these managers need is a business intelligence platform that consolidates all of the relevant data but lets each manager continue to see the data presented in a way that is meaningful for departmental reporting for analysis and decision making.  BIO business intelligence lets you consolidate an unlimited number of diverse databases. You can give your users self-service access to all of the data they need—financial, operational, even departmental—and let them use reports you create especially for them or create their own reports.  But what may be most important is that analysts, managers, and decision makers are looking at the same numbers called by the same name so that when Jane says “net revenue” everyone knows she means net of discounts and not net of commissions or returns or any other costs.

Join BIO for a free webinar to see how BIO business intelligence software allows all of your users to have self-service access to the same consolidated data.  And please contact me at 203.705.4648 or by email at if you have any questions about BIO or business intelligence in general.

By Sandi Richards Forman of BIO Analytics, Corp., Microsoft Dynamics Business Intelligence (BI) Solution Provider

Leave a Reply