I'm a studentI'm an educator

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

Price Reduced From: $39.99

Details

  • A print text
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

This product is expected to ship within 3-6 business days for US and 5-10 business days for Canadian customers.

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.

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