sqlsathistory

Nr: 786

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:

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.

This site is open source. Improve this page.