Designing a schema for a data warehouse

Are you new to data warehouses? Do you need to check whether your data warehouse follows the best practices for a good design? In both cases, this webinar is for you.

A data warehouse is a central relational database that contains all measurements about a business or an organisation. This data comes from a variety of heterogeneous data sources, which includes databases of any type that back the applications used by the company, data files exported by some applications, or APIs provided by internal or external services.

But designing a data warehouse correctly is a hard task, which requires gathering information about the business processes that need to be analysed in the first place. These processes must be translated into so-called star schemas, which means, denormalised databases where each table represents a dimension or facts.

During this webinar, Vettabase Founder Federico Razzoli discusses the following topics:

- How to gather information about a business;
- Understanding dictionaries and how to identify business entities;
- Dimensions and facts;
- Setting a table granularity;
- Types of facts;
- Types of dimensions;
- Snowflakes and how to avoid them;
- Expanding existing dimensions and facts.

Видео Designing a schema for a data warehouse канала Vettabase