Analyzing Data with Power Bi and Power Pivot for Excel: Business Skills

Autor Marco Russo, Alberto Ferrari
en Limba Engleză Paperback – 28 oct 2016
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 "naive" 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."
Citește tot Restrânge

Din seria Business Skills

Preț: 16945 lei

Preț vechi: 21182 lei

Puncte Express: 254

Preț estimativ în valută:
3242 3503$ 2778£

Carte disponibilă

Livrare economică 13-27 martie
Livrare express 28 februarie-05 martie pentru 2595 lei

Preluare comenzi: 021 569.72.76


ISBN-13: 9781509302765
ISBN-10: 150930276X
Pagini: 320
Dimensiuni: 187 x 229 x 16 mm
Greutate: 0.45 kg
Editura: Microsoft Press
Seria Business Skills

Notă biografică

Alberto Ferrari and Marco Russo are the founders of, 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.


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