Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 49
Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Introductory Data Topics & Professional Development

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: BRD163

Do you know what makes a great data model?  What does it mean to be Third Normal Form or a Star Schema?  When would you use one over the other and why?  How can you identify bad designs?  In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI ETL Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 04

Time: 8:30 AM - 9:30 AM

Room: BRD149

In this session, we will review the Azure Databricks Unified Analytics Platform and introduce best practices for development. When used together they can significantly accelerate your time to Analytic Insights, facilitate collaboration among Data Engineers, Data Analysts, and Data Scientists, and permit everyone on your project to work with any Data, at any Volume, any Velocity. We will cover best practices for data ingestion and movement of data through the zones of the data lake and data warehouse. Then we will show how you can use this platform for Exploratory Data Analysis (EDA) and Advanced Analytics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics

Level: Intermedia

Session Code:

Date: May 04

Time: 8:30 AM - 9:30 AM

Room: BRD171

Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper. 

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Visualization and Reporting

Level: Advanced

Session Code:

Date: May 04

Time: 9:45 AM - 10:45 AM

Room: BRD147

Deploying to SQL Azure? What are the best ways to login/authenticate to SQL Azure? Learn about Azure AD Authentication methods: Integrated Windows authentication, Azure AD principal name and a password, Application token authentication, and additional Azure Active Directory methods  Integrated, Universal with MFA, and Interactive
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: BRD149

It's not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA's and we should all strive to learn it. In this session, we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 8:30 AM - 9:30 AM

Room: BRD172

Azure Data Factory V2 is an Azure a Platform-as-a-Service with many SSIS-like features, but is it good enough to replace SSIS? In this session we will review some of the ETL and ELT features in Azure Data Factory, discuss design patterns for ADF pipelines, review useful activities in ADF and see how closely it compares to SSIS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI ETL Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 04

Time: 1:00 PM - 2:00 PM

Room: BRD172

Azure Data Factory version 2 continues to grow and have new features. Today we will walk through Templates , a new feature that focuses on re usability of your pipelines,data sets and other ADF objects. Focus on the new Template Gallery has a lot of good examples. We will focus on showing why we would use each example and what else we have found in the use of ADF, whether it be pulling your data from on premise to the cloud or from cloud to cloud. Today's session will help you understand what you can and can't do for your next Cloud Data implementation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 11:00 AM - 12:00 PM

Room: BRD172

Have you heard about these “Container” things? You may have questions like “What is a Container?”, Who is this “Docker?”, “Aren’t containers a Linux Thing?” and “As a DBA why do I care?” Sit back and listen as we cover these questions and many more. We will then take a closer look at leveraging Containers in a SQL world. We will review the published Microsoft SQL Server container images, what you can do with them and why you would want to use them. We will then show some examples of running MS SQL Server in a container on both a Windows host and a Linux host. This is a great introduction to Containers as well as what is possible with SQL Server in a container.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Development, Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 8:30 AM - 9:30 AM

Room: BRD165

At one of the non-profits (PCs for Refugees) I volunteer, we provide refugees with computers to help them learn English and other school subjects like Math, Science, etc. along with typical usage like ticket booking, navigation, communication, entertainment, etc.

In this session, I'll try to explain the benefits of Microsoft for Nonprofits sponsorship and how any cost-effective organization can use MS Forms (or such), Power BI, PowerApps and MS Flow to not only build a full-fledged solution but also how easy and cost-efficient it is to implement, maintain and expand it as necessary.

We will go over the implementation of a typical case management system which receives requests; visualize and plan logistics; take it through stages using mobile/web platforms; and keep everyone involved to be fully integrated and informed throughout the life-cycle of the request. We'll also touch upon the insights we used to shape up and optimize the delivery and effectiveness of the empowerment effo
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Introductory Data Topics & Professional Development

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: BRD147

Data Virtualization is becoming a key part of any data platform architecture that is built to enable users to unlock data insights. With so many tools available in the market it is important to understand the main goal of Data Virtualization. In this session, we will use one of the leading tools in the market (Denodo) to showcase how data virtualization empowers users to build Power-BI dashboards combining multiple on premise and cloud sources.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics

Level: Beginner

Session Code:

Date: May 04

Time: 1:00 PM - 2:00 PM

Room: BRD171

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. 
Mashups using data from partners, commercial and public sources are fast becoming the new normal.
Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening?
Need to determine the quality of a file downloaded from the internet or supplied by another party?
In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Introductory Data Topics & Professional Development

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: 101

Using Databricks to develop and streamline an end-to-end process. Taking data from a raw discovery level, transforming and exploring the data to a dashboard to deliver clean and clear insights across all areas of data exploration and configuration.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Introductory Data Topics & Professional Development

Level: Intermedia

Session Code:

Date: May 04

Time: 2:15 PM - 3:15 PM

Room: BRD171

In this session, I will take a use case to walk you through the process of training machine learning models in R and deploying the R models using Tableau, not as a traditional dashboard, but as an application that takes users’ input, calls R engine, and returns model predictions back to users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: BRD171

In this presentation we will examine practices that combine and automate the processes between data science and IT teams, in order that they can build, test, and release models faster and more reliably.  We will examine the Data Science Devops technology landscape, and demonstrate how Kubeflow can be used to achieve end to end Devops for Data Science.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analytics

Level: Advanced

Session Code:

Date: May 04

Time: 9:45 AM - 10:45 AM

Room: BRD149

Do you ever look at your data visualizations and feel that they are lackluster? Have you made a report using the latest chart types, but you still can’t gain adoption from your target audience? Lots of people feel this way, but they can’t quite identify what should be changed or how to change it. This session will help you identify signs that it’s time to give your data visualizations a makeover and provide practical tips for improving your reports and dashboards. We’ll discuss how simple changes in design choices related to color, chart types, chart formatting, and report layout can make a big difference in creating clear and engaging visualizations with common analysis tools like Power BI and Excel.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Visualization and Reporting

Level: Beginner

Session Code:

Date: May 04

Time: 1:00 PM - 2:00 PM

Room: BRD147

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Development, Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: BRD165

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Maintenance And Performance Tuning

Level: Intermedia

Session Code:

Date: May 04

Time: 9:45 AM - 10:45 AM

Room: BRD168

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts. 

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 11:00 AM - 12:00 PM

Room: BRD171

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Maintenance And Performance Tuning

Level: Advanced

Session Code:

Date: May 04

Time: 2:15 PM - 3:15 PM

Room: BRD168

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