Request full copy

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

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

  • Alberto Ferrari
  • Marco Russo

eTextbook

$37.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$31.99

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

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.

  • Why data modeling matters, and how to make the most of it -- step by step
  • All the knowledge you need to transform simple tables into full analytical models: from practical scenarios and examples to advanced patterns
  • By two of the world's leading experts on data analysis with Microsoft technologies

The full text downloaded to your computer

With eBooks you can:

  • search for key concepts, words and phrases
  • make highlights and notes as you study
  • share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access to this eBook.

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

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.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars