Excel Power Pivot & Power Query for dummies
By: by Michael Alexander
Series: For dummies; --For dummies
Publisher: For Dummies
Published: 2016
Language: eng
Number of pages: 268
ISBN-13: 9781119210641
Subjects: Microsoft PowerPivot (Computer file); Business; Querying (Computer science); Microsoft Excel (Computer file); Business intelligence; Data processing
Other titles: Excel PowerPivot & PowerQuery for dummies; Microsoft Excel Power Pivot & Power Query for dummies
Notes: Includes index.
Table of contents: title: Supercharged reporting with Power Pivot. Thinking like a database ; Introducing Power Pivot ; The pivotal Pivot table ; Using external data with Power Pivot ; Working directly with the internal data model ; Adding formulas to Power Pivot ; Publishing Power Pivot to SharePoint; title: Wrangling data with Power Query. Introducing Power Query ; Power Query connection types ; Transforming your way to better data ; Making Queries work together ; Extending Power Query with custom functions; title: The part of tens. Ten ways to improve Power Pivot performance ; Ten tips for working with Power Query.