| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:30:00 | Reza Rad | Business Intelligence | M and Power Query Beyond Limits |
| 10:30:00 | Sergio Reginaldo Zenatti Filho | Analytics Big Data | Building a Modern Analytics Solution in the Cloud |
| 10:30:00 | Kevin Boles | DBA/DevOps | Common TSQL Mistakes |
| 10:30:00 | Rob Farley | DBA/DevOps | Advanced Indexing for Beginners |
| 11:35:00 | Manohar Punna | Analytics Big Data | Real-Time Analytics with Power BI |
| 11:35:00 | Leila Etaati | Analytics Big Data | Machine Learning Revolution with Azure Databricks |
| 11:35:00 | Martin Catherall | Strategy and Architecture | Data Privacy and the Data Professional. |
| 13:15:00 | Gilbert Quevauvilliers | Business Intelligence | Power BI Writeback with Power Apps |
| 13:15:00 | Hamish Watson | DBA/DevOps | Building a Database DevOps Pipeline in the Cloud under 49 minutes |
| 13:15:00 | Jim McLeod | Business Intelligence | Creating Custom Visualisations with Power BI |
| 14:20:00 | Warwick Rudd | DBA/DevOps | SQLOpsStudio Vs SSMS - There can be only one |
| 14:20:00 | Martin Cairney | DBA/DevOps | Azure PaaS Databases - The Choice is Yours |
| 14:20:00 | Wyn Hopkins | Business Intelligence | Power BI and Excel. Better Together. |
| 15:45:00 | Patrick Flynn | DBA/DevOps | GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects |
| 15:45:00 | Kelly Broekstra | Business Intelligence | Tell me a story with Power BI |
| 15:45:00 | Ram Katepally | Analytics Big Data | Azure Machine Learning Power BI - Perfect Combo for Predictive Analytics |
Event Date: 25-08-2018 - Session time: 10:30:00 - Track: Business Intelligence
Event Date: 25-08-2018 - Session time: 10:30:00 - Track: Analytics Big Data
Event Date: 25-08-2018 - Session time: 10:30:00 - Track: DBA/DevOps
Event Date: 25-08-2018 - Session time: 10:30:00 - Track: DBA/DevOps
Event Date: 25-08-2018 - Session time: 11:35:00 - Track: Analytics Big Data
In this session
Event Date: 25-08-2018 - Session time: 11:35:00 - Track: Analytics Big Data
Event Date: 25-08-2018 - Session time: 11:35:00 - Track: Strategy and Architecture
But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.
Event Date: 25-08-2018 - Session time: 13:15:00 - Track: Business Intelligence
In this session I will demonstrate how to integrate write back using Power Apps, within a Power BI report.
The session will be almost entirely demo based, in which I will demonstrate how to integrate the Power App with the Power BI report. And then show by updating a record, that the data is almost instantly updated within the Power BI report.
Event Date: 25-08-2018 - Session time: 13:15:00 - Track: DBA/DevOps
Continuous integration is based around automated builds and tests. Continuous Delivery allows both application developers, database developers and DBAs alike to deploy better quality code/software.
In this DEMO heavy session, we will start off with source code only.
Over the course of 49 minutes we will build a deployment pipeline that starts off with pushing our database and application code to source control. We will utilize Visual Studio Team Services to automate our build and tests and perform Continuous Integration operations.
The output of these operations will be a standardized package of our built solution. Utilizing PowerShell in the form of Infrastructure as Code, we will spin up multiple Azure based environments that will be deployed to using automated Continuous Delivery processes. The finished result will be an automated and reliable deployment pipeline that was built under 49
Event Date: 25-08-2018 - Session time: 13:15:00 - Track: Business Intelligence
This session introduces you to writing your own fully interactive custom visualisations in NodeJS, how to troubleshoot and debug, culminating in deployment of the Visual to your Power BI environment, giving you the ability to display exactly what you want in your Power BI reports.
Event Date: 25-08-2018 - Session time: 14:20:00 - Track: DBA/DevOps
In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
Event Date: 25-08-2018 - Session time: 14:20:00 - Track: DBA/DevOps
The choice night be easy for the non-SQL Server PaaS, but the choice for SQL Server between SQL DB, Elastic Pools and Managed Instances can become, well, "cloudy". This session will explore the features available to each option to help guide you through the first part. We'll then look at what to do once you have your PaaS database deployed – what can you use to manage it and what maintenance tools are available in the service for each flavour.
Event Date: 25-08-2018 - Session time: 14:20:00 - Track: Business Intelligence
Not only do they share the same engine (Power Query and Data Model) but they interact with each other beautifully. This session will showcase the integration features between Power BI and Excel including Power BI Publisher, Analyze in Excel and Publishing Excel files to the Service. We'll even explore some of the latest data analysis innovations to hit the Excel Insider channel including Insights, and Data Types.
Event Date: 25-08-2018 - Session time: 15:45:00 - Track: DBA/DevOps
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
Event Date: 25-08-2018 - Session time: 15:45:00 - Track: Business Intelligence
Great stories will pull people in, and they will enable you to share ideas, persuade others, and get what you want. Power BI has some awesome features that take your reports from flat and boring to exciting, interactive applications, enhancing the practical experience and allowing you to tell a great story. In this session you will see demos of custom visuals, bookmarking, visual display controls, links, spotlights, drillthrough and ‘what if’ plus other tips and tricks that will give you powerful intuitive storytelling capabilities and let you create better insights and organisational performance.
Event Date: 25-08-2018 - Session time: 15:45:00 - Track: Analytics Big Data
How amazing will it be to build visualization in Power BI forecasting the sales for a grocery chain or visualize property prices based on ML model ?
In this demo filled session, we will cover how you can find hidden patterns in the data, find outliers, predict results using real world data sets.
AML is a cloud service which helps us to create predictive analytical solutions. Power BI is a powerful tool for both data analysis and visual representation. Operationalizing the ML models thru the PBI service makes it a perfect combo.
In this session, we will build a predictive solution from scratch and visualize the models thru Power BI. The audience will be equipped with sufficient knowledge to build, operationalize ML models and be able to apply to any real world data set by the end of the session.