Practical Powerpivot & DAX Formulas for Excel 2010

Tennick, Art

Valutazione media 3,5
( su 12 valutazioni fornite da GoodReads )

250 + ready-to-use, powerful DAX formulas

Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide.

• Build pivot tables and charts with PowerPivot for Excel
• Import information from Access, Excel, data feeds, SQL Server, and other sources
• Organize and format BI reports using the PowerPivot Field List
• Write DAX formulas that filter, sort, average, and denormalize data
• Construct complex DAX formulas from statistical, math, and date functions
• Compare current and past performance using date and time intelligence
• Handle non-additive numbers, non-numeric values, and running totals
• Develop complete self-service and sharable BI solutions in a few minutes

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

L'autore:

Art Tennick has worked in relational database design and SQL queries for more than 20 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Art is the author of Practical MDX Queries for Microsoft SQL Server Analysis Services 2008. His website is www.MrCube.net.

Contenuti:

Part I: PowerPivot; Chapter 1. PowerPivot: Quick Start; Chapter 2. PowerPivot: Overview; Chapter 3. PowerPivot: In-Depth; Chapter 4. DAX: Overview; Chapter 5. Pivot Tables and Pivot Charts: Overview; Part II: DAX; Chapter 6. Fundamental Functions: Filter, Logical, and Miscellaneous Functions; Chapter 7. Aggregate Functions: Statistical Functions and SUM()/SUMX() Functions; Chapter 8. Date & Time Functions 1/2: Basic Functions; Chapter 9. Date & Time Functions 2/2: Time Intelligence Functions; Chapter 10. Text Functions; Chapter 11. Math & Trig Functions; Part III: PowerPivot and DAX Applied; Chapter 12. A Few Ideas: PowerPivot and DAX Solutions; Part IV: Appendixes: Queries for PowerPivot; Appendix A. SQL Queries for PowerPivot; Appendix B. MDX Queries for PowerPivot; Appendix C. DMX Queries for PowerPivot; Index

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Compra nuovo Guarda l'articolo
EUR 15,65

Spese di spedizione: EUR 10,00
Da: India a: U.S.A.

Destinazione, tempi e costi

Aggiungere al carrello

I migliori risultati di ricerca su AbeBooks

Edizione Internazionale

1.Practical PowerPivot & DAX Formulas for Excel 2010

ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Soft cover Quantità: > 20
Edizione Internazionale
Da
University Bookstore
(DELHI, DELHI, India)
Valutazione libreria

Descrizione libro 2010. Soft cover. Condizione libro: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Codice libro della libreria UN-TM-IN-338

Compra nuovo
EUR 15,65
Convertire valuta
Spese di spedizione: EUR 10,00
Da: India a: U.S.A.
Destinazione, tempi e costi

2.Practical PowerPivot & DAX Formulas for Excel 2010

ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Quantità: 1
Da
Cherry_Books
(Missouri City, TX, U.S.A.)
Valutazione libreria

Descrizione libro Condizione libro: New. Brand New Book. Codice libro della libreria 0071746854SRB

Compra nuovo
EUR 25,90
Convertire valuta
Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

3.Practical PowerPivot and DAX Formulas for Excel 2010 (Paperback)

Editore: McGraw-Hill Education - Europe, United States (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Paperback Quantità: 10
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria

Descrizione libro McGraw-Hill Education - Europe, United States, 2010. Paperback. Condizione libro: New. 226 x 183 mm. Language: English . Brand New Book. This title provides 250+ ready-to-use, powerful DAX formulas. Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide. Build pivot tables and charts with PowerPivot for Excel. Import information from Access, Excel, data feeds, SQL Server, and other sources. Organize and format BI reports using the PowerPivot Field List. Write DAX formulas that filter, sort, average, and denormalize data. Construct complex DAX formulas from statistical, math, and date functions. Compare current and past performance using date and time intelligence. Handle non-additive numbers, non-numeric values, and running totals. Develop complete self-service and sharable BI solutions in a few minutes Download the source code from our associated website. Codice libro della libreria AA39780071746854

Compra nuovo
EUR 28,04
Convertire valuta
Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

4.Practical PowerPivot and DAX Formulas for Excel 2010 (Paperback)

Editore: McGraw-Hill Education - Europe, United States (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Paperback Quantità: 10
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria

Descrizione libro McGraw-Hill Education - Europe, United States, 2010. Paperback. Condizione libro: New. 226 x 183 mm. Language: English . Brand New Book. This title provides 250+ ready-to-use, powerful DAX formulas. Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide. Build pivot tables and charts with PowerPivot for Excel. Import information from Access, Excel, data feeds, SQL Server, and other sources. Organize and format BI reports using the PowerPivot Field List. Write DAX formulas that filter, sort, average, and denormalize data. Construct complex DAX formulas from statistical, math, and date functions. Compare current and past performance using date and time intelligence. Handle non-additive numbers, non-numeric values, and running totals. Develop complete self-service and sharable BI solutions in a few minutes Download the source code from our associated website. Codice libro della libreria AA39780071746854

Compra nuovo
EUR 28,11
Convertire valuta
Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

5.Practical PowerPivot and DAX Formulas for Excel 2010

Editore: McGraw-Hill Education (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Quantità: > 20
Da
PBShop
(Wood Dale, IL, U.S.A.)
Valutazione libreria

Descrizione libro McGraw-Hill Education, 2010. PAP. Condizione libro: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Codice libro della libreria IB-9780071746854

Compra nuovo
EUR 24,82
Convertire valuta
Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

6.Practical PowerPivot and DAX Formulas for Excel 2010

Editore: McGraw-Hill Education (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Quantità: 17
Da
Books2Anywhere
(Fairford, GLOS, Regno Unito)
Valutazione libreria

Descrizione libro McGraw-Hill Education, 2010. PAP. Condizione libro: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Codice libro della libreria CM-9780071746854

Compra nuovo
EUR 19,67
Convertire valuta
Spese di spedizione: EUR 10,40
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.Practical PowerPivot & DAX Formulas for Excel 2010

Editore: McGraw-Hill Education (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Paperback Quantità: 20
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria

Descrizione libro McGraw-Hill Education, 2010. Paperback. Condizione libro: New. Codice libro della libreria 0071746854

Compra nuovo
EUR 28,75
Convertire valuta
Spese di spedizione: EUR 2,77
In U.S.A.
Destinazione, tempi e costi

8.Practical PowerPivot & DAX Formulas for Excel 2010

Editore: McGraw-Hill Education
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi PAPERBACK Quantità: > 20
Da
Movie Mars
(Indian Trail, NC, U.S.A.)
Valutazione libreria

Descrizione libro McGraw-Hill Education. PAPERBACK. Condizione libro: New. 0071746854 Brand New Book. Ships from the United States. 30 Day Satisfaction Guarantee!. Codice libro della libreria 14190062

Compra nuovo
EUR 27,85
Convertire valuta
Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

9.Practical Powerpivot Dax Formulas for Excel 2010

Editore: McGraw-Hill/Osborne Media
ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Paperback Quantità: 20
Da
(Las Vegas, NV, U.S.A.)
Valutazione libreria

Compra nuovo
EUR 29,08
Convertire valuta
Spese di spedizione: EUR 3,66
In U.S.A.
Destinazione, tempi e costi

10.Practical PowerPivot and DAX Formulas for Excel 2010 (Paperback)

ISBN 10: 0071746854 ISBN 13: 9780071746854
Nuovi Paperback Quantità: 1
Da
Grand Eagle Retail
(Wilmington, DE, U.S.A.)
Valutazione libreria

Descrizione libro 2010. Paperback. Condizione libro: New. 188mm x 228mm x 22mm. Paperback. This title provides 250+ ready-to-use, powerful DAX formulas. Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with he.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 464 pages. 0.760. Codice libro della libreria 9780071746854

Compra nuovo
EUR 33,20
Convertire valuta
Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi