Using Power Query to Import Names To Make Dummy Data

I maintain a file of dummy data and I describe the 2 reasons in this video. But where does the data come from?

Here, I show how to import and clean data from this web page of 200 top Brazilian first names.
Once the names are imported, the names have to be fixed using Power Query’s “Add Column by Example.” This makes it easy to correct names that are ALLCAPS or all lowercase.

The result is over 20 Million combinations of names for when it’s necessary to make tutorials and test solutions.

I also mention Excel Weekend 4 that’s happening in January 2018 in São Paulo Brazil. Learn more about it here:
For an intro to Get & Transform (Power Query) try my course:


My book: Guerrilla Data Analysis 2nd Edition
My old blog: