We Need Diverse Ya Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | June 22, 2015

    Stephen Jarvis: IMG Robert Seymour — 13 Pictures



    1. Self-Portrait. My new novel, Death and Mr. Pickwick, tells the story of the origins of Charles Dickens's first novel, The Pickwick Papers. Its... Continue »
    1. $21.00 Sale Hardcover add to wish list

      Death and Mr. Pickwick

      Stephen Jarvis 9780374139667

    spacer
Qualifying orders ship free.
$42.00
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Practical Powerpivot & Dax Formulas for Excel 2010

by

Practical Powerpivot & Dax Formulas for Excel 2010 Cover

 

Synopses & Reviews

Publisher Comments:

Extract actionable BI using Excel 2010 PowerPivot and DAX language

Featuring 200 ready-to-use DAX queries, Practical PowerPivot and DAX Queries for Excel 2010 shows Office and Excel power users how to take advantage of DAX (Data Analysis Expressions)the new standard language for extracting BI within Excel. An entire section shows how to create tables, pivot tables, and PowerPivot tables in Excel. You can then progress to writing DAX queries and formulas to harness the power of BI.

This solutions-based guide contains more than 200 DAX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

  • Query: Introduction and description of query and its use
  • Syntax: Complete DAX syntax
  • Result: Screen shot showing the data returned in an Excel 2010 pivot table
  • Analysis: Analysis of the results and tips for customization

Practical PowerPivot and DAX Queries for Excel 2010

  • Includes 200+ ready-to-use, easily customizable DAX queries, all available for download
  • Features a practical and hands-on approach with a minimum of difficult concepts and theory
  • Explains how to visualize actionable BI
  • Helps to dramatically improve analysis and decision-making skills

Complete coverage of Excel 2010 PowerPivot and DAX

PowerPivot Fundamentals; Instant Business Intelligence; PowerPivot: Overview; PowerPivot: Details; DAX: Overview - Calculated Columns and Measures; Visualization - Manipulating Pivot Tables and Charts; DAX Formulas - Extending PowerPivot; Fundamental Functions; Aggregate Functions; Date and Time Functions; Date and Time Intelligence Functions; Text Functions; Math Functions; After You Finish; How to Write SQL Queries for PowerPivot; How to Write MDX Queries for PowerPivot; How to Write DMX Queries for PowerPivot - Using SSAS Data Mining Data

Book News Annotation:

Beginning with a foreword by Thierry D'hers, one of the lead designers of this new Microsoft Business Intelligence software, this work provides definitive instruction in the basic use of PowerPivot and the companion scripting language DAX. This software allows business users to access enterprise level, company wide information sources from their desktop installations of the Excel spreadsheet application without the help of their IT department yet within a controlled and connected data pool. The first half of this guide is a reference that describes each of the capabilities of the plug-in within the Excel environment with a screen shot and step-by-step instructions. The second section provides over 250 DAX formulas for extracting specific types of data and reports from the PivotPoint/Excel environment. DAX formulas as well as sample Excel data used in this work are available online. Tennick is an expert in database design and Microsoft's SQL server. Annotation ©2011 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

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 and 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

About the Author

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.

Table of Contents

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 and Time Functions 1/2: Basic Functions; Chapter 9. Date and Time Functions 2/2: Time Intelligence Functions; Chapter 10. Text Functions; Chapter 11. Math and 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

Product Details

ISBN:
9780071746854
Author:
Tennick, Art
Publisher:
McGraw-Hill/Osborne Media
Author:
Tennick Art
Subject:
Database Management - General
Subject:
Enterprise Applications - Business Intelligence
Subject:
Certification Guides - General
Subject:
Practical PowerPivot, DAX Queries, Excel 2010, Art Tennick, fundamentals, overview, details, calculated columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business intelligence, text, math, SQL Quer
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Technical Skills
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Practical, PowerPivot, DAX, Queries, Excel, 2010, Art Tennick, fundamentals, book, guide, how to, overview, details, calculated, columns, measures, visualization, tables, charts, manipulating, formulas, extending, functions, date, time, business, intellig
Subject:
Database design
Copyright:
Publication Date:
September 2010
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Pages:
464
Dimensions:
9.00x7.40x.92 in. 1.67 lbs.

Related Subjects

Computers and Internet » Computers Reference » Enterprise Applications » Business Intelligence Tools
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Design
Computers and Internet » Networking » General
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Health and Medicine » General
Health and Self-Help » Health and Medicine » General Medicine

Practical Powerpivot & Dax Formulas for Excel 2010 New Trade Paper
0 stars - 0 reviews
$42.00 In Stock
Product details 464 pages McGraw-Hill/Osborne Media - English 9780071746854 Reviews:
"Synopsis" by ,

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 and 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

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.