AI Use Cases
synvert Accel­er­at­ors
geerntetes Getreidefeld an einem sonnigen Tag mit einigen Wolken
Suc­cess stories

FOAG Switzer­land  - Stand­ard­iz­a­tion of eval­u­ation processes

Go back to success stories

Brief his­tory

The Fed­eral Office for Agri­cul­ture of Switzer­land (FOAG) is the fed­eral administration’s com­pet­ence cen­ter for the agri­cul­tural sec­tor. In addi­tion to its polit­ical and admin­is­trat­ive func­tion, it is respons­ible for the col­lec­tion, ana­lysis and pub­lic­a­tion of agri­cul­ture-related data. With a data ware­house and report­ing sys­tem, a pro­fes­sional, stand­ard­ized and auto­mated solu­tion for this task was cre­ated through a uni­form data­base and stand­ard­iz­a­tion of the eval­u­ation processes.

“The con­tact with synvert was easy from the very first moment and we were able to con­cen­trate on the work from the very first minute, which took place in an extremely pleas­ant atmosphere.”

Olivier Roux
Stv. Leiter Fachbereich Agrarinformationssystem
FOAG Switzer­land
Olivier Roux

“To real­ize our BI plat­form, we chose synvert from a large selec­tion of poten­tial candidates.

The con­tact with synvert was easy from the very first moment and we were able to con­cen­trate on the work from the very first minute, which took place in an extremely pleas­ant atmosphere.

Our BI solu­tion had to be com­pletely rebuilt, from the infra­struc­ture to the enter­prise DWH with com­plex ETL routes to the dash­board. Thanks to the out­stand­ing tech­nical and social skills of the con­sult­ants, all pro­ject goals were suc­cess­fully real­ized within the planned budget.

In par­tic­u­lar, the imple­ment­a­tion of the mul­ti­di­men­sional ana­lysis rooms proved to be very bene­fi­cial. It now allows our employ­ees who are respons­ible for the ana­lysis to handle a large amount of inform­a­tion in a par­tic­u­larly intu­it­ive way.

To ensure oper­a­tion and fur­ther devel­op­ment with internal employ­ees, we have also focused on tech­no­logy and know-how trans­fer. This del­ic­ate point also proved to be a real suc­cess thanks to the excel­lent coach­ing skills of synvert .”

Goals & challenges

The cent­ral require­ment was to set up a data ware­house in which all agri­cul­tural top­ics in Switzer­land could be suc­cess­ively recor­ded and integ­rated. Import­ant aspects that were to be taken into account:

  • Estab­lish­ment of uni­form busi­ness intel­li­gence expert­ise at the Fed­eral Office for Agriculture
  • Sim­pli­fic­a­tion and auto­ma­tion of exist­ing pre­par­a­tion and report­ing processes
  • Replace­ment of manu­ally cre­ated SQL-based eval­u­ations with a stand­ard report­ing solu­tion that is easy to use (self-ser­vice)
  • Expan­sion of the tar­get group to include spe­cial­ists and pub­lic tar­get groups who, in addi­tion to the annual agri­cul­tural report, should also have inter­act­ive access to the Fed­eral Office’s stat­ist­ics via the Internet

Archi­tec­ture

A clas­sic data ware­house archi­tec­ture based on best prac­tices is used at the Fed­eral Office for Agri­cul­ture. Based on vari­ous source sys­tems that are oper­ated and main­tained dir­ectly by the FOAG, vari­ous external source sys­tems must be integ­rated. The source sys­tem data can be sup­plied via dif­fer­ent chan­nels and is his­tor­icized and per­sisted in a sta­ging area in the first step. In order to be able to expand the sys­tem effi­ciently in the future, the extrac­tion and trans­fer of data from the source sys­tems to the sta­ging area has been auto­mated. The sta­ging area forms the basis for the data ware­house modeled in the Galaxy schema. The dimen­sion­ally modeled frame­work man­ager mod­els are based on this. For selec­ted data-intens­ive eval­u­ation areas, addi­tional data marts are gen­er­ated in which per­form­ance-crit­ical cal­cu­la­tions are avail­able in pre-aggreg­ated form. Reports and dash­boards are provided for ana­lysis and mon­it­or­ing pur­poses, while stand­ard reports are also used to pub­lish statistics.

Gen­er­ated bene­fits

  • Expand­able DWH infra­struc­ture based on best prac­tices with estab­lished technologies
  • Enabling cross-source sys­tem eval­u­ations and util­iz­a­tion of ad-hoc ana­lysis options
  • Stand­ard­iz­a­tion and sim­pli­fic­a­tion of the con­nec­tion of source systems
  • Reduc­tion of manual effort when cre­at­ing evaluations
  • Cre­ation of uni­form defin­i­tions, report­ing stand­ards and a uni­form appear­ance of evaluations

Ser­vices accom­plished by synvert 

synvert provided the fol­low­ing ser­vices as a com­pet­ent partner:

  • Car­ry­ing out the busi­ness ana­lysis and cre­at­ing the spe­cial­ist con­cepts and tech­nical concepts
  • Archi­tec­tural design
  • Struc­ture of ETL pro­cesses with gen­eric com­pon­ents and com­plex historization
  • Data mod­el­ing of rela­tional data lay­ers (core DWH, data marts)
  • Struc­ture of the dimen­sion­ally modeled IBM Cognos Frame­work Man­ager models
  • Cre­ation of stand­ard reports
  • Con­fig­ur­a­tion of the IBM Cognos BI sys­tem, in par­tic­u­lar adapt­a­tion to the cor­por­ate design and con­sid­er­a­tion of the author­iz­a­tion concept
  • Sup­port with test­ing and pro­duct­ive implementation
  • Imple­ment­a­tion of train­ing courses for admin­is­trat­ors and users

Deliv­ery / conclusion

The data ware­house and report­ing sys­tem has cre­ated a stand­ard­ized and auto­mated tech­nical basis that allows the Fed­eral Office for Agri­cul­ture (FOAG) to per­form its tasks of col­lect­ing, pro­cessing and present­ing agri­cul­ture-related data pro­fes­sion­ally and with little effort. In par­tic­u­lar, the know-how with regard to dif­fer­ent archi­tec­tures as well as the exper­i­ence in design and con­cep­tion have cre­ated a new, stable plat­form as the basis for the future BI land­scape in a short time. In this respect, synvert has become a valu­able con­sult­ing and integ­ra­tion part­ner for the Fed­eral Office for Agriculture.

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

Vehicle Data Store
Indus­tri­als

Soft­ware­Fact­ory at a lead­ing auto­mot­ive soft­ware company
Con­sumer Goods & Retail

DevX Impact at a HR-Tech Company
Con­sumer Goods & Retail

Driv­ing Inter­na­tional Expan­sion for a Lead­ing Online Car Seller
Indus­tri­als

Accel­er­at­ing Cloud-Nat­ive Devel­op­ment for a Car Manufacturer
Com­mu­nic­a­tions, Media & Telecom

Retail Com­mis­sion Dia­gnostics Anom­aly Detection
Energy & Resources

Set­ting up a Reli­able and Power­ful Platform
Com­mu­nic­a­tions, Media & Telecom

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

Early Detec­tion of Mech­an­ical Issues
Indus­tri­als

NLP​ in Auto­mot­ive Reporting
Com­mu­nic­a­tions, Media & Telecom

Oper­a­tional Data Lake
Con­sumer Goods & Retail

Real-Time Mar­ket­ing
Indus­tri­als

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

Dies­el­tech Program
Com­mu­nic­a­tions, Media & Telecom

Data Recon­cili­ation
Indus­tri­als

Cent­ral­ized Data Warehouse
Indus­tri­als

Data as a Ser­vice – BI & Big Data CC
Com­mu­nic­a­tions, Media & Telecom

Oper­a­tional Work/Support in Data Warehousing
Indus­tri­als

Erosion Detec­tion with Com­puter Vision
Com­mu­nic­a­tions, Media & Telecom

Devel­op­ment and Imple­ment­a­tion of a Fully Auto­mated MLOps Platform
Con­sumer Goods & Retail

Pre­dic­tion and Alloc­a­tion Optim­iz­a­tion for sta­tion­ary Channels
Com­mu­nic­a­tions, Media & Telecom

Build­ing a Near Real-Time Recom­mend­a­tion System
Con­sumer Goods & Retail

Migra­tion AWS data plat­form to Google Cloud
Com­mu­nic­a­tions, Media & Telecom

Design and Devel­op­ment of a Google Cloud-Based Data Platform
Con­sumer Goods & Retail

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
Indus­tri­als

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
Con­sumer Goods & Retail

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.