Introduction to Power Query -- Basic data preparation challenges -- Combining data from multiple sources -- Combining mismatched tables -- Preserving context -- Unpivoting tables -- Advanced unpivoting and pivoting of tables -- Addressing collaboration challenges -- Introduction to the Power Query M formula language -- From pitfalls to robust queries -- Basic text analytics -- Advanced text analytics: extracting meaning -- Social network analytics -- Final project: combining it all together.
in English
9781509307951
Microsoft Excel (Computer file) Electronic spreadsheets--Computer programs Business intelligence--Computer programs Information visualization--Computer programs Business--Data processing Visual analytics