02627nam 2200481 450 991059006970332120230113110312.01-4842-8578-610.1007/978-1-4842-8578-7(MiAaPQ)EBC7077809(Au-PeEL)EBL7077809(CKB)24746159600041(CaSebORM)9781484285787(OCoLC)1342534707(OCoLC-P)1342534707(PPN)264197445(EXLCZ)992474615960004120230113d2022 uy 0engurcnu||||||||txtrdacontentcrdamediacrrdacarrierPro data mashup for Power BI powering up with power query and the m language to find, load, and transform data /Adam Aspin[Place of publication not identified] :Apress,[2022]©20221 online resource (497 pages)Includes index.Print version: Aspin, Adam Pro Data Mashup for Power BI Berkeley, CA : Apress L. P.,c2022 9781484285770 Includes index.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.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.Management information systemsManagement information systems.658.501Aspin Adam895187MiAaPQMiAaPQMiAaPQBOOK9910590069703321Pro Data Mashup for Power BI2908691UNINA