What we’re about
This group started in August 2012 with the name New Zealand Business Intelligence and Power BI User Group. This group covers all technical sessions about Microsoft Data, BI, AI, and Power BI technologies, and Microsoft Fabric. We cover topics on data analysis, analytics, and information management. Our session covers introductory to the expert-level audience. We cover technologies below: Fabric Power BI, SSIS, SSAS, SSRS, MDX, Data Mining, Master Data Services, DQS, Azure Data Factory, Azure Machine Learning, Cortana Analytics… Our meetings usually scheduled at least once a month in Microsoft Auckland.
This group is an official Power BI User Group of Microsoft.
This group is part of the Microsoft Power BI User Group Program. Microsoft is not responsible for content on this website or activities that take place at Group meetings.
Topics are included but not limited to:
- Microsoft Fabric
- Power BI, Power Query, DAX, Visualization, Power BI Architecture, Power BI Development, Power BI Administration.
- AI, Machine Learning, Cognitive Services, Azure Machine Learning, Azure Data Bricks, Machine Learning Services.
- Azure SQL Database, Azure SQL Data Warehouse, Azure Data Factory, Azure Analysis Services, Azure Event Hub.
- SQL Server, Database Development, Database Administration, High Availability.
- SSIS, SSAS, SSRS.
- Power Platform: Power Apps, Microsoft Flow
- ...
Sponsors
See all
Microsoft New ZealandMicrosoft New Zealand hosts and provides high quality venue for events.
RADACADRADACAD sponsors our events with hosting and catering.- Microsoft New ZealandMicrosoft New Zealand hosts and provides high quality venue for events.
- RADACADRADACAD sponsors our events with hosting and catering.
- Microsoft New ZealandMicrosoft New Zealand hosts and provides high quality venue for events.
- RADACADRADACAD sponsors our events with hosting and catering.
Upcoming events (1)
See all- Online Only: Exploring window functions and visual calculations by Owen AugerLink visible for attendees
We will have this meeting online-only through Microsoft Teams.
*********************************### Exploring window functions and visual calculations
The first DAX window functions (INDEX, OFFSET, and WINDOW) were introduced in December 2022, soon followed by RANK and ROWNUMBER. Visual calculations were introduced in February 2024. Both of these features are still in preview, but provide a rich set of features to learn and explore. In this session, I will demonstrate how both features can simplify DAX expressions, avoid clutter in your Power BI semantic models, and make your reports more flexible.
I will cover examples including:
Using window functions to:
o Perform calculations “per partition”, such as top customer per group.
o Simplify rank calculations compared with RANKX.
o Calculate ranks based on multiple columns.
o
Using visual calculations to:
o Perform calculations that work with any date field placed on a visual’s axis.
o Filling blanks with zeros (or any other value).
o Identify top/bottom values.
o Normalize measure values.
o Navigate a visual’s hierarchy.
I will provide a demonstration PBIX for you to take away and adapt to your own reporting needs.
If you want to extend your DAX knowledge, simplify your Power BI semantic models, and add some exciting and flexible tools to your Power BI arsenal, then this session is for you!Speaker: Owen Auger
Principal Consultant, Agile Analytics
Owen Auger specialises in data modelling and visualization with Power BI, as well as financial modelling. He is currently a Principal Consultant at Agile Insights and has worked previously in analytics and finance roles at Fonterra and Contact Energy. He was a finalist at the 2014 Financial Modelling World Championships in New York City. He has a particular interest in using Power BI and related tools to improve efficiency of reporting and analysis among finance business users. Owen is a CFA Charterholder and has a Master of Operations Research.Meetup Sponsor:
**RADACAD **is a leading Power BI and Microsoft Fabric training and consulting firm and a Microsoft Gold Partner in Data Analytics. We provide training to upskill, consultation to enhance, and expert development support for Data analytics projects using Microsoft Fabric and Power BI.
We will have this meeting through Microsoft Teams online-only. Do NOT come to the Microsoft Office, no one will be there. See you online.
