Difinity 2019 Conference Sessions for 19th and 20th of Feb 2019

List of sessions will be complete shortly. Please Stay Tuned!

Real-time information with Azure and Power BI, Breaking the 3-second barrier

Track: Power BI, Azure
Length: 75 minutes
Level: 200 – Intermediate

We will extract, transform and stream real-time information in less than 3 seconds using best practice methods. Are you ready?

Have you been asked about displaying real-time information on your Power BI reports dashboards? Have you had performance problems delivering a real-time solution? Have you found the correct tools for delivering real-time solutions? Through this session, you will learn how to deliver Power BI solutions streaming real-time information keeping it simple and low-cost.

I will go over the different tools that we can use to approach as closely as possible (1 second) to a real-time solution along with combining real-time information with batch processed information.

David Alzamendi

David Alzamendi

"Delivering Business Intelligence and Data Analytics Solutions with On-Premises and Cloud technologies since 2011, David Alzamendi is a Microsoft Certified Solutions Expert and event speaker who solves problems with best practice procedures and the latest technology. David is passionate about the positive impact data can have on our lives, businesses, economy and the environment. He prides himself on using his creativity and optimism to solve what others thought impossible."

Empower your business apps using cognitive services

Track: AI, Power Platform
Length: 75 minutes
Level: 100 – Basic

You can create visually stunning and interactive report of your predictive models built in Azure Machine Learning using Power BI.

In this session, you will learn how to use a predictive model developed in Azure Machine Learning to develop an interactive Powre BI report. I will be showing you an end to end demo of a predictive use case that integrates the Azure Machine Learning model into Power BI visualisation using R script.

Indira Bandari

Indira Bandari

"Business Intelligence Consultant with over 15 years experience in designing and developing datawarehouses and analytical solutions. Has a Masters degree in Statistics and is passionate in learning data science. I am a co-organiser of the NZ Business Intelligence User Group. Speaker at a few User Groups and SQL Saturday sessions. Volunteering and sharing my knowledge is my passion. In my pass time I teach game development for primary school kids. Recently I have started teaching about databases and Power BI to 10 -15 year old kids."

Power BI, PowerApps and Sharepoint – A perfect combination for cloud services

Track: Power BI, Power Platform, Data Platform
Length: 75 minutes
Level: 200 – Intermediate

Power BI with its functionalities start moving Business Intelligence into the cloud. Embedding Power BI reports directly in SharePoint Online pages is now possible with no code required. SharePoint groups are ideally integrated with Power BI service which allows us to create App Workspaces within SharePoint itself.

Using a SharePoint lists we can manage information by gathering them in rows known as a list item. PowerApps is relatively new service offering very scalable and powerful custom business apps where data are connected across the web and mobile from the cloud. Both Power BI and PowerApps embeds its visuals in the SharePoint page. Those three products seem to be well known for BI data professionals as a daily basis reporting and sharing platforms.

However, how can we be more efficient and use them simultaneously as one integrated environment? At this session, not only we will explore the features, but we’ll look at how to best use them together.

Jakub Barzyk

Jakub Barzyk

Jakub Barzyk is a Senior Consultant at Webstep, Norwegian provider of high-end IT system development, data warehouse and business intelligence solutions. He has moved to the Vikings land to accomplish his Master’s degree studies and explore breathtaking Norway’s fjords rated as the most impressive landscapes on the planet. He specializes in Microsoft Business Application Platform technologies including Power BI, PowerApps, Flow and Azure Cloud. Today Jakub’s main focus is on translating business requirements into top-of-the-range engineering solutions. Jakub is also a member and speaker of Power BI, PowerApps and Flow User Group Norway sessions.

Azure Machine Learning Studio vs. Power BI

Track: AI, Power BI, Azure
Length: 75 minutes
Level: 100 – Basic

There are so many tools for data analysis and prediction. Let’s explore the Azure ML lab vs PowerBI, how can each of them be used? What are their differences? In this session, you will learn the differences between loading data in the Azure ML Lab vs into PowerBI. We will discuss the cleansing of data in both tools, as well as analyzing existing data (the OOTB for each tool). We will then build a simple prediction model and summarize and compare the results.

Audience: BI experts

Yana	Berkovich

Yana Berkovich

Yana is a Data Platform Microsoft MVP, MBA, Engineer, Product Management, O365 and BI consultant Based in Vancouver Canada. She is a speaker in PowerBI, Business Analysis, O365 and Power Platform topics. Yana spoke in international conferences in Data Platform topics, such as: Microsoft Business Applications Summit Seattle (Featured session), SQL Saturdays (Boston, Vancouver BC, Redmond, Calgary), O365 Saturdays (Redmond, Vancouver) and many local user group sessions in Seattle and Vancouver areas, including leading the local O365 user group. She has more than 10 years’ experience in Business Analysis Product and Process Management using Microsoft tools, and recent data visualizations, integration, and data warehouse developer. She writes blog posts in http://www.yanaberkovich.com/Blog. She worked in many industries including banking financial, Insurance, power and utility, Oil and Gas, Military & Government.

Creating and Managing a Power BI Enterprise Deployment

Track: Power BI, Azure, BI
Length: 75 minutes
Level: 100 – Basic

When implementing Power BI in any enterprise, there are many options that the project team faces, and the choices are not always obvious. The different approaches are often dictated by organisational constraints, which are often different for many organisations. In this presentation, Craig will take you on a journey of discovery about the different best practices and options you have when implementing Power BI in your enterprise. Amongst others, we will discuss topics such as:

  • The different data storage and connectivity modes
  • Power BI Pro vs Power BI Premium
  • Efficient use of workspaces and apps
  • Security Considerations
  • Content Governance

How all of the above (and other) topics impact your implementation.
Craig will bring his extensive real-world experience to this presentation, in which the audience is encouraged to participate in the discussion.

Craig Bryden

Craig Bryden

Craig has been working in Business Intelligence since the late 90’s and has gained experience in almost all industries. Craig is a current Microsoft Data Platform MVP. He has previously been seconded by Microsoft to assist in creating certification tests for the Microsoft Business Intelligence tools, and is a regular speaker at BI related user groups and conferences. Craig is the organiser for the QLD Power BI user group. Craig is the Chief Data Strategist at BiTQ (www.bitq.com.au) where he and his team help customers to transform business data into intelligent data.

Building AI solutions: Real-world examples by Freadom

Track: AI, Power Platform
Length: 75 minutes
Level: 200 (Intermediate)

For almost 20 years, Fraedom has been developing web-based technology that unshackles organisations from complexity and delivers mastery over spending processes. Data has always been the core and foundation of the Fraedom business, capturing, storing and managing data in the most professional way. But what else can we do with the beautiful data?

Can we do something more creatively to enhance our product offering so that customer experience can be significantly improved? In this session, I am taking you through the Data Science & AI journey we have been through, and how we are using Microsoft technologies to understand customer behaviour (PowerBI) and develop Data Science products (Azure SQL, Data Factory, Azure Machine Learning Studio & Data Science Virtual Machine, and R Service in SQL Server).

David Duan

David Duan

Dr David Duan is Principal Data Scientist at Fraedom, a global SaaS company that specialises in Expense Management and Advanced Payment Technology. He heads up the Data Science team in Fraedom and looks after Data Science strategies, innovation and initiatives. David focuses on building Data Science products to improve customer experience, and creating Data-Driven culture in Fraedom. David holds a PhD from The University of Auckland in Applied Mathematics.

What can you do when you can’t throw hardware at a problem?

Track: Data Platform
Length: 75 minutes
Level: 300 (Advanced)

In many instances, there is only so far you can scale your hardware before you realise it’s not actually cost-effective anymore.

This session goes through how to understand what the limitations you’re running into are, and what the best options for improving performance are.

Exploring options for large scale multi-tenency databases, systems where a mixture of OLTP/BAU, ad-hoc, and “data warehouse” style workloads have to be performed against the same databases.

With a little work, you may even be able to reduce your monthly spend.

Dave Dustin

Dave Dustin

Dave has been working in the IT industry for more than 35 years and has specialised on the Microsoft Data Platform from the very early days, delivering and managing data solutions of all sizes. Heavily involved in community activities, Dave has presented at numerous usergroups, conferences and other events, as well as being active in online engagements. Dave is currently the Data Lead for Xero.

Database Internals meets Power BI

Track: Data Platform
Length: 75 minutes
Level: 300 (Advanced)

Understanding and investigating the Internals of an SQL Server database requires use of advanced (often undocumented) DMV’s or DBCC commands

While these provide an insight into the low-level data structures of the database it can be difficult to visualise how these are actually implemented inside the mdf files of the database.

In this session we will see how adding the visualisation options of PowerBI and the Power of R can be used to get a better understanding of how SQL internally manages your data.

Rather than just talking about Fragmentation, Page Splits or Forwarded records, in this session we will show how these physically appear.

Patrick Flynn

Patrick Flynn

Patrick Flynn is a full time Production DBA and has worked with Microsoft Database and Development products since 1994. He specializes in providing Automation, Monitoring, Performance Tuning, High Availability and Disaster Recovery solutions for Enterprise environments. He has particular interests in Database Internals and Corruption Recovery Techniques as well as applying Powershell and PowerBI to assist in DBA tasks. He is a regular Presenter at SQLSaturday events in Australia, NZ and South-East Asia

Operationalizing Power BI for 20 000 users

Track: Power BI
Length: 75 minutes
Level: 100 (Basic)

Learn how to build a deployment strategy, governance plan and support model for Power BI in large scaled deployments.

Enabling Power BI in a small organization comes with some challenges, but when it comes down to deploying and operationalizing Power BI on a larger scale, it’s not as easy as it seems. Part of the problem is that Power BI bring a new BI delivery model to the table, end user BI and this means that new scenarios need to be looked at.

Join us in this session as we will provide feedback on a real life, large scale, deployment scenario for a financial institution. We will discuss deployment strategy, governance plan and support model.

Luc Labelle

Luc Labelle

Luc has been working in IT for the past 18 years. With over a decade of experience as a consultant, he's been involved in countless SharePoint, Office 365 and more recently Power BI projects. The context of intervention he has worked in has allowed him to recognize how to avoid pitfalls when it comes down to deploying new business applications from both business and technical perspectives. Passionate about IT, he founded his own consulting firm in 2014, Kabesa. Luc is deeply involved in Montreal community and participates as often as possible in the various events, both as organizer and as a speaker. Business Applications MVP, he runs the Montreal Business Applications User Group and has delivered countless of sessions in Canada, the United States and Europe, always presenting on cutting edge Microsoft technology.

Introduction to PowerApps with PowerBI

Track: Power Apps, Power Platform
Length: 75 minutes
Level: 200 (Intermediate)

This session is about two things – it is firstly a thorough introduction about PowerApps, where it came from and where is it going.

And it is also about how the sum is more than the individual parts – when we combine PowerApps and PowerBI we can build some truly amazing more interactive reports & dashboards.

This is a demo heavy session, we want to see and know a few things:

What is a Canvas App and what is a Model-driven App. What can you do out of the box, and when do you need to write the formulas. What is simple to build, and what is complex but still possible to build.

Join John to take a dive to see how you can get started on your PowerApps journey, pick up some useful patterns and build that business app you need – quickly.

John Liu

John Liu

John is a Senior Consultant based in Sydney. He specializes and blogs ( johnliu.net ) frequently on client-side scripting, custom development, workflows and Forms. Originally from a technical background in .NET, he is fluent with both creating custom software from scratch as well as extending out of box capabilities. John is a frequent speaker at Office 365 Conference, O365 Saturday around Australia, and helps to organize the Sydney SharePoint User Group (e.g. consuming all the pizza). John is a dual MVP in both Office Apps and Services (SharePoint) as well as Business Applications (Flow).

How to make everything with Microsoft Flow (Flow Advanced)

Track: Flow, Power Platform
Length: 75 minutes
Level: 300 (Advanced)

Advanced Flow for Power Users and Developers
Microsoft Flow is one of the strangest product from Microsoft. It is workflow, it is automation, it is Serverless Middleware, it orchestrates Azure Functions.

This whole session is demo-heavy – John will demonstrate what we can build today with Microsoft Flow. Flow is a product that everyone, from Power Users to IT Pros to Developers need to understand and hopefully in your toolbelt.

This session we cover the deep technical sides of Flow. What is it, what does it look like under the hood. How do we learn the expressions and why are they necessary.

When you don’t have an action – make your own actions. When you don’t have a trigger, make your own triggers. From patterns, to expressions to insane tricks.

Ultimately, we discover that the true joy of Flow is not workflow, it is pure and simple low-code server execution, they run and do whenever you want them to do.

John Liu

John Liu

John is a Senior Consultant based in Sydney. He specializes and blogs ( johnliu.net ) frequently on client-side scripting, custom development, workflows and Forms. Originally from a technical background in .NET, he is fluent with both creating custom software from scratch as well as extending out of box capabilities. John is a frequent speaker at Office 365 Conference, O365 Saturday around Australia, and helps to organize the Sydney SharePoint User Group (e.g. consuming all the pizza). John is a dual MVP in both Office Apps and Services (SharePoint) as well as Business Applications (Flow).

Using Microsoft ML Server for Data Science

Track: AI
Length: 75 minutes
Level: 200 (Intermediate)

Microsoft’s ML Server can help you overcome in-memory restrictions of R and allows you to build and deploy models that can be used natively in SQL or accessible via a web service. This demo-packed session will take you through the end to end data science process using Microsoft ML Server so that you can see if its right for you.

Steph Locke

Steph Locke

Steph is the founder of a consultancy in the UK. Her talks, blog posts, conferences, and business all have one thing in common they help people get started with data science. Steph holds the Microsoft MVP award for her community contributions. In her spare time, Steph plays board games with her husband and takes copious pictures of her doggos.

AI in the modern Enterprise using Chatbots

Track: AI
Length: 75 minutes
Level: 200 (Intermediate)

An AI-powered chatbot is a smarter version of a conventional chatbot. Intelligence can be added to these chatbots using Cognitive Services LUIS (Language Understanding Intelligent Service) and ML (Machine Learning) to understand the context and intent providing a near human level communication and responses.

In this session we will look at developing an Appointment Booking Bot with Enterprise HR Consultant using Azure Bot Service. The Bot will be integrated with
Azure Active Directory for Authenticating the Employees,
QnA maker to respond to HR related queries,
Graph API to book the appointment on Office 365 Outlook calendar
Using Skype channel for the Bot

This session will cover of an introduction to using Bots in modern Enterprise and focuses more on a hands-on demo.

Anupama Natarajan

Anupama Natarajan

"I am a Software Professional with 15+ years' experience in designing and developing Web, Data Warehouse, Business Intelligence and Mobile solutions. I am a Microsoft Most Valuable Professional (MVP) and Microsoft Certified Trainer (MCT) and passionate in sharing knowledge. I love solving complex business problems for my clients with innovative solutions using Microsoft Technologies and use that experience in my trainings. I do speak at Conferences, User Group sessions and run training sessions on variety of Design and Delivery related topics. I currently organise the SQLSaturday in Wellington and meetups at the Wellington Data Management and Analytics meetup. "

Intro to AI for BI professionals

Track: AI
Length: 75 minutes
Level: 100 (Basic)

As a long time BI and Data professional I recently embarked on a journey to be part of AI revolution. This session is to provide introduction to AI, and the ways in which we can use AI technology to benefit us.

This session is not a deep-dive or comprehensive guide to developing cognitive applications rather we will explore fundamental techniques to achieve AI capabilities. You should think of this session as a chance for you to take a peek behind the AI curtain.

We will start with a use-case and then dissect it to explore how different offerings from Microsoft Cognitive Services such as can be utilised to build a real-world application that can provide such experience.

Ankit Patira

Ankit Patira

Ankit is BI and Data Analytics consultant with several years of experience in traditional BI practices and recently with cloud based, self-service BI, big data and analytics technologies. Ankit is regular presenter at Microsoft BI related meetups and events. He is also one of the 'Super Contributors' of the Power BI Community site.

Dealing with Ugly Data in Excel & Power BI

Track: Power BI
Length: 75 minutes
Level: 200 (Intermediate)

The reality is that you spend 80 to 90 per cent of your time cleaning up data before you can build the analysis that you were really hired to do. In this session you’ll see how Power Query can be used to clean up some very nasty data files. And while it’s often quicker to use these modern tools than the classic versions, the real bonus comes when you apply the logic to next month’s data with just a single click. See how you can get hours of your life back!

This session will cover Unpivoting data, Unpivoting sub-categorized data, Pivoting stacked tables, the power of Joins and other cool tricks.

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.

Fast Lane to Azure SQL Deployments

Track: Azure, Data Platform
Length: 75 minutes
Level: 100 (Basic)

Are you planning to migrate to Azure?
Is the migration as challenging as migration on-premise?
Have you thought of automating the Azure migration?

If you have answered yes to at least one of the questions above, you should come to this session. I will walk you through few approaches and principals when it comes to Azure Data Platform deployments. Not just the applications but deploying the whole infrastructure as code. Gain knowledge of how to build your database infrastructure from the scratch to an end user application with all moving components bundled into a code which is version controlled and deployed as any other application code.

Manohar Punna

Manohar Punna

"Manohar Punna is a Microsoft Data Platform Consultant and a Data Platform MVP. In his day to day job he works on building database and BI systems, automation, building monitoring systems, helping customers to make value from their data & explore and learn. By passion Manohar is a blogger, speaker and Vice President of DataPlatformGeeks. He is a community enthusiast and believes strongly in the concept of giving back to the community. Manohar is a speaker at various Data Platform events from SQL Server Day, various user groups, SQLSaturdays, SQLBits, MS Ignite, SSGAS & DPS. His One DMV a Day series is the longest one day series on any topic related to SQL Server available so far."

I have heard about Power BI Dataflows and Incremental Refreshing, what does this mean?

Track: Power BI
Length: 75 minutes
Level: 200 (Intermediate)

In this session I will outline and explain what the different data options that are now available in Power BI.

This will cover CDS-A (Data pools), Incremental Refreshing and the standard Power BI data option.

I will also explain and demo what these options are, outlining which option is suited for different scenario’s.

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.

Azure Data Studio vs SSMS

Track: Data Platform
Length: 75 minutes
Level: 200 (Intermediate)

Azure Data Studio is the new kid in town for the data professional. Is it a replacement for good old SSMS?

In this session we will take you on a journey of comparing SSMS and Azure Data Studio 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.

Warwick Rudd

Warwick Rudd

Warwick Rudd is a Data Platform MVP, Microsoft Certified Master SQL Server 2008, Founder and Principal Consultant at SQL Master Consulting. With over 15 years of experience beginning with the release of SQL Server 6.5, he has worked in both Australia and England from small start-ups to Multi-National Corporations. Warwick predominantly specialises in designing and implementing HA & DR Solutions. He is a frequent speaker at local SQL Server User Groups & SQL Saturday events, Ignite in Australia and New Zealand. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.

Automate your Daily Database Checks with PowerShell

Track: Data Platform
Length: 75 minutes
Level: 200 (Intermediate)

You spend at least an hour or two every day checking to make sure that your SQL Server databases are compliant with your organization’s best practices. Even if your day starts in chaos trying to resolve other urgent issues, you still need to perform these daily checks. Wouldn’t it be great if you can outsource these checks to someone (or something) who will be more than willing to do these day in and day out?

In this session, learn how you can leverage PowerShell to automate your daily checks to make sure that your SQL Server databases are compliant with your organization’s best practices. You will learn how to create your own automated checks and even display the results in a Power BI dashboard. This allows you to have more time to do things that only you can do.

Edwin M Sarmiento

Edwin M Sarmiento

Edwin M Sarmiento is a Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – “To help people and organizations grow and develop their full potential.

Now you see it, but did you really? Correcting Visual Fallacies…

Track: BI
Length: 75 minutes
Level: 200 (Intermediate)

Humans see images 60,000x better than text but are we always seeing what is being shown? In this talk, we will look at ways a visual designer can intentionally or unintentionally confuse readers by using techniques that are common but not correct. We will discuss topics such as color theory, chart selection and placement among others. Come join us to learn what makes a visualization clear and learn how to convey your story.

Jonathan Stewart

Jonathan Stewart

Jonathan Stewart is a Business Intelligence Consultant specializing in data visualization, data warehousing and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments. Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and business intelligence at numerous SQL Saturday events, local user groups and conferences throughout the United States and around the world. He participates in webcasts, podcasts and online presentation events. He is also an active board member for his local Columbus, Ohio PASS chapter. Jonathan maintains a blog at https://sqllocks.net/. He is a frequent speaker at local, national and international events and is a board member of the Columbus SQL Server User Group. In his free time, Jonathan works with the Mid-Ohio Regional Planning commission to help improve central Ohio and enhance the quality of life of its residents.

SQL Server on Linux and Containers Changes everything for the better!

Track: BI
Length: 75 minutes
Level: 200 (Intermediate)

When Microsoft released SQL Server 2017 it allowed us to run SQL Server on Linux and native Linux containers. This radical change provides a wider and open platform that data professionals can choose how to deploy and run SQL Server.

This session will demonstrate what on SQL Server for Linux is familiar for the data professional and will also highlight some of the differences. We will look at how containers are a game changer for deploying and managing of SQL Server.

The session will also introduce how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server within containers.

DEMOs in this session will show how easy it is to install SQL Server on both Linux and containers and how Infrastructure as Code provides a mechanism to automate the installation of SQL Server, deploy databases and perform integration tests.

This session will show you the exciting future of SQL Server and how you can learn about it today.

Hamish Watson

Hamish Watson

"Hamish is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database & application deployment using DevOps methodologies. He has 19 years IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to end users is his career passion. Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, International speaker and a repeat guest lecturer at a local university."

Embrace and Extend: First-Class Activity and 3rd Party Ecosystem for SSIS in ADF

Track: BI, Azure
Length: 75 minutes
Level: 300 (Advanced)

This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR – dedicated ADF servers for lifting & shifting SSIS packages – and extend it with custom/3rd party components.

You can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice built-in data transformations in your ETL/ELT workflows, automatically provision Azure-SSIS IR just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions and join the growing 3rd party ecosystem for SSIS in ADF.

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 backend and DevOps

Track: Power BI, Azure
Length: 75 minutes
Level: 300 (Advanced)

Power BI is easy to get started with and publish reports and dashboard; this session covers the next steps- how can I build a more robust development & release process ?
– how can I separate test and prod ?
– where do I keep source code ?
– what moving parts in the service do I need to care about ?
…and how do I avoid this becoming a choke-point…

David Lyth

David Lyth

"David is a Premier Field Engineer (PFE) working for Microsoft NZ. He runs workshops covering SQL Server performance tuning and optimisation, high availability configurations, maintenance and management, and Powershell. He also works onsite with customers to analyse and improve the health of their SQL environments, and provide advice on consolidation and modernisation. As well as SQL Server, David supports APS (parallel data warehouse) appliances. Prior to joining Microsoft, David worked for an outsourcing company, supporting large SQL Server installations for a variety of NZ customers. "

Building Data Models with Many to Many Relationships in Power Pivot/Tabular Data Models

Track: Power BI
Length: 75 minutes
Level: 300 (Advanced)

Power Pivot/Tabular data models are built on top of SQL Server Analysis Services Tabular which is optimised for lightning performance as a reporting tool. However one unfortunately side effect of delivering this performance is that SSAS Tabular does not directly support Many to Many relationships like a traditional relational database.

In this 300 level session, I introduce the many to many pattern problem and then demonstrate how to build a data model that supports the pattern using only one to many relationships.

The session covers
Why the 1 to many pattern doesn’t work
How to configure a many to many data model using a pattern that does work

An explanation of how and why the many to many pattern works through a deep analysis of evaluation contexts and context transition.

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

Real-World Query Tuning Examples

Track: Data Platform
Length: 75 minutes
Level: 300 (Advanced)

Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples.

In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes & deal with statistics to improve query performance.

This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.

Amit Bansal

Amit Bansal

Amit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including MS Ignite, SQLBits, SSGAS/DPS, PASS Summit & SQL Saturday events. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal/

Wacky DAX

Track: BI, Azure
Length: 75 minutes
Level: 300 (Advanced)

Did you know that the DAX language is capable of much more than merely producing the SUM of values in a column or counting rows in a table. Join me in this session where I showcase a series of crazy and wacky solutions built in Power BI using just DAX.

These include some games that you wouldn’t believe were written using DAX, as well as some other quirky techniques that take advantage of the underlying analysis services database engine.

Many of the ideas and techniques shown can be used to take your Power BI reports the next level so come and pick up some new approaches to working with data in DAX.

Phil Seamark

Phil Seamark

Phil is Microsoft Data Platform MVP and an experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft B.I. stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. He has 25+ years experience in this field and an active member of Power BI community Phil is passionate about all Microsoft BI technologies including Power BI. He is an active member, and always in the top list of authors in Power BI community. If you have a question, you might find Phil answering you there.

Power BI Custom Visuals: Getting beyond the boilerplate

Track: Power BI
Length: 75 minutes
Level: 300 (Advanced)

Power BI offers an incredibly extensive custom visualisation framework and the world is (almost) your oyster when it comes to what you can do. There’s plenty of great visuals out there already, but what happens when you really want something that just doesn’t seem to be out there and you want to roll your own?

The Power BI team offer some great tools and tutorials for doing this, and our aim of this session is to get beyond the boilerplate tutorial code, learning how to effectively structure and bind your data model, configure settings and apply them to your visual and explore some of the additional APIs Microsoft offer to help you add some extra polish to your vision.

Daniel Marsh-Patrick

Daniel Marsh-Patrick

I've spent 16 years in full-stack development, QA and process engineering. Got bitten by the BI bug around 10 years ago. Doubled-down immediately upon getting introduced to what would eventually become Power BI. I've recently released the Small Multiples Line Chart custom visual to the Power BI marketplace.

Data wrangling with Azure Databricks

Track: AI, Azure
Length: 75 minutes
Level: 300 (Advanced)

In this session we’ll take a look at Azure Databricks and how you can use it to load, transform, and persist your data.

From connecting to storage and data sources (both sink and source), to manipulating and transforming dataframes using Scala, Python, and Spark SQL, and stream processing with Spark Structured Streaming.

We will also explore how to automate your data wrangling jobs using the Azure Databricks scheduled jobs, using Azure Data Factory, and by exporting code and running in a dedicated spark cluster in containers.

Regan Murphy

Regan Murphy

Regan is part of the worldwide Commercial Software Engineering (CSE) team at Microsoft, but based in Auckland, New Zealand. The CSE team has a focus across all development areas, with Regan specialising in Data Platform, including Azure Databricks, and Container technologies. Like the rest of the team Regan loves technology, gadgets, and the promise of new things to come - including #mixedreality and #artificialintelligence. Regan likes beer, craft beer. He also enjoys wine. To offset the beer and wine, he runs. Running is also a nice way to sight-see when travelling.

An All Demo View of new Microsoft’s Power Platform

Track: Power Platform
Length: 75 minutes
Level: 100 (Basic)

While you are probably already familiar with Power BI, PowerApps and Microsoft Flow; you may not know that Microsoft is bringing these tools together into a unified brand called: the Microsoft Power Platform.

In this session Microsoft Senior Program Manager, Charles Sterling will give an all demo introduction to these products AND how you can use these products together with other offerings such as their new database engine called Common Data Service for Apps and Microsoft Forms to create very sophisticated “no code/low code” for citizen developers.

Charles Sterling

Charles Sterling

Charles Sterling is Principal Progam Manager in Power BI Team based in Redmond. He came to Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as the Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

The Art of Data modelling with Azure Analysis Services

Track: BI, Azure
Length: 75 minutes
Level: 300 (Advanced)

Modern data modelling is indeed an art form, and Azure Analysis Services provides a canvas which the data artist (datist) can create beautiful and stunning masterpieces.

This session will not only focus on the critical elements required to ensure your creation is a work of art but also cover aspects of data modelling specific to Azure Analysis Services. The session will include a peek into the future with an update on the road map for Analysis Services in the cloud.

Phil Seamark

Phil Seamark

Phil is Microsoft Data Platform MVP and an experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft B.I. stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. He has 25+ years experience in this field and an active member of Power BI community Phil is passionate about all Microsoft BI technologies including Power BI. He is an active member, and always in the top list of authors in Power BI community. If you have a question, you might find Phil answering you there.

Successfully Virtualizing and Maintaining SQL Server on Vmware vSphere

Track: Data Platform
Length: 75 minutes
Level: 300 (Advanced)

Microsoft SQL server is the most virtualized enterprise mission critical application today. In recent years it has become a mainstream effort among VMware customers to virtualize critical databases to allow better agility and scale while increasing availability and operational efficiency.

In this session we will focus on the configuration of vSphere and SQL server for maximizing the benefits of virtualizing SQL server. The session is aimed at providing VMware customers and partners guidance on how to achieve best performance and efficiency with the latest versions of Microsoft SQL server and VMware vSphere.

Victor Isakov

Victor Isakov

Victor Isakov (MCA, MCM, MCSM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd/Ignite, PASS Summit, IT/Dev Connections and SQL Saturdays. Victor has written a number of books on SQL Server and worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition). He is one of only three non-Microsoft Microsoft Certified Architects in the world.

Story Telling with Power BI Desktop

Track: Power BI
Length: 75 minutes
Level: 200 (Intermediate)

Join us for this all Demo, fun interactive session by Charles Sterling, Senior Program Manager for the Power BI team at Redmond. Learn how to use bookmarks in Power BI to communicate insights in your data.

Be one of the first to learn about and use this newish feature that shipped in last October release of Power BI to tell stories with your data and help your users navigate your dashboards and reports.

Charles Sterling

Charles Sterling

Charles Sterling is Principal Progam Manager in Power BI Team based in Redmond. He came to Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as the Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

Power BI Extensibility: Developers Guide

Track: Power BI, Azure
Length: 75 minutes
Level: 200-300 (Intermediate -Advanced)

Power BI is not just a self-service tool for business analysts. Power BI has many features that help developers build, extend and programmatically manage their own reporting solutions.

Power BI Embedded, Power BI REST and Admin APIs, real-time streaming, secure embedding, customizing user experience with query string parameters, etc… along with powerful analytical engine of Power BI, can help developers take their applications that need to integrate data visualization experiences to the next level.

Come to this session to learn about the features that Power BI provides for developers of all skill levels.

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.

SQL Server 2019

Track: Data Platform

Length: 75 minutes
Level: 200 (Intermediate)

Come for a guided tour of Microsoft SQL Server 2019, now in public preview. See the new advanced analytics and data lake capabilities built into SQL Server, which offers integration with HDFS and Spark analytics.

Easily integrate data from multiple sources, including Oracle, MongoDB, and Teradata, without moving your data via ETL. Learn how enhanced security, performance, scalability, and availability of the SQL Server database engine helps you manage critical applications and data warehouses.

Darmadi Komo

Darmadi Komo

Darmadi Komo has been with Microsoft for over 18 years with extensive career in marketing, consulting, technical pre-sales, and technical partner readiness that spans both US subsidiary, Redmond headquarters, and Asia Pacific regions. Currently, Darmadi is leading Data and AI marketing in APAC and based in Singapore.