Array
(
    [en-en] => Array
        (
            [id] => 22
            [order] => 0
            [slug] => en-en
            [locale] => en-GB
            [name] => England (English)
            [url] => https://synvert.com/en-en/successstories/cloud-self-service-bi-for-data-driven-corporate-management/
            [flag] => https://synvert.com/wp-content/plugins/polylang-pro/vendor/wpsyntex/polylang/flags/gb.png
            [current_lang] => 1
            [no_translation] => 
            [classes] => Array
                (
                    [0] => lang-item
                    [1] => lang-item-22
                    [2] => lang-item-en-en
                    [3] => current-lang
                    [4] => lang-item-first
                )

            [link_classes] => Array
                (
                )

        )

    [ch-de] => Array
        (
            [id] => 2224
            [order] => 0
            [slug] => ch-de
            [locale] => de-CH
            [name] => Schweiz (Deutsch)
            [url] => https://synvert.com/ch-de/success-stories/vorwerk-schweiz/
            [flag] => https://synvert.com/wp-content/plugins/polylang-pro/vendor/wpsyntex/polylang/flags/ch.png
            [current_lang] => 
            [no_translation] => 
            [classes] => Array
                (
                    [0] => lang-item
                    [1] => lang-item-2224
                    [2] => lang-item-ch-de
                )

            [link_classes] => Array
                (
                )

        )

    [de-de] => Array
        (
            [id] => 20
            [order] => 1
            [slug] => de-de
            [locale] => de-DE
            [name] => Deutschland (Deutsch)
            [url] => https://synvert.com/de-de/SuccessStories/vorwerk-schweiz/
            [flag] => https://synvert.com/wp-content/plugins/polylang-pro/vendor/wpsyntex/polylang/flags/de.png
            [current_lang] => 
            [no_translation] => 
            [classes] => Array
                (
                    [0] => lang-item
                    [1] => lang-item-20
                    [2] => lang-item-de-de
                )

            [link_classes] => Array
                (
                )

        )

)
AI Use Cases
synvert Accel­er­at­ors
ein-lager-mit-einer-holzpalette-auf-dem-boden
Suc­cess stories

Vor­werk Switzerland  - Cloud self-ser­vice BI for data-driven cor­por­ate management

Go back to success stories

Brief his­tory

For more than 130 years, Vorwerk’s Ther­mo­mix® kit­chen appli­ances and Kobold vacuum clean­ers have impressed mil­lions of fam­il­ies with their super­ior, innov­at­ive tech­no­logy and their pro­ver­bial long ser­vice life. The products are not sold via tra­di­tional retail­ers, but via dir­ect sales. Through­out Switzer­land, over 1,500 rep­res­ent­at­ives are on hand to provide cus­tom­ers with per­sonal advice and sup­port before and after their purchase.

For data-driven cor­por­ate man­age­ment, it should be pos­sible to use exist­ing data treas­ures quickly and eas­ily. A self-ser­vice BI is designed to bring together internal and external data sources for the analyst and make them usable. The Vor­werk Switzer­land PowerBI pro­ject cre­ates a flex­ible and power­ful BI solution.

Goals & challenges

The exist­ing eval­u­ations made insuf­fi­cient and inflex­ible use of the avail­able data for data-driven cor­por­ate man­age­ment and the acquis­i­tion of insights. The “Vor­werk Switzer­land PowerBI” pro­ject aimed to cre­ate a new plat­form with which internal data from ERP, HR and account­ing as well as external data could be linked and ana­lyzed eas­ily and flex­ibly by users. Expenses needed to be massively reduced through extens­ive auto­ma­tion and self-ser­vice. Manu­ally col­lect­ing and pre­par­ing data in Microsoft Excel were meant to be a thing of the past with the new solu­tion. After­wards, Spe­cial­ists were planed to be able to focus more on ana­lysis rather than pre­par­a­tion. The aim was to cre­ate a single source of truth for the vari­ous ana­lyses. Des­pite the ambi­tious object­ive, the lim­ited IT skills and resources were meant to also be taken into account with a prag­matic over­all solution.

Archi­tec­ture

Due to the tech­nical focus of Vor­werk Switzer­land and the use of Microsoft Office 365, the BI solu­tion is based on Microsoft’s BI products. The data from the SELECTLINE ERP and external data is loaded into an SQL Server data­base (on premise) using Microsoft SQL Server Integ­ra­tion Ser­vices. The neces­sary trans­form­a­tions, his­tor­iz­a­tions and DQ checks are car­ried out. The data­base is used as a single source of truth from which topic-ori­ented data sets are cre­ated in Microsoft PowerBI Ser­vices. These data sets provide the eval­u­ation-optim­ized data­base in the sense of data marts for the visu­al­iz­a­tions (ana­lyses and stand­ard reports) in Microsoft PowerBI Ser­vices. The ana­lyses and users use work­spaces and apps in the Microsoft PowerBI Portal to access ana­lyses and information

Gen­er­ated bene­fits

The BI solu­tion developed provides the fol­low­ing benefits:

  • The data from internal and external data sources is auto­mat­ic­ally avail­able for ana­lysis and report­ing on an hourly basis.
  • The his­tor­icized stor­age of mas­ter data enables ana­lyses in the “as booked” and “as today” view­points, thus massively expand­ing the per­spect­ive of the ERP system.
  • All ana­lyses are based on uni­form data truth and trans­par­ent data defin­i­tions thanks to the data catalog.
  • Ana­lysts can gain new insights from the data quickly and inde­pend­ently with self-ser­vice. The time required for manual data pre­par­a­tion has been massively reduced.
  • A data-driven man­age­ment cul­ture and an “ana­lyt­ical mind­set” were established.

Ser­vices accom­plished by synvert 

As a com­pet­ent part­ner, synvert provided the fol­low­ing services:

  • Car­ry­ing out the require­ments ana­lysis and archi­tec­ture definition
  • Pro­fes­sional and tech­nical con­cep­tion and data modeling
  • Sup­port with source sys­tem analysis
  • Imple­ment­a­tion of ETL pro­cesses with Microsoft SSIS
  • Struc­ture of the data sets and key fig­ure cal­cu­la­tions with DAX in Microsoft PowerBI
  • Sup­port and coach­ing in the imple­ment­a­tion of visu­al­iz­a­tion with Microsoft PowerBI
  • Sup­port in oper­a­tion and fur­ther development

Deliv­ery / conclusion

The intro­duc­tion of cloud-based self-ser­vice BI has made it much easier and more flex­ible to use the exist­ing data from the ERP sys­tem for ana­lyses. The his­tor­icized view of the data and the link­ing of internal and external data has made it pos­sible to gain valu­able new insights. The cloud-based infra­struc­ture makes the use of inform­a­tion for ana­lysts and man­age­ment inde­pend­ent of loc­a­tion, time and medium. The prag­matic archi­tec­ture and tech­nical imple­ment­a­tion enable simple and secure oper­a­tion. Over­all, the “Vor­werk Switzer­land PowerBI” is a first step towards data-driven cor­por­ate man­age­ment and massively increases the import­ance of data as a resource within the company.

Categories
All
Tech
Banking
Communications, Media & Telecom
Consumer Goods & Retail
Energy & Resources
Health & Life Science
Industrials
Insurance
Public Sector

Vehicle Data Store

Soft­ware­Fact­ory at a lead­ing auto­mot­ive soft­ware company

DevX Impact at a HR-Tech Company

Driv­ing Inter­na­tional Expan­sion for a Lead­ing E‑Commerce Company

Accel­er­at­ing Cloud-Nat­ive Devel­op­ment in the Auto­mot­ive Industry

Retail Com­mis­sion Dia­gnostics Anom­aly Detection

Set­ting up a Reli­able and Power­ful Platform

Pre­dic­tion of cus­tomer prob­ab­il­ity to churn

Early Detec­tion of Mech­an­ical Issues

NLP​ in Auto­mot­ive Reporting

Oper­a­tional Data Lake

Real-Time Mar­ket­ing

Auto­matic clas­si­fic­a­tion of cars by their model

Dies­el­tech Program

Data Recon­cili­ation

Cent­ral­ized Data Warehouse

Data as a Ser­vice – BI & Big Data CC

Oper­a­tional Work/Support in Data Warehousing

Erosion Detec­tion with Com­puter Vision

Devel­op­ment and Imple­ment­a­tion of a Fully Auto­mated MLOps Platform

Pre­dic­tion and Alloc­a­tion Optim­iz­a­tion for sta­tion­ary Channels

Build­ing a Near Real-Time Recom­mend­a­tion System

Migra­tion AWS data plat­form to Google Cloud

Design and Devel­op­ment of a Google Cloud-Based Data Platform

Refact­or­ing, shift and new devel­op­ment of Data Ser­vices in Google Cloud

Estab­lish­ment of a Mas­ter Data Man­age­ment Foundation

Cent­ral Data Lake

Replace­ment of a com­plex IBM Data­stage structure

CRM ana­lyt­ics and lead management

Stand­ard­iz­a­tion of eval­u­ation processes

Devel­op­ment of an ERP data hub

Estab­lish­ment and fur­ther devel­op­ment of a DWH

Devel­op­ment of a group-wide BI platform

Estab­lish­ment of a new sales report­ing system

Source data migra­tion with auto­ma­tion of the source data connection

Cloud self-ser­vice BI for data-driven cor­por­ate management

Devel­op­ment of vari­ous ML use cases with AWS

Replace­ment of an in-house soft­ware development

Com­pany-wide data integration

Imple­ment­a­tion of real-time data links

Smart Data Catalog

Contact us

* Required fields
top

Thank you!

You will shortly receive an email to activ­ate your account.

Log in

Browse webinar videos and white­pa­pers from synvert any­time you want

Reset pass­word

For­got your pass­word? Enter your email address and you will receive a link to reset your password.

Log in

You are suc­cess­fully logged in.

Register

Thank you!

You will shortly receive an email to activ­ate your account.

Log out

You are suc­cess­fully logged out.