88. spotkanie Data Community Kraków
- 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
Zapraszamy na pierwsze spotkanie Study Group przygotowujące do egzaminu 70-767: Implementing a Data Warehouse using SQL organizowane przez Data Community - Kraków.
KIEDY
21 marca (czwartek) godz. 17:30
ABSTRAKTY
Study Group przygotowuje do egazminu 70-767: 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
