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 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