Microsoft Fabric Quick Start

Overview "Microsoft Fabric: Quick Start" is a one-day course that provides a comprehensive overview of Microsoft's Fabric data storage environment. Suitable for Data Analysts, Data Engineers, Data Scientists, and Power BI users, this course explores the various components of Microsoft Fabric, including lakehouses, Apache Spark, Delta Lake tables, Data Factory pipelines, and more. _ Participants will learn how to leverage Microsoft Fabric for large-scale data analytics, data ingestion, and transformation tasks. The course also covers the creation of relational data warehouses, real-time analytics, and data science capabilities within Microsoft Fabric. Finally, it delves into the administrative aspects of Microsoft Fabric, including security and data governance. Special Note: Fabric Planning Session for Managers This course is also available in a half-day format for managers wanting an overview of the new Fabric environment so that they can plan for a Fabric implementation in their organization. When taught in this format, there is less time allocated for hands-on practice, and more time for discussing implementation and governance issues. Who Should Attend This course is appropriate for these roles: Data Analyst, Data Engineer, Data Scientist, and Power BI users who want to explore the capabilities of Microsoft Fabric. Prerequisites You should be familiar with basic data concepts and terminology. Course Outline Introduction to end-to-end analytics using Microsoft Fabric Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs. Explore end-to-end analytics with Microsoft Fabric Data teams and Microsoft Fabric Enable and use Microsoft Fabric Get started with lakehouses in Microsoft Fabric Lakehouses merge data lake storage flexibility with data warehouse analytics. Microsoft Fabric offers a lakehouse solution for comprehensive analytics on a single SaaS platform. Explore the Microsoft Fabric Lakehouse Work with Microsoft Fabric Lakehouses Use Apache Spark in Microsoft Fabric Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data in a Lakehouse at scale. Prepare to use Apache Spark Run Spark code Work with data in a Spark dataframe Work with data using Spark SQL Visualize data in a Spark notebook Work with Delta Lake tables in Microsoft Fabric Tables in a Microsoft Fabric lakehouse are based on the Delta Lake storage format commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions. Understand Delta Lake Create delta tables Work with delta tables in Spark Use delta tables with streaming data Use Data Factory pipelines in Microsoft Fabric Microsoft Fabric includes Data Factory capabilities, including the ability to create pipelines that orchestrate data ingestion and transformation tasks. Understand pipelines Use the Copy Data activity Use pipeline templates Run and monitor pipelines Ingest Data with Dataflows Gen2 in Microsoft Fabric Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows (Gen2) for visually creating multi-step data ingestion and transformation using Power Query Online. Understand Dataflows (Gen2) in Microsoft Fabric Explore Dataflows (Gen2) in Microsoft Fabric Integrate Dataflows (Gen2) and Pipelines in Microsoft Fabric Get started with data warehouses in Microsoft Fabric Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution. Understand data warehouse fundamentals Understand data warehouses in Fabric Query and transform data Prepare data for analysis and reporting Secure and monitor your data warehouse Get started with Real-Time Analytics in Microsoft Fabric Analysis of real-time data streams is a critical capability for any modern data analytics solution. You can use the Real-Time Analytics capabilities of Microsoft Fabric to ingest, query, and process streams of data. Introduction What is Synapse Real-Time Analytics? Understand KQL database and tables Write queries with KQL Exercise: Explore Synapse Real-Time Analytics in Fabric Get started with data science in Microsoft Fabric In Microsoft Fabric, data scientists can manage data, notebooks, experiments, and models while easily accessing data from across the organization and collaborating with their fellow data professionals. Understand data science Explore data science in Microsoft Fabric Use MLflow to track your experiments Exercise - Train and track a model in Microsoft Fabric Administer Microsoft Fabric Microsoft Fabric is a SaaS solution for end-to-end data analytics. As an administrator, you can configure features and manage access to suit your organization's needs. Understand the Fabric Architecture Understand the Fabric administrator role Manage Fabric security Govern data in Fabric