14
Troublesome Data Patterns
Reshaping and preparing data for analysis is often a combination of art and science, blending theory and skills with creative problem-solving. There are a wide range of troublesome data patterns, from dealing with stacked data to multiline headers and beyond. Challenges are not limited to the structure of the data alone but often also include inconsistencies and other complexities that can arise from the unique nature of the data itself or specific business rules and requirements.
When we think about problem-solving, it’s important to remember that there are many different approaches and techniques. In this book, we’re not claiming to have all the answers or that these methods are best. Rather, we aim to offer a ...
Get The Definitive Guide to Power Query (M) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.