{"product_id":"excel-power-pivot-power-query-for-dummies-9781119844488","title":"Excel Power Pivot \u0026 Power Query for Dummies","description":"\u003cp\u003e\u003cb\u003eLearn to crunch huge amounts of data with PowerPivot and Power Query\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eDo you have a ton of data you need to make sense of? Microsoft's Excel program can handle amazingly large data sets, but you'll need to get familiar with PowerPivot and Power Query to get started. \u003c\/p\u003e\u003cp\u003eAnd that's where Dummies comes in. With step-by-step instructions--accompanied by ample screenshots--\u003ci\u003eExcel PowerPivot \u0026amp; Power Query For Dummies \u003c\/i\u003ewill teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization's data. Then use PowerPivot to model it in Excel. You'll also learn to: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eMake use of databases to store large amounts of data\u003c\/li\u003e \u003cli\u003eUse custom functions to extend and enhance Power Query\u003c\/li\u003e \u003cli\u003eAdd the functionality of formulas to PowerPivot and publish data to SharePoint\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIf you're expected to wrangle, interpret, and report on large amounts of data, \u003ci\u003eExcel PowerPivot \u0026amp; Power Query For Dummies\u003c\/i\u003e gives you the tools you need to get up to speed quickly.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.\u003c\/p\u003e\u003cbr\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":50651535835410,"sku":"9781119844488","price":28.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_e5d0d1ad-a0a4-4eef-a18b-859aafdd801b.jpg?v=1733303264","url":"https:\/\/surprise-castle.myshopify.com\/products\/excel-power-pivot-power-query-for-dummies-9781119844488","provider":"Surprise Castle","version":"1.0","type":"link"}