You can’t analyze data unless it’s properly structured. Doing so by hand may be impossible for all but the smallest data sets. Power Query can automate much of the process.
This live, one-hour program covers:
-What Power Query can do and where to find it;
-Data sources it can work with;
-How to plan and build a query;
-Parsing data such as first and last name, and elements of an address;
-Transposing rows and columns;
-Combining tables (relationships); and -Outputting results.

Speaker Bio: Jerry Rosenthal, ComputerImages.com

Duration: 60min