One Source of the Truth!

I first became familiar with this term over 10 years ago at T&G Global. It was my first role as an analyst, and one of my responsibilities was to prepare forecasts. These forecasts served as the foundation for many other functions—planning, sales, logistics, and finance. Each of these teams had different needs and would challenge the assumptions used in preparing the forecast. I quickly learned that I needed to provide answers tailored to each audience. They all wanted similar information, just presented in different ways—sometimes even in different units of measure, such as bins of apples or packed cartons (TCEs, for those familiar with the apple industry).

The solution was Excel and its data model feature. I didn’t know it at the time, but learning to use Power Query and the data model, along with writing those first basic DAX formulas, would eventually lead me to start my own business.

Back then, I was simply trying to create pivot tables. Ones that would let me answer everyone’s questions while maintaining a single source of truth. That goal has remained the same with every business I work with today. Data can get messy, so paying attention to detail and checking assumptions with experts in the business is key to ensuring the results can be trusted. Because without good data, how can you make good decisions?

If conflicting data in your business is causing frustration, get in touch