Microsoft Fabric Data Flows and Data Storage

Microsoft Fabric Data Flows and Data Storage

1h 45mIntermediate2024-01-19

Authors

Ginger Grant

Ginger Grant

Course details

Microsoft Fabric is an integrated cloud data environment that includes data lakehouses, data warehousing, data transformation, and machine learning. Explore the different components of data in Microsoft Fabric as well as how to get started organizing data lakes, developing and managing data factory pipelines, and implementing data engineering solutions with third-party notebooks, Python, and Spark. Instructor Ginger Grant also shows you how to secure data stored in one lake and in data lakes within Microsoft Fabric.

This course is designed for analytics professionals with data and dimensional modeling experience who are interested in learning how Microsoft Fabric can be applied to enterprise data environments.

Skills covered

Microsoft FabricEnterprise Content ManagementCloud StorageBusiness AnalysisProject ManagementNetwork and System AdministrationCloud ComputingBusiness Analysis and StrategyMicrosoftOne-Off

Concepts

Introduction

  • Implementing Microsoft Fabric
  • What you should know
  • Course data configuration

Introducing Microsoft Fabric

  • Microsoft Fabric overview
  • Microsoft Fabric environment
  • Microsoft Fabric data component review
  • Compute engines in Microsoft Fabric
  • Challenge - Examining the lakehouse
  • Solution - Examining the lakehouse

Data Organization in Microsoft Fabric

  • OneLake architecture
  • Data organization
  • Adding data to OneLake
  • Using data wrangling to examine your data
  • Challenge - Creating and using pipelines
  • Solution - Creating and using pipelines

Security in Fabric

  • Fabric security overview
  • Workspace permissions and access
  • Fabric compute
  • Challenge - Implementing database roles
  • Solution - Implementing database roles

Integrating OneLake with Power BI

  • OneLake and Power BI data modeling
  • Data transformation with dataflows
  • Using SQL endpoints
  • Using AI with Power BI

Conclusion

  • Further your knowledge with Fabric
40,000 Toman