Articoli correlati a Mastering Excel: Power Query

Mastering Excel: Power Query - Brossura

Libro 9 di 30: Mastering Excel

Moore, Mark

 
9781546909071: Mastering Excel: Power Query
Brossura
ISBN 10: 1546909079 ISBN 13: 9781546909071
Casa editrice: CreateSpace Independent Publishing Platform, 2017

Sinossi

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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Editore
CreateSpace Independent Publishing Platform
Data di pubblicazione
2017
Lingua
Inglese
ISBN 10 
1546909079
ISBN 13 
9781546909071
Rilegatura
Copertina flessibile
Numero di pagine
66
Contatto del produttore
Manufactured by Amazon on behalf of the author
https://www.amazon.it/hz/contact-us

c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy
Luxembourg
L-1855
Lussemburgo