ДMK, 2022. — 574 c. Уму непостижимо, как легко и просто можно очистить данные с помощью Power Query в Excel или Power BI! Наши данные редко появляются на свет в готовом к работе виде, и у нас могут уходить долгие часы на их очистку, фильтрацию и преобразование. Power Query помогает сократить этот процесс при первичной обработке данных, а все последующие обновления позволяет...
Пер. с англ. Александра Сергеева. — СПб.: БХВ, 2021. — 480 с.: ил. — ISBN 978-5-9775-6725-1. В книге описан Power Query, инструмент для продвинутого бизнес-анализа, встроенный в Excel, Power BI и другие продукты Microsoft и предназначенный для подключения к источникам данных и их преобразования. Рассказано, как обрабатывать таблицы Excel без использования сложных формул и...
Apress, 2014. — 272 p. — ISBN10: 1430266910. ISBN13: 978-1430266914. This book is for people who spend a lot of time working with Excel building reports and dashboards. More specifically, this book is for people who work with Excel building reports and dashboards and who are bored with copying and pasting data into worksheets, bored with clicking the same sequence of buttons...
2nd.ed. - Holy Macro! Books, 2021 - 386p. - ISBN: 1615470581 Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle—there are tools hiding in plain...
Microsoft Press, 2018. — 432 p. — ISBN: 9781509307951. 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...
Packt, 2020. - 428p. - ISBN: 9781839219719 Discover how you can combine data from various sources to create data models to suit your business requirements with the help of this clear and concise guide Key Features Understand how Power Query overcomes the shortcomings of Excel Power Pivot in handling complex data Create customized dashboards and multi-dimensional reports using...
Packt Publishing, 2021. — 412 p. — ISBN 1800569483, 9781800569485. Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily manage highly complex data lifecycles with Power Query Key Features Collect, combine, and transform data using Power Query's data connectivity and data preparation features Overcome the...
Apress Media LLC., 2024. — 410 p. — ISBN-13: 978-1-4842-9753-7. This book is a complete guide to using functions in Power Query and is designed to help users of all skill levels learn and master its various functions. The Ultimate Guide to Functions in Power Query begins with an introduction to Power Query and an overview of the different types of functions available, along...
Комментарии