Power pivot and power BI : (Record no. 34187)
[ view plain ]
| LIBRARY OF CONGRESS CONTROL NUMBER | |
|---|---|
| LC control number | 2015940638 |
| INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781615470396 |
| DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Call number | 005.54 CO PO |
| MAIN ENTRY--PERSONAL NAME | |
| Authors | Collie, Robert |
| TITLE STATEMENT | |
| Title | Power pivot and power BI : |
| Subtitle | the excel user's guide to DAX, power query, power BI & power pivot in excel 2010-2016 |
| Statement of responsibility, etc | Rob Collie and Avichal Singh |
| EDITION STATEMENT | |
| Edition | 2nd ed. |
| PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication | Merritt Island : |
| Publisher | Holy Macro! Books, |
| Date | c2016. |
| PHYSICAL DESCRIPTION | |
| Extent | vi, 312 p. : |
| Other Details | col. ill. ; |
| Size | 28 cm. |
| CONTENTS | |
| Contents | Front Cover; Back Cover; Preface/Forward/Intro; Dedications; Supporting Workbooks and Data Sets; Errata and Book Support; A Note on Hyperlinks; Foreword and Forward; Introduction -- Our Two Goals for this Book; 1 -- A Revolution Built On YOU; 2 -- Power Pivot and the Power BI Family: Making Sense of the Various Versions; 4 -- Loading Data Into Power Pivot; 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 Powers12 -- Disconnected Tables; 13 -- Introducing the FILTER() Function, and Disconnected Tables Continued; 14 -- Introduction to Time Intelligence; 15 -- IF(), SWITCH(), BLANK(), and Other Conditional Fun; 16 -- SUMX() and Other X ("Iterator") Functions; 17 -- Multiple Data Tables; 18 -- Multiple Data Tables -- Differing Granularity; 19 -- Performance: Keep Things Running Fast; 20 -- Power Query to the Rescue; 21 -- Power BI Desktop; 22 -- "Complicated" Relationships; 23 -- Row and Filter Context Demystified; 24 -- CALCULATE and FILTER -- More Nuances. 25 -- Time Intelligence with Custom Calendars: Greatest Formula in the World26 -- Advanced Calculated Columns; 27 -- New DAX Functions ... and Variables! ; 28 -- "YouTube for Data" -- The Importance of a Server; PS: Can We Ask You for a Special Favor?; A1 -- Power Pivot and SSAS Tabular: Two Tools for the Price of One (again!); A2 -- Cube Formulas -- the End of GetPivotData(); A3 -- Some Common Error Messages; A4 -- People: The Most Powerful Feature of Power Pivot; Index; Power Pivot and Power BI; Dedications; Supporting Workbooks and Data Sets; Errata and Book Support; A Note on Hyperlinks. Foreword and Forward"State of the Union" November 2015 -- What's Changed?; What Has Changed at Microsoft? Virtually Everything.; What's Changed in My Corner of the World? Also Everything.; Introduction -- Our Two Goals for this Book; 1 -- A Revolution Built On YOU; Does This Sound Familiar?; Excel Pros: The World Is Changing in Your Favor; Our Importance Today; Excel at the Core; Three Ingredients of Revolution; Ingredient One: Explosion of Data; Ingredient Two: Economic Pressure; Ingredient Three: Dramatically Better Tools. 2 -- Power Pivot and the Power BI Family: Making Sense of the Various VersionsIt's a Family of Products Built on Shared Engines; Power Query is a Close Second in Importance; Visuals: The Crucial "Last Mile"; Power BI Desktop: Two Tools for the (Learning) Price of One!; Same Engines, Just Different Visuals; What do we mean by the "tough" or "valuable" stuff?; Power Pivot (in Excel) Versions; Power Pivot for Excel 2010; Power Pivot for Excel 2013 -- Only Available in "Pro Plus" Excel; Differences in User Interface: 2010, 2013, 2016; When We Said "Cosmetic" We Meant "Awkward"; 32-bit or 64-bit? |
| SUMMARY | |
| Summary | 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. This book tackles DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. 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. It includes 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. -- |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Heading | Microsoft Excel (Computer file) |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Heading | Microsoft PowerPivot (Computer file) |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Heading | Electronic spreadsheets |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Heading | Business intelligence |
| General | Computer programs |
| ADDED ENTRY | |
| Name | Singh, Avichal |
| ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | https://uowd.box.com/s/6a48cy7znfkoq4ybvtdb8uqd2sw8fs9v |
| Public note | Location Map |
| MAIN ENTRY--PERSONAL NAME | |
| -- | 19180 |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| -- | 328 |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| -- | 19181 |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| -- | 463 |
| SUBJECT ADDED ENTRY--TOPICAL TERM | |
| -- | 579 |
| ADDED ENTRY | |
| -- | 19529 |
| Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Permanent location | Current location | Shelving location | Date acquired | Source of acquisition | Full call number | Barcode | Date last seen | Price effective from | Koha item type | Public note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| University of Wollongong in Dubai | University of Wollongong in Dubai | Main Collection | 2018-05-30 | AMAUK | 005.54 CO PO | T0059891 | 2018-05-18 | 2018-05-18 | REGULAR | June2018 |