Analyzing Data with Power BI and Power Pivot for Excel, 1st edition

Published by Microsoft Press (April 28, 2017) © 2017

  • Alberto Ferrari
  • Marco Russo
Products list
$37.99
Buy nowOpens in a new tab
Sold by InformIT and ebook resellers
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list
$37.99
Buy nowOpens in a new tab
Sold by InformIT and ebook resellers
  • Available for purchase from all major ebook resellers, including InformIT.com

Title overview

Step by step, students will learn how to transform simple tables into full analytical models of immense power. They will master data modeling through a collection of realistic scenarios of increasing sophistication. For each, the authors start with a simple "naïve" model that can't provide robust solutions. Next, they guide readers to update and improve the model, so it can deliver the knowledge and insights they really need.

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

Need help?Get in touch