Collect, combine, and transform data using Power Query in Excel and Power BI / Gil Raviv.
By: Raviv, Gil [author.].
Publisher: [United States] : published with the authorization of Microsoft Corporation by Pearson Education, Inc., ©2019Copyright date: ©2019Description: 402 p: illustrations ; 23 cm.Content type: text Media type: unmediated Carrier type: volumeISBN: 9781509307951.Subject(s): Microsoft Excel (Computer file) | Microsoft Excel (Computer file) | Electronic spreadsheets -- Computer programs | Business intelligence -- Computer programs | Information visualization -- Computer programs | Business -- Data processing | Visual analytics | Business -- Data processing | Electronic spreadsheets -- Computer programs | Visual analyticsGenre/Form: Print books.| Current location | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|
| On Shelf | HF5548.4.M523 R38 2019 (Browse shelf) | Available | AU00000000015564 |
Browsing Alfaisal University Shelves , Shelving location: On Shelf Close shelf browser
|
|
|
|
|
|
|
||
| HF5548.4 .M523 M343 2019 Microsoft excel 2019 formulas and functions / | HF5548.4 .M523 M3763 2016 Teach yourself visually Excel 2016 / | HF5548.4.M523 P759 2020 Core statistical concepts with Excel : an interactive modular approach / | HF5548.4.M523 R38 2019 Collect, combine, and transform data using Power Query in Excel and Power BI / | HF5548.4.M523 Z46 2022 Mastering Excel through projects : a learn-by-doing approach from payroll to crypto to data analysis / | HF5548.4.M523 Z86 2021 Python for Excel | HF5548.4.M525 H334 2019 Microsoft Office 2019 inside out / |
Includes bibliographical references and 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.
"Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data-and transform it into actionable knowledge."--