– Basically, the combination of Excel and PowerPivot is extremely useful and provides us with the ability to easily gain a coherent and fact-based insight in almost every part of our operation. For instance, today we’re able to – in a few seconds – to see
how many service-tickets we solve for which departments and exactly how many resources we spend doing so. Furthermore, it’s extremely easy to make reports, thus empowering everyone in IT Site Service to see where we’re heading as a department or as individuals,
says Sune Baastrup. He is regional IT director at Danfoss and responsible for the services delivered to the local sites.
Danfoss is a global leader focused on energy-efficient solutions that save energy and costs, and reduce CO2-emissions. The company’s wide range of products and services are used in areas such as cooling food, air conditioning, heating buildings, controlling
electric motors and powering mobile machinery. The company is also active in the field of solar and wind power as well as district heating and cooling infrastructure that targets entire cities and urban communities.
With more than 250 sites to serve globally, the IT-department has more a fair share of tasks to solve.
– In a typical year, Site Service handles 15.000 service tickets, while the IT Department worldwide touch base with more than 300.000 individual tasks. So it’s crucial for us to perform and to spend resources in the most efficient way possible, Sune Baastrup
PowerPivot “extremely versatile and easy to use”
||It’s really a very useful and versatile tool indeed. Actually, I think it’s fair to conclude that this has lifted us as an organization by giving us access to an insight in our operation that we simply did not have before.
| Sune Baastrup
Regional IT Director
Until recently, however, employees had to feed data from the task-management system into Excel and make their own operational assessments from scratch; a cumbersome and time-consuming task that – not infrequently – resulted in contradictory conclusions,
even when based on the same sets of data.
– We needed a tool to implement a much more coherent analysis-model and had been looking for it for quite some time. In the end, we decided on PowerPivot for Excel in combination with SQL Server and SharePoint. Not only because PowerPivot is free; that might
actually be a somewhat secondary point as long as it performs. But most of all because the solution is extremely versatile, draws data from a number of sources – amongst them SAP and the ticketing system – presents them in a browser environment though SharePoint
and is extremely easy to use, Sune Baastrup says.
Thorough and unambiguous analysis based on raw data in a few seconds
– No matter which analysis you want to perform, all you have to do is click on the relevant type of report in the browser. Then the system automatically draws the relevant data from our backbone and presents them as a final report with visually pleasing
and easily comprehensible graphs. Furthermore, as the reports are based on a combination of raw data and a fixed analysis-model, it matters not if you or a colleague from Denmark, Poland, Mexico or China draws it; the result will be the same. That makes it
much easier to draw conclusions, benchmark performance and have a fruitful dialog across the Group, he adds.
Still, it’s perfectly possible to draw an arbitrary set of data from the system and crunch them in Excel, if an employee wants to. Likewise, it’s easy to combine reports or – with a little know-how – to define a new standard-report for everyone to use. All
without having the need to perform a time-consuming analysis or having to call upon expensive consultants from outside the company.
– So it’s really a very useful and versatile tool indeed. Actually, I think it’s fair to conclude that this has lifted us as an organization by giving us access to an insight in our operation that we simply did not have before. And, as a direct result of
the preliminary experiences in IT Site Service, we are most definitively going to intensify the use of this tool going forward, Sune Baastrup ends.