Catch up with the latest additions to Power BI desktop and "the Service" with Microsoft MVP and meetup host Wyn Hopkins. Speaker Bio Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book  “Power BI for the Excel Analyst” Based in Perth, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 66,000+ subscribers and the Access Analytic team spend their time delivering Power BI and Excel reporting solutions and training for clients of all industries and sizes.. 4:00 Session Starts with Wyn's presentation 5:00 Close

Writing DAX is easy, writing the correct formula is hard. Understanding the concepts of how DAX works differently to Excel is one of the biggest hurdles to Power BI adoption by the Excel crowd. Having learned DAX initially from Rob Collie's awesome (but now a little outdated) book - "Power Pivot and Power BI" it took me a while to realise that the CALCULATE function is not a superior SUMIFS, and thinking of it that way hindered my understanding of more complicated DAX functions. This session will cover how I explain to people how DAX works. Speaker profile: Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book “Power BI for the Excel Analyst” Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 48,000+ subscribers and Wyn co-hosts the Perth Power BI and Modern Excel meetup group. Once upon a time Wyn was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes. NEW VENUE!!! Microsoft Office Level 10 100 St Georges Terrace Agenda: Wednesday 15th Feb 5:10pm Perth Time • 5:10pm - Welcome (doors open 5.00 ) • 5:15pm - Power BI and Excel News • 5:25pm - Main Session • 6:15pm - Close (a beer afterwards? ) Hope to see you there! Please cancel your spot if you cannot make it The session will not be recorded nor streamed on-line. This is an in-person only event.

We're back! Via Teams. No question too small or too big. No guarantees we'll have an answer! What's on your mind? Send us some questions in advance or save them for the day https://forms.office.com/r/WuH7GAr68H Agenda: Thursday 18th August 5:00pm Perth Time (UTC 9:00am) • 5:00pm - Welcome and virtual meeting housekeeping • 5:05pm - Power BI and Excel News • 5:15pm - Ask us Anything with discussion among participants • 6:00pm - Close Hope to see you there! The session will not be recorded

This session will be delivered live via Teams Melissa De Korte - Automation & Data-analysis at Adamas BV a Diamond tooling company. Power Query in the Trenches: 3 Solutions to a Data Problem Data often needs to be reshaped before it can be used for analysis. And just like there are usually three or more ways to do things in Excel, there are often multiple routes to convert ugly data into the required tabular format. It’s fascinating how many different approaches you can take! In this session, Melissa de Korte will explore three different solutions that can be used to unwind a messy data set using practical problem solving with Power Query/M. Speaker profile: Melissa de Korte is an all-round Power Platform enthusiast and Enterprise DNA Expert. On a mission to share what she's learned, in particular her passion for solving practical problems with Power Query/M.

The term DevOps emerged in the early 2000’s as a way to integrate development and operational software teams. The aim was to break down silos to enable better, faster and more sustainable development. It worked. In this session, we review the core components and drivers of DevOps and look at tools and frameworks that can be used to apply a DevOps approach to Power BI development. There isn’t a one-size fits all way of doing it. You should, however, walk away from this session with some clear, actionable DevOp(tions) for Power BI. Speaker profile Nicholas Schafer is the Data & AI Practice Lead at Velrada where he works with a great team of Data & AI practitioners supporting customers with everything from Data Analytics Platforms to BI Development, Data Engineering and Data Science solutions. Nicholas has held senior data roles at Telstra Purple, Readify and Bankwest and provided data consulting services to a range of major brands including CBA, Schneider Electric, Telstra, UWA, South32 and St John of God Health Services. Agenda : Wednesday 15th March 5:00pm Perth Time AWST (UTC + 😎 • 5:00pm - Welcome and virtual meeting housekeeping • 5:05pm - Power BI and Excel News • 5:10pm - DevOp(tions) for Power BI • 6:00pm - Close Hope to see you there! The session will not be recorded

Please Register VIA Meetup to book your spot https://www.meetup.com/perth-modern-excel-power-bi-user-group/events/293835653/ Bravo for Power BI is an external tool to analyze a model, format DAX, export data, and manage dates table and time intelligence calculation. In this session, we will see how to quickly create a Date table for a Power BI model and how to apply one of the existing templates for time intelligence calculations. We will also take a look at how to create or customize a template to create a company standard for all the tenant users. Speaker Bio Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services. Marco wrote several books about Power BI, Analysis Service, and Power Pivot with Alberto Ferrari. They also regularly write articles and white papers that are available on sqlbi.com.