O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required