ILMAINEN WEBINAARI: Unified Star Schema – New Paradigm of Data Modeling and Analytics

Kurssin esittely

Francesco Puppini will present the Unified Star Schema. The democratization of data is continuously improving, but there is still a lot to achieve. Self Service Business Intelligence today exists for data experts, but it does not exist for average business users. Every time a new business requirement arises, some new code must be written. This ”ad-hoc” approach is slow, expensive, and painful.

”The Unified Star Schema” (USS): it is a special data model that acts as a foundation for all the possible analytical requirements of your organization (reports, dashboards, OLAP cubes, free-hand SQL, R, Python, machine learning models…). It is a generalization of the Dimensional Modeling: the same structure can be used either for a classic Kimball approach (having many star-snowflake schemas sharing conformed dimensions) or one universal star schema, where all facts and dimensions are pre-connected, all centered on the the ”Bridge” (some call it the ”Puppini Bridge”).

This structure will NEVER create any duplication in your data: this is a massive achievement!!! This solution also solves the problem of circular references and non-confirmed granularities. And especially, it allows working on data that comes from multiple fact tables. It is not easy to build, but it is incredibly easy to use.

In this workshop, you will become familiar with the Unified Star Schema (USS). You will see that one single Star Schema can satisfy multiple business requirements, and potentially all of them. You will understand how the USS makes this possible. You will see a live demo with Tableau and ThoughtSpot.

The session will be highly interactive, because the USS is a work in progress, and you will become part of a community that works constantly to make this resource useful to every data practitioner, across multiple countries, industries, and technologies.

+ Lue koko kurssiesittely

Kouluttaja:

Francesco Puppini

Lue lisää

ILMAINEN WEBINAARI: Unified Star Schema – New Paradigm of Data Modeling and Analytics

Teema:
Ketterä kehitys
Kouluttaja:
Francesco Puppini
Kieli:
English
Kesto:
1.5 hours
Paikka:
Remote training 15-16.30
Aloituspäivämäärät:
Ota yhteyttä

Kurssilla ei ole aktiivisia aloituspäivämääriä, jos olet kiinnostunut kurssista ota yhteyttä.

Ota yhteyttä

Ilmoittakaa minulle seuraavasta toteutuksesta.

  • Kenttä on validointitarkoituksiin ja tulee jättää koskemattomaksi.

 

Tuleeko yrityksestäsi useampi osallistuja?

Järjestämme myös yrityskohtaisia kursseja.

Haluan koulutuksen koko yritykselleni

Saattaisit olla kiinnostunut myös näistä

Tiedolla johtaminen

Practical steps for developing Data Strategy and Governance

Lue lisää
Datan hallinta

Data Management Fundamentals and DAMA Certification Preparation

Lue lisää
Datan hallinta

Centralised Data Governance of a Distributed Data Landscape

Lue lisää
+