Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 27
In this session, we will have an introduction to Agile Methodologies for Data Warehousing.  Traditional Agile Methods have been created to improve development projects of transactional systems, however, in order to benefit from these approaches and leverage all of its potentials in DW/BI, these technics and practices should be tailored for the nuances and nature of DW/BI projects.  We will describe a set of principles and artifacts that can be used in Agile Methods for DW/BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 19

Time: 3:50 PM - 4:50 PM

Room: Salon 1

Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: November 19

Time: 1:50 PM - 2:50 PM

Room: Salon 1

Beginners session to compare Amazon Redshift technology offering to SQL Server BI tools and how they can possibly interact.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehouse Architecture, Development & Administration

Level: Beginner

Session Code:

Date: November 19

Time: 11:10 AM - 12:10 PM

Room: Salon Principal

En esta sesion se te mostrará ¿Qué es Azure Analysis Services? el nuevo servicio de BI en la nube de Microsoft
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Big Data / Internet of Things

Level: Intermedia

Session Code:

Date: November 19

Time: 3:50 PM - 4:50 PM

Room: Salon Principal

Que es el Master Data Sercice y cuales son sus aplicaciones, desde la Instalación y configuración, como la utilización del servicio de creando los modelos, entidades, jerarquias. Tambien las facilidades de accesar los datos de forma externa  y desde Excel.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehouse Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 19

Time: 3:00 PM - 4:00 PM

Room: Salon 2

Are you interested to build a Modern Data Warehouse?
Did you hear about the Azure Data Factory? End Near For SSIS?
I am a SSIS Developer "there is nothing new for me..." or not?

With the introduction of Azure Data Warehouse and Hadoop for Data Platforms and Power BI and a growing set of cloud-based analytics. Some times we forget about the data integration process (ETL). Modern data integration tools ensure timely, trusted, relevant, secure and authoritative data.

This session will provide a quick reference for the different ETL options that we have and what to expect.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehouse Architecture, Development & Administration

Level: Advanced

Session Code:

Date: November 19

Time: 10:20 AM - 11:20 AM

Room: Salon Principal

En esta sesión vamos a construir una app que incluya los servicios Microsoft Cognitive Services para crear una solución con poderosos algoritmos con tan solo unas pocas líneas de código.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: November 19

Time: 9:10 AM - 10:10 AM

Room: Salon 1

Se aprenderá a crear Dashboard de alto rendimiento e impacto para las organizaciones, utilizando la herramienta DataZen de Microsoft. Se explorarán la diversas configuraciones de seguridad, así como los diversos métodos de acceso a la información (calendarizado, en tiempo real, entre otros) y sus diversos orígenes de datos (Transaccionales, Data Warehouse, OLAP)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: November 19

Time: 11:10 AM - 12:10 PM

Room: Salon 1

We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: November 19

Time: 9:10 AM - 10:10 AM

Room: Salon Principal

Los datawarehouse son probablemente las bases de datos mas grande que vamos a encontrar en los sistemas. si alguna vez te has preguntado como diseño mi datawarehouse de tal forma que en caso de desastre pueda recuperarlo rapidamente o si nunca te has hecho la pregunta, en esta sesión vamkos a discutir con base al esquema estrella la distribucion de files y filegroups anl igual que la utilizacion de tecnologias como inmemory OLTP para hacer mi datawarehouse "Disaster recovery ready"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehouse Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 19

Time: 8:20 AM - 9:20 AM

Room: Salon 1

Within Shared Service Centers, during the last few years a new tendency has disrupted how business is carried out day-by-day. It has the catchy name of "Robotic Process Automation" (RPA), and consists of taking a process from the process of being done mostly manually to being completely automatic. 

In this case, we are proposing the automation of manual work done by a group of ~10 people, who on a daily basis have to classify products for customs purposes, based on the products' characteristics... this takes hundreds of hours per month to complete. Our proposal is to take the products' data, both the text description plus other qualitative data like product specs, and apply techniques to automatically determine what is the customs classification that the product should have.

Accuracy expectations for the process are above 98%, so the automated classification has to be near-perfect. Additionally, for the process to be fully automated, we can turn to features of SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: November 19

Time: 9:10 AM - 10:10 AM

Room: Salon 2

1. BI 2.0: Alimentación de una Herramienta de Inteligencia de Negocios para la creación de dashboards sin necesidad de construir cubos.
2. Ejemplo de conexión directa a MS SQL Server para que la herramienta automáticamente defina que son medidas y dimensiones.
3. Creación de Consultas a nivel de usuario final
4. Integración con Multiples fuentes de datos Join automático desde una fuente de datos externa para integrarla a la fuente original haciendo Drag & Drop.
5. Creación de una consulta utilizando diversas fuentes de datos
6. Graficación y mejores practicas de visualización y análisis 
7. Desarrollo de un Dashboard y Publicación
8. Código de Embebido para publicar el Dashboard en Share Point
9. Caso de uso conectado a Redes Sociales.
10. Tips para aplicar en Infografía Gerencial.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: November 19

Time: 1:50 PM - 2:50 PM

Room: Salon 2

Sacarle provecho a los datos no estructurados para Inteligencia de Negocios no siempre es lo que se espera, pero ¿qué tal si existiera una forma de entender esos datos oscuros y transformarlos a datos estructurados?
Conozca IBM Watson y como puede apoyar su inteligencia de negocios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Big Data / Internet of Things

Level: Beginner

Session Code:

Date: November 19

Time: 3:00 PM - 3:15 PM

Room: Salon 1

This is a must attend session for every data professional.  Join me as I provide an overview of Microsoft Mobile Reporting, Microsofts newly acquired on-premises mobile BI solution.  Mobile Reporting is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device.  In this session I will provide an overview of Mobile Reporting, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: November 19

Time: 8:20 AM - 9:20 AM

Room: Salon Principal

Cuando estas diseñando un Datamart o Data Warehouse con frecuencia te encuentras algunas  dimensiones NO-regulares y donde el diseño tradicional de dimensiones conformadas puede quedarse corto.
Revisaremos dimensiones copo de nieve, dimensiones degeneradas, dimensiones chatarra, de muchos miembros, etc,
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: November 19

Time: 1:50 PM - 2:50 PM

Room: Salon Principal

En esta sesión veremos el proceso paso a paso de como leer una página web y convertirla en una fuente de datos de nuestros Queries de SQL. Aprenderemos algunos casos prácticos y tips de cómo ser exitosos en el proceso.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Data Warehouse Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 19

Time: 10:20 AM - 11:20 AM

Room: Salon 2

El Lenguaje R se ha convertido en una de las herramientas más populares para el análisis de información, es muy utilizado por los científicos de datos y se ha convertido en pilar para el análisis de datos. En esta sesión presentamos una introducción de cómo podemos integrar el uso del Lenguaje R dentro de las soluciones de Inteligencia de Negocios y veremos también cómo lo podemos integrar con herramientas tales como PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: November 19

Time: 1:00 PM - 2:00 PM

Room: Salon 2

En esta sesión vamos mostrar las nuevas funcionalidades que se incluyeron en SSIS para la reciente version de SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: November 19

Time: 8:20 AM - 9:20 AM

Room: Salon 2

En esta sesión veremos cómo aprovechar el Potencial de las Réplicas Read-Only de los AlwaysOn Availability Groups para ejecutar cargas de datos hacia nuestro Datawarehouse mediante procesos controlados de lectura de las Réplicas.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Warehouse Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 19

Time: 1:00 PM - 2:00 PM

Room: Salon Principal

En esta sesión daremos los primeros pasos en Power Bi, transformaremos datos comunes en información empresarial sacando el máximos resultado para distintas áreas
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: November 19

Time: 11:10 AM - 12:10 PM

Room: Salon 2

Sessions Found: 27
Back to Top cage-aids
cage-aids
cage-aids
cage-aids