After evaluating a variety of solutions, the company decided to implement Tableau, because the self-service model fit the company’s philosophy for employees to act as independent entrepreneurs. Today, decision makers can create their own reports within one hour. Day-to-day decision making at the company has seen significant improvements. By introducing Tableau Server, ConSol* has taken a big step towards their goal of democratizing company data throughout the organization.
Delayed reporting hinders strategic progress
ConSol* Consulting & Solutions Software GmbH, founded in 1984, is a German IT full service provider for businesses of all sizes. Aside from their headquarters in Munich and branch offices in Düsseldorf, the company has subsidiaries in Dubai, Austria, Poland, and Romania. The company portfolio includes a complete range of IT services as well as its self-developed business process management software ConSol*CM.
ConSol* uses a solution by Navision for Enterprise Resource Planning (ERP) and stores everything in a data warehouse. Apart from typical business purposes such as cost, revenue, and profit analysis, ConSol* mainly requires reports for project controlling. “For us it’s essential to know how well the individual departments are doing,” says Henning von Kielpinski, departmental manager of Business Development Partner & Alliances at ConSol*.
“We are a consulting company, a software developer, and a product manufacturer. In most cases we are working on projects. That’s why it is so important to know which projects are going well and which aren’t, how the timelines are developing, when invoices are sent, and when payments are received. We also need to keep track of how our actual expenses compare to our calculations.”
In the past, one employee in controlling was responsible for creating all business and project related reports for the executive management. That employee was working with data warehouse extracts in Excel. As the business grew more complex, the waiting times for reports and analyses grew longer and longer.
“We had to wait up to four weeks for our latest figures, for things such as month-end closing,” says Henning von Kielpinski. “We couldn’t accept these delays in getting our basis for important and time-critical decisions any longer.”
With seven people constantly requesting new or modified reports, the controlling department was forced to hand out Excel files with base data and leave the analysis to the executives themselves. There simply wasn’t the capacity to deal with the ever increasing urgency of requests. “Because even the BI tools of our data warehouse were falling way short of our requirements, we were looking for an analytics solution that was powerful, fast and visually pleasing. But it should also be easy enough to use that non-mathematicians like myself could use it,” says Henning von Kielpinski.