{"product_id":"mastering-excel-mark-moore-9781546909071","title":"Mastering Excel: Power Query","description":"\u003cb\u003eImport data from text files, other Excel files, databases, web pages, Facebook, even entire folders of files using Power Query.\u003c\/b\u003eExcel is the most accessible program for data analysis. \u003cb\u003ePower Query (also known as Get \u0026amp; Transform)\u003c\/b\u003e takes that one step further. The first step of any data analysis project is importing the data. Related to that, you must clean and standardize the data (aka ETL: Extract, Transform and Load)Power Query has all that covered. You will learn to set up Power Query for connecting Excel to all kinds of data sources, performing hundreds of ETL tasks and loading clean data into your worksheet. Power Query can extract data from columns, join columns, remove duplicates, skip errors, join tables, the list is almost endless.Additionally, Power Query is set up to remember all the steps you performed and it will redo them with a single click of a button.Learn to use Power Query and save yourself hours of work.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Mark Moore\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1546909079\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781546909071\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Createspace Independent Publishing Platform\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 05\/23\/2017\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 68\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.23lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.00w x 0.14d","brand":"Mark Moore","offers":[{"title":"Paperback","offer_id":43985090019583,"sku":"9781546909071","price":15.2,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_0fd828b5-f426-4154-99ea-8c332636d041.jpg?v=1683275505","url":"https:\/\/www.whiterainbookhouse.com\/products\/mastering-excel-mark-moore-9781546909071","provider":"WR Book House","version":"1.0","type":"link"}