“BI is becoming more and more important and our foreign branches in Canada, Denmark and the Netherlands can now analyse their sales figures down to the smallest detail. The figures come from their own ERP application but the analysis and reporting happens through our central application in Belgium,” says Jan Blomme, IT Manager at Delta Light.
Putting it to the test in a concrete work environment
“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.”
Seeing all possible combinations superfast
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.”
Much more visual
The new version also makes it a lot faster to build interactive dashboards. Figures can be represented in several ways: the pie chart and graph with bars or lines are expanded with meters, the indicator overview or even a results-driven map.
Kohera developed an application in Report Builder 3.0 in less than two hours, giving Delta Light a quick overview of all countries in which it is active. Countries that meet the predefined budgets appear green, while countries that do not perform as well as anticipated are red. And from the size of a sphere within these countries you can deduce how strongly the results differ from what was proposed. In the same way you can easily see which products lines are doing well in which countries and which are not.
Microsoft SharePoint Server is still on Delta Light’s wish list. Business analysts compile their reports and dashboards in PowerPivot or Report Builder 3.0. These could easily be published in SharePoint. Those who don’t yet have Excel 2010 can also view reports, including slicers, sparklines and maps in a web browser.
“With Report Builder 3.0 users with some aptitude for IT can now develop new reports and dashboards themselves that fully meet their needs. All we have to do is to prepare a number of report parts, such as graphs, tables or data sets, so that the end users can use these building blocks to quickly put together their own reports. We are firmly convinced about the ease of use of Excel 2010 and PowerPivot,” concludes Jan Blomme.
About Delta Light
Delta Light was established in 1987 and grew into a market leader and trendsetter in architectural designer lighting. The company sells its products in more than 80 countries worldwide. Its head office is in Belgium, where about 200 people work. Last year the company achieved a turnover of almost 50 million euros.
Get in touch and we’ll get the best solution for your company!