Power Query for Power BI and Excel



Bookstore > Books > Power Query for Power BI and Excel

Power Query for Power BI and Excel
Price$31.03 - $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

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...
Beginning Power BI with Excel 2013

Beginning Power BI with Excel 2013

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...
Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

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

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...
Analyzing Data with Power BI and Power Pivot for Excel

Analyzing Data with Power BI and Power Pivot for Excel

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...
Learning Bitcoin

Learning Bitcoin

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