Cargando…

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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Webb, Chris, 1975- (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Berkeley, CA] : Apress, 2014.
Colección:Expert's voice in business intelligence.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Descripción
Sumario: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.
Descripción Física:1 online resource (xv, 150 pages) : illustrations
ISBN:9781430266921
1430266929