Microsoft Fabric: Working with Data Lakehouses
Microsoft Fabric 2024
| Expert
- 17 videos | 2h 12m 42s
- Earns a Badge
Microsoft Fabric's OneLake includes a data lakehouse that combines some of the most attractive features of data warehouses and data lakes. Heavily leveraging Delta tables as well as Apache Spark, it also adds the power of Power BI and Power Query. In this course, you'll explore data warehouses, comparing them with Azure Data Lake and Amazon S3. You'll build your first data lakehouse in Microsoft Fabric, running T-SQL queries, exploring parquet files and the delta log. You'll write SQL queries, construct visual queries and work with Spark notebooks, using PySpark and SparkSQL. After that, you'll study the Delta Lake architecture and its implementation as Delta tables. You'll explore data ingestion, including data pipelines, dataflows, and Spark notebooks. Finally, you'll create visual queries from the SQL analytics endpoint, learn about query folding, work with M-language expressions, and create and customize Power BI reports. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this courseDefine and enumerate attributes of structured, semi-structured and unstructured dataAnalyze features, benefits, drawbacks and important examples of data warehousesEnumerate important examples of data lakes and contrast them with data warehousesAnalyze data lakehouses in relation to data warehouses and data lakes and determine microsoft fabric's place amid important data lakehousesCreate a new workspace and a lakehouse within itCreate a delta table from an uploaded file and examine the parquet files and delta logRun t-sql queries and visual queries on data in a delta tableCreate a spark notebook and use pyspark and sparksql to work with delta tables and files
-
Analyze features, benefits and drawbacks of data lakesOutline the architecture of a typical data lakehouse and analyze onelake and its constituent offerings, including data lakehouses, data warehouses, and kql databasesDefine and analyze the delta lake open-source storage layer and its implementation in the form of delta tablesSpecify methods of ingesting data into fabric lakehouses, including data pipelines, dataflows, spark notebooks, and the lakehouse explorerCreate a visual query, view the equivalent t-sql, and open the visual query in the power query editorExamine query folding, how it is sometimes impossible to convert a visual query to t-sql, and how to add m-language steps to a visual queryCreate, customize and save power bi reports in a data lakehouseSummarize the key concepts covered in this course
IN THIS COURSE
-
2m 9sIn this video, you will discover the key concepts covered in this course. FREE ACCESS
-
9m 6sLearn how to define and enumerate attributes of structured, semi-structured and unstructured data. FREE ACCESS
-
7m 49sIn this video, discover how to analyze features, benefits, drawbacks and important examples of data warehouses. FREE ACCESS
-
5m 1sDuring this video, you will learn how to enumerate important examples of data lakes and contrast them with data warehouses. FREE ACCESS
-
9m 27sFind out how to analyze data lakehouses in relation to data warehouses and data lakes and determine Microsoft Fabric's place amid important data lakehouses. FREE ACCESS
-
9m 12sUpon completion of this video, you will be able to create a new workspace and a lakehouse within it. FREE ACCESS
-
11m 2sDuring this video, you will learn how to create a delta table from an uploaded file and examine the parquet files and delta log. FREE ACCESS
-
6m 1sAfter completing this video, you will be able to run T-SQL queries and visual queries on data in a delta table. FREE ACCESS
-
7m 45sIn this video, you will learn how to create a spark notebook and use PySpark and SparkSQL to work with delta tables and files. FREE ACCESS
-
8m 52sDiscover how to analyze features, benefits and drawbacks of data lakes. FREE ACCESS
-
7m 17sLearn how to outline the architecture of a typical data lakehouse and analyze OneLake and its constituent offerings, including data lakehouses, data warehouses, and KQL databases. FREE ACCESS
-
8m 17sIn this video, learn how to define and analyze the Delta Lake open-source storage layer and its implementation in the form of delta tables. FREE ACCESS
-
6m 45sDiscover how to specify methods of ingesting data into Fabric Lakehouses, including data pipelines, dataflows, Spark notebooks, and the Lakehouse explorer. FREE ACCESS
-
7m 31sFind out how to create a visual query, view the equivalent T-SQL, and open the visual query in the Power Query editor. FREE ACCESS
-
12m 29sLearn how to examine query folding, how it is sometimes impossible to convert a visual query to T-SQL, and how to add M-language steps to a visual query. FREE ACCESS
-
12m 1sAfter completing this video, you will be able to create, customize and save Power BI reports in a data lakehouse. FREE ACCESS
-
1m 59sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.