Pro Data Mashup for Power BI
Powering Up with Power Query and the M Language to Find, Load, and Transform Data
Taschenbuch
BOD - 2 Tage | Lieferzeit: BOD - 2 Tage I
62,91 €*
Alle Preise inkl. MwSt.| Versandkostenfrei
Sicherheits- und Produktressourcen
Bilder und Kontakte
Sicherheitsbilder- und Kontakte
Artikelnummer:
9781484285770
Veröffentlichungsdatum:
2022
Einband:
Taschenbuch
Erscheinungsdatum:
26.08.2022
Seiten:
508
Autor:
Adam Aspin
Gewicht:
945 g
Format:
254x178x28 mm
Sprache:
Englisch
Langbeschreibung
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.
Hauptbeschreibung
Teaches you to cleanse, prepare, and transform external data
Inhaltsverzeichnis
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.