+612 9045 4394
 
CHECKOUT
Analyzing Data with Microsoft Power BI and Power Pivot for Excel : Business Skills - Alberto Ferrari

Analyzing Data with Microsoft Power BI and Power Pivot for Excel

Business Skills

By: Alberto Ferrari (Contribution by), Marco Russo (Contribution by)

Paperback Published: 17th April 2017
ISBN: 9781509302765
Number Of Pages: 256

Share This Book:
In Stock
Enter an Australian post code for delivery estimate

To get the right insights from your data, you need to model it right. From Power BI to Power Pivot for Excel, Microsoft offers extremely powerful and accessible tools for modeling data. Now, for the first time, there's a complete guide to building exceptionally effective models using Microsoft's tools. World-renowned Microsoft data analytics experts Marco Russo and Alberto Ferrari introduce all the data modeling theory you'll need, and show how to apply it in the context of Microsoft's current and evolving products.

Step by step, you'll learn how to transform simple tables into full analytical models of immense power. You'll 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 you to update and improve the model, so it can deliver the knowledge and insights you really need.

About the Author

Alberto Ferrari is a consultant, trainer and software developer in the Business Intelligence field. He has particular competence and experience of BI solutions in sectors like financial services, manufacturing, commercial distribution and TV broadcasts. He works as a mentor for several software houses who need to implement complex BI solutions.

Alberto is one of the authors of the SQLBI Methodology and of the books "Expert Cube Development with Microsoft SQL Server 2008 Analysis Services" . He is currently writing a book about PowerPivot that will be soon published by Microsoft Press.

  • 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

ISBN: 9781509302765
ISBN-10: 150930276X
Series: Business Skills
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 256
Published: 17th April 2017
Publisher: Microsoft Press,U.S.
Country of Publication: US
Dimensions (cm): 22.9 x 18.8  x 1.3
Weight (kg): 0.41
Edition Number: 1