SQLSaturday #786 - Puerto Rico 2018

Event Date: 10/06/2018 00:00:00

Event Location:

  • Engine-4
  • Complejo Onofre Carballeira Esq. PR-2 con Int. PR-5
  • San Juan, San Juan, Puerto Rico

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


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

Speaker(s):

  • Jose L. Rivera

Track and Room: BI Information Delivery - Borinken A y B


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.

Speaker(s):

  • Joan Manuel Pérez

Track and Room: BI Platform Architecture, Development Administration - Room 1


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

Speaker(s):

  • Jose L. Rivera

Track and Room: BI Information Delivery - Borinken A y B


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.

Speaker(s):

  • Jose L. Rivera

Track and Room: BI Platform Architecture, Development Administration - Room 2


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.

Speaker(s):

  • Gilda Alvarez

Track and Room: Enterprise Database Administration Deployment - Room 1


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.

Speaker(s):

  • Isaias Martinez

Track and Room: Advanced Analysis Techniques - Room 2


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.

Speaker(s):

  • Jose L. Rivera

Track and Room: Advanced Analysis Techniques - Room 2


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.

Speaker(s):

  • Edwin Torres

Track and Room: BI Platform Architecture, Development Administration - Room 1


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.

Speaker(s):

  • Juan Martí

Track and Room: Cloud Application Development Deployment - Room 1


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.

Speaker(s):

  • Juan Martí

Track and Room: Application Database Development - Room 1


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.

Speaker(s):

  • Orlando Mezquita

Track and Room: Analytics and Visualization - Room 2


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Isaias Martinez

LinkedIn: Isaias Martinez

Contact: http://www.isaiasmartinez.com

Awarded as MVP C# for 7 consecutive years. Over 20 years of extensive experience in management, design and implementation of information technology projects aimed to automate processes to minimize time, save resources and improve operational efficiency. This to enhance the vision and mission of the organizations. The experience has been gathered in projects performed in various countries such as: Venezuela, Bolivia, Panama, Colombia, and Puerto Rico. In the last 6 years, I have specialized as Cloud Architect, leading the implementation of Microsoft Azure Solutions in Puerto Rico. My certifications include Microsoft MCP, MCSD, MCSE, MCT, MCDBA.#160;

Gilda Alvarez

Twitter: - @Latina_DBA

She graduated from the University of Central Florida with MIS and Computer science degrees. She has over a decade of experience in Enterprise Information Technology solutions for several Fortune 500 companies. In depth and applied knowledge of database administration with emphasis on high availability and disaster recovery solutions, security audits, database health checks, capacity planning, resource utilization analysis and enterprise database migrations. She is a big advocate of technical and leadership education in her community. She loves to spend time with her family, friends and dance Latin music.

Jose L. Rivera

Twitter: - SQLConqueror

LinkedIn: Jose L. Rivera

Contact: http://sqlconqueror.com

Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.

Orlando Mezquita

Twitter: - orlandomezquita

LinkedIn: Orlando Mezquita

Contact: http://www.MasterDataAnalysis.com

Orlando is principal consultant and trainer at Master Data Analysis. He is a passionate analytics professional who shares his knowledge through MasterDataAnalysis.com. Orlando provides analytics training and consulting services with Power BI, Excel, R, and Minitab.

Joan Manuel Pérez

LinkedIn: Joan Manuel Pérez

Visionary and versatile manager with over 15 years of diverse professional experience in Information Systems, Quality Assurance, Business/Data Analytics and Education within global technology company, regulated pharmaceutical manufacturing and university environments.

Areas of Expertise: Digital Advisory ♦ Data and Analytics ♦ Business Intelligence (BI) ♦ Business/Process Improvement ♦ Passion to Quality ♦ Lean/Six Sigma ♦ Scrum/Agile ♦ Data Integration ♦ Project Management ♦ Virtual Project Teams ♦ Consultative Problem Solving ♦ Risk Change Management ♦ Agile BI ♦ BI Platform Architecture ♦ Business Analytics.

Juan Martí

Twitter: - @jmarti326

LinkedIn: Juan Martí

Contact: http://polybits.io

Passionate Software Developer in mobile and web technologies. Leader of the Google Developers Group Puerto Rico Chapter and collaborator of various other developers communities in the US and Puerto Rico.

Jose L. Rivera

Twitter: - SQLConqueror

LinkedIn: Jose L. Rivera

Contact: http://sqlconqueror.com

Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.

Edwin Torres

Twitter: - https://twitter.com/_edtorr

LinkedIn: Edwin Torres

An experienced data architect and technical leader, has more than 10 years of consulting practice across different industries and verticals including digital media, advertising, health, government, retail, education and tourism.

Jose L. Rivera

Twitter: - SQLConqueror

LinkedIn: Jose L. Rivera

Contact: http://sqlconqueror.com

Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.

Jose L. Rivera

Twitter: - SQLConqueror

LinkedIn: Jose L. Rivera

Contact: http://sqlconqueror.com

Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.

Juan Martí

Twitter: - @jmarti326

LinkedIn: Juan Martí

Contact: http://polybits.io

Passionate Software Developer in mobile and web technologies. Leader of the Google Developers Group Puerto Rico Chapter and collaborator of various other developers communities in the US and Puerto Rico.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page