Single Blog

How All C-Stores Can Afford to Use Their Back Office Data

Analytics Concepts

Customizing your reports is not a new concept. Most Business Intelligence and even some Back-Office tools come with standard reports, but this usually entails data that you can currently get from your Back-Office system already. There are core areas of activity that impact the totals these systems give you that need to be watched and measured in order to totally understand why the totals on those existing sheets are what they are.

Most companies have certain metrics they measure, for instance, one company measures how many coffee cups the sell each day. A generic BI tool will not give you this information without some form of custom development. With a configurable product you will probably only need to know the UPC code, and the report can be created in very little time. When it doesn’t cost anything, you will be surprised to see how many ideas you may have to improve your business through the performance measurement process. There are report writing tools, and business intelligence tool. An ideal tool for Convenience Stores is to find one that will do both

C-Stores have a unique mix of data to correlate so they can completely understand where their issues and opportunities lie. Knowing sales amount by location usually is not enough to help you get to core issues that reside in those stores to help you understand why they may be failing.  These reports identify a symptom, but not the root cause of an issue.

To get to the data that can help them identify core issues, C-Store companies are often led to the expense of customization in their reporting. Not only is there the development cost, but the cost of time and resources to define what will be on the report,  the time waiting for development to occur, and in some cases, even maintenance costs. Depending on the complexity of the report, or the number of systems it has to touch, will determine its costs. Because of the various activities, programs and detail, C-Stores have to deal with, custom reports through software development can be rather costly. This forces a company to evaluate the benefits of the customization and whether the trade off would truly be in their favor.  The need  has to become a choice.

  • What would the frequency of use be in such a customization?
  • What is the possible savings it could generate with it’s use?
  • How many people in the company would find it of value?
  • How soon would the ROI be realized?
  • How much does it cost to extract this information through manual means?

Ask several of the larger chain CEO’s and they will tell you that your back office data should not be ignored if to succeed in this industry. So how does the small to mid size retailer get the reporting it needs without depleting all of their profits? The answer is to look for BI tools that offer configuration. Finding one that is built for C-Stores will prevent the expense of any customizations you would need with a generic Business Intelligence tool.   These are tools that provide a templates that allow you to create your own reports, that will allow you to drill down to the areas of activity that impacts the results of the higher level reports. This help you adapt to the times and changing plans at no cost and it will put you on the same playing field with the larger companies.

Time is another consideration when deciding to go custom vs configuration.  Sangeep Cherry wrote ” Customization vs. Configuration: The Effect on Deployment Velocity” which is an article  that relays the  benefits of configuration when it comes to deployment.  The end result is that the report can be produced and rolled out much more quickly when configured.

If is for these reasons that it is recommended that when investing in reporting to run your business, you will receive much more value from a configurable product than opting for one that would require customization.

  • It will allow you to obtain the view of things when you need to see them, without cost or having to wait to do so.
  • It will give you the ability to see what your issues are where they are happening.
  • Its use can be cost justified because specialized reports would then be possible across multiple projects.