Build Analytics Models with Excel Power Pivot

This session will cover building models in PowerPivot, the semantic layer of Power BI. It will include examples from both dimensional and non-dimensional models, along with limitations, workarounds and best practices. You will also learn how to incorporate images and other types of content. The session will include a basic introduction of the Data Analysis Expressions Language (DAX) and cover some of the most common expressions that are used in data models.

• Brian Gogle

  1 Recording

  Brian Gogle is the Practice Area Lead for the Enterprise Data Manage Practice in Dallas, leading a team of data architecture and integration consultants. Prior to consulting, he was Vice President of Information Services at Mosaic, leading a forty person team in designing a Microsoft BI solution accessed by over 100 retailers and retail manufacturers. He has over 15 years of Business Intelligence experience.

• SQL Saturday 127 Recordings

• Power Pivot 2 Recordings