banner letter Contact Us


The need for data integration

In business, data reigns supreme. However, when multiple data streams become intertwined, it can lead to confusion. Restricted access to data, often kept in separate silos, can also hinder timely decision-making, a vital aspect of effective leadership. Addressing these challenges requires using the right tools to effectively manage data and ensure accessibility for senior stakeholders when necessary.

This principle applies to all business functions, particularly in the Human Resource (HR) function, where the COVID-19 pandemic has accelerated shifts in work paradigms. This transition has spurred many HR trends that demand a cohesive response from the entire HR function. To help navigate these changes, HR leaders need a unified and reliable view of their workforce data.


Optimizing data management: volume, complexity, and cost

Our client, one of the largest electronic companies in the world, wanted a streamlined, central view of the vast data at their disposal. They faced challenges managing the vast amounts of data generated daily, including the sheer volume of data from multiple vehicles, the complexity of data formats, and associated operational costs. This arose the need for a single source of truth to uncross the wires — improving data access and resource efficiency.

Data volume and retrieval time

Our client’s vehicle tests generated several terabytes of data daily, accumulating to petabytes across multiple vehicles. Decoding this vast volume of data was costly and time-consuming. The client struggled to meet the deadline of retrieving specific data entities within 24 hours of test runs.

Data format complexity

The client collected data in the standardized industry format, Measurement Data Format (MDF), which is designed for efficient and secure binary data storage. However, its complexity presented a significant challenge in deciphering intricate data structures, especially with the precision required for various signals.

Operational costs and processing delays

The client incurred an operational cost of 1,000 Euros per terabyte to process the data. Furthermore, delays in data processing led to extended detection times for anomalies and failures, resulting in increased operational expenses.


Workday data potential: A roadmap to performance optimization

Due to the absence of a centralized knowledge database for the extensive data housed in Workday (the ERP system utilized by the business); our solution mechanism did the trick.

Phase Function Reason

1: Identify users and KPIs

Identify users for the dashboard, key performance indicators (KPIs), and relevant data from Workday.

Establish clarity on stakeholders and objectives to ensure the dashboard meets user needs and business goals.

2: Set up the back-end engine

Configure the back-end engine for data calculation on various data sets, including extraction, preparation, rules configuration, output structuring, and result storage.

Ensure efficient data processing and adherence to client-defined data definitions, leading to accurate dashboard outputs.

3: Implement layered architecture

Establish layered architecture to integrate results into the dashboard, focusing on process optimization, data aggregation, and performance enhancement.

Enhance dashboard functionality and user experience by streamlining data delivery and maximizing performance.

HR insights with QlikSense: data visualization and analysis

We presented the client with a solution incorporating QlikSense, a business intelligence tool proficient in data extraction, processing, and visualization. Alongside its robust ETL capabilities, QlikSense boasts intuitive visualizations, facilitating user-friendly accessibility throughout the organization.

The development timeline for HR360 spanned 2 months of planning, 6 weeks of design, and 8 months of implementation, with each dashboard released sequentially. Upon completion, HR360 emerged as a comprehensive suite of applications, encompassing dashboards addressing headcount, talent acquisition, inclusion and diversity, turnover, and leadership. This consolidation provided the HR department with the unified, authoritative source of information they had been looking for.

Alongside its robust ETL capabilities, QlikSense boasts intuitive visualizations, facilitating user-friendly accessibility throughout the organization.


Short-term wins: performance, data Integrity, and talent acquisition

Our solution delivered immediate benefits upon implementation, ensuring consistent Key Performance Indicators (KPIs) among various user groups and HR departments for enhanced alignment and clarity in performance evaluation.

It established a single source of truth for all reporting purposes, streamlined data access, and boosted confidence in data integrity. Improved planning in hiring processes led to smoother recruitment operations and talent acquisition. It also strengthened employee retention efforts, fostering workforce stability and organizational growth. Introduction of HR360 dashboards empowered strategic decision-making with insightful analytics and performance metrics.

The ongoing value of HR360 for performance monitoring, adaptability, and strategic decision-making

Our client will continue to reap the benefits of our solution over time. For ongoing growth and enhancement, HR360 offers month-to-month and year-over-year KPI comparisons, providing valuable insights into performance trends and identifying areas for improvement

In addition, the client will be empowered to make data-driven decisions and adapt to evolving business needs by using the dashboards for ad-hoc analysis and future projects. Our solution also equips the client with the capability to identify the need for policy changes through advanced features such as headcount forecasting and turnover prediction, ensuring agility and resilience in navigating organizational challenges.

The immediate benefits The long-term impact

Consistent KPIs & single source of truth

Continued benefit from HR360 insights

Enhanced hiring planning & retention

Dashboards for analysis & policy adaptation

Access the PDF version of this case study for convenient reference and easy sharing.

Download PDF Don’t let data get lost in translation

Explore Fractal’s capabilities & industries

Financial Services

Explore industry

Contact Us

Enable better decisions with us

    *By submitting your details, you are agreeing to receive communications about Fractal resources, events, products, or services. By submitting this form you are acknowledging that you have read and agree to our privacy statement.