
Cleaning Excel Data With Power Query Straight to the Point
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Content
- Intro
- About the Author
- Acknowledgments
- INTRODUCTION
- So, What Is Power Query?
- When I Became a Believer.
- FIRST, SOME BACKGROUND FOR POWER QUERY
- Excel Versions
- Everything Happens via Queries
- Data Types
- Power Query Warnings
- GETTING DATA INTO POWER QUERY
- Importing Data from a Table or Range
- Importing Data from a Workbook
- FILL UP AND FILL DOWN
- PARSING TEXT
- Splitting Names by Delimiter
- Splitting into Rows
- SORTING IN POWER QUERY
- MERGING DATA: JOINING AND APPENDING
- Joins and Merging
- Full Outer Join: Creating a Master List
- Inner Join: Determining Who Registered and Attended
- Right and Left Anti Joins: Determining What's over Here That's Not over There
- RIGHT ANTI JOIN
- LEFT ANTI JOIN
- Left and Right Outer Joins: Power Query's VLOOKUP
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- Appending Datasets
- GROUPING DATA
- REFRESHING AND UPDATING DATA
- ADDING COLUMNS
- Adding Conditional Columns
- Adding Multiple Conditions
- Adding Custom Columns
- Adding Custom Columns with Power Query Functions and Adding Whole Numbers to Dates
- Adding a Column Using Column from Examples
- UNPIVOTING DATA
- CONCLUSION
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.