Loading…
WHAT IS DIFINITY Power BI DayPower BI Conference
Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand focusing on Data Platform, AI, Business Intelligence, Business Applications, Power Platform, and Analytics. IT Decision Makers, Developers, Business Analysts, IT Professionals, BI Managers, BI Professionals, Database Administrators, Architects, Digital & Big Data business leaders, and Consultants will gather for three consecutive days of learning.
Difinity Power BI Day is a shorter and smaller version of this conference focused only on the Microsoft Power BI topic. There will be two tracks of sessions all in one day from morning to evening. 12 sessions in the day. The event is held in-person in three cities in December 2020 with the COVID-19 considerations.
Like many of you, we have been doing a lot of events online through Teams and Zoom meetings. This event is a chance for us to get together in a safe environment.

Log in to bookmark your favorites and sync them to your phone or calendar.

←View All Dates
Thursday, December 3
 

8:00am NZDT

Registration
Thursday December 3, 2020 8:00am - 8:30am NZDT
Auckland

8:30am NZDT

Welcome note & meet and great
Speakers
avatar for Reza Rad

Reza Rad

CEO, Author, Speaker, Trainer and Consultant, RADACAD Systems Ltd
Reza Rad is author, speaker, trainer and consultant. He is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, Microsoft Data Insight... Read More →
avatar for Leila Etaati

Leila Etaati

Co-Director, Data Scientist, BI Consultant, Trainer and Speaker, RADACAD Systems Ltd
Leila is the First Microsoft AI MVP in New Zealand and Australia. She has a PhD in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft... Read More →


Thursday December 3, 2020 8:30am - 9:00am NZDT
Auckland
  General
  • Room 4:09 & 4:10

9:00am NZDT

Break
Thursday December 3, 2020 9:00am - 9:30am NZDT
Auckland

9:30am NZDT

Getting started with Power BI
This session is for absolute beginners using Power BI. This session is full of demos and explanations of how you can use Power BI to build a dashboard from a data source. You will learn the basics of Power BI implementation through this session.

Speakers
avatar for Aaron Gong

Aaron Gong

Business Intelligence Consultant, RADACAD Systems Limited
Aaron's job is all about helping business transform their data into insights and helping executives make better decision though financial management, improve operational efficiency and better health and risk management. Right now, Aaron works with many SMES in both NZ and AUS that... Read More →



Thursday December 3, 2020 9:30am - 10:30am NZDT
Auckland
  Analyst
  • Level 100
  • Room 4:08

9:30am NZDT

Performance Tuning the Power BI report
Phil Seamark from the Power BI Customer Advisory Team (CAT) works on some of the largest BI models around for the largest companies on the planet.  This session will share some of the latest tips and tricks used by the Power BI C.A.T. to performance tune a Power BI report.

Speakers
avatar for Phil Seamark

Phil Seamark

Principal Program Manager in Power BI CAT team, Microsoft
Phil is a Principal Program Manager in Power BI CAT team. He is 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... Read More →



Thursday December 3, 2020 9:30am - 10:30am NZDT
Auckland
  Developer
  • Level 300
  • Room 4:09 & 4:10

10:30am NZDT

Morning Tea
Thursday December 3, 2020 10:30am - 10:45am NZDT
Auckland

10:45am NZDT

Power BI & Teams: A digital workplace
Power BI is too big for one person. In this session you will see how Teams facilitates collaboration in Power BI:
* Discuss Power BI data within Teams channels and chats
* Comment on Power BI report pages or visualizations and share to Teams
* Embed Power BI reports within Teams channels
* Add the Power BI app to Microsoft Teams

Speakers
avatar for Allison Kennedy

Allison Kennedy

Microsoft Certified Professional and Tutor, ACE
Allison Kennedy is a Microsoft Certified Professional in BI Reporting. An analytical thinker with a passion for teaching, Allison supports business professionals and companies to work smarter, not harder. Extracting valuable insights from multiple data sources, leveraging the power... Read More →



Thursday December 3, 2020 10:45am - 11:45am NZDT
Auckland
  Analyst
  • Level 200
  • Room 4:08

10:45am NZDT

Data preparation and shaping in Power BI using Power Query
Throughout the development of a Power BI solution, you likely spend most of your time (some said about 70% of the overall time) preparing the data, shaping it and getting it in the right, and sometimes merging it before loading it into Power BI. This is a task you can do in the Power BI ecosystem using the Power Query transformation engine. This session will take you through some of the most common scenarios of data transformations with live demos. This session includes tips and tricks that you can use in your everyday Power BI implementations.

Speakers
avatar for Reza Rad

Reza Rad

CEO, Author, Speaker, Trainer and Consultant, RADACAD Systems Ltd
Reza Rad is author, speaker, trainer and consultant. He is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, Microsoft Data Insight... Read More →



Thursday December 3, 2020 10:45am - 11:45am NZDT
Auckland
  Developer
  • Level 200
  • Room 4:09 & 4:10

11:45am NZDT

Break
Thursday December 3, 2020 11:45am - 12:00pm NZDT
Auckland

12:00pm NZDT

AI in Power BI; Taking the analytics to the next level
This session will see what AI options we have inside Power BI from AI visual to AI insight. The audience will see how AI insight helps them analyze their text and connect to their available machine learning models inside Azure ML. They will also get familiar with the newest AI visual: smart narrative to key influencers QnA visual inside Power BI Desktop. 

Speakers
avatar for Leila Etaati

Leila Etaati

Co-Director, Data Scientist, BI Consultant, Trainer and Speaker, RADACAD Systems Ltd
Leila is the First Microsoft AI MVP in New Zealand and Australia. She has a PhD in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft... Read More →



Thursday December 3, 2020 12:00pm - 1:00pm NZDT
Auckland
  Analyst
  • Level 300
  • Room 4:08

12:00pm NZDT

DAX and Calculations in Power BI
If you have ever found yourself scratching your head over a DAX calculation in Power BI, this may be the session for you.
Phil Seamark, member of Power BI CAT and author of two books on DAX, will share his insights and experience on the fundamentals to focus on to help you leap up the learning curve and improve your all-round DAX skills.

Speakers
avatar for Phil Seamark

Phil Seamark

Principal Program Manager in Power BI CAT team, Microsoft
Phil is a Principal Program Manager in Power BI CAT team. He is 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... Read More →



Thursday December 3, 2020 12:00pm - 1:00pm NZDT
Auckland
  Developer
  • Room 4:09 & 4:10

1:00pm NZDT

Lunch
Thursday December 3, 2020 1:00pm - 2:00pm NZDT
Auckland

2:00pm NZDT

Visualization best practices for Power BI
Building a visualization is not a task that you spend just the last five minutes implementing it. It would be best if you worked on having impactful visualization. A visualization that tells stories can be much more powerful than just a list of numbers in a matrix. In this session, you will learn about good visualization principles and how to implement them in Power BI. The learnings of this session are practical and can be used right after the session.

Speakers
avatar for Indira Bandari

Indira Bandari

Business Intelligence & SQL Lead, Clanwilliam Health (Asia-Pacific)
Indira is a Business Intelligence Consultant and an aspiring Data Scientist with over 15 years of experience in designing and developing data warehouses and analytical solutions. She has been awarded is a Microsoft Data Platform MVP in New Zealand. She has a Masters degree in Statistics... Read More →



Thursday December 3, 2020 2:00pm - 3:00pm NZDT
Auckland
  Analyst
  • Room 4:08

2:00pm NZDT

Let's explore Power Excel!
Description:
Many of the self-service BI features we know and love in Power BI made their first appearance as add-ins for Microsoft Excel, in the form of Power Pivot and Power Query. These features live on in the latest versions of Excel, and are valuable tools for anyone who works with data in Excel. This session is for anyone who is curious about what "Power Excel" has to offer.
In this session I will build a "Power Excel" report using Power Query and Power Pivot, and compare with a similar report in Power BI, while demonstrating:
•Key differences between Power BI and Excel's Power Query & Power Pivot
•Excel-specific features, including PivotTables, cube functions and named sets
•Visualization options in Excel
•How to import from Excel to Power BI

Speakers
avatar for Owen Auger

Owen Auger

Data Analytics Manager, Fonterra
Owen Auger specialises in data analytics with Power BI with a focus on financial applications. He is currently a Data Analytics Manager at Fonterra in Auckland, and has previously worked in Corporate Finance at Contact Energy. He was a finalist at the 2014 Financial Modelling World... Read More →



Thursday December 3, 2020 2:00pm - 3:00pm NZDT
Auckland
  Developer
  • Level 300
  • Room 4:09 & 4:10

3:00pm NZDT

Afternoon Tea
Thursday December 3, 2020 3:00pm - 3:15pm NZDT
Auckland

3:15pm NZDT

Building Power BI Custom Visuals
This session will see what amazing visuals you can create with Charticulator from customized Bullet Chart and Ribbon chart to create a custom visual map style chart that you can import images. The audience gets familiar with the data axis and how it works, creating a spiral chart from their simple bar chart and other exciting visuals.

Speakers
avatar for Leila Etaati

Leila Etaati

Co-Director, Data Scientist, BI Consultant, Trainer and Speaker, RADACAD Systems Ltd
Leila is the First Microsoft AI MVP in New Zealand and Australia. She has a PhD in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft... Read More →



Thursday December 3, 2020 3:15pm - 4:15pm NZDT
Auckland
  Analyst
  • Level 300
  • Room 4:08

3:15pm NZDT

Enterprise Analytics: API data analysis using Azure and Power BI
An increasing number of my clients are leveraging data from sensors that give them a greater insight to what is happening or needs to happen in their organisations. This could be from wind speed and temperature from weather stations, flow rates and levels from rivers or foot falls from a retail outlet. Many of these solutions are provided by third parties who make the information available in proprietary dashboards.
But what if you want to use (almost) real time information in Power BI alongside other business information or analyse current information against historical trends?
Third party information is often available via an API call, which is great if you have the ability inhouse to utilise it programmatically. However, if you do not have the developers to do that then utilising Azure services and Power BI provides a solution.
Technology:
•Azure Data Factory
•Azure Stream Analytics
•Azure Storage Account
oBlob Storage
oAzure Data Lake Store
•Power BI

Speakers
avatar for Jack Horlock

Jack Horlock

Associate Consultant, Decisive NZ
Jack Horlock is an independent consultant based in the rural north of New Zealand. Now into his fifth decade of witnessing changes in technology he has had a varied career including the development and design of business and information systems and the management of customers, suppliers... Read More →



Thursday December 3, 2020 3:15pm - 4:15pm NZDT
Auckland
  Developer
  • Level 300
  • Room 4:09 & 4:10

4:15pm NZDT

Break
Thursday December 3, 2020 4:15pm - 4:45pm NZDT
Auckland

4:45pm NZDT

Sharing methods and licensing in Power BI
So you built a Power BI report and want to share it with others. However, you realized that there are many different ways of sharing the report; you can use simple sharing, share in a workspace, use apps, or through Teams or SharePoint. For every one of these methods, the licensing can also be different. There is a premium option, and also an embedded and per-user licensing. This session is clarifying everything for you. The licensing and sharing in the world of Power BI won’t be a mystery for you anymore, and you would be able to decide the best option for your solution.

Speakers
avatar for Indira Bandari

Indira Bandari

Business Intelligence & SQL Lead, Clanwilliam Health (Asia-Pacific)
Indira is a Business Intelligence Consultant and an aspiring Data Scientist with over 15 years of experience in designing and developing data warehouses and analytical solutions. She has been awarded is a Microsoft Data Platform MVP in New Zealand. She has a Masters degree in Statistics... Read More →



Thursday December 3, 2020 4:45pm - 5:45pm NZDT
Auckland
  Analyst
  • Level 200
  • Room 4:08

4:45pm NZDT

Architecture and governance for a successful Power BI implementation
Starting to build a Power BI solution is easy, but adopting it successfully in an organization can be challenging. There are many elements to think about to make sure you have enough governance and enough self-service power. There are connection types and layers of the architecture that need to be considered. The culture and the training of the users and many other aspects are critical parts of adopting Power BI successfully in an organization. Reza will take you through many of these aspects with advice on what to do in this session.

Speakers
avatar for Reza Rad

Reza Rad

CEO, Author, Speaker, Trainer and Consultant, RADACAD Systems Ltd
Reza Rad is author, speaker, trainer and consultant. He is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, Microsoft Data Insight... Read More →



Thursday December 3, 2020 4:45pm - 5:45pm NZDT
Auckland
  Developer
  • Room 4:09 & 4:10

5:45pm NZDT

Networking Event
Thursday December 3, 2020 5:45pm - 6:45pm NZDT
Auckland
 


Twitter Feed