TY  - BOOK
AU  - Raviv, Gil
TI  - Collect, combine, and transform data using Power Query in Excel and Power BI
SN  - 9781509307951
AV  - 005.54 R19c 2019 
PY  - 2019///
CY  - United States
PB  - published with the authorization of Microsoft Corporation by Pearson Education, Inc.
KW  - Microsoft Excel (Computer file)
KW  - Electronic spreadsheets
KW  - Computer programs
KW  - Business intelligence
KW  - Information visualization
KW  - Business
KW  - Data processing
KW  - Visual analytics
N1  - Includes index; 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
ER  -