Bill Inmon and Francesco Puppini: "Building the Unified Star Schema"

Bill Inmon and Francesco Puppini: "Building the Unified Star Schema"

Special guests Francesco Puppini and Bill Inmon joined a virtual meeting of the User Group to give us a preview of their new book "Building the Unified Star Schema".  A short 30 minute recording is now available. Bill Inmon, regarded as the father of the data warehouse, gives an introduction to the issues resulting from a proliferation of data marts around data warehouses.  Then Francesco Puppini, a freelance consultant in business intelligence and data warehousing, presents in detail the approach he is pioneering for the unified star schema (the "Puppini Bridge"). Are you are building marts for your Data Vault using a Kimball approach BUT... Kimball's star schemas have a big limitation: he does not tell you what to do when a query involves multiple fact tables. How do we merge two star schemas? It usually ends up with an "ad-hoc approach”, where a data analyst writes an SQL query, specific for a business requirement. But this means that the business users do not have full access to a proper experience of self-service analytics: for every new requirement they need to go through a data expert. What if we could build a special data structure that involves all the required facts and dimensions, all connected together in a single star schema, easy to use, and always available for self-service analytics? Francesco's innovative solution is the subject of this video! Subsequent to this presentation Francesco and Bill’s book “The Unified Star Schema: An Agile and Resilient Approach to Data Warehouse and Analytics Design” is now available on Amazon and at https://technicspub.com/uss/.