X

Sign Up




READARA
Power Query for Power BI and Excel

Overall Rating

NA

Reviews

NA

Power Query For Power BI And Excel

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

What you 'll learn

  • Import data from sources including relational databases, text files, web pages, and Excel workbooks.
  • Import from more exotic sources such as Facebook, Windows Azure Marketplace, Wikipedia, and OData feeds within and outside your organization.
  • Build repeatable processes to filter, clean, aggregate, and transform your data.
  • Load your data into an Excel table or directly into the Excel 2013 Data Model.
  • Write complex expressions in Power Query's M expression language.
  • Share queries and their data with other users in your organization.
  • Position your data for further analysis using Power View, Power Map, Power Pivot, and the rest of Microsoft's Power BI suite.

Who this book is for

Power Query for Power BI and Excel is aimed at serious Excel and Power BI users who need to import data into a worksheet. Whether you are an analyst, report writer, business intelligence consultant, or just " that guy " whose job it is to prepare the monthly sales dashboard, you 'll learn how Power Query can make your life easier. Power Query for Power BI and Excel is especially important for Excel and BI power users who want to work directly in the M language that underlies all of Power Query 's functionality.

Table of Contents

  1. Power Query and When to Use It
  2. Data Sources
  3. Transformations
  4. Tables and the Excel Data Model
  5. Expressions in the M Language
  6. Multiple Data Sources
  7. Power BI and Sharing
  8. Common Problems Solved

Apress

Apress

No image

Chris Webb

No of Pages
272
Publisher
Apress
ISBN-13
9781430266914
Awards
None
Book Format
Paperback
Published Date
Jun 24, 2014

Circles

Not in any circle

Book Journey

Reviews [0]

Likes [0]

Recommends [0]

Bookshelf [0]

Table of Contents

No data Found

About Chris Webb

No data Found

Other Books by Author

No Books Available

More Data Processing Related Books

other Related books
The Non-Designer's Web Book, 3rd Edition
The Non-Designer's Web Book, 3rd Edition
Author :
Robin Williams, John Tollett
Publisher :
Peachpit Press
Published Date :
Sep 26, 2005
No of Pages :
336
Book Format :
Paperback
Category :
Data Processing
other Related books
Think Bayes
Think Bayes
Author :
Allen B. Downey
Publisher :
O'Reilly Media
Published Date :
Oct 4, 2013
No of Pages :
210
Book Format :
Paperback
Category :
Data Processing
other Related books
Seductive Interaction Design: Creating Playful, Fun, and Effective User Experiences (Voices That Matter)
Seductive Interaction Design: Creating Playful, Fun, and Effective User Experiences (Voices That Matter)
Author :
Stephen P. Anderson
Publisher :
New Riders
Published Date :
Jun 25, 2011
No of Pages :
240
Book Format :
Paperback
Category :
Data Processing
other Related books
High Impact Data Visualization with Power View, Power Map, and Power BI
High Impact Data Visualization with Power View, Power Map, and Power BI
Author :
Adam Aspin
Publisher :
Apress
Published Date :
Jun 11, 2014
No of Pages :
552
Book Format :
Paperback
Category :
Data Processing
other Related books
Power Query for Power BI and Excel
Power Query for Power BI and Excel
Author :
Chris Webb
Publisher :
Apress
Published Date :
Jun 24, 2014
No of Pages :
272
Book Format :
Paperback
Category :
Data Processing
other Related books
Take Back Your Life!: Using Microsoft Office Outlook 2007 to Get Organized and Stay Organized
Take Back Your Life!: Using Microsoft Office Outlook 2007 to Get Organized and Stay Organized
Author :
Sally McGhee, John Wittry
Publisher :
Microsoft Press
Published Date :
Jun 13, 2007
No of Pages :
368
Book Format :
Paperback
Category :
Data Processing
other Related books
TIBCO Spotfire: A Comprehensive Primer
TIBCO Spotfire: A Comprehensive Primer
Author :
Michael Phillips
Publisher :
Packt Publishing - ebooks Account
Published Date :
Feb 19, 2015
No of Pages :
346
Book Format :
Paperback
Category :
Data Processing
other Related books
Automatic Speech Recognition: A Deep Learning Approach (Signals and Communication Technology)
Automatic Speech Recognition: A Deep Learning Approach (Signals and Communication Technology)
Author :
Dong Yu, Li Deng
Publisher :
Springer
Published Date :
Nov 11, 2014
No of Pages :
321
Book Format :
Hardcover
Category :
Data Processing
other Related books
A Primer on Scientific Programming with Python (Texts in Computational Science and Engineering)
A Primer on Scientific Programming with Python (Texts in Computational Science and Engineering)
Author :
Hans Petter Langtangen
Publisher :
Springer
Published Date :
Aug 2, 2014
No of Pages :
872
Book Format :
Hardcover
Category :
Data Processing
other Related books
F# Deep Dives
F# Deep Dives
Author :
Tomas Petricek, Phil Trelford
Publisher :
Manning Publications
Published Date :
Dec 28, 2014
No of Pages :
372
Book Format :
Paperback
Category :
Data Processing
other Related books
Cody's Data Cleaning Techniques Using SAS, Second Edition (SAS Press)
Cody's Data Cleaning Techniques Using SAS, Second Edition (SAS Press)
Author :
Ron Cody
Publisher :
SAS Institute
Published Date :
May 13, 2008
No of Pages :
272
Book Format :
Perfect Paperback
Category :
Data Processing
other Related books
ZooKeeper: Distributed Process Coordination
ZooKeeper: Distributed Process Coordination
Author :
Flavio Junqueira, Benjamin Reed
Publisher :
O'Reilly Media
Published Date :
Dec 5, 2013
No of Pages :
238
Book Format :
Paperback
Category :
Data Processing
other Related books
Getting started with Julia Programming Language
Getting started with Julia Programming Language
Author :
Ivo Balbaert
Publisher :
Packt Publishing - ebooks Account
Published Date :
Feb 27, 2015
No of Pages :
159
Book Format :
Paperback
Category :
Data Processing
other Related books
Business Intelligence For Dummies
Business Intelligence For Dummies
Author :
Swain Scheps
Publisher :
For Dummies
Published Date :
Jan 10, 2008
No of Pages :
388
Book Format :
Paperback
Category :
Data Processing
other Related books
Data Science at the Command Line: Facing the Future with Time-Tested Tools
Data Science at the Command Line: Facing the Future with Time-Tested Tools
Author :
Jeroen Janssens
Publisher :
O'Reilly Media
Published Date :
Oct 12, 2014
No of Pages :
212
Book Format :
Paperback
Category :
Data Processing
other Related books
Phylogenetic Trees Made Easy: A How To Manual, Fourth Edition
Phylogenetic Trees Made Easy: A How To Manual, Fourth Edition
Author :
Barry G. Hall
Publisher :
Sinauer Associates, Inc.
Published Date :
Apr 30, 2011
No of Pages :
255
Book Format :
Paperback
Category :
Data Processing
other Related books
Learning Apache Kafka, Second Edition
Learning Apache Kafka, Second Edition
Author :
Nishant Garg
Publisher :
Packt Publishing - ebooks Account
Published Date :
Feb 16, 2015
No of Pages :
120
Book Format :
Paperback
Category :
Data Processing
other Related books
Graph Theory (Graduate Texts in Mathematics)
Graph Theory (Graduate Texts in Mathematics)
Author :
Reinhard Diestel
Publisher :
Springer
Published Date :
Oct 31, 2010
No of Pages :
410
Book Format :
Paperback
Category :
Data Processing
other Related books
Hands-On Programming with R: Write Your Own Functions and Simulations
Hands-On Programming with R: Write Your Own Functions and Simulations
Author :
Garrett Grolemund
Publisher :
O'Reilly Media
Published Date :
Aug 2, 2014
No of Pages :
250
Book Format :
Paperback
Category :
Data Processing
other Related books
Data Algorithms: Recipes for Scaling Up with Hadoop and Spark
Data Algorithms: Recipes for Scaling Up with Hadoop and Spark
Author :
Mahmoud Parsian
Publisher :
O'Reilly Media
Published Date :
Jun 29, 2015
No of Pages :
778
Book Format :
Paperback
Category :
Data Processing
+

Editorial Reviews

No Editorial Reviews Available

Community Reviews

No Community Reviews Available

Press Releases

No Press Release found

Testimonials

No Data available

Market Place

ddddddddddd