Power Query for Power BI and Excel



Bookstore > Books > Power Query for Power BI and Excel

Price$27.99 - $32.14
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 32

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

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

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

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

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

Pro Data Mashup for Power BI

Pro Data Mashup for Power BI

by Adam Aspin

This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The boo...

Price:  $51.08  |  Publisher:  Apress  |  Release:  2022

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

Mathematics for Game Programming and Computer Graphics

Mathematics for Game Programming and Computer Graphics

by Penny de Byl

Mathematics is an essential skill when it comes to graphics and game development, particularly if you want to understand the generation of real-time computer graphics and the manipulation of objects and environments in a detailed way. Python, together with Pygame and PyOpenGL, provides you with the opportunity to explore these features un...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2022

Introducing Charticulator for Power BI

Introducing Charticulator for Power BI

by Alison Box

Create stunning and complex visualizations using the amazing new Charticulator custom visuals in Power BI. Charticulator offers users immense power to generate visuals and graphics. To a beginner, there are myriad settings and options that can be combined in what feels like an unlimited number of combinations, giving it the unfair label, ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2022

The Definitive Guide to DAX, 2nd Edition

The Definitive Guide to DAX, 2nd Edition

by Marco Russo, Alberto Ferrari

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You...

Price:  $33.30  |  Publisher:  Microsoft Press  |  Release:  2019