Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Power Query for Power BI and Excel, Paperback / softback Book

Power Query for Power BI and Excel Paperback / softback

Paperback / softback

Out of stock

Description

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 iscovered 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.

Teaches the basics of using Power Query to load data into ExcelHelps you solve common, data-related problems with Power QueryShows how to write your own solutions in the powerful M language

Information

  • Out of stock

  • Format:Paperback / softback
  • Pages:272 pages, 326 Illustrations, black and white; XV, 272 p. 326 illus.
  • Publisher:Springer-Verlag Berlin and Heidelberg GmbH & Co. K
  • Publication Date:
  • Category:
  • ISBN:9781430266914

Other Formats

£49.99

Out of stock
Add to Basket
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information

  • Out of stock

  • Format:Paperback / softback
  • Pages:272 pages, 326 Illustrations, black and white; XV, 272 p. 326 illus.
  • Publisher:Springer-Verlag Berlin and Heidelberg GmbH & Co. K
  • Publication Date:
  • Category:
  • ISBN:9781430266914