sqlsathistory

Nr: 812

SQLSaturday #812 - Lima 2018

Start Time (24h)	Speaker	Track	Title
09:40:00	ALAN FERRANDIZ LANGLEY	Artificial Intelligence	Herramientas de Data Science: Analítica e Storytelling
09:40:00	Daniel Enrique Espinoza Solórzano	BI Platform Architecture, Development Administration	El sorprendente mundo de la ciencia de datos
09:40:00	Alejandro Humberto Sánchez Núñez	BI Platform Architecture, Development Administration	Time Intelligence with SSAS Power BI
10:50:00	Raul Martin Sarachaga Diaz	BI Platform Architecture, Development Administration	Best practices using Azure Data Warehouse
10:50:00	Fernando Cobo Enriquez	Enterprise Database Administration Deployment	Azure SQL Database - Lessons learned from the trenches
12:15:00	Fernando Cobo Enriquez	Enterprise Database Administration Deployment	Back to the future - Migrating our SQL Server On-premises database to Azure SQL Database
12:15:00	Alejandro Humberto Sánchez Núñez	BI Platform Architecture, Development Administration	Dynamic Row Level Security with SSAS Power BI
13:25:00	Raul Martin Sarachaga Diaz	Artificial Intelligence	Modelos Predictivos con Azure Machine Learning
13:25:00	Juan Rafael	Enterprise Database Administration Deployment	The roadmap for SQL Server
13:25:00	Marlon Leandro	BI Platform Architecture, Development Administration	Enviando datos a Power BI desde Arduino
15:40:00	Juan Rafael	Cloud Application Development Deployment	Microsoft PowerApps, Power BI, and Flow: Power platform vision and roadmap
15:40:00	Raul Martin Sarachaga Diaz	BI Platform Architecture, Development Administration	Data Modeling with Power BI
15:40:00	Jorge Michael Muchaypiña Gutierrez	Enterprise Database Administration Deployment	Que necesito saber de los Indices en SQL Server?
16:50:00	Juan Rafael	BI Platform Architecture, Development Administration	Microsoft Dynamics 365 for Finance Operations and Power BI: Intro to building great analytics
16:50:00	Jorge Michael Muchaypiña Gutierrez	BI Platform Architecture, Development Administration	Power BI en Ambientes Empresariales

SessionID: 86367

Herramientas de Data Science: Analítica e Storytelling

Back to calendar

Event Date: 01-12-2018 - Session time: 09:40:00 - Track: Artificial Intelligence

Speaker: ALAN FERRANDIZ LANGLEY

Title: Herramientas de Data Science: Analítica e Storytelling

Abstract:

En esta charla descubriremos los secretos para crear impacto en una presentación usando los recursos que nos brinda la analítica y el storytelling. Adicionalmente, veremos los errores más comunes que se cometen al presentar datos y cómo solucionarlos utilizando las mejores prácticas de analítica e storytelling.

SessionID: 87313

El sorprendente mundo de la ciencia de datos

Back to calendar

Event Date: 01-12-2018 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel Enrique Espinoza Solórzano

Title: El sorprendente mundo de la ciencia de datos

Abstract:

Ciencia de Datos: definición, evolución, perspectivas y recomendaciones.

SessionID: 87393

Time Intelligence with SSAS Power BI

Back to calendar

Event Date: 01-12-2018 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Alejandro Humberto Sánchez Núñez

Title: Time Intelligence with SSAS Power BI

Abstract:

Veremos distintos tipos de calendarios y como trabajar con nuestros indicadores versus el tiempo haciendo uso desde las clásicas funciones de time intelligences hasta el uso de patrones DAX analizando caso por caso.

SessionID: 86010

Best practices using Azure Data Warehouse

Back to calendar

Event Date: 01-12-2018 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Raul Martin Sarachaga Diaz

Title: Best practices using Azure Data Warehouse

Abstract:

Esta sesión se verán las mejores técnicas para la carga de datos hacia Azure DW(Polybase, Azure Data Factory) , diseño correcto de distribución de tablas , optimización de querys y ventajas de utilizar Azure DW Gen2.

SessionID: 87407

Azure SQL Database - Lessons learned from the trenches

Back to calendar

Event Date: 01-12-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Fernando Cobo Enriquez

Title: Azure SQL Database - Lessons learned from the trenches

Abstract:

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.

SessionID: 87408

Back to the future - Migrating our SQL Server On-premises database to Azure SQL Database

Back to calendar

Event Date: 01-12-2018 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Fernando Cobo Enriquez

Title: Back to the future - Migrating our SQL Server On-premises database to Azure SQL Database

Abstract:

We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On-premises.

This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database

SessionID: 87595

Dynamic Row Level Security with SSAS Power BI

Back to calendar

Event Date: 01-12-2018 - Session time: 12:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Alejandro Humberto Sánchez Núñez

Title: Dynamic Row Level Security with SSAS Power BI

Abstract:

RLS

SessionID: 86009

Modelos Predictivos con Azure Machine Learning

Back to calendar

Event Date: 01-12-2018 - Session time: 13:25:00 - Track: Artificial Intelligence

Speaker: Raul Martin Sarachaga Diaz

Title: Modelos Predictivos con Azure Machine Learning

Abstract:

En esta sesión se creará un modelo predictivo utilizando Azure Machine Learning, con el cual se abarcarán algunas consideraciones como: Selección de Variables, Transformación de variables ,Limpieza de datos , etc.

SessionID: 87319

The roadmap for SQL Server

Back to calendar

Event Date: 01-12-2018 - Session time: 13:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Juan Rafael

Title: The roadmap for SQL Server

Abstract:

SQL Server 2017 has brought to market a new modern data platform including support for Linux, Docker Containers and rich features in intelligent performance, HADR, machine learning, and graph database. Come learn about the roadmap and new functionality planned for SQL Server including intelligent query processing, data virtualization, new features for mission critical security and HADR, and new scenarios for Linux and Docker Containers.

SessionID: 87417

Enviando datos a Power BI desde Arduino

Back to calendar

Event Date: 01-12-2018 - Session time: 13:25:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marlon Leandro

Title: Enviando datos a Power BI desde Arduino

Abstract:

Aprenda como conectar un circuito elaborado en Arduino con la nube de Power BI y a enviar datos en tiempo real

SessionID: 87320

Microsoft PowerApps, Power BI, and Flow: Power platform vision and roadmap

Back to calendar

Event Date: 01-12-2018 - Session time: 15:40:00 - Track: Cloud Application Development Deployment

Speaker: Juan Rafael

Title: Microsoft PowerApps, Power BI, and Flow: Power platform vision and roadmap

Abstract:

Turn insight into action when you build business apps with PowerApps, Microsoft Power BI, and Microsoft Flow. This session gives you an overview of the power platform and how you can empower everyone to build apps that transform your business. We cover what we have in market today along with our roadmap and vision for the future

SessionID: 87352

Data Modeling with Power BI

Back to calendar

Event Date: 01-12-2018 - Session time: 15:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Raul Martin Sarachaga Diaz

Title: Data Modeling with Power BI

Abstract:

En esta sesión los participantes podrán ver las consideraciones que deben tener al realizar un modelo dimensional y teniendo como consideraciones las capacidades que te brinda Power BI(Cross Filter,Many to Many, UseRelationShip,etc)

SessionID: 87388

Que necesito saber de los Indices en SQL Server?

Back to calendar

Event Date: 01-12-2018 - Session time: 15:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Jorge Michael Muchaypiña Gutierrez

Title: Que necesito saber de los Indices en SQL Server?

Abstract:

Veremos lo necesario que debemos saber sobre los indices en SQL Server, los diferentes tipos de indices, optimizando el diseño de estrategias de indices, como mejoran nuestras consultas con los indices y verificar el monitorio y mantenimiento de los indices.

SessionID: 87321

Microsoft Dynamics 365 for Finance Operations and Power BI: Intro to building great analytics

Back to calendar

Event Date: 01-12-2018 - Session time: 16:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Juan Rafael

Title: Microsoft Dynamics 365 for Finance Operations and Power BI: Intro to building great analytics

Abstract:

Join us to better understand how you can build high volume, near real-time analytics leveraging Microsoft Entity store and Power BI. We'll learn about the incremental refresh feature that keeps Entity store up to date and how to extend ready-made analytics using your own Power BI subscription.

SessionID: 87389

Power BI en Ambientes Empresariales

Back to calendar

Event Date: 01-12-2018 - Session time: 16:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jorge Michael Muchaypiña Gutierrez

Title: Power BI en Ambientes Empresariales

Abstract:

Veremos como incorporar para Power BI en una pequeña o gran empresa. Las diferencias entre Power BI Desktop, Power BI Service, Power BI Premium, Power BI Report Server. Las nuevas caracteristicas que traeran estas nuevas herramientas.

This site is open source. Improve this page.