Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition

CHAPTER 2Basic Data Preparation Challenges

Before anything else, preparation is the key to success.

—Alexander Graham Bell

IN THIS CHAPTER, YOU WILL

• Learn how to split and extract valuable information from delimiter-separated values

• Learn how to enrich your data from lookup tables in a single table or by using relationships between fact tables and lookup tables

• Learn how Add Column from Examples can help you extract or compute meaningful data from columns and use it to explore new transformations

• Learn how to extract meaningful information, such as hyperlinks, from text columns

• Handle inconsistent date values from one or more locales

• Learn how to extract date or time elements from Date columns

• Split a table into a fact table and a lookup table ...