Building Robust, Maintainable, and High-Performance Data Transformations in Excel and Power BI
Buch, Englisch, Format (B × H): 155 mm x 235 mm
ISBN: 979-8-8688-3472-1
Verlag: APRESS L.P.
Organized around practical problems rather than individual functions, this book shows how experienced Power Query users solve real-world data challenges. Instead of simply explaining what a function does, it demonstrates how and when to use it, compares alternative approaches, and highlights techniques for creating more maintainable, robust, and efficient solutions. The result is a practical companion that helps you spend less time troubleshooting and more time actually working with data.
Through hands-on examples, you'll learn how to import, clean, reshape, combine, and enrich data from a variety of sources. You'll explore reusable functions, joins, grouping, data validation, query folding, performance optimization, and advanced M language techniques while developing a deeper understanding of the tools available in Power Query and how to apply them effectively. Whether you're building new reports or improving existing ones, you'll gain practical techniques for creating solutions that are easier to maintain, easier to expand, and better able to handle changing requirements.
What You Will Learn
- Automate data cleaning and data transformation workflows with Power Query
- Create robust queries that handle changing column names, file paths, and source structures
- Build reusable Power Query functions and maintainable transformation patterns
- Apply advanced M language techniques, including List.Accumulate and List.Generate
- Optimize query performance through query folding, buffering, and efficient joins
- Clean, standardize, and validate data from spreadsheets, databases, and text files
- Use grouping, merging, and transformation techniques to solve real-world data preparation problems
- Design scalable Power Query solutions that require less ongoing maintenance
Who This Book Is For
Business analysts; data analysts; Excel power users; Power BI professionals; reporting specialists; analytics practitioners with basic Power Query experience.
Zielgruppe
Professional/practitioner
Autoren/Hrsg.
Fachgebiete
Weitere Infos & Material
Chapter 1. Introduction.- Chapter 2. Fancy Operators.- Chapter 3. Create Your Own Values.- Chapter 4. Excel.- Chapter 5. Functions.- Chapter 6. Text Functions.- Chapter 7. Record Functions.- Chapter 8. List Functions.- Chapter 9. List.Accumulate and List.Generate.- Chapter 10. Table Functions.- Chapter 11. Splitters and Combiners.- Chapter 12. Grouping Data.- Chapter 13. Joining Tables.- Chapter 14. Transforming and Replacing Columns.- Chapter 15. Databases.- Chapter 16. Scripting and Regex.- Chapter 17. Recursion.- Chapter 18. Practical Power Query.
