000			01864nam a22002057a 4500
999			_c3883 _d3883
005			20221220120848.0
008			221122b ||||| |||| 00| 0 eng d
020			_a9781484252468
082			_a005.741 _bWEB
100			_aWebb, Chris _99104
245			_aPower query for power BI and excel
260			_bApress  _aNew York _c2022
300			_axxi, 247 p.
365			_aINR _b849.00
520			_aAbout this book Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis.
650			_aMicrosoft Excel (Computer file) _9850
650			_aQuerying (Computer science) _910226
650			_aComputer science _91018
942			_2ddc _cBK