Simplifying and combining complex data with Tableau Prep
In 2018, YIT completed a major merger with another Finnish construction company; Lemminkäinen Corporation. As part of the merger, all of Lemminkäinen’s key data had to be cleaned and combined with YIT’s, so it could be added to the cloud-based database and then connected to Tableau for future analytics purposes.
“We took over the HR and procurement data,” says Heikki. “With the help of Tableau Prep we were able to provide the business with critical information of the merged company in no time.”
Such tasks can often take many years to complete, but Heikki and his team were able to be much more agile and create an initial solution over disparate systems for immediate business results, which would also serve as a long-term data engineering guideline.
“In situations like this, the separate data sources can often be wildly different in terms of scope, quality and consistency, making the task extremely difficult,” says Heikki. “Fortunately, we were able to use Tableau Prep to merge the HR and procurement data quickly, cleaning, shaping and combining both sets of data for easy consolidation in Tableau. We saved huge amounts of time and money in the process.”
As a result, critical information from both companies, such as head count, can now be viewed as one in Tableau, making life a lot easier for the newly combined HR department. Prep is also used in other areas of the organisation to test the flow of data coming from multiple different vendors and make everything accessible via a handful of comprehensive Tableau dashboards.
“Tableau Prep played a key role in the success of the recent merger and continues to be an invaluable part of our day-to-day operations,” says Heikki. “It offers a really flexible first line solution whenever people require it. It allows us to maximise our operational efficiency by empowering employees with all the information they need to perform to the best of their ability, at all times.”