Precon: Creating a modern data environment in Microsoft Fabric-Ginger & Belinda

This workshop will provide participants with the knowledge and tools needed to create an enterprise-ready Microsoft Fabric datastore from scratch using either SQL DB, Lakehouse, or Warehouse. The workshop covers everything from getting started, gathering data from different sources, transforming the data into an analytical model, securing access, and monitoring its performance. As Fabric provides many methods for performing these tasks, we will cover a variety of development tools, including shortcuts, copying data, pipelines, Data Flow Gen 2, and notebooks, and explain which is the best choice in a given situation. Participants will practice the steps through hands-on exercises using medallion architecture to transform data into an analytical lakehouse or warehouse, which can be used for ad hoc querying and, of course, as a source for Power BI reports. Participants will learn how to provide ongoing maintenance, security, and monitoring of the processes to ensure it is an enterprise-level solution. The workshop experience and examples will provide participants with the knowledge needed to implement the techniques to create their own lakehouse and warehouse. We will also review security and DevOps with Fabric.

By the end of the session, participants will not only understand the technical steps involved but also when and which data architecture to choose for their organizational data needs.