Business Intelligence

Reporting All the Way…

Naughty or Nice Map through QlikviewWith the population of the world currently growing at an average rate of 1.14% every year it is no surprise that Santa has seen a steep increase in demand. As one of his top priorities for 2013 Santa was looking to improve his stock management and reporting in order to ensure Christmas went off without a hitch.

Over the past couple of years Santa has seen a decline in productivity with many of his processes becoming inefficient and time consuming. His stock manager elf was finding it increasingly difficult to determine the appropriate level of stock as he was not able to access critical data needed to match the supply with customer demand.

The elves were also seeing poor results becoming frequently frustrated at having to wait hours, days and weeks for naughty and nice reports, which are vital in predicting demand. They were pulling disparate data from numerous sources, resulting in multiple reporting silos. Additionally, the reports were pulled together in Excel, an extremely inflexible and static tool. The inaccurate stock control was becoming quite an issue within Santa’s grotto resulting in misplaced stock, wrong deliveries and production bottlenecks due to stock shortages.

Recommended for YouWebcast: Sales and Marketing Alignment: 7 Steps To Implement Effective Sales Enablement

After accessing several different business intelligence (BI) tools, Santa found that a Data Discovery tool such as QlikView was more suited to his needs. With instant access to business critical data, Santa was better equipped to maximise stock without affecting his customer satisfaction. It had made the whole process more agile and Santa was able to become more responsive and proactive to the altering naughty and nice lists.

Santas online formThe elves no longer have to spend hours manually entering the right present information for each child into the database as it could be done automatically by the parents via a web portal. In the portal, powered by NetSuite, parents can even order specific presents to help him with the process and demand planning.

Instead of trying to analyse the data held within disparate systems, their new BI tool pulled all the information into one easy to navigate dashboard. They were able to use ‘what if’ scenarios and historical data to predict fluctuations in the naughty and nice list in order to set stock levels for the upcoming months. Having real time visibility into their stock levels meant that they were able to lower stock costs associated with excess stock and lower customer dissatisfaction (i.e. tantrums) affiliated with a stock out.

Santa is now able to deliver informational insight with the speed and flexibility that is required for meaningful decision making. The ability to manage and control his stock more efficiently has changed the way Christmas operates. No longer are well behaved kids waking up to a lump of boring coal. Instead Santa has seen an increase in the elves, the children and their parents feeling more satisfied and fulfilled. The elves are better informed, more proactive and can execute decisions in a timelier manner leaving Santa to focus on what’s really important – what he is going to get Mrs Claus for her Christmas!

For companies interested in Business Intelligence Software, like Santas, download the guide on how to avoid the 10 pitfalls of Business Intelligence.

  Discuss This Article

Comments: 0

Add a New Comment

Thank you for adding to the conversation!

Our comments are moderated. Your comment may not appear immediately.