| Summary: | This book is a practical guide to Power Query (part of the Microsoft Power BI suite) which automates the process of getting data into Excel. Topics covered include: importing data from sources including relational databases, text files, web pages, Excel workbooks, Facebook, Windows Azure Marketplace, Wikipedia, and OData feeds; building repeatable processes to filter, clean, aggregate, and transform data; loading data into an Excel table or directly into the Excel 2013 Data Model; writing complex expressions in Power Query's M expression language; sharing queries and their data with other users; and positioning data for further analysis using Power View, Power Map, Power Pivot, and the rest of Microsoft's Power BI suite. This book is for readers interested in business intelligence from data analysis
|
|---|