How J-Oil Mills Transformed HR Data Management with Panalyt

About

Company: J-Oil Mills

Employee size: 1,300

Industry: Food & Beverage

Interviewee:
– Ken Ogaki, Head of HR Development Group  

– Keisuke Nakamura, HR Development Group  

– Toshihiko Amano, Head of Labor Group  

– Kaori Matsumori, Labor Group 

Interviewer:
Kyogo Hayashi, Customer Business Partner (Panalyt)

The Challenge: Managing Disjointed HR Data Across Multiple Group Companies

J-Oil Mills, like many organizations with a complex structure, faced significant challenges in managing and consolidating HR data across its multiple group companies. Whenever they needed to gather data for financial reports, government submissions, or internal reviews, the HR team had to reach out to each group company individually. This process was inconsistent and time-consuming, often leading to delays and discrepancies.

Data definitions, such as the definition of an “employee,” varied across reports, creating additional confusion. Manual work was the only way to cross-check numbers, leading to hours of labor just to confirm headcount. Adding to the complexity, different HR systems used across group companies meant automation with traditional Business Intelligence (BI) tools was very complex.

In short, the HR team was stuck in a cycle of manual, disjointed, and often frustrating data management.

Enter Panalyt: A Tailored Solution for a Complex Data Problem

When J-Oil Mills explored solutions, they realized that most BI tools were too rigid for their needs, especially considering their frequent organizational restructures. Then, they found Panalyt—a tool that could provide flexible data cleansing and aggregation, tailored to their specific requirements. Panalyt didn’t just offer a system; it offered ongoing support to navigate these complex HR processes and data management issues.

Why Panalyt?

– Panalyt could handle J-Oil Mills’ existing HR data, without needing to reformat it on the client side.

– The tool was flexible enough to deal with varying data structures across group companies.

– The Panalyt team worked closely with J-Oil Mills to ensure smooth implementation, offering hands-on support throughout the onboarding process.

The Solution: Turning Heaps of Data into Actionable Insights

Step-by-Step Onboarding Success

Panalyt’s implementation at J-Oil Mills was smooth and efficient, completed within just over a month. Here’s how the process unfolded:

1. Data Preparation: In just two weeks, J-Oil Mills gathered all their HR data from group companies.

2. Requirement Definition: The next two weeks were spent defining exactly how the data needed to be visualized and accessed by various user types.

3. Data Cleansing & Visualization: Over two more weeks, Panalyt cleaned and visualized the data, making sense of disparate formats.

4. Validation: The final step was verifying that everything matched across companies—a challenge, but Panalyt handled it swiftly.

The HR team noted that trying to do all this in-house would have taken many additional months and became a burden for each company, whereas Panalyt streamlined the process to a fraction of the time and launched the dashboards without hassle for the in-house teams.

Real Impact: Speed, Accuracy, and Simplicity

What changed?

– Time Saved: The HR team no longer spends hours manually cross-checking data or gathering information from group companies. What used to take up to 4 hours can now be done in minutes, even seconds.

– Consistency: Panalyt automatically ensures consistent, clean data across the board, so there’s no need to worry about discrepancies in definitions or employee counts.

– Better Collaboration: Panalyt’s centralized data system means group companies can upload their data directly, drastically reducing back-and-forth communications.

Key Features that influenced the purchase:

– For J-Oil Mills, it was the ease. All subsidiary companies could upload their raw HR data directly to Panalyt in its original format, and Panalyt took care of the rest, cleaning and organizing the data without any additional work for the HR team.

– Even inconsistent data formats (like different ways of labelling job titles or missing resignation dates) were brought to attention and handled seamlessly by Panalyt, ensuring nothing slipped through the cracks.

Looking Ahead: A Strategic Future with Panalyt

J-Oil Mills now has real-time visibility into staffing levels and can see trends across departments and group companies. The next big step? Connecting finance data to the system, allowing the HR team to see not just who is working where and how, but also how staffing decisions impact the company’s business success.

With Panalyt, J-Oil Mills is moving toward a future where HR can take a more strategic role in workforce planning. They’re aiming for data-driven, fact-based conversations about staffing needs and decisions, with HR leading the charge.
“Before Panalyt, managing our workforce was reactive. Now, we can make proactive, data-driven decisions about our workforce.” – Ken Ogaki, Head of HR Development

Conclusion: A Game-Changer for J-Oil Mills

By partnering with Panalyt, J-Oil Mills has turned a fragmented, manual data process into a streamlined, automated system. Not only has this saved time, but it has also empowered the HR team to take control of workforce management in a strategic, data-driven way.

For J-Oil Mills, the future is clear: real-time data, strategic workforce planning, and a more proactive approach to HR management—all made possible with Panalyt.

Want to learn how Panalyt can help your organization? Contact us today!