Fórmulas DAX para PowerPivot: Una guía simple hacia la revolución de Excel (Spanish Edition)

4.35 avg rating
( 71 ratings by Goodreads )
 
9781615470297: Fórmulas DAX para PowerPivot: Una guía simple hacia la revolución de Excel (Spanish Edition)
View all copies of this ISBN edition:
 
 

Microsoft PowerPivot es un complemento gratuito para Excel de Microsoft que permite a los usuarios producir nuevos tipos de informes y análisis que simplemente eran imposibles antes, y este libro es el primero en abordar fórmulas DAX, la capacidad central de PowerPivot, desde la perspectiva de la audiencia de Excel. Escrito por el principal blogger a nivel mundial y practicante de la herramienta, los conceptos y el enfoque del libro se introducen de una manera paso a paso sencilla adaptada al estilo de aprendizaje de los usuarios de Excel en todas partes. Las técnicas que se presentan permiten a los usuarios producir, en horas o incluso minutos, resultados que anteriormente habrían tenido equipos enteros semanas o meses para producir e incluir lecciones sobre la diferencia entre las columnas y medidas calculadas, cómo fórmulas pueden ser reutilizadas a través de informes de totalmente diferentes formas , cómo combinar conjuntos disjuntos de datos en informes unificados, cómo hacer que ciertas columnas en un pivote se comporten como si el pivote estuviese filtrado mientras otras columnas no, y cómo crear cálculos de tiempo inteligentes en las tablas dinámicas como "Año a Año" y "Medias Móviles" si utilizan un calendario estándar, fiscal o un calendario personalizado. Las técnicas de "tipo-patrón" y las mejores prácticas contenidas en este libro se han desarrollado y perfeccionado a lo largo de dos años de entrenamiento en sitio con los usuarios de Excel de todo el mundo, y las lecciones clave de los seminarios que cuestan miles de dólares por día ya están disponibles dentro de las páginas de esta fácil de seguir guía.

 

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce and include lessons on the difference between calculated columns and measures, how formulas can be reused across reports of completely different shapes, how to merge disjointed sets of data into unified reports, how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not, and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide.

"synopsis" may belong to another edition of this title.

About the Author:

Rob Collie is a former engineering leader at Microsoft, where he helped develop PowerPivot during his 14-year career with the company. He is the former chief technology officer at Pivotstream LLC and is the creator of PowerPivotPro.com, the world’s leading PowerPivot website. He regularly consults and trains businesses and individuals on making the most of PowerPivot. He lives in Cleveland Heights, Ohio. Miguel Escobar is a consultant and expert on business intelligence, PowerPivot, Excel, Power View, and SharePoint.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Collie, Rob
ISBN 10: 1615470298 ISBN 13: 9781615470297
New Quantity Available: 5
Seller:
GreatBookPrices
(Columbia, MD, U.S.A.)

Book Description Condition: New. Seller Inventory # 20153172-n

More information about this seller | Contact this seller

Buy New
US$ 27.64
Convert currency

Add to Basket

Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

2.

Rob Collie, Miguel Escobar (translator)
Published by Holy Macro! Books 2014-07-29, Uniontown (2014)
ISBN 10: 1615470298 ISBN 13: 9781615470297
New paperback Quantity Available: 1
Seller:
Blackwell's
(Oxford, OX, United Kingdom)

Book Description Holy Macro! Books 2014-07-29, Uniontown, 2014. paperback. Condition: New. Seller Inventory # 9781615470297

More information about this seller | Contact this seller

Buy New
US$ 24.24
Convert currency

Add to Basket

Shipping: US$ 6.18
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Collie, Rob
Published by Holy Macro! Books (2014)
ISBN 10: 1615470298 ISBN 13: 9781615470297
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)

Book Description Holy Macro! Books, 2014. Condition: New. book. Seller Inventory # M1615470298

More information about this seller | Contact this seller

Buy New
US$ 25.99
Convert currency

Add to Basket

Shipping: US$ 4.78
Within U.S.A.
Destination, rates & speeds

4.

Rob Collie
Published by Holy Macro! Books
ISBN 10: 1615470298 ISBN 13: 9781615470297
New Paperback / softback Quantity Available: 3
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)

Book Description Holy Macro! Books. Paperback / softback. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9781615470297

More information about this seller | Contact this seller

Buy New
US$ 30.56
Convert currency

Add to Basket

Shipping: US$ 13.57
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Collie, Rob
ISBN 10: 1615470298 ISBN 13: 9781615470297
New Quantity Available: 1
Seller:
GreatBookPricesUK
(Castle Donington, DERBY, United Kingdom)

Book Description Condition: New. Seller Inventory # 20153172-n

More information about this seller | Contact this seller

Buy New
US$ 30.55
Convert currency

Add to Basket

Shipping: US$ 18.59
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Rob Collie
Published by Holy Macro! Books (2014)
ISBN 10: 1615470298 ISBN 13: 9781615470297
New Quantity Available: 3
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)

Book Description Holy Macro! Books, 2014. PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # GZ-9781615470297

More information about this seller | Contact this seller

Buy New
US$ 23.93
Convert currency

Add to Basket

Shipping: US$ 37.18
From United Kingdom to U.S.A.
Destination, rates & speeds

7.

Collie, Rob/ Escobar, Miguel (Translator)
Published by Holy Macro Books (2014)
ISBN 10: 1615470298 ISBN 13: 9781615470297
New Paperback Quantity Available: 1
Seller:
Revaluation Books
(Exeter, United Kingdom)

Book Description Holy Macro Books, 2014. Paperback. Condition: Brand New. 250 pages. Spanish language. 12.00x9.00x0.50 inches. In Stock. Seller Inventory # zk1615470298

More information about this seller | Contact this seller

Buy New
US$ 29.84
Convert currency

Add to Basket

Shipping: US$ 37.18
From United Kingdom to U.S.A.
Destination, rates & speeds