US

Pentaho and microstrategy audit for Palmers Textil

  • 10

    10 issues identified in 2 areas

  • pentaho and microstrategy audit for palmers textil icon 1

    DWH documents created

  • pentaho and microstrategy audit for palmers textil icon 2

    KPIs suggested for better analysis

Project overview

Palmers Textil AG is one of the largest fashion brands in Austria. It was founded back in 1914 and evolved over time. In the 2000s and 2010s, Palmers started the global digitalization campaign. We joined it as experts in digital transformation, business analysis, and development. Particularly, DICEUS carefully analyzed internal ETL processes, including an audit of Pentaho and MicroStrategy. We identified issues and suggested solutions.

Client information

Palmers Textil AG is an international clothing brand that originated in Austria. Ludwig Palmers started it as a laundry back in 1914. In 2000, the company opened its first online shop. Since 2015, Palmers is owned by P Tex Holding GmbH. Today, the brand sells underwear, clothes, and accessories in more than 300 stores in 17 countries.

pentaho and microstrategy audit for palmers textil logo

Business challenge

Due to outdated digital solutions, our client faced problems with business processes. Furthermore, in-house IT experts didn’t work closely with key users from other departments, so they had unaligned goals. The company wanted to analyze ETL processes and report systems to optimize operations, save costs, fix issues. Our team reviewed core areas, divided issues into three categories by urgency, and proposed improvements.

Technical challenges

Two target areas of the audit were Pentaho and MicroStrategy. We had to check the related processes and data-related activities. As long as MicroStrategy is the visualization tool for reports, we also worked with these documents. Many environment elements were undocumented and difficult to analyze. At all, we spotted minor, middle, and major issues related to ETL, data processing, and reporting.

Audit areas

Pentaho

According to the audit, the company has four core servers: SAP, POS, FBC, and CRM. They exchange data with the data warehouse or DWH. These operations rely on Pentaho – the software solution that provides data integration, OLAP, and ETL. In total, we’ve identified 4 issues, including 2 major ones: missing key info in the DWH and not optimized OLAP schemas. Suggested improvements:
  • Gather, update, and make new documents related to DWH and ETL processes
  • Optimize ETL processes, remove irrelevant data transfers
  • Prepare and test transformations in SAP and POS servers
  • Redesign the main DWH schema according to the department’s goals
pentaho and microstrategy audit for palmers textil audit 1

MicroStrategy

MicroStrategy is a company behind graphical and visualization solutions for reports. Working on this project, we tested how the software works for Palmers. We checked several reports, overall performance, user experience for sales, marketing, inventory, and other reports. The total number of issues was 6, including 2 major ones. The main problem was that many reports didn’t meet the goals of users and their departments. Also, results were unverified, so it was barely possible to rely on them.
Suggested improvements:
  • Define key users in each department related to the reporting processes
  • Define the most essential reports for each department
  • Identify goals, set priorities based on general and fashion-retail KPIs
  • Prepare necessary supporting documents, manuals, and data glossary
  • Test the environment, run data verification procedures
  • Train end-users after the system upgrade
  • Use SAP reports, if possible, instead of MicroStrategy
pentaho and microstrategy audit for palmers textil audit 2

Audit results

In two target areas, we identified 10 problems that affected the client’s performance and business results. Generally, this audit showed a lack of critical internal info and process optimization. Based on our suggestions, the company could set new clear processes to improve ETL, data analysis, reporting, and user experience.

Value to our client

  • Insights for better efficiency

    Analyzing MicroStrategy reports, we found that it’s better to use SAP analogs as they’re verified and already integrated. This decision can increase the value of data, improve ETL processes.

  • New documents related to the DWH schema

    During our audit, we’ve started preparing documentation for the data warehouse processes. These docs should help the client with further guides and descriptions.

  • Special diagrams for goals proposed

    We recommended using charts based on the general vision of the company’s goals. This format provides for moving from the long-term vision to SMART goals and KPIs.

  • The most relevant KPIs suggested

    To optimize the entire reporting system, we recommended a few noteworthy KPIs. The list included GMROI, sales per square foot, inventory turnover, buying patterns, NPS.

Our tech stack

  • java Java
  • microstrategy-1 MicroStrategy
  • pentaho-1 Pentaho
  • sap SAP
  • pl-sql PL/SQL

Software solutions bringing business values

gartner
5/5
3 reviews
clutch
4.9/5
47 reviews

    Contact us

    100% data privacy guarantee

    Thank you!
    Your request has been sent
    We will get back to you as soon as possible

    USA (Headquarters)

    +16469803276 2810 N Church St, Ste 94987, Wilmington, Delaware 19802-4447

    Denmark

    +4531562900 Copenhagen, 2900 Hellerup, Tuborg Havnepark 7

    Poland

    +48789743438 ul. Księcia Witolda, nr 49, lok. 15,
    50-202 Wrocław

    Lithuania

    +4366475535405 Vilnius, LT-09308,
    Konstitucijos ave.7
    6th floor

    Faroe Islands

    +298201515 Smærugøta 9A, FO-100 Tórshavn,
    Faroe Islands

    Austria

    +4366475535405 Donau-City-Straße 11 - Ares Tower, 1220 Wien

    UAE

    +4366475535405 Emarat Atrium, 423 Al Wasl Area, Dubai, P.O. Box 112344

    Ukraine

    +4366475535405 Vatslava Havela Boulevard, 4,
    Kyiv
    Case study
    Pentaho and microstrategy audit for Palmers Textil
    diceus.com
    Case study
    Pentaho and microstrategy audit for Palmers Textil
    Project overview
    Palmers Textil AG is one of the largest fashion brands in Austria. It was founded back in 1914 and evolved over time. In the 2000s and 2010s, Palmers started the global digitalization campaign. We joined it as experts in digital transformation, business analysis, and development. Particularly, DICEUS carefully analyzed internal ETL processes, including an audit of Pentaho and MicroStrategy. We identified issues and suggested solutions.
    Client information

    Palmers Textil AG is an international clothing brand that originated in Austria. Ludwig Palmers started it as a laundry back in 1914. In 2000, the company opened its first online shop. Since 2015, Palmers is owned by P Tex Holding GmbH. Today, the brand sells underwear, clothes, and accessories in more than 300 stores in 17 countries.

    Information

    • Team composition: 3 members

      IT project coordinator ; Pentaho/MicroStrategy developer; Mathematician

    • Client name:

      Palmers Textil AG

    • Expertise used:

      Data warehouse and ETL

    • Duration:

      3 months

    • Services provided:

      Software audit

    • Country:

      Austria

    • Industry:

      Retail, Logistics

    Business challenge

    Due to outdated digital solutions, our client faced problems with business processes. Furthermore, in-house IT experts didn’t work closely with key users from other departments, so they had unaligned goals. The company wanted to analyze ETL processes and report systems to optimize operations, save costs, fix issues. Our team reviewed core areas, divided issues into three categories by urgency, and proposed improvements.

    Technical challenges

    Two target areas of the audit were Pentaho and MicroStrategy. We had to check the related processes and data-related activities. As long as MicroStrategy is the visualization tool for reports, we also worked with these documents. Many environment elements were undocumented and difficult to analyze. At all, we spotted minor, middle, and major issues related to ETL, data processing, and reporting.

    Value to our client
    • Insights for better efficiency

      Analyzing MicroStrategy reports, we found that it’s better to use SAP analogs as they’re verified and already integrated. This decision can increase the value of data, improve ETL processes.

    • New documents related to the DWH schema

      During our audit, we’ve started preparing documentation for the data warehouse processes. These docs should help the client with further guides and descriptions.

    • Special diagrams for goals proposed

      We recommended using charts based on the general vision of the company’s goals. This format provides for moving from the long-term vision to SMART goals and KPIs.

    • The most relevant KPIs suggested

      To optimize the entire reporting system, we recommended a few noteworthy KPIs. The list included GMROI, sales per square foot, inventory turnover, buying patterns, NPS.

    Tech stack used in project
    • Java
    • MicroStrategy
    • Pentaho
    • SAP
    • PL/SQL
    diceus.com