Microsoft Excel 2013: Building Data Models with PowerPivot

Chapter 13. Using advanced DAX

Now that you have gotten this far, you have learned many different aspects of DAX, data modeling, and report building, and, in general, you have learned the basics of self-service Business Intelligence (BI). Yes, you read that right: We have been able to teach only the basics up to now. You will need to master many other skills before you can qualify for the Microsoft PowerPivot gurus club. You will learn how to create a good BI solution only with experience: the more scenarios you work on, the more your skills become refined.

This chapter helps you get some of that experience, by virtue of our sharing our experience with you. Here, we analyze several common scenarios and, for each one, we show some useful techniques ...