LEADER 02627nam 2200481 450 001 9910590069703321 005 20230113110312.0 010 $a1-4842-8578-6 024 7 $a10.1007/978-1-4842-8578-7 035 $a(MiAaPQ)EBC7077809 035 $a(Au-PeEL)EBL7077809 035 $a(CKB)24746159600041 035 $a(CaSebORM)9781484285787 035 $a(OCoLC)1342534707 035 $a(OCoLC-P)1342534707 035 $a(PPN)264197445 035 $a(EXLCZ)9924746159600041 100 $a20230113d2022 uy 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aPro data mashup for Power BI $epowering up with power query and the m language to find, load, and transform data /$fAdam Aspin 210 1$a[Place of publication not identified] :$cApress,$d[2022] 210 4$dİ2022 215 $a1 online resource (497 pages) 300 $aIncludes index. 311 08$aPrint version: Aspin, Adam Pro Data Mashup for Power BI Berkeley, CA : Apress L. P.,c2022 9781484285770 320 $aIncludes index. 327 $a1. 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. 330 $aThis 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. 606 $aManagement information systems 615 0$aManagement information systems. 676 $a658.501 700 $aAspin$b Adam$0895187 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910590069703321 996 $aPro Data Mashup for Power BI$92908691 997 $aUNINA