Mastering Excel: Power Query - Couverture souple

Moore, Mark

Couverture souple

ISBN 10 : 1546909079 ISBN 13 : 9781546909071

Editeur : CreateSpace Independent Publishing Platform, 2017

Synopsis

Import data from text files, other Excel files, databases, web pages, Facebook, even entire folders of files using Power Query.Excel is the most accessible program for data analysis. Power Query (also known as Get & Transform) 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.

A propos du livre

Présentation de l'éditeur

Welcome another lesson in the Mastering Excel series. This lesson is looking into the future and delving into what Excel is becoming: a powerhouse for data analysis. Power Query is the first step in analyzing data, before you do any substantial analysis, you need to get the data into Excel. Not only get data into Excel but probably clean it up. Parse columns, join columns, remove errors, you know, that kind of stuff.Of course, you can add a column with formulas to do this. That will work for 100 or 1,000 rows of data. What about 250,000, 700,000 or even 1,000,000 rows? Excel really slows down with that many calculations. Power Query solves this. It shapes the data before it gets into Excel. You will learn how to use Power query to split columns, parse data, check for errors, get data from multiple files in a folder, and more. Power Query remembers all the steps you took. To get new data, you simply have to click the 'Refresh' button.***OK, THIS IS IMPORTANT***Power Query is a new feature in Excel. It is standard in Excel 2016 and it can be installed in some previous versions of Excel, but not all. Before buying this lesson, please go to this Microsoft website, check out the requirements and try to install Power Query.https://www.microsoft.com/en-us/download/details.aspx?id=39379If you cannot install Power Query because you do not have the correct version of Excel, you will not be able to follow along with this lesson.

Détails de l'édition

• Éditeur: CreateSpace Independent Publishing Platform
• Date d'édition: 2017
• Langue: anglais
• ISBN 10: 1546909079
• ISBN 13: 9781546909071
• Reliure: Broché
• Nombre de pages: 66
• Coordonnées du fabricant: Manufactured by Amazon on behalf of the author; https://www.amazon.fr/hz/contact-us; ; c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy; Luxembourg; L-1855; Luxembourg