Videos Complementarios
Capítulo 1 - Introducción al Business Intelligence
Capítulo 2 - Metodologías y Herramientas aplicadas a soluciones BI
Bill Inmon & Intellego - Business Intelligence y Data Warehousing
Metodología de Ralph Kimball para la Implementación de DW/BI
Capítulo 3 - Gestión de Proyectos de Inteligencia de Negocio
Capítulo 4 - Diseño de un Data Mart
Exposición Modelo Multidimensional -2015 BDhttps://www.youtube.com/watch?v=j0kl1vZjsGE
Modelo Multidimensional
https://www.youtube.com/watch?v=gqftTcKvGvQ
Capítulo 5 - Datawarehousing y Datawarehouse
Data Warehousing - An Overview
Introduction to Microsoft Parallel Data Warehouse (PDW)
Building BI Solutions with Microsoft SQL Server Parallel Data Warehouse (PDW)
Polybase in the Modern Data Warehouse
Capítulo 6 - Poblando un Data Mart
Carga Datos nuevos ETL
http://www.guillesql.es/Articulos/SQLServerIntegrationServices_SSIS_FAQ.aspx
Getting Started
https://www.youtube.com/watch?v=3cPq9FXk-RA - SQL Server Integration Services (SSIS) Part 1 - Getting Started
Performing Basic Tasks
https://www.youtube.com/watch?v=tHbjhSEiyOs - SQL Server Integration Services (SSIS) Part 2 - Performing Basic Tasks
Basic Transformations
https://www.youtube.com/watch?v=VZrlXwM0_Pg - SQL Server Integration Services (SSIS) Part 3 - Basic Transformations
Variables
https://www.youtube.com/watch?v=S9c8kB7j7ao - SQL Server Integration Services (SSIS) Part 4 - Variables
Data Types and Data Conversion
https://www.youtube.com/watch?v=8I9IfZUK2dk - SQL Server Integration Services (SSIS) Part 5 - Data Types and Data Conversion
Expressions
https://www.youtube.com/watch?v=a0fCg7jvESM - SQL Server Integration Services (SSIS) Part 6 - Expressions
Conditional split and derived column transforms
https://www.youtube.com/watch?v=QSuI-qV7yWY - SQL Server Integration Services (SSIS) Part 7 - Conditional split and derived column transforms
Debugging
https://www.youtube.com/watch?v=OsqQT6eHs00 - SQL Server Integration Services (SSIS) Part 8 - Debugging
Lookup Transforms
https://www.youtube.com/watch?v=GazT32eqdsk - SQL Server Integration Services (SSIS) Part 9 - Lookup Transforms
Sequence Containers and FOR Loops
https://www.youtube.com/watch?v=lL63ZSRp_Ck - SQL Server Integration Services (SSIS) Part 10 - Sequence Containers and FOR Loops
Looping Over Files
https://www.youtube.com/watch?v=h6x0oI9gSh8 - SQL Server Integration Services (SSIS) Part 11 - Looping Over Files
Other Foreach Loops
https://www.youtube.com/watch?v=HIp06xn8puw - SQL Server Integration Services (SSIS) Part 12 - Other Foreach Loops
Script Tasks using C#
https://www.youtube.com/watch?v=iPmXgiUHUPQ - SQL Server Integration Services (SSIS) Part 13 - Script Tasks using C#
Script Tasks using Visual Basic
https://www.youtube.com/watch?v=VWLlIXjUtgY - SQL Server Integration Services (SSIS) Part 14 - Script Tasks using Visual Basic
Script Components
https://www.youtube.com/watch?v=nIPZvzivo_M - SQL Server Integration Services (SSIS) Part 15 - Script Components
Expression and Other Constraints
https://www.youtube.com/watch?v=oqiG4oNyvHk - SQL Server Integration Services (SSIS) Part 16 - Expression and Other Constraints
Event-handling and logging
https://www.youtube.com/watch?v=xFx4adO92gg - SQL Server Integration Services (SSIS) Part 17 - Event-handling and logging
Error handling
https://www.youtube.com/watch?v=LzFxNFPrPyQ - SQL Server Integration Services (SSIS) Part 18 - Error handling
Parameters and deployment
https://www.youtube.com/watch?v=idFCAFAgOO0 - SQL Server Integration Services (SSIS) Part 19 - Parameters and deployment
Getting Started
https://www.youtube.com/watch?v=3cPq9FXk-RA - SQL Server Integration Services (SSIS) Part 1 - Getting Started
Performing Basic Tasks
https://www.youtube.com/watch?v=tHbjhSEiyOs - SQL Server Integration Services (SSIS) Part 2 - Performing Basic Tasks
Basic Transformations
https://www.youtube.com/watch?v=VZrlXwM0_Pg - SQL Server Integration Services (SSIS) Part 3 - Basic Transformations
Variables
https://www.youtube.com/watch?v=S9c8kB7j7ao - SQL Server Integration Services (SSIS) Part 4 - Variables
Data Types and Data Conversion
https://www.youtube.com/watch?v=8I9IfZUK2dk - SQL Server Integration Services (SSIS) Part 5 - Data Types and Data Conversion
Expressions
https://www.youtube.com/watch?v=a0fCg7jvESM - SQL Server Integration Services (SSIS) Part 6 - Expressions
Conditional split and derived column transforms
https://www.youtube.com/watch?v=QSuI-qV7yWY - SQL Server Integration Services (SSIS) Part 7 - Conditional split and derived column transforms
Debugging
https://www.youtube.com/watch?v=OsqQT6eHs00 - SQL Server Integration Services (SSIS) Part 8 - Debugging
Lookup Transforms
https://www.youtube.com/watch?v=GazT32eqdsk - SQL Server Integration Services (SSIS) Part 9 - Lookup Transforms
Sequence Containers and FOR Loops
https://www.youtube.com/watch?v=lL63ZSRp_Ck - SQL Server Integration Services (SSIS) Part 10 - Sequence Containers and FOR Loops
Looping Over Files
https://www.youtube.com/watch?v=h6x0oI9gSh8 - SQL Server Integration Services (SSIS) Part 11 - Looping Over Files
Other Foreach Loops
https://www.youtube.com/watch?v=HIp06xn8puw - SQL Server Integration Services (SSIS) Part 12 - Other Foreach Loops
Script Tasks using C#
https://www.youtube.com/watch?v=iPmXgiUHUPQ - SQL Server Integration Services (SSIS) Part 13 - Script Tasks using C#
Script Tasks using Visual Basic
https://www.youtube.com/watch?v=VWLlIXjUtgY - SQL Server Integration Services (SSIS) Part 14 - Script Tasks using Visual Basic
Script Components
https://www.youtube.com/watch?v=nIPZvzivo_M - SQL Server Integration Services (SSIS) Part 15 - Script Components
Expression and Other Constraints
https://www.youtube.com/watch?v=oqiG4oNyvHk - SQL Server Integration Services (SSIS) Part 16 - Expression and Other Constraints
Event-handling and logging
https://www.youtube.com/watch?v=xFx4adO92gg - SQL Server Integration Services (SSIS) Part 17 - Event-handling and logging
Error handling
https://www.youtube.com/watch?v=LzFxNFPrPyQ - SQL Server Integration Services (SSIS) Part 18 - Error handling
Parameters and deployment
https://www.youtube.com/watch?v=idFCAFAgOO0 - SQL Server Integration Services (SSIS) Part 19 - Parameters and deployment
Capítulo 7 - Modelos Multidimensionales
SQL 2014 Cubos OLAP
https://www.youtube.com/watch?v=ddOaljj66C8
No hay comentarios:
Publicar un comentario