sqlsathistory

Nr: 786

Back to Main list

SQLSaturday #786 - Puerto Rico 2018

Start Time (24h) Speaker Track Title
09:00:00 Jose L. Rivera BI Information Delivery End to End Power BI Workshop - Part1
13:30:00 Jose L. Rivera BI Information Delivery End to End Power BI Workshop - Part2
09:45:00 Gilda Alvarez Enterprise Database Administration Deployment Migrations 101
09:45:00 Isaias Martinez Advanced Analysis Techniques Converting images into information with Artificial Intelligence
11:00:00 Jose L. Rivera Advanced Analysis Techniques Getting Started with Azure DataBricks
11:00:00 Joan Manuel Pérez BI Platform Architecture, Development Administration Power BI Dataset monitoring tool
13:30:00 Juan Martí Cloud Application Development Deployment Azure CosmoDB Globalizing Your Data
13:30:00 Orlando Mezquita Analytics and Visualization Data Visualization Best Practices
14:45:00 Jose L. Rivera BI Platform Architecture, Development Administration SQL Server 2017: SSIS Scale Out
14:45:00 Edwin Torres BI Platform Architecture, Development Administration Building a data warehouse in the cloud and its new challenges
16:00:00 Juan Martí Application Database Development Smart ways to consume your data with LUIS.AI

SessionID: 85739

End to End Power BI Workshop - Part1

Back to calendar

Event Date: 06-10-2018 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Jose L. Rivera

Title: End to End Power BI Workshop - Part1

Abstract:

Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.

Join us for this hand-on intensive workshop were you will learn Power BI from end to end. At the end of the day, attendees will better understand how to:

Connect to, import, and transform data from a variety of sources Define business rules and KPIs Explore your data with powerful visualization tools Build stunning reports Advanced Data Modeling R integration Advanced Visualizations Share your dashboards with your team and/or the world Power BI Administration

SessionID: 85740

End to End Power BI Workshop - Part2

Back to calendar

Event Date: 06-10-2018 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Jose L. Rivera

Title: End to End Power BI Workshop - Part2

Abstract:

Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.

Join us for this hand-on intensive workshop were you will learn Power BI from end to end. At the end of the day, attendees will better understand how to:

Connect to, import, and transform data from a variety of sources Define business rules and KPIs Explore your data with powerful visualization tools Build stunning reports Advanced Data Modeling R integration Advanced Visualizations Share your dashboards with your team and/or the world Power BI Administration

SessionID: 82684

Migrations 101

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Gilda Alvarez

Title: Migrations 101

Abstract:

The only constant thing is change. As companies continue to migrate to newer versions or different data centers, we need to develop strategies and tools to make sure we can perform successful migrations. What if we had a checklist? Just like moving to a new home the success of the "move" relies on the preparation. This presentation will go over a checklist of steps needed to prepare for a database migration.

SessionID: 86144

Converting images into information with Artificial Intelligence

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Advanced Analysis Techniques

Speaker: Isaias Martinez

Title: Converting images into information with Artificial Intelligence

Abstract:

For decision making, businesses need more than just data entry, with the Artificial Intelligence we can cross borders that until now were unthinkable and image analysis is one of them.

SessionID: 85738

Getting Started with Azure DataBricks

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: Advanced Analysis Techniques

Speaker: Jose L. Rivera

Title: Getting Started with Azure DataBricks

Abstract:

In this session we will explore this new service called Azure Databricks and demonstrates its capabilities to accelerate big data analytics and artificial intelligence (AI) solutions with its easy, fast and collaborative Apache Spark–based analytics service.

SessionID: 85832

Power BI Dataset monitoring tool

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Joan Manuel Pérez

Title: Power BI Dataset monitoring tool

Abstract:

The Power BI Dataset monitoring tool is a “In House” application that can help monitor heterogeneous database environments. It also helps database administrators (DBAs) and system administrators by notifying potential dataset performance problems. For database server monitoring, Power BI Dataset monitoring tool connects to the database and ensures it is up. Power BI Dataset monitoring tool is also an agentless monitoring tool that executes Power BI Service API queries to collect refresh status and includes auto-retry features. Using the Power BI reports/visualizations capabilities, DBAs can plan inventory requirements and troubleshoot incidents quickly.

SessionID: 85900

Azure CosmoDB Globalizing Your Data

Back to calendar

Event Date: 06-10-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Juan Martí

Title: Azure CosmoDB Globalizing Your Data

Abstract:

As a globally distributed, multi-model database service, Azure Cosmos DB makes it easy to build scalable, highly responsive applications at global scale anywhere in the world. Join me to learn about Azure CosmoDB and great tools to work with it.

SessionID: 85989

Data Visualization Best Practices

Back to calendar

Event Date: 06-10-2018 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Orlando Mezquita

Title: Data Visualization Best Practices

Abstract:

You might an expert creating all kinds of visualizations in Power BI or other tools but, do you really know how to communicate effectively using data? In this session, we will cover key elements to consider when creating dashboards and reports, such as the appropriate type of graph to use depending on the data, visual perception principles, when to use tables and what to avoid when creating graphs.

SessionID: 85737

SQL Server 2017: SSIS Scale Out

Back to calendar

Event Date: 06-10-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jose L. Rivera

Title: SQL Server 2017: SSIS Scale Out

Abstract:

Como parte de las nuevas características que nos trae SQL Server 2017, en esta sesión demostraremos de una manera práctica la configuración y uso de esta nueva funcionalidad de escalabilidad llamada SSIS Scale out.

SessionID: 85828

Building a data warehouse in the cloud and its new challenges

Back to calendar

Event Date: 06-10-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Edwin Torres

Title: Building a data warehouse in the cloud and its new challenges

Abstract:

Technology changes quickly and you need to know if the new toys are for you. This session will take you through how to deploy, design, and load data in the cloud using Microsoft's Azure SQL Data Warehouse.

We will discuss how to decide if this cloud-based massively parallel processing solution is the right Big Data solution for your project.

SessionID: 85899

Smart ways to consume your data with LUIS.AI

Back to calendar

Event Date: 06-10-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Juan Martí

Title: Smart ways to consume your data with LUIS.AI

Abstract:

In today's world, we consume data in many different ways. Some data we obtain it by browsing the web, a mobile app, and even asking our smartphones for it. What if we can make our data available by voice or by the person typing a question in a human natural way. In this section, we will learn how to do it with LUIS.AI.