Power Query for Power BI and Excel

ISBN-10: 1430266929
ISBN-13: 9781430266921
Category: Computers
Pages: 261
Language: English
Published: 2014-07-05
Publisher: Apress
Authors: Christopher Webb, Crossjoin Consulting Limited

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 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. Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language

Get the book

Similar books

Family History Digital Libraries
By William Sims Bainbridge
One named Sara and Timberlake had 11 male workers, 1 female worker, and 4 children workers, so it might have employed the Minor family.
Foundation Dreamweaver MX
By Craig Grannell, Jerome Turner, Matt Stephens
So here's what we need to do to arrive at our layout: s Create the main table to hold all the page elements. s Deal with the navigation area which is ...
Cisco CCNA Certification, 2 Volume Set: Exam 200-301
By Todd Lammle
This inclusive, two-book set provides what you need to know to succeed on the new CCNA exam. The set includes Understanding Cisco Networking Technologies: Volume 1 and the CCNA Certification Study Guide: Volume 2.
CompTIA Network+ Study Guide: Exam N10-006
By Todd Lammle
... you can use: –a –A –c –n –r –R –S –s All nbtstat switches are case sensitive. Generally speaking, lowercase switches deal with NetBIOS names of hosts, ...
CompTIA Network+ Study Guide with Online Labs: N10-007 Exam
By Todd Lammle, Jon Buhagiar
... you can use: –a –A –c –n –r –R –S –s All nbtstat switches are case sensitive. Generally speaking, lowercase switches deal with NetBIOS names of hosts, ...
CCNA: Cisco Certified Network Associate FastPass
By Todd Lammle
S The S reference point defines the point between the customer router and an ... with the letter E deal with using ISDN on the existing telephone network.
Stranger in the Chat Room
By Todd Hafer, Jedd Hafer
A sequel to In the Chat Room With God finds a group of teens contacted by a mysterious and increasingly malevolent character who claims to know about their encounters with the Almighty and challenges their beliefs. Original.
Error Correction Coding: Mathematical Methods and Algorithms
By Todd K. Moon
M M−1∑ k=0 −∞ ∞ k=0 The average energy per signal E s ∫ can be related to the ... we will deal primarily with additive white Gaussian noise (AWGN), ...
Security+ Training Guide
By Todd King
... to deal with most , but unfortunately not all , of these potential threats . ... The S / MIME standard implements encryption for message content using ...
CCDA: Cisco Certified Design Associate Study Guide: Exam 640-861
By Todd Lammle, Andy Barkl
S reference point The S reference point defines the reference point between ... with the letter E deal with using ISDN on the existing telephone network.