Videos

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 BD
https://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


Capítulo 7 - Modelos Multidimensionales


SQL 2014 Cubos OLAP
https://www.youtube.com/watch?v=ddOaljj66C8







No hay comentarios:

Publicar un comentario

Capítulo 9 - Medidas

1. Cubos Un cubo contiene un subconjunto de la información de un Data Mart o Data Warehouse. Su información se almacena en una estr...