Pre Conference Workshops 17th February, Post Conference Workshops 20th February

Analysis of your SQL Server like a PRO

Full Day Workshop

Level: 300

Pre-Conference: 17th of Feb 2020

SQL Server is a mission critical database platform but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.
If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyse and tune SQL Server like a PRO.

In this full training day, I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach.”

Uwe Ricken

Uwe Ricken

Uwe Ricken has been working with IT systems since the 90s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of membership administration software for the American Chamber of Commerce in Germany. After the development the software has been distributed to five additional European countries. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for the Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he earned in May 2013 the Microsoft Certified Master SQL Server 2008 certification which the highest technical certification by Microsoft. The successful year 2013 has been finalized with the first MVP award for his outstanding support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken was the first MCM + MVP in Germany! To provide his deep knowledge about Microsoft SQL Server to the interested community Uwe Ricken is blogging since 2010 at http://www.sqlmaster.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German speaking SQL community enthusiasts deep inside views into the technology of Microsoft SQL Server. Uwe Ricken is a speaker on many international conferences and events and preferred topics for Database Internals Indexing and Development.

Data Science Algorithms

Full Day Workshop

Level: 400 Expert

Pre-Conference: 17th of Feb 2020

Advanced data analysis techniques are gaining popularity. With modern statistics / data mining / machine learning engines, products and packages, like SQL Server Analysis Services (SSAS), R, Python, and Azure ML, data mining has become a black box. It is possible to use data mining without knowing how it works.

However, not knowing how the algorithms work might lead to many problems, including using the wrong algorithm for a task, misinterpretation of the results, and more. This seminar explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm as well.

Demonstrations show the algorithms usage in SQL Server Analysis Services, R and Python languages and SQL Server Machine Learning Services, Azure ML native algorithms, using R in Power BI, and using the R and Python algorithms in Azure ML. The attendees also learn how to evaluate different predictive and unsupervised models.

Dejan Sarka

Dejan Sarka

Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.

Getting Started with Data Science and Databricks

Full Day Workshop

Level: 100

Pre-Conference: 17th of Feb 2020

Databricks is a very popular environment for developing data science solutions. More and more companies are interested in Databricks as it is very simple to set up and contains a collaborative workspace for working with a team of people. In this session you will see how to create Machine Learning Solutions with multiple workflows starting with ETL, to data exploration, model experimentation, and lastly to a production release of a data science solution.

Today, more and more development is performed on very large datasets. Attendees will learn how to use Apache Spark, which is part of Databricks, to rapidly analyze lots of data. Learn how to use Databricks to reduces operational complexity to create solutions which can be scaled up or down depending on the amount of data needed to process without having to change the underlying code.
Python, Jupyter Notebooks, and Apache Spark are the technologies used to create solutions within this session. No experience is required.

Ginger Grant

Ginger Grant

Ginger is a consultant who shares what she has learned while working with data technology at clients by providing training to people around the world. As a Microsoft MVP in Data Platform and a Microsoft Certified Trainer, she is proficient in creating solutions using the entire Microsoft Data Stack, which includes SQL Server, T-SQL, SSIS, SSAS, Power BI and Azure Data Cloud components including Databricks, Data Factory, Data Lakes, Data Analytics, IOT, Event Hubs, Machine Learning. In addition to blogging at http://www.desertislesql.com, Ginger has authored 70-774 Perform Cloud Data Science with Azure Machine Learning. When not working, she maintains her blog and spends time on twitter @desertislesql.

Design and develop blockchain applications in Azure

Full Day Workshop

Level: 400 Expert

Pre-Conference: 17th of Feb 2020

“This workshop describes enterprise design patterns for blockchain architectures (network and applications), specific use cases of adoption of blockchain in industries besides fintech, and examples of implementation of blockchain solutions for distributed digital identities, proof of existence and validity of digital assets, verifiable audit trail, etc.

During this workshop, we’ll be using extensively Azure Blockchain Workbench for creating a decentralized solution deployed on a blockchain network, which shares on and off-chain data and services. Focus is on automating the workflows that can be generated in Blockchain Workbench, by leveraging the Azure Blockchain Development Kit and Microsoft Flow.

Since the Azure Blockchain API provides access to on and off-chain data, we’ll understand how to integrate blockchain data with PowerBI, chat bots, Azure Service Bus, Event Grid and Machine Learning as well.

Stefano Tempesta

Stefano Tempesta

Stefano Tempesta is a Microsoft RD (Regional Director), MVP on AI and Business Applications, and member of the Blockchain Council. A regular speaker at international IT conferences, including Microsoft Ignite and Tech Summit, Stefano's interests extend to blockchain and AI-related technologies. He created Blogchain Space (blogchain.space), a blog about blockchain technologies, writes for MSDN Magazine and MS Dynamics World, and publishes Machine Learning experiments on the Azure AI Gallery (gallery.azure.ai). "

Demystifying DAX

Full Day Workshop

Level: 200

Post-Conference: 20th of Feb 2020

DAX is the data modelling language of Power BI and Power Pivot for Excel.  It is reasonably easy to get started with DAX, however sooner or later most people hit a wall where they get stuck and can’t move forward. Have you ever typed a DAX formula, pressed enter and then crossed your fingers hoping you will get the right answer? If this sounds like you, then chances are there are some deeper concepts that you don’t fully understand, and these gaps are stopping you from moving forward.

In this full day pre-con session, Matt Allington (Author of the book Supercharge Power BI) will clearly explain how the DAX language really works under the hood. At the end of the session you will fully understand filter propagation, initial filter context and evaluation contexts. The session will use real world examples to explain the concepts. This is not a beginners course you should already know the basics of DAX before attending.

Matt Allington

Matt Allington

Matt Allington is a career data professional that has spent more than 30 years leveraging data to drive success. In 2014 Matt left the corporate world to start his own company (Excelerator BI) and now works full time to help others to use Microsoft BI products (Power BI, Power Pivot for Excel, Power Query for Excel). Matt is Microsoft MVP based in Sydney Australia, however has a global reach through his blog at http://xbi.com.au/blog

Power BI Premium – What is it, how does it work and how can it help my organisation

Full Day Workshop

Level: 200

Post-Conference: 20th of Feb 2020

I will cover what Power BI Premium is, what features it offers.

Then walk through showing people how it works by walking through demo’s using those features such as (Free users, Incremental Refreshing, Paginated Reports, XMLA End Points & more as new features become available. And if there is anything of particular interest people are looking for.)

I will also cover off what actually happens when using some of the features in Power BI Premium and how this could affect the performance not only of reports, but of your Power BI Premium capacity.

During the entire session, I will also explain how it can help your organisation to ensure that you can deliver the best reporting solution to your end users be that internal or external.”

Gilbert Quevauvilliers

Gilbert Quevauvilliers

Microsoft MVP - Power BI Consultant using Microsoft Power BI to provide solutions for business challenges by sitting with the users within the business to build Power BI models which enable the business to gain insights. My goal is for the business to see their data on their terms by delivering Microsoft Power BI Solutions in weeks or less, thereby enabling them to move forward to leverage their data. I have assisted with the implementation and completion of Power BI which includes Power BI Desktop development, assistance with Power BI Gateway, Power BI Service, Power BI Internal Training, Power BI Best Practice & Power BI User Group sessions. Power BI training provided to Businesses based on their requirements. Participate and present at the Brisbane Power BI User Group Leader, SQL Saturday Presenter, Brisbane Power BI User Group, Power BI Community and publish blog posts to the Power BI Community Blogs. Past working experience in Business Intelligence (BI), working on large, complex end to end BI solutions for customers.

Master your data for Excel & Power BI

Full Day Workshop

Level: 200

Post-Conference: 20th of Feb 2020

The sad reality is that not all data we need for our reports is stored in nicely curated databases. While some of the data may be, the reality is that we also need to piece together data provided in text files, Excel files, web pages and even the body of emails in order to build the complete business intelligence solutions we need. Until now this has been a painful process with a great deal of cutting and pasting into Excel files. Updates have been tedious and error prone, if the solution isn’t abandoned outright. That stops today.
This course is about Data. It’s about getting, transforming, cleaning and reshaping your data. It’s about turning awkward data into shiny golden tables that are perfect for analysis, whether you need it in Excel, or in Power BI. In fact, the techniques are so portable, that you’ll be able to follow along in whichever program you like best!

Ken Puls

Ken Puls

Ken Puls, FCPA, FCMA, is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken has held the Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. He is also one of about 4% of CPAs to be recognized as a Fellow of his accounting body. Learn more about Ken at https://ca.linkedin.com/in/kenpuls.

Back to Basics: Power BI Modelling for Non-Data Professionals

Full Day Workshop

Level: 100

Pre-Conference: 17th of Feb 2020

You are not a data professional, and you find it difficult to understand what the relationships are in the data model, why should you merge or not merge tables together, or what is the reason for it. You find it hard to understand what is fact table and dimension table, yet you heard that you should design your tables that way to have a better data model. You want to build a Power BI solution that performs fast, and you have no data modelling or database background, and all the resources you find requires knowing the basics of modelling in advance. You are learning Power BI as a business person, and you want to be able to use this tool properly.

If any of the above is you, then this workshop is for you!

In this workshop, you will learn about the basics of modelling. Here is the proposed agenda (subject to minor changes):

What are relationships
Direction of relationship
Inactive vs. Active relationships
Multiple tables in the model
What is dimension and fact tables?
What is Shared dimension?
What is Star Schema? And how to build it?
Tables with different granularity (Budget vs. Actual)
Calculations to help with basic modelling
Power Query transformations to help with the basics of modelling

Reza Rad

Reza Rad

Reza Rad is author, speaker, trainer and consultant. He is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, Microsoft Data Insight Summit, and so on. He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star; http://radacad.com/online-book-power-bi-from-rookie-to-rockstar

AI in Power Platform: The Realm of the impossible

Full Day Workshop

Level: 100

Post-Conference: 20th of Feb 2020

Using AI is a norm this day in developing applications and analyzing the data. Easy AI is not a dream anymore, that means everyone regardless of how they are familiar with AI and ML concepts can use AI in their applications and analysis.

Besides, Power Platform technologies (Power BI, Power Apps, and Flow) have been used by analysts, BI developers, office 365 specialists and users, and so forth for a while. In a one day workshop, audiences will learn how to leverage AI in Power Platform.

Module 1: Introduction to AI and ML

The audience will get familiar with AI and ML concepts and what architecture and opportunity they have. Some introduction to ML approaches from predictive, descriptive, and prescriptive analytics will be provided. The audience also gets familiar with pre-build and Custom AI tools in Microsoft stacks such as cognitive service and Azure Ml Service.

Module 2:

Next, an introduction to Power BI desktop and service, especially Data flow, will be provided. The audience will see different approaches to use AI and ML inside Power desktop and Power BI service. In Data flow, how we able to use AutoML, and AI insight will be shown. Also, audience will see how to consume their models that have been created in Azure ML Services using Python, AutoML interface, or Azure ML Studio inside Power bI desktop or Data flow. Also, they will get familiar with some of the interesting visuals like Key Influencer to analyze their data better.

Module 3:

In this module, the audience will learn about how to do AI in Power Apps and Microsoft Flow using AI builder for the aim of classification, regression, and forecasting. Also, they will learn how they can create an application for the aim of object detection and form processing using AI builder. Next audience will see how to consume the other cognitive service model in Microsoft Flow such has an image tag or face recognition.

Leila Etaati

Leila Etaati

Leila is the First Microsoft AI MVP in New Zealand and Australia. She has a PhD in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members. Leila is also the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now), Difinity (2017 till now) and Global AI Bootcamp 2-18. She is a Data Scientist, BI Consultant, Trainer and Speaker. Leila is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

Intelligent Data Integration with SSIS and Azure Data Factory

Full Day Workshop

Level: 300

Post-Conference: 20th of Feb 2020

This session focuses on the all Platform as a Service (PaaS) solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift & shift, modernize, and extend ETL workflows. We will first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI, configure it to access data on premises using Windows authentication and Virtual Network injection, and extend it with custom/Open Source/3rd party components.

You can then use the familiar SSDT/SSMS tools to deploy/execute/manage your packages in the cloud just like you do on premises. We will next show you how to modernize your ETL workflows by invoking/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to leverage ADF connectors (+80), connect using Azure Active Directory authentication, store secrets in Azure Key Vault, automatically (de)provision SSIS IR just in time, and splice advanced transformations, such as Power Query Source, Data Quality Components, etc.

Andy Leonard

Andy Leonard

Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS Trainer, Consultant, and developer, a Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks - A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page. .

Sandy Winarko

Sandy Winarko

Sandy is a seasoned Product Manager with extensive experience in the US, Europe, and Asia, combining commercial/technical responsibilities in principal/senior roles at various TMT (Technology, Media, and Telecommunications) companies, such as Microsoft/Skype/Nokia, BSkyB (British Sky Broadcasting), and C&W (Cable & Wireless). At Microsoft, he is currently driving the efforts to modernize SSIS (SQL Server Integration Services) on premises and in the cloud as part of ADF (Azure Data Factory).

Power BI for Developers and Programmers

Full Day Workshop

Level: 300

Pre-Conference: 17th of Feb 2020

This course targets programmers who want to leverage Power BI in their applications, or want to extend Power BI features with custom visuals. It’s an advanced course where you will learn what Power BI platform has to offer developers including:

Embedding Power BI content into web applications
Power BI REST API and using it into custom .NET applications
Streaming data concepts; pushing data into real-time dashboards.
Introduction to Custom Visuals; creating new visuals

Prerequisites:
Familiarity with Power BI content creation (i.e., modeling, report building, publishing to service)
Familiarity with .Net, PowerShell and JavaScript basics are highly desirable
Power BI Pro account (60 day free trial is sufficient)

Sergei Gundorov

Sergei Gundorov

The presenter, Sergei Gundorov, currently works as a Program Manager on the Power BI team at Microsoft. He has Master’s Degree in Business Administration. Sergei published numerous articles over the course of the last 26 years through multiple channels on various subjects that range from accounting and economics to in depth technical articles on MSDN (Microsoft Developer Network). Sergei’s most recent contribution was to the Security Whitepaper for Power BI published in May of 2017. He presented his most valuable technological advancements to worldwide developer audiences at TechEd, TechReady, and Office/SharePoint Developer conferences. He participated and contributed to numerous webcasts that focused on various technologies that he is considered to be an expert on. He is an inventor and filed several patent applications. Sergei runs popular technical “XLGeek’s Space” blog where his work is praised very highly by the readers and his apps users.