Loading…
This event has ended. Visit the official site or create your own event on Sched.
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.

Back To Schedule
Thursday, December 3 • 2:00pm - 3:00pm
Let's explore Power Excel!

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback form is now closed.
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 →

Difinity Power BI Day 2020 Power Excel Owen Auger pdf
Thursday December 3, 2020 2:00pm - 3:00pm NZDT
Auckland
  Developer
  • Level 300
  • Room 4:09 & 4:10

Attendees (5)