Collect, combine, and transform data using Power Query in Excel and Power BI /

Raviv, Gil

Collect, combine, and transform data using Power Query in Excel and Power BI / Gil Raviv. - United States : published with the authorization of Microsoft Corporation by Pearson Education, Inc., ©2019. - xxvii, 402 pages: Illustrations 23 cm

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.


in English

9781509307951


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