Join our Microsoft Power BI – UK User Group for our webinar in association with Onyx Data (onyxdata.co.uk). This session we are excited to announce our host Leon Gordon will be introducing Microsoft MVP Alberto Ferrari.

Join the Microsoft Power BI UK – User Group on –

Microsoft Community – https://community.powerbi.com/t5/Power-BI-UK-User-Group/gh-p/pbi_UK_usergroup
LinkedIn – https://www.linkedin.com/groups/8909321/
MeetUp – https://www.meetup.com/microsoft-power-bi-uk

Session Abstract

By using calculation groups in Power BI and Analysis Services, you can apply transformations to existing DAX measures without creating new measures in the model. For example, you can define the year-over-year calculation once, and apply it to all the measures you want. Yet, calculation groups can do more than that.

This session introduces the syntax of calculation groups, when they should be used, and several examples of use cases. You also learn how calculation groups work internally and what are the limits of this fantastic tool.

Biography

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.

Today, Alberto’s main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.

Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.Outside of SQLBI, most of Alberto’s personal time is spent practicing video games, in the vain hope of eventually beating his son.