Loading…
Monday, November 6
 

08:30

Registration and Breakfast
Grab a bite and your badge as you meet with other attendees before the sessions kick off!

Monday November 6, 2017 08:30 - 09:00
Microsoft Sydney Office 1 Epping Road North Ryde, NSW 2113

09:00

Networking Activity & Introduction
Welcome to the PUG World Tour! Let's get to know each other.

Speakers
avatar for Onika Allen

Onika Allen

Business Manager, Dynamic Communities
As a former Chapter Director, I have a strong passion for building communities from the ground up to support the local regions with education and networking. Talk to me about starting a user group, joining an existing one, leadership opportunities, and partnering with PUG.
avatar for Matt Allington

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 →



Monday November 6, 2017 09:00 - 09:30
Federation/Kingsford Smith/Trugeranner

09:30

General Session: What's New and Exciting in Power BI
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.

Speakers
avatar for Amanda Cofsky

Amanda Cofsky

Program Manager, Microsoft
Amanda is a program manager for the Power BI Desktop team. Her main focus is on enabling analysts to create beautiful and insightful visualizations. You may also know her from the Power BI blogs, which can be found at https://powerbi.microsoft.com/en-us/blog/author/amac/. She is also... Read More →


Monday November 6, 2017 09:30 - 10:30
Federation/Kingsford Smith/Trugeranner

10:45

Super Charge Power BI and What is new with Analysis Services
Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session introduces Azure Analysis Services as a fully-managed platform as a service (PaaS) in Azure. We will discuss where Analysis Services fits into Microsoft’s BI platform and strategy, reference architectures and cloud efficiencies. Modeling and analytics features covered by the last two compatibility levels will be reviewed and demonstrated, including Power Query connectivity, object-level security, and Detail Rows for non-technical users to drill through to transactional records.

Speakers
avatar for Darren Gosbell

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 →



Monday November 6, 2017 10:45 - 11:45
Kingsford Smith

10:45

From Excel to Power BI
Everyone has used Excel, but despite this, many people still find it hard to get started with Power BI.  This session will show you how to get started with Power BI so you can take your Excel worksheets to the next level.  This is an absolute beginner lesson where I cover tips and tricks to get started using Power BI from the mind set of an Excel user.  I explain the differences between the tools and how you should approach using Power BI compared to Excel.

Speakers
avatar for Matt Allington

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 →



Monday November 6, 2017 10:45 - 11:45
Federation

10:45

Power BI - Dynamic Row Level Security Simplified
In this session I will first give an overview of what Row Level Security is. Then I am going to demonstrate how easy it can be to implement Dynamic Row Level security. I will achieve this by showing how to leverage AD Groups, simplified security mapping table and Power BI Desktop and Power BI Service configuration of Row Level Security. It will be an live demo, where I will step through each process to show how easy this process can be, so that the people in the audience will be able to implement this within their own organisation.

Speakers


Monday November 6, 2017 10:45 - 11:45
Trugeranner

11:45

Lunch with Peers
Enjoy lunch while connecting with other Power BI Users!

Monday November 6, 2017 11:45 - 13:00
Microsoft Sydney Office 1 Epping Road North Ryde, NSW 2113

13:00

Governance and Enterprise Deployment Strategy
Whether you're planning an enterprise-wide reporting deployment or providing structure to self-service BI activities within teams, Power BI has you covered. Learn about tools for developing, publishing, and managing your BI assets. We cover the data gateway, managing report lifecycle, publishing options, administration and governance controls, and end-user capabilities across devices and platforms.

Speakers
avatar for Iman Eftekhari

Iman Eftekhari

Director, AgileBI



Monday November 6, 2017 13:00 - 14:00
Kingsford Smith

13:00

Data Modeling 101
In this session, we will start with some high-level data modelling theory and apply the techniques to create a powerful model that conforms data from multiple sources to create a seamless single version of the truth.



Speakers
avatar for Matt Allington

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 →



Monday November 6, 2017 13:00 - 14:00
Federation

13:00

Endless Possibilities: R and power BI
R integration with Power BI provides more flexibility for users. People able to have more visualizations which not exist currently in Power BI such as: normal distribution chart, column width chart, facet chart plot, Plotly chart (interactive chart in R) and so forth. Moreover, writing R scripts inside power query and Power BI Visualization enable users to do machine learning using R cods. In this session, first I will show how to create some interesting charts using ggplot package inside Power BI. Then, I will show how to do Machine Learning inside Power query by following machine learning process: data gathering, data cleaning, feature selection, model creation, data sampling and finally prediction. I will show how to do predictive analysis using KNN algorithm. Moreover, a short explanation about KNN algorithms concepts will be provided.

Speakers

Codes pdf

Monday November 6, 2017 13:00 - 14:00
Trugeranner

14:15

Creating Enterprise Grade BI Offerings with Azure Analysis Services
Analysis Services enables consistent data across reports and users of Power BI. This session will focus on optimizing configurations, management automation, governance, sizing considerations and best practices. Various modeling enhancements will be included such as Detail Rows allowing users to easily see transactional records, deployment and application-lifecycle management (ALM) features to bridge the gap between self-service and corporate BI.

Speakers
avatar for Darren Gosbell

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 →



Monday November 6, 2017 14:15 - 15:15
Kingsford Smith

14:15

Take Power BI Visualization to the Next Level
Data Visualization is the front end of every BI system, and getting it right is one of the most important tasks in a BI application. Good visualization will benefit the decision making process, while bad visualization can lead to wrong decisions. In this session, you will learn how to create the right chart or visual, with examples ranging from line charts, bar/column charts, and some other useful chart styles in Power BI. You will also learn some tips and tricks to control interactivity of visuals in Power BI. Session is full of demos, and through that you will learn tips and tricks for choosing best colors and best visuals for your solution.

Speakers
avatar for Reza Rad

Reza Rad

Consultant, RADACAD Systems Limited
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data... Read More →



Monday November 6, 2017 14:15 - 15:15
Federation

14:15

Data Management will be Critical for High Performing Businesses of all Sizes
More and more data is being generated by businesses of all sizes. IDC research suggests that data doubles every two years and will reach 40 trillion gigabytes by 2020. With this amount of data comes great opportunity, but also potential issues. It is important that businesses of all sizes consider their approach to data management. Not just how they capture and analyze it, but how they manage (integrate, model, etc.) and govern it to ensure it is accurate, secure and accessible. Join this session to find out what you should be considering in terms of the best-practice approaches to managing data to ensure you seize the opportunity it presents and negate the potential issues it can create.

Speakers
avatar for Bill Wass

Bill Wass

General Manager, ZAP
Managing the Data 'fire hydrant' without the need for large IT teams Gaining insights and outcomes around the businesses rich data


Monday November 6, 2017 14:15 - 15:15
Trugeranner

15:30

15:30

From Concept to Dashboard in 5 Days - A Customer Story
Power BI - We all know what it is, how it works and why we should be using it but how many of us have actually made the transition from tinkering with colourful visualisations to rolling out a functional dashboard used by people across the organisation? In this session, MVP Peter Ward will explain how Tasmania’s leading insurance provider, RACT, did just this. Peter will detail the steps RACT took and how a single dashboard has empowered staff to make data-driven decisions.

Speakers
avatar for Peter Ward

Peter Ward

Managing Director, WARDY IT Solutions
Peter Ward is an entrepreneur, investor and technology start-up mentor. Peter is a proud Queenslander who has successfully grown several technology investments that have been listed in the Deloitte Australia’s Technology Fast 50. Peter has been awarded the Pearcey Award for entrepreneurial... Read More →


Monday November 6, 2017 15:30 - 16:30
Federation

15:30

Real-Time Streaming in Power BI
Speakers
avatar for Sergio  Zenatti Filho

Sergio Zenatti Filho

National Data and Analytics Architect, Velrada
Sergio Zenatti is a Cloud Data & Analytics Solution Architect at Velrada with over 15 years experience in the delivery of Business Intelligence and Analytics Solutions.



Monday November 6, 2017 15:30 - 16:30
Trugeranner

16:30

Networking Reception
After a great day of educational sessions, what better way to unwind than to join fellow attendees in networking and socializing over some drinks and appetizers.

Monday November 6, 2017 16:30 - 18:00
Microsoft Sydney Office 1 Epping Road North Ryde, NSW 2113
 
Tuesday, November 7
 

08:00

Networking Breakfast
Share experiences and notes from the first day with your peers over breakfast

Tuesday November 7, 2017 08:00 - 08:30
Microsoft Sydney Office 1 Epping Road North Ryde, NSW 2113

08:30

Intro to DAX
In this breakout session, you'll learn the basics of the DAX language, Power BI’s modelling language. We will introduce you to the concept of evaluation contexts, and how they impact calculated columns and measures, with some practical examples that you will reproduce on your machine. This introduction will cover basic calculations and an overview of the most common scalar and table functions.

Speakers
avatar for Reza Rad

Reza Rad

Consultant, RADACAD Systems Limited
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data... Read More →



Tuesday November 7, 2017 08:30 - 09:30
Federation

08:30

Dig in to Map Visualizations
Speakers
avatar for Peter O'Gorman

Peter O'Gorman

AI Sydney


Tuesday November 7, 2017 08:30 - 09:30
Kingsford Smith

08:30

Power BI Gateways as a Solution
There are number of blog posts, technical deep dive(s) and how-to articles on Power BI desktop and service but very few on Gateways for Power BI. Gateways form major part of Power BI enterprise deployment and so in this introductory session we will go through ways of managing, configuring and administering Gateways for Power BI within an organisation. We will also discuss real-world scenarios for the application of Gateways and how you can benefit from Gateways being in different job functions.

Speakers
avatar for Ankit Patira

Ankit Patira

BI | Data | Analytics | Cloud | Architect


Tuesday November 7, 2017 08:30 - 09:30
Trugeranner

09:45

Member Showcase: Managing a Conservation Business with Power BI
Bush Heritage Australia is a national not-for-profit conservation organisation. We have very limited resources available to manage our business, and have long struggled to get good management insight across all the different parts of our organisation. Power BI has changed all that - big time! We can now extract data from the systems supporting our core business processes - conservation management, fundraising management, financial management and people management - to provide integrated management dashboards that are helping us to make key management decisions - such as how our projects are tracking, and whether we are achieving the expected impact. In this short presentation we will show how, with a bit of help from a Power BI consultant, two people with no prior knowledge of Power BI have been able to revolutionise our management reporting.

Speakers
avatar for Liz Hackett

Liz Hackett

Key Relationships Database Officer, Bush Heritage Australia
I joined Bush Heritage 8 years ago after 10 years with a major IT company in Digital Media. I help manage our CRM (Blackbaud) database for our major gifts and bequest teams, but also work on database configuration and reporting. This lead to an interest in PowerBI and lead to me... Read More →
avatar for Mike Honey

Mike Honey

Tech Lead, Manga Solutions
Data Integration & Visualisation Consultant, specialising in Power BI.
avatar for Annette Stewart

Annette Stewart

Conservation Systems Specialist, Bush Heritage Australia
I work for Bush Heritage Australia, a conservation organisation committed to protecting Australia's plants and animals. My role involves setting up and supporting the processes and systems used by our people to do their conservation work. We are using Power BI to collate and... Read More →



Tuesday November 7, 2017 09:45 - 10:45
Federation

09:45

A look at Power BI Embedded
This session will provide an overview of Power BI Embedded and share a real-life example of how one company evaluated and implemented it. 

Speakers
avatar for Christian Eriksen

Christian Eriksen

Co-Founder and Director, Investment Control Systems
We help simplify the business and data management of investment organisations by introducing a single source of truth via our cloud-based Investment Control platform. Power BI Embedded has been incorporated into our platform, enabling our clients to build visualisations and BI reports... Read More →
avatar for Reza Rad

Reza Rad

Consultant, RADACAD Systems Limited
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data... Read More →



Tuesday November 7, 2017 09:45 - 10:45
Kingsford Smith

09:45

PowerQuery the data import Swiss Army Knife
In this session, you will get to see why PowerQuery deserves to have Power in its name. It will first explore how to create custom functions in M so that they can be stored and used in other projects. It will then introduce recursion in M; what is it, why would you want to do it and how to do it efficiently. Lastly, the session will demonstrate how PowerQuery, using R, can perform advanced data cleansing when you have pesky missing values.

Speakers
avatar for Daniil Maslyuk

Daniil Maslyuk

Consultant, Analytics8
Power BI, advanced DAX, advanced M
avatar for Kale Temple

Kale Temple

Data Scientist, AgileBI
Kale Temple is a Data Scientist with over 3 years experience in delivering data science and business intelligence projects. He has helped a range of clients, from government to financial services, realise the value that can be created from advanced analytics using Microsoft technologies... Read More →



Tuesday November 7, 2017 09:45 - 10:45
Trugeranner

11:00

11:00

Advanced Power Query
Speakers
avatar for Reza Rad

Reza Rad

Consultant, RADACAD Systems Limited
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data... Read More →



Tuesday November 7, 2017 11:00 - 12:00
Kingsford Smith

11:00

Advanced DAX
A walk through of lessons picked up while learning DAX. This will cover tips and tricks on multi-field joins, group by aggregations and other techniques that will be useful for the SQL Pro.

Speakers
avatar for Phil Seamark

Phil Seamark

Senior Business Intelligence Architect, MVP, Trade Me


Tuesday November 7, 2017 11:00 - 12:00
Trugeranner

12:00

Lunch and Learn: 5 New Features in 30 Minutes presented by Wardy IT
Grab your lunch and take a seat in a breakout room to listen in to one of the sponsor lunch and learns. Presentations will begin at 12:30

Since the first release two years ago, Power BI has transformed drastically from a simple collection of Excel-based add-ins to a comprehensive suite of business analytics tools. With weekly and monthly releases, it can be hard to keep on top of what’s new, and why it matters to you. In this session, MVP Peter Ward will showcase 5 of the latest, most useful features with practical examples – explaining what they are, how they can be used and how they can help you take your dashboarding skills to the next level.



Speakers
avatar for Peter Ward

Peter Ward

Managing Director, WARDY IT Solutions
Peter Ward is an entrepreneur, investor and technology start-up mentor. Peter is a proud Queenslander who has successfully grown several technology investments that have been listed in the Deloitte Australia’s Technology Fast 50. Peter has been awarded the Pearcey Award for entrepreneurial... Read More →


Tuesday November 7, 2017 12:00 - 13:00
Federation

12:00

Lunch and Learn: Get Even More from Power BI with ZAP’s Automated Data Management
Grab your lunch and take a seat in a breakout room to listen in to one of the sponsor lunch and learns. Presentations will begin at 12:30. Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.

Speakers
avatar for Akos Gyori

Akos Gyori

Pre-sales Consultant, ZAP
avatar for Bill Wass

Bill Wass

General Manager, ZAP
Managing the Data 'fire hydrant' without the need for large IT teams Gaining insights and outcomes around the businesses rich data


Tuesday November 7, 2017 12:00 - 13:00
Kingsford Smith

12:00

Lunch and Learn: TimeXtender - The combined strength of Discovery Hub® and Power BI
Grab your lunch and take a seat in a breakout room to listen in to one of the sponsor lunch and learns. Presentations will begin at 12:30

Learn about a new approach to business intelligence which brings together the best of both worlds: governance and self-service. Discovery Hub® leverages the power of automation and makes it easy to access, model and govern data. See how easily we do all the tricky things such as incremental loading, Slowly changing dimensions, Documentation, Version control, development environments, machine learning execution optimisation, tracing and lineage… and of course integration into Power BI

Speakers
avatar for Tim Turner

Tim Turner

Director, TimeXtender


Tuesday November 7, 2017 12:00 - 13:00
Trugeranner

13:15

To BI or Not to BI

New to Power BI? Are you the Power BI superhero tasked with moving the organization or team to a functioning Power BI environment? You have some of data and direction…now what?

In this session we discuss the key first steps and important considerations for building your Power BI business model. 

Help you prepare for a data-driven environment. Partner with and balance the concerns of data stewards with the needs of business key stakeholders to develop a common path forward.


Speakers


Tuesday November 7, 2017 13:15 - 14:15
Federation

13:15

Deep Dive into the Latest Desktop Enhancements
Speakers
avatar for Amanda Cofsky

Amanda Cofsky

Program Manager, Microsoft
Amanda is a program manager for the Power BI Desktop team. Her main focus is on enabling analysts to create beautiful and insightful visualizations. You may also know her from the Power BI blogs, which can be found at https://powerbi.microsoft.com/en-us/blog/author/amac/. She is also... Read More →


Tuesday November 7, 2017 13:15 - 14:15
Kingsford Smith

13:15

PowerApps and Flow
In today's fast paced world, putting data quickly at the business analyst's fingertips is more important than ever. With the increased integration points between PowerApps and Power BI, you can now better enable business decisions. Learn how to use Power BI, PowerApps and Microsoft Flow to create and customize your very own business applications that utilize Power BI real time data.

Speakers
avatar for Boris Kravtsov

Boris Kravtsov

Technology Solutions Professional - Advanced Analytics & AI at Microsoft, Microsoft
avatar for Fred lecul

Fred lecul

Data and AI Technology Specialist, Microsoft


Tuesday November 7, 2017 13:15 - 14:15
Trugeranner

14:30

Use What You Learned
If today was a whirlwind of new Power BI knowledge, this session is for you. During the session, we will learn to apply the concepts and methodologies of Power BI, such as visuals, into your real business scenarios to ensure that you walk away from Power BI Thursday with a sound understanding of how Power BI can work for you.

Speakers
avatar for Mike Honey

Mike Honey

Tech Lead, Manga Solutions
Data Integration & Visualisation Consultant, specialising in Power BI.
avatar for Mary Law

Mary Law

Advanced Analytics, AI & Big Data Professional, Microsoft
avatar for Ankit Patira

Ankit Patira

BI | Data | Analytics | Cloud | Architect



Tuesday November 7, 2017 14:30 - 16:00
Federation

14:30

Certification Prep Session
Ready yourself for Microsoft Exam 778 with this preparatory readiness class that will include a review of exam coverage, vital ways to prepare and additional details.

Speakers
avatar for Peter O'Gorman

Peter O'Gorman

AI Sydney


Tuesday November 7, 2017 14:30 - 16:00
Kingsford Smith

14:30

Ask the Experts
During this session ask the Microsoft team, MVPs, and Industry Experts the questions that you didn't get answered during the regular sessions. This session is always jam packed with information and tidbits from the brightest and the best.

Speakers
avatar for Amanda Cofsky

Amanda Cofsky

Program Manager, Microsoft
Amanda is a program manager for the Power BI Desktop team. Her main focus is on enabling analysts to create beautiful and insightful visualizations. You may also know her from the Power BI blogs, which can be found at https://powerbi.microsoft.com/en-us/blog/author/amac/. She is also... Read More →
avatar for Phil Seamark

Phil Seamark

Senior Business Intelligence Architect, MVP, Trade Me


Tuesday November 7, 2017 14:30 - 16:00
Trugeranner