DAX Formulas for PowerPivot: the Excel Pro's Guide to Mastering DAX.
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
Chicago
Holy Macro! Books
2013
|
Schlagworte: | |
Online-Zugang: | Volltext |
Beschreibung: | Cover; Copyright; Table of Contents; Acknowledgements; A Note on Hyperlinks; Introduction; 1- A Revolution Built on YOU; 2- What Version of PowerPivot Should You Use?; 3- Learning PowerPivot "The Excel Way"; 4- Loading Data Into PowerPivot; 5- Intro to Calculated Columns; 6- Introduction to DAX Measures; 7- The "Golden Rules" of DAX Measures; 8- CALCULATE() -- Your New Favorite Function; 9- ALL() -- The "Remove a Filter" Function; 10- Thinking in Multiple Tables; 11- "Intermission" -- Taking Stock of Your New Powers; 12- Disconnected Tables 13- Introducing the FILTER() Function, and Disconnected Tables Continued14- Introduction to Time Intelligence; 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun; 16- SUMX() and Other X ("Iterator") Functions; 17- Multiple Data Tables; 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER(); 19- Performance: How to keep things running fast; 20- Advanced Calculated Columns; 21- The Final Transformation: One Click That Will Change Your Life Forever; A1- Further Proof That the Game is Changing; A2- So Much Power, So Little Space: Further Capabilities A3- Four Common Error MessagesA4- Supporting Workbooks and Data Sets; A5- People: The Most Powerful Feature of PowerPivot; Index 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 |
Beschreibung: | 1 Online-Ressource (256 pages) |
ISBN: | 9781615472123 1615472126 9781615473328 1615473327 |
Internformat
MARC
LEADER | 00000nmm a2200000zc 4500 | ||
---|---|---|---|
001 | BV042964857 | ||
003 | DE-604 | ||
005 | 00000000000000.0 | ||
007 | cr|uuu---uuuuu | ||
008 | 151030s2013 |||| o||u| ||||||eng d | ||
020 | |a 9781615472123 |c electronic bk. |9 978-1-61547-212-3 | ||
020 | |a 1615472126 |c electronic bk. |9 1-61547-212-6 | ||
020 | |a 9781615473328 |c electronic bk. |9 978-1-61547-332-8 | ||
020 | |a 1615473327 |c electronic bk. |9 1-61547-332-7 | ||
035 | |a (OCoLC)818851430 | ||
035 | |a (DE-599)BVBBV042964857 | ||
040 | |a DE-604 |b ger |e aacr | ||
041 | 0 | |a eng | |
082 | 0 | |a 005.54 | |
100 | 1 | |a Collie, Rob |e Verfasser |4 aut | |
245 | 1 | 0 | |a DAX Formulas for PowerPivot |b the Excel Pro's Guide to Mastering DAX. |
264 | 1 | |a Chicago |b Holy Macro! Books |c 2013 | |
300 | |a 1 Online-Ressource (256 pages) | ||
336 | |b txt |2 rdacontent | ||
337 | |b c |2 rdamedia | ||
338 | |b cr |2 rdacarrier | ||
500 | |a Cover; Copyright; Table of Contents; Acknowledgements; A Note on Hyperlinks; Introduction; 1- A Revolution Built on YOU; 2- What Version of PowerPivot Should You Use?; 3- Learning PowerPivot "The Excel Way"; 4- Loading Data Into PowerPivot; 5- Intro to Calculated Columns; 6- Introduction to DAX Measures; 7- The "Golden Rules" of DAX Measures; 8- CALCULATE() -- Your New Favorite Function; 9- ALL() -- The "Remove a Filter" Function; 10- Thinking in Multiple Tables; 11- "Intermission" -- Taking Stock of Your New Powers; 12- Disconnected Tables | ||
500 | |a 13- Introducing the FILTER() Function, and Disconnected Tables Continued14- Introduction to Time Intelligence; 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun; 16- SUMX() and Other X ("Iterator") Functions; 17- Multiple Data Tables; 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER(); 19- Performance: How to keep things running fast; 20- Advanced Calculated Columns; 21- The Final Transformation: One Click That Will Change Your Life Forever; A1- Further Proof That the Game is Changing; A2- So Much Power, So Little Space: Further Capabilities | ||
500 | |a A3- Four Common Error MessagesA4- Supporting Workbooks and Data Sets; A5- People: The Most Powerful Feature of PowerPivot; Index | ||
500 | |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 | ||
630 | 0 | 4 | |a Microsoft Excel (Computer file) |
650 | 4 | |a Microsoft Excel (Computer file) | |
650 | 7 | |a COMPUTERS / Desktop Applications / Spreadsheets |2 bisacsh | |
650 | 4 | |a Wirtschaft | |
650 | 4 | |a Business |x Computer programs | |
650 | 4 | |a Business intelligence |x Computer programs | |
856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=502675 |x Aggregator |3 Volltext |
912 | |a ZDB-4-EBU | ||
940 | 1 | |q FLA_PDA_EBU | |
999 | |a oai:aleph.bib-bvb.de:BVB01-028390725 |
Datensatz im Suchindex
_version_ | 1804175289655230464 |
---|---|
any_adam_object | |
author | Collie, Rob |
author_facet | Collie, Rob |
author_role | aut |
author_sort | Collie, Rob |
author_variant | r c rc |
building | Verbundindex |
bvnumber | BV042964857 |
collection | ZDB-4-EBU |
ctrlnum | (OCoLC)818851430 (DE-599)BVBBV042964857 |
dewey-full | 005.54 |
dewey-hundreds | 000 - Computer science, information, general works |
dewey-ones | 005 - Computer programming, programs, data, security |
dewey-raw | 005.54 |
dewey-search | 005.54 |
dewey-sort | 15.54 |
dewey-tens | 000 - Computer science, information, general works |
discipline | Informatik |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03284nmm a2200445zc 4500</leader><controlfield tag="001">BV042964857</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151030s2013 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615472123</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-61547-212-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1615472126</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-61547-212-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615473328</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-61547-332-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1615473327</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-61547-332-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)818851430</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042964857</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Collie, Rob</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">DAX Formulas for PowerPivot</subfield><subfield code="b">the Excel Pro's Guide to Mastering DAX.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Chicago</subfield><subfield code="b">Holy Macro! Books</subfield><subfield code="c">2013</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (256 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Cover; Copyright; Table of Contents; Acknowledgements; A Note on Hyperlinks; Introduction; 1- A Revolution Built on YOU; 2- What Version of PowerPivot Should You Use?; 3- Learning PowerPivot "The Excel Way"; 4- Loading Data Into PowerPivot; 5- Intro to Calculated Columns; 6- Introduction to DAX Measures; 7- The "Golden Rules" of DAX Measures; 8- CALCULATE() -- Your New Favorite Function; 9- ALL() -- The "Remove a Filter" Function; 10- Thinking in Multiple Tables; 11- "Intermission" -- Taking Stock of Your New Powers; 12- Disconnected Tables</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">13- Introducing the FILTER() Function, and Disconnected Tables Continued14- Introduction to Time Intelligence; 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun; 16- SUMX() and Other X ("Iterator") Functions; 17- Multiple Data Tables; 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER(); 19- Performance: How to keep things running fast; 20- Advanced Calculated Columns; 21- The Final Transformation: One Click That Will Change Your Life Forever; A1- Further Proof That the Game is Changing; A2- So Much Power, So Little Space: Further Capabilities</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">A3- Four Common Error MessagesA4- Supporting Workbooks and Data Sets; A5- People: The Most Powerful Feature of PowerPivot; Index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="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</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Desktop Applications / Spreadsheets</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business intelligence</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=502675</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBU</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FLA_PDA_EBU</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028390725</subfield></datafield></record></collection> |
id | DE-604.BV042964857 |
illustrated | Not Illustrated |
indexdate | 2024-07-10T07:13:55Z |
institution | BVB |
isbn | 9781615472123 1615472126 9781615473328 1615473327 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028390725 |
oclc_num | 818851430 |
open_access_boolean | |
physical | 1 Online-Ressource (256 pages) |
psigel | ZDB-4-EBU FLA_PDA_EBU |
publishDate | 2013 |
publishDateSearch | 2013 |
publishDateSort | 2013 |
publisher | Holy Macro! Books |
record_format | marc |
spelling | Collie, Rob Verfasser aut DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. Chicago Holy Macro! Books 2013 1 Online-Ressource (256 pages) txt rdacontent c rdamedia cr rdacarrier Cover; Copyright; Table of Contents; Acknowledgements; A Note on Hyperlinks; Introduction; 1- A Revolution Built on YOU; 2- What Version of PowerPivot Should You Use?; 3- Learning PowerPivot "The Excel Way"; 4- Loading Data Into PowerPivot; 5- Intro to Calculated Columns; 6- Introduction to DAX Measures; 7- The "Golden Rules" of DAX Measures; 8- CALCULATE() -- Your New Favorite Function; 9- ALL() -- The "Remove a Filter" Function; 10- Thinking in Multiple Tables; 11- "Intermission" -- Taking Stock of Your New Powers; 12- Disconnected Tables 13- Introducing the FILTER() Function, and Disconnected Tables Continued14- Introduction to Time Intelligence; 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun; 16- SUMX() and Other X ("Iterator") Functions; 17- Multiple Data Tables; 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER(); 19- Performance: How to keep things running fast; 20- Advanced Calculated Columns; 21- The Final Transformation: One Click That Will Change Your Life Forever; A1- Further Proof That the Game is Changing; A2- So Much Power, So Little Space: Further Capabilities A3- Four Common Error MessagesA4- Supporting Workbooks and Data Sets; A5- People: The Most Powerful Feature of PowerPivot; Index 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 Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Wirtschaft Business Computer programs Business intelligence Computer programs http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=502675 Aggregator Volltext |
spellingShingle | Collie, Rob DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Wirtschaft Business Computer programs Business intelligence Computer programs |
title | DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. |
title_auth | DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. |
title_exact_search | DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. |
title_full | DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. |
title_fullStr | DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. |
title_full_unstemmed | DAX Formulas for PowerPivot the Excel Pro's Guide to Mastering DAX. |
title_short | DAX Formulas for PowerPivot |
title_sort | dax formulas for powerpivot the excel pro s guide to mastering dax |
title_sub | the Excel Pro's Guide to Mastering DAX. |
topic | Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Wirtschaft Business Computer programs Business intelligence Computer programs |
topic_facet | Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets Wirtschaft Business Computer programs Business intelligence Computer programs |
url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=502675 |
work_keys_str_mv | AT collierob daxformulasforpowerpivottheexcelprosguidetomasteringdax |