Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Power Query for Power BI and Excel

Buy
Power Query for Power BI and Excel, 9781430266914 (1430266910), Apress, 2014

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

 

(HTML tags aren't allowed.)

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book...
Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence
Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence

Design, create and manage robust Power BI solutions to gain meaningful business insights

Key Features

  • Master all the dashboarding and reporting features of Microsoft Power BI
  • Combine data from multiple sources, create stunning visualizations and publish your reports across...
Using R for Data Analysis in Social Sciences
Using R for Data Analysis in Social Sciences
Statistical analysis is common in the social sciences, and among the more popular programs is R. This book provides a foundation for undergraduate and graduate students in the social sciences on how to use R to manage, visualize, and analyze data. The focus is on how to address substantive questions with data analysis and replicate...

Mathematical Olympiad Challenges
Mathematical Olympiad Challenges
This significantly revised and expanded second edition of "Mathematical Olympiad Challenges" is a rich collection of problems put together by two experienced and well-known professors and coaches of the U.S. International Mathematical Olympiad Team. Hundreds of beautiful, challenging, and instructive problems from algebra, geometry,...
Visual Basic 2005 Cookbook: Solutions for VB 2005 Programmers (Cookbooks)
Visual Basic 2005 Cookbook: Solutions for VB 2005 Programmers (Cookbooks)

This book will help you solve more than 300 of the most common and not-so-common tasks that working Visual Basic 2005 programmers face every day. If you're a seasoned .NET developer, beginning Visual Basic programmer, or a developer seeking a simple and clear migration path from VB6 to Visual Basic 2005, the ...

Oracle Warehouse Builder 11g R2: Getting Started 2011
Oracle Warehouse Builder 11g R2: Getting Started 2011

Competing in today's world requires a greater emphasis on strategy, long-range planning, and decision making, and this is why businesses are building data warehouses. Data warehouses are becoming more and more common as businesses have realized the need to mine the information that is stored in electronic form. Data warehouses provide...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy