TY - BOOK AU - Alexander, Michael TI - Microsoft : : excel power pivot and power query for dummies / SN - 9781119844488 AV - SHS HF 5548.4 A44 2022 PY - 2022/// CY - Hoboken, New Jersey PB - John Wiley & Sons, KW - Microsoft Excel (computer File) N1 - Includes index; pt.1 Supercharged reporting with power pivot -- ch.1 Thinking like a database -- ch.2 Power pivot -- ch.3 The pivotal pivot table -- ch.4 Using external data with power pivot -- ch.5 Working directly with the internal data model -- ch.6 Adding formulas to power pivot -- ch.7 Diving into dax -- pt.2 Wrangling data with power query -- ch.8 Power query -- ch.9 Power query connecting types -- ch.10 Transforming your way to better data -- ch.11 Making queries work together -- ch.12 Extending power query with custom functions -- pt.3 The part of tens -- ch.13 Ten ways to improve power pivot performance -- ch.14 Ten tips for working with power query ER -