Delta Light Uses Business Intelligence for Faster, Visual Data

“At Kohera we always like to test the latest technologies quickly to see what they have to offer our customers. That’s why we asked Delta Light whether they wanted to join us in taking the first steps in using Excel 2010 and PowerPivot. This way, they could learn about them without any obligations and we could start experimenting right away in a concrete work environment,” according to Frederik Vandeputte, managing partner at Kohera.

“We agreed with the proposal because with the previous version of Excel there remained a number of unresolved issues,” adds Jan Blomme. “Anyone searching for detailed information in large dimensions had to scroll down endlessly with a slow system. This is not surprising when you consider that our complete product list contains more than 56,000 articles. You could get round the sluggishness, it’s true, by pre-filtering according to article type, group, family or sort and so gradually reducing the selection. But this also took a lot of time. Excel 2010 now solves this problem with a standard solution. A search term allows you to sort through everything with an initial filtering, until you get down to the required level.”

“Another problem was the input of budgeting data. Previously an error by one budget manager could wreck the whole system. If someone inserted a column somewhere to make a calculation, suddenly there would be no figures in the morning. In Excel 2010 the budget managers each fill in the values for their own department by using the write back function. These are then submitted to a central template. If anyone makes an error, it no longer affects the whole report.”

Business analyst Jan De Wilde is responsible for forecasting, analysis of trends and figures, and reporting at the lighting manufacturer Delta Light. In order to process and analyse data, he needs the correct figures fast. That’s why it is important to be able to represent lists of numbers in a form that is easily readable, graphically or in overviews that give the essentials at a glance. Microsoft SQL Server 2008 and the new Microsoft Office Excel 2010 now allow users to quickly retrieve, process and present data clearly.

So for instance, with sparklines you can see at a glance how the sales of a specific product are doing. A simple graphic next to the table of figures gives so much more information than just some columns with numbers alongside each other. With custom sets you can filter specifically for a certain set of articles that you want to analyse regularly. If you want to know the stock and the delivery time for a specific set, or its sales or price, then you no longer have to keep selecting this set through filters each time. Additionally, measurements can now be shown in a variety of ways as standard. So you instantly see the absolute values of a range of articles also, for example, as percentages. Or you can quickly compare the results with those of the previous month or year. You used to have to make extra fields for this, which required some skill. With PowerPivot the users can now add calculations themselves and combine information from the data warehouse with other data sources. In this way they can easily compare figures with the evolution of the market.

Jan Blomme is impressed by slicers: “A must for data analysts, who can now compare different scenarios with just a few mouse clicks. If you want to know about sales in April, you click at the top on the “April” tab and the figures instantly adjust themselves. If you want to compare them with a different year, then you just need a click to select a different year. So you can quickly retrieve all possible information without having to know anything about Excel yourself. Previously you had to go through several steps and use all kinds of filters. Now you have the results you want much faster and obviously the graphics change accordingly.”

“With a few useful slicers, preparing a report takes no longer than five minutes,” says Frederik Vandeputte, “because we can compile it on the basis of existing reports. The slicers function is new but we already had the reports and pivot tables. And you can quickly define a link.”