Toronto PASS


Next Meeting




PASS November Event: Optimizing multi-billion row tables in Tabular

Please join us Toronto local PASS Group event on 13th November, 2019.

What ~ Toronto PASS local event

When ~ Wednesday November 13th, 2019

6:00 Networking with Refreshments and Introduction
6:30 Feature topic: Optimizing multi-billion row tables in Tabular by Alberto Ferrari
8:00 End

Where @ Dimensional Strategies Inc (Innovation Lab), 503-5450 Explorer Dr. Mississauga Ontario L4W 5N1 Canada

Donation: To join the event you are welcome to donate from as little 1 CAD to max you like. This donation will help us to run the events through the year.

Featured Presentation:

Optimizing multi-billion row tables in Tabular

Alberto Ferrari, Consultant Sqlbi

Tabular is the engine used in Analysis Services and Power BI. When your model gets bigger, you need the most sophisticated tools and techniques to obtain the best performance. In this session, we will show how Tabular performs when you are querying a model with many billion rows, we will consider the possible optimizations available leveraging the latest features of the products, and what to do without them.

About Alberto:
Alberto Ferrari started working with SQL Server in 2000 and immediately focused his interest on Business Intelligence. He and Marco Russo created, 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.

Back to Top