excel power pivot and power query for dummies Alexander, Michael creator text 2nd edition. monographic eng

print

ix, 275 pages : illustrations ; 24 cm. 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. Michael Alexander Includes index. Microsoft Excel (computer File) SHS HF 5548.4 A44 2022 9781119844488 240129 20240129152006.0