Season Kickoff - Marco Russo on Power BI and Data

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.

To help Marco budget his time, could you please complete these 2 poll questions: https://www.meetup.com/Toronto-SQL-Server-User-Group/polls/

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 (www.sqlbi.com), 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.
http://www.sqlbi.com/articles/author/marco-russo/

Agenda

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