Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data from External Sources

Data Mashup with Microsoft Excel Using Power Query and M Finding, Transforming, and Loading Data from External Sources

Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other...

Descripción completa

Detalles Bibliográficos
Autor principal: Aspin, Adam. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2020.
Edición:1st ed. 2020.
Materias:
Microsoft Excel (Computer file)
Microsoft software.
Microsoft .NET Framework.
Microsoft and .NET.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630999006719
Tabla de Contenidos:
  • 1. Using Power Query to Discover and Load Data into Excel
  • 2. Discovering and Loading File-Based Data with Power Query
  • 3. Loading Data from Databases and Data Warehouses
  • 4. Loading Data from the Web and the Cloud
  • 5. Generic Data Sources
  • 6. Structuring Imported Data
  • 7. Data Transformation
  • 8. Restructuring Data
  • 9. Complex Data Loads
  • 10. Organizing and Managing Queries
  • 11. Parameterizing Queries
  • 12. The M Language
  • 13. Appendix A: Sample Data.

Ejemplares similares