Synopsis
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 iscovered 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
"synopsis" may belong to another edition of this title.
About the Author
Chris Webb is a UK-based consultant and trainer specializing in the Microsoft Business Intelligence stack. He has co-authored three books - MDX Solutions, Expert Cube Development with Microsoft SQL Server Analysis Services 2008, and SQL Server Analysis Services 2012: The BISM Tabular Model and is a regular speaker at conferences and user groups around the world. He blogs at http://cwebbbi.wordpress.com.
"About this title" may belong to another edition of this title.
Search results for Power Query for Power BI and Excel
Seller Image
Power Query for Power BI and Excel
Seller: Austin Goodwill 1101, Austin, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: acceptable. Book shows noticeable wear from use. May include writing, highlighting, or other markings, but not excessive. Cover or edges may have visible wear. The book remains complete and fully readable. Seller Inventory # 4RZUP6001MKR
Stock Image
Power Query for Power BI and Excel
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_437801478
Stock Image
Power Query for Power BI and Excel
Seller: Books From California, Simi Valley, CA, U.S.A.
Seller rating 4 out of 5 stars
paperback. Condition: Fine. Seller Inventory # mon0003656130
Stock Image
Power Query for Power BI and Excel
Published by
Apress, New York, New York, U.S.A., 2014
ISBN 10: 1430266910
ISBN 13: 9781430266914
Used
Soft cover
Seller: Elizabeth Brown Books & Collectibles, San Diego, CA, U.S.A.
Seller rating 5 out of 5 stars
Soft cover. Condition: Very Good to Fine. No Jacket. Near fine with a hint of rubbing and scuffing to glossy paper wraps. Trace soil to text edges. Otherwise tight, bright, unmarked interior. NO remainder marks. Shipping confirmed! Seller Inventory # 011250
Stock Image
Power Query for Power BI and Excel
Seller: GoldBooks, Denver, CO, U.S.A.
Seller rating 5 out of 5 stars
Condition: new. Seller Inventory # 21C64_69_1430266910
Stock Image
Power Query for Power BI and Excel
Seller: Sell Books, Elland, YORKS, United Kingdom
Seller rating 5 out of 5 stars
paperback. Condition: Very Good. Most of our very good books have only minor imperfections such as shelf wear consistent with a new book that's sat on a bookshop shelf for a year or two. Occasionally we may miss other minor imperfections as we have to grade books at speed. Our books are dispatched from a Yorkshire former cotton mill. We list via barcode/ISBN so please note that the images are stock images and may not be the exact copy you receive, furthermore the details about edition and year might not be accurate as many publishers reuse the same ISBN for multiple editions and as we simply scan a barcode or enter an ISBN we do not check the validity of the edition data when listing. If you're looking for an exact edition please don't order (at least not without checking with us first, although we don't always have time to check). We aim to dispatch prompty, the service used will depend on order value and book size. We can ship to most countries, see our shipping policies. Payment is via Abe only. Seller Inventory # mon0000026990
Buy Used
£ 22.94
£ 12.15 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Stock Image
Power Query for Power BI and Excel (eng)
Print on DemandSeller: Brook Bookstore On Demand, Napoli, NA, Italy
Seller rating 4 out of 5 stars
Condition: new. Questo è un articolo print on demand. Seller Inventory # c1d5ec302dc0e75db7b5825fa3f5aaa1
Buy New
£ 44.76
£ 5.88 shipping
Ships from Italy to U.S.A.
Ships from Italy to U.S.A.
Quantity: Over 20 available
Stock Image
Power Query for Power Bi and Excel
Seller: Books Puddle, New York, NY, U.S.A.
Seller rating 4 out of 5 stars
Condition: New. pp. 272. Seller Inventory # 26127083130
Stock Image
Power Query for Power Bi and Excel
Seller: Majestic Books, Hounslow, United Kingdom
Seller rating 4 out of 5 stars
Condition: New. pp. 272 3:B&W 7.5 x 9.25 in or 235 x 191 mm Perfect Bound on White w/Gloss Lam. Seller Inventory # 132423077
Buy New
£ 70.58
£ 6.50 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Seller Image
Power Query for Power BI and Excel
Print on DemandSeller: BuchWeltWeit Ludwig Meier e.K., Bergisch Gladbach, Germany
Seller rating 5 out of 5 stars
Taschenbuch. Condition: Neu. This item is printed on demand - it takes 3-4 days longer - Neuware -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 iscovered 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 ExcelHelps you solve common, data-related problems with Power QueryShows how to write your own solutions in the powerful M language 272 pp. Englisch. Seller Inventory # 9781430266914