4-page Case Study
Posted: 9/30/2013
277
Rate This Evidence:

Danfoss Simple Excel-based tool provides Danfoss with second-to-none operational insight in IT

– 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 explains.

*
* 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
Danfoss

*
PowerPivot “extremely versatile and easy to use”

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.

Solution Overview



Organization Size: 18000 employees

Organization Profile
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.

Business Situation
In order to maximize transparency and gain operational insight, Danfoss IT needed a solution able to draw data from numerous systems, analyze them coherently and present the result graphically in a portal-environment.

Solution
Microsoft Excel in combination with PowerPivot, SharePoint and SQL server. The data sources are currently the ticketing system, lists and SAP.

Benefits
  • Much better insight in operational performance
  • Simplifies reporting
  • Creates a common foundation for assessment of and dialog about performance
  • The usage of a common data-analysis model makes it possible to use results across a company spanning numerous divisions and – indeed – the entire globe
  • Tool is based on the common Microsoft Office user interface; this makes it easy to use ‘out-of-the-box’ without prerequisites.
  • Graphically pleasing and easily comprehensible reports

Software and Services
  • Microsoft Excel
  • Microsoft Sharepoint Server
  • Microsoft SQL Server

Vertical Industries
Power & Utilities

Country/Region
Denmark

Business Need
  • Business Intelligence and Reporting
  • Business Productivity

Languages
English

RSS