Power BI World Tour 2018 - Melbourne: Full Schedule

08:00 AEST

Registration & Breakfast

Tuesday August 21, 2018 08:00 - 09:00 AEST
Promenade Foyer

Registration, Registration

09:00 AEST

Networking and Introductions

Tuesday August 21, 2018 09:00 - 09:30 AEST
Promenade 1

Networking and Introductions

09:30 AEST

General Session

See live demos presented by local experts and MVPs, and hear from keynote speaker Elaine van Bergen, Senior Program Manager at Microsoft.

Elaine works on the Commercial Software Engineering (CSE) Team working side by side with organisations to address their business problems using cutting edge technology. Formerly a Microsoft MVP and MCM in SharePoint at a leading Microsoft Gold partner, she now works at Microsoft Australia in Melbourne. She is always excited about new technology areas and how they can be used to solve specific business problems.

Tuesday August 21, 2018 09:30 - 10:30 AEST
Promenade 1

General Session, Microsoft Keynote

10:30 AEST

Break

Tuesday August 21, 2018 10:30 - 10:45 AEST
Promenade Foyer

Break

10:45 AEST

Introduction to Power BI

Power BI turned 3 a couple of weeks ago, and unlike most 3 year old’s it’s maturing rapidly.
If you’re new to Power BI, not took a look for a while or are just a bit rusty then this session should help you get up and running pretty fast.
We’ll look at some of the features – big and small - that make Power BI a great tool for anybody to start using straight away.
After one hour you’ll have all the information that you need to produce first class Power BI dashboards & reports and we’ll introduce you to some fabulous resources that you can use to build on the information presented in this session to become even more of a Power BI aficionado.

Speakers

Martin Catherall

Tuesday August 21, 2018 10:45 - 11:45 AEST
Promenade 2

New Business User

10:45 AEST

Why Your Charts Suck and How to Fix Them

Building effective data visualizations is an increasingly important skill. As data professionals the amount of data and the speed at which it is arriving is constantly growing. At the same time our business users are increasingly time poor in a world filled with distractions and shiny things. With social media, instant messaging, conference calls and emails if the message that you are trying to convey is not clear, engaging and easy to understand it will not get the attention that it deserves. Clicking next, next, next, finish on a chart wizard is not the way to build engaging data visualizations. In this presentation we will look at what you need to consider to build clear and engaging data visualizations and what pitfalls you should avoid.

Speakers

Darren Gosbell

Darren Gosbell has been working in the Business Intelligence and data visualiztion field since 1999 with practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Darren has been awarded as a Microsoft MVP... Read More →

Why your charts suck and how to fix them Final pptx

Why your charts suck Demos zip

Tuesday August 21, 2018 10:45 - 11:45 AEST
Promenade 1

Power User

10:45 AEST

Power BI API For Beginners

Do you want to learn more about the Power BI API? Do you want to know how to take advantage of the Power BI API? Do you want to start using the Power BI API but you don’t know where to start? This session is for you.

This session will cover the fundamentals of using the Power BI API. I will cover the different scenarios where the Power BI API is the masterpiece for solving the problem. I will also cover the main characteristics such as creating data sets, types of datasets and streaming real time information with the API.

Speakers

David Alzamendi

Data Analytics & Cloud Consultant, Wardy IT

Tuesday August 21, 2018 10:45 - 11:45 AEST
Promenade 3

Technical

11:45 AEST

Break

Tuesday August 21, 2018 11:45 - 12:00 AEST
Promenade Foyer

Break

12:00 AEST

Partner Solution Showcase: How does Power BI fit into a Modern Data Warehouse? Presented by Wardy IT

A modern data warehouse is the hub for all your data to drive transformative solutions —structured, unstructured, or streaming. In this session you will discover the advantage of the performance, flexibility, and security of a modern data warehouse and how Power BI can accelerate insights from fully managed Azure services such as Azure SQL Data Warehouse and Azure Databricks.

Speakers

Peter Ward

Managing Director, Wardy IT

Tuesday August 21, 2018 12:00 - 12:30 AEST
Promenade 2

Solution Showcase

12:00 AEST

Partner Solution Showcase: Use Automation to Leverage The Cloud Presented by TimeXtender

To help you leverage the cloud, we use automation to remove technical roadblocks that prevent instant access to meaningful data. In this session we will show you how we future-proof your solutions weather the be on-premise, Hybrid, in the cloud. We will show you how we move from On-Premise to the cloud with the click of a button, all while maintaining documentation and security.

Speakers

Soren Sorenson

Director, TimeXtender

Tim Turner

Director, TimeXtender

Tuesday August 21, 2018 12:00 - 12:30 AEST
Promenade 1

Solution Showcase

12:30 AEST

Networking Lunch

Tuesday August 21, 2018 12:30 - 13:30 AEST
Mesh Restaurant

Networking Lunch

13:30 AEST

Data Modelling for Business Professionals

It can be relatively easy to get started using Power BI, however most people quickly discover that there is a lot more to it than first meets the eye. DAX is a functional language that is very similar to the Excel functional language, but before you can properly learn DAX you must first understand the principles of Data Modelling. In this session you will learn the principles of data modelling and how these are all part of the process of extracting value from your data using the DAX language.

Speakers

Matt Allington

Principal Consultant, Excelerator BI Pty Ltd

Matt Allington is a full time professional Power BI Consultant and Trainer with more than 30 years' practical business and IT experience. Matt works primarily with Business people who want to get more out of their data, by providing coaching and mentoring support on their Power BI... Read More →

Tuesday August 21, 2018 13:30 - 14:30 AEST
Promenade 1

New Business User

13:30 AEST

Real-Time Analytics with Power BI

Power BI helps you build appealing visualizations of your data. With the ever-growing footprint of data, it is equally important to get real-time insights into your data. It can be as simple as monitoring a single metric or viewing real-time sales performance across multiple locations. Power BI real-time streaming enables you to stream data and update dashboards in real-time. Any time-sensitive data can be a source of streaming, like IoT sensor devices, social media sources, service usage metrics etc.

In this session: 1. I will dive deep into real-time analytics with Power BI. 2. Show how to build streaming tiles in Power BI Dashboards. 3. Demo using Power BI REST APIs. 4. Demo using Azure Event Hub and Azure Stream Analytics.

Level: 200

Speakers

Manohar Punna

LobsterPot Solutions

Tuesday August 21, 2018 13:30 - 14:30 AEST
Promenade 2

Power User

13:30 AEST

Power Query and M Beyond Limit

Speakers

Reza Rad

Power Query and M Beyond Limits Reza Rad pdf

Tuesday August 21, 2018 13:30 - 14:30 AEST
Promenade 3

Technical

14:30 AEST

Break

Tuesday August 21, 2018 14:30 - 14:45 AEST
Promenade Foyer

Break

14:45 AEST

Introduction to DAX

DAX is the formula language used for aggregating data in Power BI, Power Pivot and Analysis Services Tabular. While there are many similarities between Excel and DAX, there are some crucial differences to understand before you can really leverage the incredible power it has to offer. This session will point out some of those differences and introduce you to the concepts you'll need to kick off your journey to becoming a DAX jedi.

Speakers

André de Lange

Manufacturing Data Manager, Blundstone

André has been working with Power Pivot, Power Query and later Power BI in a consumer goods manufacturing industry for the past four years, developing sales progress reports, manufacturing and materials forecasts and cash flow forecasts. He leads the Hobart Power BI User Group.

Tuesday August 21, 2018 14:45 - 15:45 AEST
Promenade 3

New Business User

14:45 AEST

Predictive Analytics with Power BI and R

Learning from past data to better analyze the future possibilities helps many organizations, companies and service providers. There are several ways to do predictive analysis in Power BI from creating visuals to performing predictive analysis in Powe Query. In this session, an overview of what is predictive analysis, what is the main process of doing prediction, what are the different type of predictions such a classification, regression and forecasting will be explained. Moreover, the custom visuals that can be useful for predictive analysis will be introduced. The process of running a predictive analysis in Power Query will be explained. In addition, how we can forecast the data based on the time series model in Power Query and reporting area will be demonstrated.

Speakers

Leila Etaati

Consultant, RADACAD

Tuesday August 21, 2018 14:45 - 15:45 AEST
Promenade 2

Power User

14:45 AEST

How to Build Your Own Super Model

While you can do some pretty amazing things with DAX expressions, at the end of the day nothing beats having a correctly structured data model. Having the right data model can make everything else a breeze. Having the wrong data model can make result in slow performance, convoluted expressions or potentially even block you from achieving your desired output all together. In this session we will look at the basic theory of building a good data model for Power BI and look at some demos of a few different modelling patterns and how to implement them to solve real world business problems.

Speakers

Darren Gosbell

Build Your Own Super Model Final pptx

Build Your Own Super Model Demos zip

Tuesday August 21, 2018 14:45 - 15:45 AEST
Promenade 1

Technical

15:45 AEST

Break

Tuesday August 21, 2018 15:45 - 16:00 AEST
Promenade Foyer

Break

16:00 AEST

A Business Focus on Visualisation

This session is a demonstration more in terms of walking through a completed working example rather than diving into the technical how-to details.

The example is of a global company operating in Australia and headquartered in the UK. The company's publically available key financials are packaged into simple Power BI storyboard report.

You'll think you're on this company's web site or in thier PowerPoint template - but your not. Power BI's custom visual theme features are at work to replicate branding. Similarly Power BI's bookmarking is used to replicate the same navigation menu styles and function as used on this company's website.

With Power BI you will see meaningful interactive charts showing key business financials but in the normal business visual playbook styling of the web or PowerPoint.

Examine and critique the interactivity of charts with drill-downs and data exploration.

This is for business folk who want to understand what Power BI can really look like in a branded business visual setting. Also a look at ways to select chart types that best communicate financial reports including for Income Statements, Balance Sheet and Cash Flows.

To have this done for your company; chat to me after the session or contact via https://fastlanebi.com

Speakers

David Taylor

Principal Consultant and Owner, FAST LANE BUSINESS INTELLIGENCE

Freelance official Microsoft partner for Power BI creating insightful, business focused and innovative solutions for companies and teams.David is a fellow of the financial services industry association FINSIA, a certified financial modeller in Excel using the FAST standard.If a tree... Read More →

2018 PBI WT DT Visualizations pptx

World Tour Visualisations pbix

Merlin Theme json

key financials xlsx

Share Price Information xlsx

Tuesday August 21, 2018 16:00 - 17:00 AEST
Promenade 1

New Business User

16:00 AEST

Sales Reporting Using DAX

The DAX language is very powerful and can be learnt by any competent Excel user. There are many "out of the box" functions that cover standard sales patterns such as "Sales Year to Date", and "Sales Previous Year", but these only work if you have a standard calendar. This session will look at some common sales patterns using the DAX language as well as ways to report on data that does not use a standard calendar table.

Speakers

Matt Allington

Principal Consultant, Excelerator BI Pty Ltd

Tuesday August 21, 2018 16:00 - 17:00 AEST
Promenade 2

Power User

16:00 AEST

Power BI Performance Tips and Techniques

Power BI gives end users unprecedented business analytics tools to analyze data and share insights. You can easily load and report on a large volume of data. At what price however? Will performance be adequate? Will it scale well as your data volume increases. In this session we will focus on performance in Power BI, especially when working with large volumes of data. We will discuss different techniques of how data can be consumed and in particular focus on Direct Query and how to optimize it’s performance. Make sure you understand the different ways in which you can consume data and how to optimize performance of large data sets.

Speakers

Victor Isakov

Tuesday August 21, 2018 16:00 - 17:00 AEST
Promenade 3

Technical

17:00 AEST

Welcome Reception

Tuesday August 21, 2018 17:00 - 18:00 AEST
Promenade Foyer

Welcome Reception

08:00 AEST

Registration & Breakfast

Wednesday August 22, 2018 08:00 - 09:00 AEST
Crown Melbourne 8 Whiteman St Southbank, VIC 3006

Registration, Registration

09:00 AEST

Practical Power BI - Organising Your Groups, Workspaces, Apps and RLS

Speakers

Greg Nash

Wednesday August 22, 2018 09:00 - 10:00 AEST
Promenade 1

New Business User

09:00 AEST

Enterprise Performance Management With Power BI

Principles of effective information design: best visuals for specific business requirements and common mistakes to avoid
Best practice for building financial models in Power BI
Tips & tricks to build professional finance reports
Variance and other typical calculations required for business users
How to effectively display KPI’s and variances
Options for managing data entry, planning with: PowerApps, Microsoft Flow and Acterys

Speakers

Martin Kratky

Managing Director, Managility

Martin has worked with Power BI from the start, among others developing one of the initial Power BI demo models and has 8 entries in the Power BI Partner Showcase. His key focus areas are best practice methods around financial reporting and planning in Power BI as well as optimal... Read More →

Wednesday August 22, 2018 09:00 - 10:00 AEST
Promenade 2

Power User

09:00 AEST

Power BI For DBAs

Do you need to look after the performance of your databases? Looking for a dashboard that can display the status of your databases? Are you a DBA? This session is for you.

Through this session you will learn how to build Power BI solutions to monitor the performance of your environments keeping it simple and low-cost. We will cover the different options for collecting and displaying the information such as using Power BI Desktop application, Power BI API and Power BI Services for streaming and displaying the information in real time.

Speakers

David Alzamendi

Data Analytics & Cloud Consultant, Wardy IT

Wednesday August 22, 2018 09:00 - 10:00 AEST
Promenade 3

Technical

10:00 AEST

Break

Wednesday August 22, 2018 10:00 - 10:15 AEST
Promenade Foyer

Break

10:15 AEST

Tell Me a Story with Power BI

“There are 2 ways to share knowledge. You can push information out or you can pull them in with a story.” – Quote by unknown 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.

Speakers

Kelly Broekstra

Data Platform Consultant, LobsterPot Solutions

Kelly Broekstra has over fifteen years’ SQL Server database and data warehouse development experience and a passion for understanding a client’s need to create the most fit for purpose solution achievable. Kelly has considerable practice utilising and adapting the Agile principles... Read More →

Wednesday August 22, 2018 10:15 - 11:15 AEST
Promenade 1

New Business User

10:15 AEST

Implementing AI Applications with Power BI

There is a need to embed the AI in the most applications and reports. Power BI is a powerful tool for self-service BI. There are many ways to embed the AI in the Power BI reports. In this session, First, some explanation of what is text analysis and how it can be useful for customer feedbacks analysis will be provided. Then, I will show how to use cognitive services with the aim of text analysis such as sentiment analysis, keyword extraction and topic extraction and so forth. Also, I will show how we can use the model that has been created in some cloud applications such as Azure ML studio into Power BI reports. This session will show you how you can consume the AI model and services into Power BI report and create more smart reports.

Speakers

Leila Etaati

Consultant, RADACAD

Wednesday August 22, 2018 10:15 - 11:15 AEST
Promenade 2

Power User

10:15 AEST

Advanced DAX

Speakers

Reza Rad

Advanced DAX Reza Rad pdf

Wednesday August 22, 2018 10:15 - 11:15 AEST
Promenade 3

Technical

11:15 AEST

Break

Wednesday August 22, 2018 11:15 - 11:30 AEST
Promenade Foyer

Break

11:30 AEST

Partner Solution Showcase: PowerApps and Power BI: More Power for the User Presented by Xello

Interested in unlocking greater potential from your business intelligence initiatives?

PowerApps is a service that allows users to create enterprise apps that run on most Web browsers and operating systems without any coding required. You can use a range of connectors to popular Software as a Service (SaaS) solutions to connect and integrate your data from multiple sources, including Power BI. By embedding PowerApps into your Power BI projects, you can to write your data back to the data source - enabling bidirectional interaction and empowering your business with greater control over your data.

Xello invites you to attend our session to discover the hidden gem of PowerApps working together with Power BI to give you endless possibilities.

Speakers

Graham Fairley

Principal Consultant, Xello

Peter Lillywhite

Director, Xello

Wednesday August 22, 2018 11:30 - 12:00 AEST
Promenade 2

Solution Showcase

11:30 AEST

Partner Solution Showcase: PowerBI at Enterprise Scale Presented by Versor

In this session we will share our best practices for designing and building enterprise scale PowerBI solutions integrating real-time streaming data, big data platforms, relational databases, real-time data science and DataOps for source code and release management.

Speakers

Chris Benson

Practice Lead – Advanced Analytics and Data Platforms, Versor

Wednesday August 22, 2018 11:30 - 12:00 AEST
Promenade 1

Solution Showcase

12:00 AEST

Networking Lunch

Wednesday August 22, 2018 12:00 - 13:00 AEST
Mesh Restaurant

Networking Lunch

13:00 AEST

A 3PL story of Analysis Services for web-based Power BI

My intention is to provide a case study for users that may be considering upgrading their Power BI models into Azure Analysis Services. I will give examples of the challenges faced, and examples of our live project in different stages. I will aslo show examples of writing and deploying measures to the Azure stack and some of the APIs I use to solve these functions. This is targeted to users who may have a need to upgrade their exiting models and real life examples of what to expect and the cost in development time. This case study is centered around the logistics industry and the result of this development is power BI reports embedded into a custom website.

Speakers

Chris Nash

Navia

Wednesday August 22, 2018 13:00 - 14:00 AEST
Promenade 3

New Business User

13:00 AEST

A Business Focus on PowerApps

PowerApps is putting Power Users into the drivers seat on business application development. This session sets the scene and covers implications for business.

What does PowerApps mean in a business context?

Why is citizen development leading to competitive advantage?

Does this disintermediate or empower corporate IT?

What type of PowerApps use cases are possible?

Demo some PowerApps

A final word about the ecosystem and extensibility

Q&A – on cost, timelines, development approaches and wha
t’s new.

Speakers

David Taylor

Principal Consultant and Owner, FAST LANE BUSINESS INTELLIGENCE

Wednesday August 22, 2018 13:00 - 14:00 AEST
Promenade 1

Power User

13:00 AEST

Unleash Row Level Security Patterns in Power BI

Security is different from Sharing, Sharing is about sharing the entire content with others, security is about authorizing different views of the content to others. In this session we go through many different Row Level Security patterns; Static Row Level Security, Dynamic Row Level Security, and many variations of the dynamic RLS, such as giving manager access as well as employee access, you will learn about user profile security scenarios, and hierarchical access levels. This session shows you how DAX and Power BI security comes together to play an important part of a Power BI project lifecycle: Row Level Security.

Speakers

Reza Rad

Unleash Row Level Security Patterns in Power BI Reza Rad pdf

Wednesday August 22, 2018 13:00 - 14:00 AEST
Promenade 2

Technical

14:00 AEST

Break

Wednesday August 22, 2018 14:00 - 14:15 AEST
Promenade Foyer

Break

14:15 AEST

Tips and Tricks with Power BI

Speakers

Greg Nash

Wednesday August 22, 2018 14:15 - 15:15 AEST
Promenade 1

New Business User

14:15 AEST

Want to be a Data Scientist? Here is How to Start

Embedding Data science in Business Intelligence services is a new trend. There is always a question about who is a data scientist and what qualifications people should have to become a data science. In this session, an overview of the main roles and qualification of a data science will be presented, what is the difference between data science, data engineer, statistician and a BI person will be explained. Moreover, an explanation on how to start to learn Machine learning, R or Python will be provided. In addition, an explanation of what is the difference between R and Python as the main language for data science will be presented. Finally, an overview of what possibility we have in Microsoft products with the aim of machine learning and data science will be briefly explained and demonstrated.

Speakers