Designing Your Data Warehouse from the Ground Up
Check Out Our SSAS Blog - http://blog.pragmaticworks.com/topic/ssas What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session, we’ll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We’ll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.
Видео Designing Your Data Warehouse from the Ground Up канала Pragmatic Works
Видео Designing Your Data Warehouse from the Ground Up канала Pragmatic Works
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Dimensional ModelingSSIS - Loading Dimensions TablesImplementing a Data Warehouse with SQL Server, 01, Design and Implement Dimensions and Fact TablesBuilding Your First Azure SQL Data WarehouseBuild your own Data warehouse in just 4 stepsIQ15: 6 SQL Query Interview QuestionsData Warehousing - An OverviewNormalization - 1NF, 2NF, 3NF and 4NFWhy Data Warehouse Projects are a Bad IdeaWhat is the difference between Database vs. Data lake vs. Warehouse?A Quick Tour about a Data WarehouseCreating a Data Warehouse using SQL Server 2012 and SQL Server Data ToolsETL Architecture In-Depth - Dimensional Modelling 101Introducing the modern data warehouse solution pattern with Azure SQL Data WarehouseSSIS Design Patterns for Loading a Data WarehouseSQL Best Practices - Designing An ETL - Part 13 - ETL Tutorial | Extract Transform and LoadDimensional Modeling to Data Vault EvolutionWhy Surrogate Keys are used in Data Warehouse