Books

Excel Power Pivot & Power Query for dummies

1st Edition

By Michael Alexander

ISBN: 111921064X
Publisher: For Dummies
Year: 2016
Pages: 282
Compare & Save from $9.35 total - 4 sellers competing

Select Condition

Condition Guide

Select a condition to see available offers

About This Book

A guide to PowerPivot and Power Query no data cruncher should be without!Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data-today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. Demonstrates how Power Query is used to discover, connect to, and import your dataShows you how to use PowerPivot to model data once it's been importedOffers guidance on using these tools to make analyzing data easierWritten by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brandIf you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life-and work-easier.
Marketplace from $9.35
Partner price may differ
Buy →

Product Details

Publisher For Dummies
Publication date January 1, 2016
Language English
Print length 282 pages
ISBN-10 111921064X
ISBN-13 978-1119210641
Item Weight 0.85 pounds

All Marketplace Offers

4 sellers competing for your order

Filter:
Condition Seller Total (book + shipping) Delivery Action
Acceptable

Shipping standard: ships in ≤2 business days · Returns: Ask seller before buying · Seller-error returns always accepted (30 days; seller covers return shipping).

HA
New seller · 0 reviews
$9.35
$5.36 book + $3.99 shipping
Arrives Nov 26-Nov 29 · Handling: 2 days
Estimated · shipping & returns
Select
Good

Shipping standard: ships in ≤2 business days · Returns: Ask seller before buying · Seller-error returns always accepted (30 days; seller covers return shipping).

BE
$59.90
$56.91 book + $2.99 shipping
Arrives Nov 29-Dec 2 · Handling: 5 days
Estimated · shipping & returns
Select
Very Good

Shipping standard: ships in ≤2 business days · Returns: Ask seller before buying · Seller-error returns always accepted (30 days; seller covers return shipping).

CA
New seller · 0 reviews
$116.21
$110.22 book + $5.99 shipping
Arrives Nov 25-Nov 28 · Handling: 1 days
Estimated · shipping & returns
Select
New

Shipping standard: ships in ≤2 business days · Returns: Ask seller before buying · Seller-error returns always accepted (30 days; seller covers return shipping).

BA
★ 4.8 · 2,192 reviews
3,260 sales
$120.38
$115.39 book + $4.99 shipping
Arrives Nov 27-Nov 30 · Handling: 3 days
Estimated · shipping & returns
Select
No marketplace copies available in this condition.
Showing of 4 offers

Editorial Reviews

Editorial Review

From the Inside FlapLearn to:Learn to:Extract data from databases and external files for use in Excel reportingExtract data from databases and external files for use in Excel reportingCreate powerful interactive reporting mechanisms and dashboardsCreate powerful interactive reporting mechanisms and dashboardsIntegrate Power Query with Power Pivot to create truly robust Business IntelligenceIntegrate Power Query with Power Pivot to create truly robust Business IntelligenceThe Excel guide that no serious data cruncher should live without!The Excel guide that no serious data cruncher should live without!Want to familiarize yourself with the rich set of tools and reporting capabilities available in Excel? Look no further! Inside, you'll discover how Power Pivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Want to familiarize yourself with the rich set of tools and reporting capabilities available in Excel? Look no further! Inside, you'll discover how Power Pivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Rev up your reporting — fire up Power Pivot, build table relationships, and create robust pivot table reporting using multiple data sourcesRev up your reporting — fire up Power Pivot, build table relationships, and create robust pivot table reporting using multiple data sourcesFormulate a plan — find out how to add formulas to Power Pivot reports and get the know-how to share your BI solutions with othersFormulate a plan — find out how to add formulas to Power Pivot reports and get the know-how to share your BI solutions with othersWhen in doubt — get the lowdown on Power Query, from choosing where to load Query results to refreshing and managing queries—and everything in betweenWhen in doubt — get the lowdown on Power Query, from choosing where to load Query results to refreshing and managing queries—and everything in betweenCan't we all just get along? — discover how to make Queries work together, build your own Query functions, and make marvelous magic with M Query languageCan't we all just get along? — discover how to make Queries work together, build your own Query functions, and make marvelous magic with M Query languageGet what you need — transform your way to better data by adding Query filters, filling in blank spaces and empty values, splitting and merging columns, and transposing and pivoting data Get what you need — transform your way to better data by adding Query filters, filling in blank spaces and empty values, splitting and merging columns, and transposing and pivoting data Open the book and find:Open the book and find:How to create your own database right in ExcelHow to create your own database right in ExcelWays to make pivot tables that use multiple data sourcesWays to make
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers