Power query for Power BI and Excel:

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

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Beteilige Person: Webb, Chris 1975- (VerfasserIn)
Format: Elektronisch E-Book
Sprache:Englisch
Veröffentlicht: [Berkeley, CA] Apress 2014
Schriftenreihe:Expert's voice in business intelligence
Schlagwörter:
Links:https://learning.oreilly.com/library/view/-/9781430266921/?ar
Zusammenfassung: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.
Beschreibung:Online resource; title from PDF title page (EBSCO, viewed November 30, 2017)
Umfang:1 Online-Ressource (xv, 150 Seiten) illustrations
ISBN:9781430266921
1430266929