Collect, combine, and transform data using Power Query in Excel and Power BI
Raviv, Gil
creator
text
xx
United States
published with the authorization of Microsoft Corporation by Pearson Education, Inc.
©2019
2019
monographic
und
xxvii, 402 pages: Illustrations
23 cm
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.
Gil Raviv.
Includes index
in English
Microsoft Excel (Computer file)
Electronic spreadsheets
Computer programs
Business intelligence
Computer programs
Information visualization
Computer programs
Business
Data processing
Visual analytics
005.54 R19c 2019
9781509307951
251212
20260803094236.0