Data mashup with Microsoft Excel using Power Query and M : finding, transforming, and loading data from external sources /

Mostrar otras versiones (1)

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 Excels Get and Transform feature set, showing you how to connect to a range of external databases and other...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Aspin, Adam
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress, 2020.
Temas:
Microsoft Excel (Computer file)
Electronic data processing.
Statistical matching.
Appariement (Statistique)
Microsoft programming.
Computers > Programming > Microsoft Programming.
Electronic data processing
Statistical matching
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Intro
  • Table of Contents
  • About the Author
  • About the Technical Reviewer
  • Acknowledgments
  • Introduction
  • What Is Power Query?
  • Connecting to Source Data
  • Data Transformation
  • Loading into a Worksheet or the Data Model
  • Integrating Power Query into Daily Workflows
  • The Evolution of Power Query
  • How to Use This Book
  • On to Learning Power Query
  • Chapter 1: Using Power Query to Discover and Load Data into Excel
  • Power Query
  • The Data Load Process
  • Why Use Power Query?
  • The Queries & Connections Pane
  • Displaying the Queries & Connections Pane
  • The Peek Window
  • Peek Window Options
  • View in Worksheet
  • Deleting a Query
  • Understanding Data Load
  • The Navigator Dialog
  • Select Multiple Source Tables
  • Searching for Datasets
  • Navigator Display Options
  • Only Selected Items
  • Enable Data Previews
  • Refresh
  • Source Data Refresh
  • Data Preview Refresh
  • Select Related Tables
  • The Navigator Data Preview
  • Modifying Data
  • The Power Query Editor
  • Data Sources
  • Source Data Properties
  • Query Properties
  • Load Destinations
  • Repurposing an Existing Connection
  • Load to Excel
  • Load to the Data Model
  • Conclusion
  • Chapter 2: Discovering and Loading File-Based Data with Power Query
  • File Sources
  • Loading Data from Files
  • CSV Files
  • What Is a CSV File?
  • Text Files
  • Text and CSV Options
  • File Origin
  • Delimiter
  • Data Type Detection
  • Fixed-Width Text Files
  • Simple XML Files
  • Excel Files
  • Why Use Power Query to Connect to Excel
  • From Table/Range
  • Microsoft Access Databases
  • JSON Files
  • Conclusion
  • Chapter 3: Loading Data from Databases and Data Warehouses
  • Relational Databases
  • SQL Server
  • Automatically Loading Related Tables
  • Database Options
  • Server Connection
  • Searching for Databases, Tables, and Views in Navigator
  • Searching for Databases
  • Searching for Tables
  • Database Security
  • Using a SQL Statement
  • Stored Procedures in SQL Server
  • Oracle Databases
  • Other Relational Databases
  • Microsoft SQL Server Analysis Services Data Sources
  • From Analysis Services
  • SSAS Tabular Data Warehouses
  • Types of Credentials When Connecting
  • Unable to Connect
  • Other Database Connections
  • Conclusion
  • Chapter 4: Loading Data from the Web and the Cloud
  • Web and Cloud Services
  • Web Pages
  • Online Services
  • Microsoft Azure
  • Web Pages
  • Advanced Web Options
  • Viewing the Source Web Page
  • Salesforce
  • Loading Data from Salesforce Objects
  • Salesforce Reports
  • Microsoft Dynamics 365
  • Azure SQL Database
  • Azure SQL Data Warehouse (Azure Synapse Analytics)
  • Connecting to SQL Server on an Azure Virtual Machine
  • Azure Blob Storage
  • Azure Security
  • Other Source Types
  • Conclusion
  • Chapter 5: Generic Data Sources
  • ODBC Sources
  • OLE DB Data Sources
  • OData Feeds
  • OData Options
  • Refreshing Data
  • Refreshing the Entire Data in the Excel In-Memory Model
  • Refreshing an Individual Query
  • Conclusion

Ejemplares similares