Cleaning Excel Data With Power Query Straight to the Point : Efficient Data Cleaning Techniques in Excel Using Power Query
Unlock the secrets of Power Query in Excel to clean, parse, and transform data. Learn key techniques like joining datasets, unpivoting, and creating custom columns to simplify and streamline your data analysis process. Key Features: A clear guide to Power Query tools and techniques ; Practical examp...
Guardat en:
| Autor principal: | |
|---|---|
| Format: | Livre numérique |
| Idioma: | Anglais |
| Publicat: |
Birmingham :
Packt Publishing
2024.
Paris : Cyberlibris |
| Accés en línia: | Accès Université d'Orléans et IFPM |
| Nota: |
Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781837026180.jpg Cyberlibris (ScholarVox) corpus Informatique |
| Autres localisations: | Voir dans le Sudoc |
| Edition sous un autre format: | • Cleaning Excel Data With Power Query Straight to the Point, Efficient Data Cleaning Techniques in Excel Using Power Query, Oz du Soleil, Birmingham, Packt Publishing, 2024, 1 vol. (60 p.), 978-18-3702-619-7 |
| LEADER | 03082nam a22002177a 4500 | ||
|---|---|---|---|
| 001 | 1287989 | ||
| 008 | 250217s2024 xxg ||| |||| 00| 0 eng d | ||
| 009 | PPN283329467 | ||
| 020 | |a 9781837026180 | ||
| 041 | 0 | |a eng | |
| 100 | 1 | |a Soleil, Oz du. | |
| 245 | 1 | 0 | |a Cleaning Excel Data With Power Query Straight to the Point : |b Efficient Data Cleaning Techniques in Excel Using Power Query |c Oz du Soleil. |
| 260 | |a Birmingham : |b Packt Publishing. | ||
| 260 | |a Paris : |b Cyberlibris, |c 2024. | ||
| 500 | |a Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781837026180.jpg | ||
| 500 | |a Cyberlibris (ScholarVox) corpus Informatique | ||
| 506 | |a L'accès en ligne est réservé aux établissements ou bibliothèques ayant souscrit l'abonnement. Cyberlibris | ||
| 520 | |a Unlock the secrets of Power Query in Excel to clean, parse, and transform data. Learn key techniques like joining datasets, unpivoting, and creating custom columns to simplify and streamline your data analysis process. Key Features: A clear guide to Power Query tools and techniques ; Practical examples of common data tasks ; A complete coverage of advanced transformations and joins. Book Description: This book provides a step-by-step guide to using Power Query in Excel for efficient data cleaning and transformation. Starting with an introduction to its capabilities, it explains how to import data, handle missing values, and parse text fields with ease. Advanced techniques such as merging datasets, appending data, and performing joins are explored in detail. The book also covers grouping data, creating conditional and custom columns, and reshaping data through unpivoting for analysis. Each concept is illustrated with practical examples for clarity. By the end of the book, readers will be equipped with the skills to automate repetitive tasks and streamline workflows. Whether dealing with messy data or preparing datasets for analysis, this guide ensures you can confidently tackle any Excel data transformation challenge. What you will learn: Import and prepare data using Power Query ; Apply fill up and fill down techniques ; Parse and split text fields by delimitersMerge and append datasets seamlessly ; Group and unpivot data for analysis ; Create custom and conditional columns. Who this book is for: This book is ideal for data analysts, business professionals, and Excel users looking to simplify data cleaning and transformation tasks. Readers are recommended to have a basic understanding of Excel. Familiarity with formulas and tables is helpful but not required | ||
| 776 | 0 | |t Cleaning Excel Data With Power Query Straight to the Point |o Efficient Data Cleaning Techniques in Excel Using Power Query |f Oz du Soleil |c Birmingham |n Packt Publishing |d 2024 |p 1 vol. (60 p.) |z 978-18-3702-619-7 | |
| 856 | 4 | |5 452349901:845618164 |u https://ezproxy.univ-orleans.fr/login?url=https://univ.scholarvox.com/book/88962188 |z Accès Université d'Orléans et IFPM | |
| 997 | |0 1287989 |1 Livre numérique |a Ressource numérique |b INSA |b ENSA |c 0/Bibliothèque numérique/ |c 1/Bibliothèque numérique/ScholarVox (ebooks)/ | ||