Table of Contents

• CHAPTER 1 Introduction to data modeling 
• CHAPTER 2 Using header/detail tables 
• CHAPTER 3 Using multiple fact tables 
• CHAPTER 4 Working with date and time 
• CHAPTER 5 Tracking historical attributes 
• CHAPTER 6 Using snapshots 
• CHAPTER 7 Analyzing date and time intervals 
• CHAPTER 8 Many-to-many relationships
• CHAPTER 9 Working with different granularity
• CHAPTER 10 Segmentation data models
• CHAPTER 11 Working with multiple currencies
• APPENDIX A Data modeling 101

About the Author

Alberto Ferrari and Marco Russo are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power Pivot, Power BI, DAX, and SQL Server Analysis Services. Both Ferrari and Russo provide consultancy and mentoring on business intelligence (BI). They are also frequent speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits.