|Start Time (24h)||Speaker||Track||Title|
|09:00:00||Peter Myers||BI Information Delivery||Zero to Microsoft Power BI|
|09:30:00||Peter Myers||BI Platform Architecture, Development Administration||Power BI for the Developer|
|09:30:00||Patrick Flynn||Enterprise Database Administration Deployment||Schroedinger’s Backup – will your recovery work?|
|09:30:00||Martin Catherall||Application Database Development||Build your first Service Broker application|
|11:00:00||Hamish Watson||Enterprise Database Administration Deployment||DevOPs and the DBA|
|11:00:00||Peter Myers||BI Information Delivery||Reports on the Run: Mobile Reporting with SQL Server 2016|
|11:00:00||Reza Rad||BI Platform Architecture, Development Administration||Security in Power BI; Everything You Need to Know|
|13:30:00||Matt Allington||BI Platform Architecture, Development Administration||Power Query is more than just a desktop BI ETL tool|
|13:30:00||Leila Etaati||Advanced Analysis Techniques||On-premises Machine Learning : SQL Server 2016 with R|
|13:30:00||Manohar Punna||Cloud Application Development Deployment||Azure Database Migration – Choosing the Right Tier|
|14:50:00||Victor Isakov||Enterprise Database Administration Deployment||SQL Server 2016: It Just Runs FASTER!|
|14:50:00||Craig Bryden||Application Database Development||Visual Studio SQL Server Database Projects and integrating into VSTS|
|14:50:00||Reza Rad||BI Platform Architecture, Development Administration||Data Preparation is the Keystone; Power Query is Building Block|
|16:00:00||Gilbert Quevauvilliers||Analytics and Visualization||Power BI real world tips and tricks|
|16:00:00||Martin Cairney||Cloud Application Development Deployment||Database Administration for Azure SQL DB|
|16:00:00||Peter O'Gorman||BI Information Delivery||Drone or Die - Defenders of the Universe|
Event Date: 27-05-2017 - Session time: 09:00:00 - Track: BI Information Delivery
The workshop has been specifically designed to empower attendees with the technical knowledge required to become proficient with the Power BI service and also its growing number of capabilities and features. It is sure to inspire attendees with opportunities, and to provide them with resources to help them take the next steps on their path to mastering Power BI.
The workshop will include the following modules:
1: Microsoft Power BI Overview 2: Working with the Power BI Service 3: Connecting to Power BI Data Sources 4: Creating Power BI Desktop Solutions
This workshop is suitable for a broad array of professionals, including business analysts, IT managers, Business Intelligence practice leads and architects. As an introductory workshop, there is no requirement to have existing Powe
Event Date: 27-05-2017 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 27-05-2017 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
While Schrödinger’s cat was a thought experiment that may have injured an imaginary feline, a failure to be able to recover databases when required can prove terminal to both careers and Companies.
In this session Patrick we will walk you through how to design, create and test Recovery strategies. Using T-SQL and PowerShell you will leave with the tools necessary to avoid you own failed Schroedinger’s Backup experiment.
Event Date: 27-05-2017 - Session time: 09:30:00 - Track: Application Database Development
However, Service Broker is possibly one of the least used components of SQL Server despite debuting in the product in 2005. This session will aim to demystify Service Broker and introduce people to some of the major benefits that it offers. We’ll build a full application which will demonstrate just how easy it is to get up and running with this technology. This session is aimed at people with little to no Service Broker knowledge and aims to show how applications can be easily created with Service Broker. You should leave this session with enough knowledge to then take your Service Broker skills to the next level and be capable of handling more complex projects.
Event Date: 27-05-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work
Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Event Date: 27-05-2017 - Session time: 11:00:00 - Track: BI Information Delivery
This session will describe and demonstrate how to prepare data for mobile reporting, and also how to develop and publish mobile reports. In addition, it will describe the architecture of the engine, and how to manage mobile reports.
This session will be of interest to a full range of professionals, including analysts, report developers, IT managers, and data architects.
Event Date: 27-05-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
This is a demo-heavy session. Come and get answer to all your questions about Security in Power BI.
Event Date: 27-05-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
• Use Power Query as a data provider for traditional Excel Pivot Tables without using Power Pivot. • Building a Power Pivot calendar table from scratch using pure Power Query steps. • Add commentary to bank statements and make those comments "stick" using self-referencing tables. • Using Power Query as an auditing and exception management • Using Power Query as a pure ETL tool and exporting more than 1 m rows of transformed data to a file.
Event Date: 27-05-2017 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 27-05-2017 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
Microsoft offers two types of PaaS (Platform as a Service) or DBaaS (Database as a Service) for SQL Server Database native to could – Single Database and Elastic Pool. Choosing the right tier for your database gets harder with the complexity in calculating the resource utilization for your Azure SQL Database. In this session, I will walk you through the steps involved in analyzing the resource utilization and estimating the right tier to choose for your database in Azure.
Event Date: 27-05-2017 - Session time: 14:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 27-05-2017 - Session time: 14:50:00 - Track: Application Database Development
In this session, I will demonstrate how to use SQL Server Database Projects, discuss the benefits of using SQL Server Database Projects for authoring databases, and demonstrate the benefits of integrating your database development with Visual Studio Team Services.
Event Date: 27-05-2017 - Session time: 14:50:00 - Track: BI Platform Architecture, Development Administration
We will use customer case studies to go through scenarios of preparing data for modelling, and visualization. You will learn how to use features of Power Query such as generators, custom functions, and lots of built-in functions to solve those scenarios. You will also learn some data preparation techniques through Excel itself.
Event Date: 27-05-2017 - Session time: 16:00:00 - Track: Analytics and Visualization
By providing real world, real working examples I plan to show how some simple tips and tricks can make their reports and dashboards amazing and insightful. This will be an interactive and demo rich presentation.
The real world tips will cover the following sections of Power BI: • Query Editor • DAX • Visuals • Power BI Service
Event Date: 27-05-2017 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
This session will identify the main aspects of the Azure SQL DBA role, including how to ensure you have longer term backups (if you need them for compliance), how to manage your Tier level automatically, how to ensure you have the best performance to keep your DTUs to a minimum. You will leave this session with a better story for your manager to convince him to move your workload to Azure and lower your total SQL Server costs.
Event Date: 27-05-2017 - Session time: 16:00:00 - Track: BI Information Delivery
And drones actually produce a lot of raw data.... With that data comes great opportunity and great responsibility, as we take to the skies with a guided tour of what drone data looks like, and what are the opportunities but what are the responsibilities.... "Up ahead was Pandora. You grew up hearing about it, but I never figured I’d be goin’ there...".