Booth 512
Visit Centage at IMA 24 in San Antonio, TX June 9th - 12th
New Blog
Check out our latest blog: Deep dive into variance analysis
Read now

Discovering What’s Possible: Sales Metrics from Analytics Maestro

September 21, 2016
Reporting
Formula-free FP&A

Eliminate human error, increase confidence, and shave hours (or more) off your FP&A process.

Book a Demo

I love it when we learn more about how our customers are using our products. If you track operational stats and metrics (or want to), you may want to take a look at the recent case study we published featuring our customer, Mighty Leaf Tea.Once we got their budgeting and financial reporting issues solved with Budget Maestro and Analytics Maestro, their CFO got to thinking about another ongoing dilemma they’ve had for some time. They use Sage 500 as their ERP system and knew that they had a ton of sales, inventory, and distribution data in there that they would love to mine. I think we’ve all shared that frustration of KNOWING that there is information we’re housing that we just can’t figure out how or don’t have the time to work out a system to get to it.Mighty Leaf Tea had sketched out a process to build an Excel SQL-embedded workbook to pull out their sales and inventory data and help them create reports that could be used to increase their business. It’s a great idea… that would take weeks, if not months to build and test. Mighty Leaf had just installed our Centage suite of products and had quickly gotten familiar with maneuvering the information fields to create their financial month-end reports with Analytics Maestro. They love the time it is saving them and the confidence they have in the results.Their CFO thought about their other dilemma and saw how the OLAP technology (online analytical processing) that we use in Analytics Maestro might be able to be applied to getting data from their sales and inventory modules. The cube structure they were now using to build their Balance Sheet, Income Statement, and Cash Flow reports and forecasts might be the key to getting to their operations data that had been elusive.I’m sure you can see the end of this story already. How it got there depended on a simple step that people don’t often do enough of. He asked. Taking that step of talking with our Financial Analyst and then our Analytics Maestro team led the CFO and Mighty Leaf Tea to accessing a goldmine of data that they now use daily to produce instant sales reports, weekly product analysis and trends, and inventory management projections. Of course, reports are just reports if you don’t use them. But they use them and it’s been remarkable how quickly drilling down on the dimensions of a cube becomes second nature.How often do you wonder about whether an app, product or process might work for something else? Do you ask about it or do you file it away to check into…someday?  We’re all guilty of that at times. Hopefully not too often though. In our financial leadership roles, we’re accustomed to taking initiative and problem solving with whatever it takes. I’m sure you make it a point to train your staff (and children!) that they’ll go much farther when they speak up and look at creative and innovative ways to find solutions.We’re fortunate to have a great team here at Centage and we love both asking those types of questions and receiving them. We’re able to connect CRM systems, HR systems, and as you can see, sales and product modules along with the financial data in ERP systems that we routinely integrate with. It’s a great feeling to help people solve irritating problems and produce results that help them to better manage their businesses.Pick an issue that has had you stumped for a while. Do some brainstorming and connect the dots to a familiar tool or process that might hold the answers to move that issue closer toward having a solution.

  • Error message label
  • Error message label
  • Error message label
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Stay in the loop!

Sign up for our newsletter to stay up to date with everything Centage.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Latest posts

Keep reading...

Interviews, tips, guides, industry best practices, and news.

View all Resources