|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910590069703321 |
|
|
Autore |
Aspin Adam |
|
|
Titolo |
Pro data mashup for Power BI : powering up with power query and the m language to find, load, and transform data / / Adam Aspin |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
[Place of publication not identified] : , : Apress, , [2022] |
|
©2022 |
|
|
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (497 pages) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Management information systems |
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di bibliografia |
|
|
|
|
|
|
Nota di contenuto |
|
1. Discovering and Loading Data with Power BI Desktop 2. Discovering and Loading File-Based Data with Power BI Desktop 3. Loading Data From Databases and Data Warehouses 4. DirectQuery and Live Connect 5. Loading Data from the Web and Cloud 6. Loading Data from Other Data Sources 7. Power Query 8. Structuring Data 9. Shaping Data 10. Data Cleansing 11. Data Transformation 12. Complex Data Structures 13. Organizing, Managing, and Parameterizing Queries 14. The M Language 15. Appendix A: Sample Data. |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The book also explains the use of Direct Query and Live Connect to establish instant connections to databases and data warehouses and avoid loading data. The book provides detailed guidance on techniques for transforming inbound data into normalized data sets that are easy to query and analyze. |
|
|
|
|
|
|
|