88. spotkanie Data Community Kraków - Study Group 70-767 #1

This is a past event

32 people went

Location image of event venue

Details

Zapraszamy na pierwsze spotkanie Study Group przygotowujące do egzaminu[masked]: Implementing a Data Warehouse using SQL organizowane przez Data Community - Kraków.

KIEDY
21 marca (czwartek) godz. 17:30

AGENDA
17:30 – 17:40 Rozpoczęcie spotkania, sprawy organizacyjne
17:40 – 18:40 Design and implement dimension and fact tables - Michał Sadowski
18:40 – 19:00 Networking
19:00 - 20:00 Design and implement indexes and storage for a data warehouse workload - Michał Sadowski
20:00 - 20:10 Zakończenie spotkania

ABSTRAKTY
Study Group przygotowuje do egazminu[masked]: Implementing a Data Warehouse using SQL organizowane . Na spotkaniu będziemy omawiać nastepujące wymagania do egazminu:
Design and implement dimension tables - Design shared and conformed dimensions, determine support requirements for slowly changing dimensions, determine attributes, design hierarchies, determine star or snowflake schema requirements, determine the granularity of relationship by using fact tables, determine auditing or lineage requirements, determine keys and key relationships for a data warehouse, implement dimensions, implement data lineage of a dimension table
Design and implement fact tables - Identify measures, identify dimension table relationships, create composite keys, design a data warehouse that supports many-to-many relationships, implement semi-additive measures, implement non-additive measures
Design and implement indexes for a data warehouse workload - Design an indexing solution; select appropriate indexes; implement clustered, non-clustered, filtered, and columnstore indexes
Design storage for a data warehouse - Design an appropriate storage solution, including hardware, disk, and file layout