Power Query for Power BI and Excel



Bookstore > Books > Power Query for Power BI and Excel

Price$31.28 - $39.99
Rating
AuthorChris Webb
PublisherApress
Published2014
Pages272
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101430266910
ISBN-139781430266914
EBook Hardcover Paperback

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.


  1. (2 books)



4 5 19

Similar Books


Beginning Big Data with Power BI and Excel 2013

Beginning Big Data with Power BI and Excel 2013

by Neil Dunlop

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft's Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps.While Beginni...

Price:  $36.44  |  Publisher:  Apress  |  Release:  2015

Beginning Power BI with Excel 2013

Beginning Power BI with Excel 2013

by Dan Clark

Understanding your company's data has never been easier than with Microsoft's new Power BI package for Excel 2013. Consisting of four powerful tools - Power Pivot, Power View, Power Query and Power Maps - Power BI makes self-service business intelligence a reality for a wide range of users, bridging the traditional gap between Excel users...

Price:  $5.98  |  Publisher:  Apress  |  Release:  2014

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

by Mark Polino

Accounting systems like Microsoft Dynamics GP 2013 hold a wealth of information. Excel 2013 provides a great tool for linking to, extracting, analysing, and presenting that rich data to help companies make better, faster, and smarter decisions.Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 covers how to get the rich, d...

Price:  $24.99  |  Publisher:  Packt Publishing  |  Release:  2013

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

by Gil Raviv

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

Price:  $29.28  |  Publisher:  Microsoft Press  |  Release:  2018

Analyzing Data with Power BI and Power Pivot for Excel

Analyzing Data with Power BI and Power Pivot for Excel

by Alberto Ferrari, Marco Russo

How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It's meant for rea...

Price:  $28.39  |  Publisher:  Microsoft Press  |  Release:  2017

PowerPoint 2019 For Dummies

PowerPoint 2019 For Dummies

by Doug Lowe

PowerPoint continues to be the go-to tool for business presentations. The software helps anyone who needs to communicate clearly by creating powerful and effective slideshow presentations featuring data in the form of charts, clip art, sound, and video. You can even use it to create presentations for the Web. In PowerPoint 2019 For Dummie...

Price:  $19.77  |  Publisher:  Wiley  |  Release:  2018

Learning Bitcoin

Learning Bitcoin

by Richard Caetano

Bitcoin exists as an open and transparent financial system without banks, governments, or corporate support. Simply put, Bitcoin is "programmable money" that has the potential to change the world on the same scale as the Internet itself.This book arms you with immense knowledge of Bitcoin and helps you implement the technology i...

Price:  $35.99  |  Publisher:  Packt Publishing  |  Release:  2015

PowerShell Core for Linux Administrators Cookbook

PowerShell Core for Linux Administrators Cookbook

by Prashanth Jayaram, Ram Iyer

PowerShell Core, the open source, cross-platform that is based on the open source, cross-platform .NET Core, is not a shell that came out by accident; it was intentionally created to be versatile and easy to learn at the same time. PowerShell Core enables automation on systems ranging from the Raspberry Pi to the cloud.PowerShell Core for...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2018