Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type


Sessions Found: 30
Due to varying definitions of Big Data which confuse data volume and data organization, the common perception is that Big Data requires the use of Hadoop, MongoDB, or another NoSQL database.  SQL Server can easily store and manipulate very large volumes of data and perform quite well provided the database is properly set up and tuned.  In this session we'll cover some of the definitions and misconceptions of Big Data, look at some Big Data solutions that went horribly wrong and review a case where Big Data was successfully implemented in SQL Server.  Finally, we'll take a peek under the covers to see how SQL Server best handles Big Data through proper data models, table designs, performance tuning, and T-SQL techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 22

Time: 3:00 PM - 3:50 PM

Room: MPR1

Unlock insights from all your data and build artificial intelligence (AI) solutions with Azure Databricks, set up your Apache Spark™ environment in minutes, autoscale, and collaborate on shared projects in an interactive workspace. Azure Databricks supports Python, Scala, R, Java, and SQL, as well as data science frameworks and libraries including TensorFlow, PyTorch, and scikit-learn.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Artificial Intelligence

Level: Intermedia

Session Code:

Date: February 22

Time: 10:35 AM - 11:25 AM

Room: EBC

Want to learn how to create an SSIS package? With no prior experience we will dive into the world of ETL. How to create a package and build the intelligence based on your business needs. 
Join me to this introductory class.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 22

Time: 4:00 PM - 4:50 PM

Room: Mambo

The power of cloud storage and compute power has made data warehousing and big data possible for businesses of all sizes. What was once a large capital expenditure and multi-year implementation can now be deployed and ready to use within minutes and allow any organization to collect, query and discover insights from their structured and unstructured data sources. 

With tightly integrated services and a user-centric approach, a cloud-native data platform can fit transparently into your business data strategy and leverage already existing and familiar development and management skills.
 
In this session we will look at the main components and reference architectures for building a modern business intelligence platform that includes data warehousing, big data and analytics with examples using Microsoft Azure. We will talk about ways to integrate with on-premises systems as well as lessons learned from building these Enterprise BI Data Platforms for multiple clients.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 22

Time: 9:30 AM - 10:20 AM

Room: MPR1

Want to learn Power BI, and not sure where to start? This session will teach you all the basics you need to know to get started. We will discuss some of the parts of Power BI Desktop such as Power Query, Data Model, and the Report Canvas. I will also teach you where to go to follow the latest updates, and give you a few recommended books and websites to get to the next level.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: February 22

Time: 9:30 AM - 10:20 AM

Room: MPR2

AutoML was proposed as an artificial intelligence-based solution to the ever-growing challenge of applying machine learning. Business analysts can build Machine Learning models to solve business problems that once required data scientists. In this session, Hector will explain the principles of Machine Learning and AutoML (Automated machine learning) and he will demo AutoML PowerBI features end-to-end and show How to interpret and extract the optimum results based on specific business problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Artificial Intelligence

Level: Beginner

Session Code:

Date: February 22

Time: 3:00 PM - 3:50 PM

Room: EBC

Whether you have worked with SSIS or are new to data pipelines, come and learn about Azure Data Factory (ADF), what it is, how to deploy it, integrate with Git for source control, create and monitor data pipelines.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 22

Time: 11:40 AM - 12:30 PM

Room: MPR1

There is a new Azure SQL DB option: Hyperscale. It introduces a redesigned architecture under the hood not comparable to the other SQL DB PaaS options. 
In this session you will learn and see how it works and the best scenarios where it fits in. And how it blends in a cloud based BI solution arctecture.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 22

Time: 10:35 AM - 11:25 AM

Room: MPR1

Azure Analysis Services at times is collocated with Azure Synapse Analytics as Business Intelligence  back-end layer. This session will help the audience determine what architecture should be chosen for a given enterprise requirement. Session will also provide features and advantages from each PaaS offering.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 22

Time: 2:00 PM - 2:50 PM

Room: MPR1

A data warehouse (DW) is a core component of business intelligence and a central data repository for different sources. This poses many challenges as the schema definition for those sources may be completely different from one another. In this presentation, we discuss how to create a data warehouse model that can support data from multiple systems. Oscar Garcia shows how to build a dimensional model which can enable us to import the data with different shapes into a data warehouse. We then create processes to transform and load the data using Apache Spark. We finally use Power BI to visualize the data from our data warehouse and Spark.


Learning Objectives:

Challenges when using disparate data sources (different models)

Define a common model to support the different model shapes (Star Schema)

Apache Spark Overview

Strategy for loading the different data-sets into the common model

Data analysis and visualization with Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
LATAM ( BI topics in Spanish)

Level: Intermedia

Session Code:

Date: February 22

Time: 11:40 AM - 12:30 PM

Room: Mambo

For centuries the humans have been looking for the way to improve their bodies, mental capacity, and the ways to acquiring knowledge and techniques to improve their personal and professional lives.
In other words, a different outlook of the concept of wellbeing and perform better on whatever is the activity their doing.
During this session you will discover, thru the assessment of the peak performance, your status and preparedness to change and the tools available to make quick changes and tweaks, like techniques for speed reading, biohacking, how to be mindful instead of mindfull, how to achieve a flow state, and much more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Networking

Level: Beginner

Session Code:

Date: February 22

Time: 4:00 PM - 4:50 PM

Room: Tango

For too long, data developers have been left in the dark on the power of DevOps. From creating entire new environments with infrastructure and configuration as code to maintaining consistency on existing systems with source control and automated builds and deployments, DevOps tools are as accessible to data platforms as to application developers. In this session, we will focus on the benefits and concepts of continuous integration and continuous delivery with PowerBI. Using AzureDevOps, we will deal with maintaining reports in source control, triggering automated builds, and publishing to multiple environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: February 22

Time: 2:00 PM - 2:50 PM

Room: EBC

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage.  As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances.  In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources.  We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down.  Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 22

Time: 4:00 PM - 4:50 PM

Room: MPR1

If you want to use PowerBI, you'll want to learn the DAX language.  We will go over what, when and how to use it along with where to get help!  If you are an excel person, this might be an easy shift.  If you are not, then you will definitely want to understand this language if you or your teams are using PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: February 22

Time: 10:35 AM - 11:25 AM

Room: MPR2

Your Power BI looks awesome! but have you thought if it is accessible enough for people with disabilities? Or better yet for people with visual impairments?
Do you know what tools do you have available to make your app. ADA ready?
Let's work together on a hands-on journey to learn the statistics that affect our customers and to walk away with real tools to make our apps Intelligent ready for ALL!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
LATAM ( BI topics in Spanish)

Level: Beginner

Session Code:

Date: February 22

Time: 9:30 AM - 10:20 AM

Room: Mambo

For the traditional administrator of Microsoft Data Platform Architectures, Azure brings new ways to deploy services for Business Intelligence, Big Data, and AI solutions. 
So many options can be overwhelming and there is no single solution that can be applied to every requirement.  In this session, we will cover the different options available in Azure to deploy Data Platform components, without leaving the performance, costs, and migration complexity aspects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
LATAM ( BI topics in Spanish)

Level: Beginner

Session Code:

Date: February 22

Time: 10:35 AM - 11:25 AM

Room: Mambo

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve your skill set, as well as help provide career stability.  PASS and other organizations practically give you all the tools you need to succeed in the data field. Come learn about those events and opportunities that help make this possible as well as how you can get involved to help others who are starting out.  The rewards of the SQL Community are endless.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Networking

Level: Beginner

Session Code:

Date: February 22

Time: 2:00 PM - 2:50 PM

Room: Tango

In this talk we will discuss the principles of a virtual data warehouse, how you can reduce or eliminate ETL jobs, and how to combine the power of SQL Server and Enzo to build a data warehouse that can deliver near-time and real-time SaaS data to PowerBI, data integration, AI integration, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 22

Time: 12:45 PM - 1:45 PM

Room: MPR1

Come and join us for the keynote and Women in Technology Panel

"The art of creating Allies to grow your career"

Panelists:
Barkha Herman 
Diana Betancourt
Gilda Alvarez
Dave Noderer

Moderator:
Cecilia Brusatori
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Panel of Discussion

Level: Beginner

Session Code:

Date: February 22

Time: 8:15 AM - 9:15 AM

Room: MPR1

You've been working with Power BI, building fantastic reports and dashboards. Let's take a look at some of the cool features that will help you make your reports more appealing and add more functionalities.
This session is 100% demos: shortcuts, visuals interactions, drilling down/up/through data , custom tooltips, buttons & bookmarks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes) (50 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: February 22

Time: 3:00 PM - 3:50 PM

Room: MPR2

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