Microsoft Fabric & OneLake: Data Engineering for Excel Professionals

di Imad Muratspahic (Autore)

neobooks, 2026

Microsoft Fabric & OneLake: Data Engineering for Excel Professionals is the ninth volume of the Advanced Excel & Data Modeling series — a production-oriented guide to Microsoft's unified data platform, written specifically for professionals who already know Excel, Power Query, and Power BI. It opens with the architecture: OneLake as the single tenant-wide Delta lake, tenants vs capacities vs workspaces, and the seven engines that read the same physical storage. Then it walks through the Lakehouse and Warehouse items, Data Factory pipelines, and the full medallion pattern — Bronze (raw with metadata), Silver (clean and conformed), Gold (star schema), and Serving (Direct Lake). The data engineering section covers Spark notebooks, Delta Lake with time travel and MERGE, partitioning and file layout, PySpark and Spark SQL, Dataflows Gen2, KQL for real-time, Git integration with CI/CD, data quality with quarantine patterns, incremental loading with watermarks, performance tuning with ZORDER and broadcast joins, capacity management and CU monitoring, security with Purview and OneLake roles, and cost optimization. The integration section shows how Excel, Power BI, and Power Query compose with Fabric, plus an honest comparison against Synapse, Databricks, and Snowflake, and the team topology that makes Fabric projects succeed. It closes with eight full case studies — a 500-million-row retail platform, migrating a Power BI import model to Direct Lake, real-time telemetry with KQL, a full medallion with Git and deployment pipelines, monitoring and alerting, security for regulated industries, halving the capacity bill, and the mindset that outlasts the platform.

• Autore: Imad Muratspahic
• Anno edizione: 2026
• Editore: neobooks
• Formato: EPUB2 con Adobe DRM
• Lingua: Tedesco
• Compatibilità: Tutti i dispositivi (eccetto Kindle)
• Layout: Reflowable
• EAN: 9783565996612