Skip to content

Organization

Tunap is an internationally active German group that develops and produces aerosols, lubricants and cleaners for industrial and technical applications, offering complete solutions from in‑house research and development through manufacturing to direct sales, with a strong focus on innovative, sustainable and health‑ and environmentally compatible products serving automotive, industrial, private‑label and sports segments, supported by several production sites, a dense international sales network, online B2B and B2C shops, and positioning itself as a modern, attractive employer with diverse career opportunities and global locations.

Internet: https://www.tunap.com/

Power Partners company code: #tun

Company Structure

Tunap is part of the Würth Group. For IT matters, group standards apply.

Key People

The key people at #tun are:

  • BE:

    • Leon Mooibroek

  • DE:

    • Sales
      • Sergej Pawlitschek: Head of Sales
      • Nicolas Lehnert: our main contact
    • IT:
      • Franz-Xaver Pöschl: Head of IT, our formal sponsor
      • Korbinian Kraus: From Group IT, the person that provides access, creates users, etc.

Project History

Phase 1: Belgium

We started working with the Belgian country office. Later, our tool was rolled out to Germany.

Phase 2: Germany

Today, the project is sponsored by the German HQ.

We added many more source files.

The process was, in a nutshell:

  1. Nicolas received the Emails from his counterparts

  2. He then used a Translator file to map the Representatives to IDs.

  3. The translated files were then imported by Power BI

Nicolas Lehnert was our main contact.

flowchart TD
    n1["Haeusler<br>2025KW17"] --> n3["global cube<br>Translator"]
    n2["Lueg<br>2025KW17"] --> n4["Lueg<br>Translator"]
    n3 --> n5["Input DE"]
    n4 --> n5
    n5 --> n7["Sales Report<br>Semantic Model"]
    n6["Input IT"] --> n7
    n7 --> n8["Sales Report"]
    n9["other<br>2025KW17"] --> n3
    n1@{ shape: procs}
    n3@{ shape: tag-proc}
    n2@{ shape: procs}
    n4@{ shape: tag-proc}
    n5@{ shape: rect}
    n7@{ shape: db}
    n6@{ shape: rect}
    n8@{ shape: rounded}
    n9@{ shape: procs}

Phase 3: Dataflows

In 2025-12, we started moving the imports from Power Query / Dataset imports to Dataflows.

See #13011 for details.