Practical PowerPivot & DAX Formulas for Excel 2010
Osborne/McGraw-Hill (Verlag)
978-0-07-174685-4 (ISBN)
- Titel z.Zt. nicht lieferbar
- Versandkostenfrei
- Auch auf Rechnung
- Artikel merken
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
250 + ready-to-use, powerful DAX formulasDevelop 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 www.mhprofessional.com/computingdownload
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.
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
| Erscheint lt. Verlag | 16.10.2010 |
|---|---|
| Zusatzinfo | 0 Illustrations |
| Verlagsort | New York |
| Sprache | englisch |
| Maße | 188 x 229 mm |
| Gewicht | 760 g |
| Themenwelt | Informatik ► Office Programme ► Excel |
| ISBN-10 | 0-07-174685-4 / 0071746854 |
| ISBN-13 | 978-0-07-174685-4 / 9780071746854 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
