Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type




Sessions Found: 27
Accelerate big data analytics with Azure Databricks. Native integration with (Azure AD) and other Azure services enables you to build your modern data warehouse and machine learning and real-time analytics solutions.
This talk will show the importance and justification with 4 reasons for the new offering [Azure Databricks] which is, in fact, a game changer in the industry.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Lightning Talk (15 and 30 minutes Talk)

Level: Beginner

Session Code:

Date: August 10

Time: 12:40 PM - 12:55 PM

Room: 183-1045

As data specialists, data integration projects are some of the most complex environments we have to deal with. In particular when it involves data migration.
There are many tasks that need to be performed, ranging from data profiling, data quality assessments, master data management, testing, to the standard ETL processes. We often wind up reinventing the wheel, especially because most of these projects are one-off throw aways. These make our lives that much harder as we are often pressed for time by the business to get on with the job.
In this session, I would like to show you how a generic ETL framework can help save us time by leveraging off some standard processes that can easily be developed and reutilised.
I will show you how with a few simple SSIS tasks and lines of code we can create an efficient ETL process that we can keep using again and again. Because it's extendable, we can easily add additional components for DQS, MDM and reconciliation testing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 10

Time: 10:50 AM - 11:50 AM

Room: 180-2044

This session is about the new possibility of doing AI inside Power Apps and Microsoft Flow.  the audience will get familiar with the new update announced in Business Application Summit on AI Builder that provides the facility to run easy AI inside Power Apps and Flow.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 10

Time: 10:50 AM - 12:20 PM

Room: 183-1104

Azure Data Studio is no longer the new kid on the block. How many of you have used Azure Data Studio? 
              In this session we will take you on a journey introducing you to Azure Data Studio so that you can understand the ins and outs and when you should consider using Azure Data Studio in place of SQL Server Management Studio. In this idemo heavy session we will look at how productive you can be with Azure Data studio and some of the features that are not available in SQL Server Management Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 10

Time: 9:40 AM - 10:40 AM

Room: 180-2045

Got an idea for a data visualisation but don't want to write any code? There's a thing for that...

Charticulator comes from Microsoft Research and is used to create reusable, web-based bespoke data visualisations for use on the web. The icing on the cake is that you can use these templates to generate Power BI custom visuals as well!

In this session, we'll go through the concepts of the tool and build on these to create our own chart.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: August 10

Time: 12:40 PM - 1:40 PM

Room: 180-B001

Today’s database professionals must be engineers, not just administrators.
We build things. We create things. As engineers practicing devops, we are all in this together, and nothing is someone else’s problem. 
As engineers, we apply repeatable processes, established knowledge, and expert judgment to design, build, and operate production data stores and the data structures within. 
As database reliability engineers, we must take the operational principles and the depth of database expertise that we possess one step further. 
Guiding Principles of the DBRE 
* Protect the Data 
* Self-Service for Scale 
* Elimination of Toil 
* Databases Are Not Special Snowflakes 
* Eliminate the Barriers Between Software and Operations
Speaker:

Session Type:
Short Session (30 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 10

Time: 3:00 PM - 3:30 PM

Room: 183-1045

Traditionally, SSRS is used for paginated reports which gives flexibility like drill through reports, subscriptions and print formatting. With Power BI the reports are now more interactive and dynamic. There are still few gaps between these two platforms which are built to purpose. This gap is getting smaller as features are ported between these two platforms. In this session I will be going through various features which are bridging these gaps and point out the differences. These are significant and can affect your decision in choosing the right platform which will fit your needs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 10

Time: 9:40 AM - 10:40 AM

Room: 183-1104

Sharing and documenting Machine Learning solutions is now easier with Azure Notebooks. Azure Notebooks will allow Data Scientists to share the whole machine learning process from data acquisition, to data cleaning, and finally creating a machine learning model.
With Azure Notebooks the information can also be presented to non-technical stakeholders in an easier way. In this session you will learn 
•	What are Azure Notebooks?
•	How to create your first notebook in Azure Notebooks?
•	How to use code snippets and visualisations in a notebook?
•	Create a slideshow of your notebook
•	How to share your notebook with your team?
By the end of the session you will get a good understanding about Azure Notebooks and how to use them for real world problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 10

Time: 1:50 PM - 2:50 PM

Room: 183-1045

Would you like to get to $1m annual revenue in 5 easy steps?
Or, do you simply want to go from barely sustainable to profitable?

In this session I will touch on the 5 steps I considered when building and growing out a SQL Data Platform practice. 
1. Choose a specialty.
- How to decide what to do, and how to make it shine.
2. Pick your partners.
- Why partnering is essential.
- Augmenting your capabilities.
3. Defining services.
- What are the differences between Managed Service and Professional Service.
- How many services to offer.
- How to pick a service and price point.
- How long before you actually make money.
4. Market your offerings.
- Yes, you have to sell, yourself.
- When to give things away for free
- The value of existing customers
5. Build your team.
- You're making it, now you need to manage it
- Bringing on the right people.

I'll also touch on how long it took me to achieve each of these, and how I measure success.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: August 10

Time: 1:50 PM - 2:50 PM

Room: 180-2044

With the release of the GDPR regulations and similar global standards security is finally becoming the focus it always should have been.  Businesses are now able to put a number on how much a data breach will cost them...and that number is big enough to put many firms out of business.  
  In this session we'll talk about the various ways you can implement Encryptian natively within SQL Server - with Backup Encryption, Transparent Data Encryption(TDE), AlwaysEncrypted, and connection encryption
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 1:50 PM - 2:50 PM

Room: 180-2045

Azure Cosmos DB is an awesome multi-model database service that allows us to distribute our data on a global scale. It's fairly easy to get started with Cosmos DB, but when it comes to implementing it for use within our Enterprise applications, there are many things that you will want to consider when developing a Cosmos DB database.

In this session, I'll cover important topics that you'll want to consider when developing and administrating Cosmos DB for Enterprise use, including security considerations, partitioning, provisioning throughput for your databases and collections, distributing your data and much more.

By the end of this session, you should be able to take these learnings and apply them when developing Cosmos DB applications for your business.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 10

Time: 12:40 PM - 1:40 PM

Room: 180-2045

Azure Cosmos DB is Microsoft’s Globally Distributed, Multi-Model database service.  Transparently scaling across multiple Azure regions, Cosmos DB provides for many API’s including MongoDB, Cassandra, Gremlin and SQL. It offers multiple consistency models and guarantees uptime or 5 9’s.
Azure data lake provides a way for a whole range of different data to be stored, analysed and manipulated – all form a single place – so that developers, data scientists and data analysists can access it. Forming part of what is often termed ‘a modern data warehouse’ this technology is something that is becoming more common.
In this session we’ll take a look at these two technologies and how they might be useful – either now or in the future.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: August 10

Time: 9:40 AM - 10:40 AM

Room: 183-1045

In this session I will cover some of the essential financial calculations that can be performed with DAX, for visualization in Power BI.

Financial calculations in Power BI are useful for individuals and businesses who want to better understand their past and future financial performance, and quickly and easily visualize the results.

I will include practical examples and a take-away Power BI model covering:
- Valuation and return calculations using XNPV and XIRR.
- Personal finance projections.
- Risk calculations using the normal distribution.
- Calculations on portfolios of assets, including correlation calculations and plotting the efficient frontier.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: August 10

Time: 1:50 PM - 2:50 PM

Room: 180-B001

In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life. 
With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!

In this session we will investigate the setup and use of GitHub and Git for source control.
Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!

Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 10

Time: 12:40 PM - 1:40 PM

Room: 183-1104

They say every cloud has a silver lining, well this one is gold! This demo heavy session will introduce you to Azure Analysis Services. We begin by looking at a traditional analytics platform, and how this fits into the "modern data warehouse". This session will guide you through the processes (and pitfalls) of modernizing your data analytics solution. Still using PowerPivot models or for that matter still using SQL Server Analysis Services on-premise? Let's see how to leverage these assets into the modern would of cloud computing using Azure Analysis Services, with minimal downtime. Prepare to be amazed at what is possible with all the wonders of cloud computing in the Azure world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 10

Time: 10:50 AM - 11:50 AM

Room: 183-1045

New to DAX and want to code like a pro? This session is designed to accelerate you up the DAX learning curve by covering the five most useful concepts to help you get started and become an expert in no time! Topics covered include filters, variables and calculations, along with plenty of tips on optimizing, troubleshooting, and performance tuning best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 10

Time: 10:50 AM - 11:50 AM

Room: 180-B001

We have to short sessions in this slot:
Title: Use PowerShell to deploy and configure Azure SQL Database (PaaS)  with good resilience to outages and with integrated Azure SQL Analytics monitoring solution.
Duration: 30 Minutes
Speaker: Zoran Barac
Abstract:
Use one single PowerShell script to deploy cloud service with Azure SQL Database with good resilience to outages (GEO Replication, Fail-over Group) and to enable diagnostics for Azure SQL database and configure Azure SQL Analytics monitoring solution for monitoring performance of Azure SQL Databases. 

4 Reasons to love Azure Databricks (? G?MË CH?NGËR)
Speaker: Tariq Younas
Duration: 15 minutes
Accelerate big data analytics with Azure Databricks. Native integration with (Azure AD) and other Azure services enables you to build your modern data warehouse and machine learning and real-time analytics solutions.
This talk will show the importance and justification with 4 reasons for the new offering [Azure Databricks] which i
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Lightning Talk (15 and 30 minutes Talk)

Level: Intermedia

Session Code:

Date: August 10

Time: 10:50 AM - 11:50 AM

Room: 180-2045

MLOps empowers data scientists and app developers to help bring ML models to production. MLOps enables you to track / version / audit / certify / re-use every asset in your ML lifecycle and provides orchestration services to streamline managing this lifecycle. 
In this session, we will cover how MLOps is different to DevOps, MLOps workflow and best practices, and a demo of orchestrating pipelines in R and Python.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: August 10

Time: 12:40 PM - 1:40 PM

Room: 183-1045

If you find yourself getting lost then SQL Server’s spatial technology is here to help. At first glance, the spatial functions and data types can be quite confusing and weird. This presentation will demystify SQL Server’s spatial features so that you can use them confidently in your job. I will step through the theory and show a number of examples and best practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 10

Time: 3:00 PM - 4:00 PM

Room: 183-1104

Learn about Power BI Modeling through real-world examples. Learn what is fact table, dimension tables, star schema, and how it can help to design a better Power BI data model. You will see examples of a bad data model, and how it can be transformed into a good practice data model using Power BI, Power Query, and DAX.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: August 10

Time: 3:00 PM - 4:00 PM

Room: 180-B001

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