Next Meeting

Next Meeting: Tue, Sep 20 2016

Toronto SQL Server & Data Platform w/Marco Russo DAX & Power BI

It's time to get back to talking about SQL Server and Data Platform

Our first meeting of the season as a special location since we couldn't book our usual room.  The good news is it's conveniently located in the TD Tower, so lots of subway options to get you there. We will have limited space here, so get your RSVP in ASAP. 

The second great news is that we have a fantastic presenter scheduled.

You must be registered (RSVP here) to participate in the pizza and prize draws.

Introduction to DAX in Power BI

DAX is the language to enrich the data models in Power BI. You can create measures, calculated columns, and calculated tables. In this sessions, you will learn the difference between them, and the syntax you use in DAX to create simple formulas for common scenario, such as: 

• Analysis by range of prices (1-10, 11-20, 21-30, …) 

• How to pass a calculation parameter using a slicer

• Year-over-year calculation 

• Comparison between budget and sales at different granularities

As you will see, you can use measures to overcome certain (apparent) limitations of Power BI, creating richer reports over your data.

Marco Russo 
Business Intelligence consultant, SQLBI 

Marco Russo is a consultant and trainer in Business Intelligence. He is a founder of SQLBI (, which provides mentoring and consulting on Business Intelligence based on Microsoft technologies. Marco has several Microsoft certifications including SSAS Maestro, MCDBA, MCSD, MCSA and MCAD, and is also an MVP and a former MCT. He wrote several books about Analysis Services, Power Pivot, Power BI, and DAX, for Microsoft Press. He is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLBits. 


5:30 - 6:00 PM Pizza and Networking

6:00 - 6:15 PM Updates and Announcements

6:15 - 8:15 PM Presentation(s)

8:15 - 8:30 PM Wrap-up and prize draw


UTC : Tue, Sep 20 2016 21:30 - 00:30
Event Time : Tue, Sep 20 2016 17:30 - 20:30 Eastern Daylight Time
Your Local Time: Tue, Sep 20 2016 21:30 - 00:30

Featured Presentation

DAX & Power BI with Marco Russo

Speaker: Marco Russo, Consultant SQLBI

Summary: See registration website for more info.

About Marco: Marco is a Business Intelligence consultant and mentor. He worked with Analysis Services since 1999, and wrote several books about Power Pivot, Power BI, Analysis Services Tabular, and the DAX language. With Alberto Ferrari, he writes the content published on, mentoring companies’ users about the new Microsoft BI technologies. Marco is also a speaker at international conferences such as Microsoft Data Insights, PASS Summit, Microsoft Ignite, and SQLBits.

Please ensure you pre-register for our meetings. Registration allows you to participate in our awesome drawings and helps us plan for the meetings.