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.

Developer [clear filter]
Thursday, December 3
 

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: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

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

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: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: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
 
Wednesday, March 10
 

9:30am 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 →


Wednesday March 10, 2021 9:30am - 10:30am NZDT
Wellington
  Developer
  • Room 1

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 →


Wednesday March 10, 2021 10:45am - 11:45am NZDT
Wellington
  Developer
  • Level 200
  • Room 1

12:00pm 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 →


Wednesday March 10, 2021 12:00pm - 1:00pm NZDT
Wellington
  Developer
  • Room 1

2:00pm 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 →


Wednesday March 10, 2021 2:00pm - 3:00pm NZDT
Wellington
  Developer
  • Room 1

3:30pm NZDT

Enterprise Application Monitoring using Power BI
Enterprise business applications are complex due to the large number of components integrated with the solution. Monitoring these applications present new and interesting challenges to quickly isolate the problem and recommend a fix.
In this session, we will be looking at a real-world example of how to use Power BI from an Enterprise Application monitoring perspective. I will walk you through the different components involved in the application and how to use Power BI to actively monitor them. You will get to learn to leverage your Power BI skills to monitor complex applications at your Enterprise.


Speakers
avatar for Anupama Natarajan

Anupama Natarajan

Data & AI Consultant, MCT, Microsoft AI MVP, Principal Consultant/Director, Pearl Innovations
Anu is a Data, Analytics and AI Consultant with 20+ years of experience working in design and development of Data Warehouse, Business Intelligence, AI enabled applications and SaaS integrated solutions. She is a Microsoft MVP in Artificial Intelligence, Microsoft Certified Trainer... Read More →


Wednesday March 10, 2021 3:30pm - 4:30pm NZDT
Wellington
  Developer
  • Level 300
  • Room 1
 
Monday, March 22
 

9:30am 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 →


Monday March 22, 2021 9:30am - 10:30am NZDT
Christchurch
  Developer
  • Level 300
  • Room 1

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 →


Monday March 22, 2021 10:45am - 11:45am NZDT
Christchurch
  Developer
  • Level 200
  • Room 1

12:00pm 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 →


Monday March 22, 2021 12:00pm - 1:00pm NZDT
Christchurch
  Developer
  • Level 300
  • Room 1

2:00pm 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 →


Monday March 22, 2021 2:00pm - 3:00pm NZDT
Christchurch
  Developer
  • Level 300
  • Room 1

3:15pm NZDT

Enterprise Analytics: Azure Synapse, Data Factory, and Power BI
Cloud technologies have provided many benefits to Data Warehouses. It is easy to scale out workloads in Azure Data Factory v2 and store large amounts of data in Azure Data Lake. With Polybase we are able to make data available to the relational layer from the Lake using external tables. This session will cover how we use Microsoft Master Data Services; the Azure Data Lake; Azure Data Factory v2 and Azure Synapse (SQL Data Warehouse) in our Data Platform at Farmlands Cooperative Society to supply data to our Power BI reports.

Speakers
avatar for Jean Van Schalkwyk

Jean Van Schalkwyk

Business Intelligence Lead, Farmlands Co-operative Society Ltd
Jéan van Schalkwyk is the Business Intelligence Lead at Farmlands Co-operative Society Ltd. Jean has over 16 years’ experience and has expertise in BI and Master Data Management – strategy, architecture, analysis and design specialising in Microsoft’s BI suite of applications... Read More →


Monday March 22, 2021 3:15pm - 4:15pm NZDT
Christchurch
  Developer
  • Level 300
  • Room 2
 


Twitter Feed