Creating Views, Functions, and Stored ProceduresViewsFunctionsStored ProceduresEnriching DataEnriching Data in the Fabric Warehouse with SQLEnriching Data in the Fabric Lakehouse with NotebooksEnriching Data in the Fabric Lakehouse with Dataflow Gen2Refining DataJoins for Combining DataJoins in a Fabric WarehouseJoins in a Fabric Lakehouse Using NotebooksJoins in a Fabric Lakehouse Using Dataflow Gen2Summarizing DataAggregations to Summarize DataAggregation in a Fabric Warehouse with SQLAggregation in a Fabric Lakehouse with NotebooksAggregation in a Fabric Lakehouse with Dataflow Gen2Filters and Focusing on Relevant DataFiltering DataFiltering in a Fabric Warehouse with SQLFiltering in a Fabric Lakehouse with NotebooksFiltering in a Fabric Lakehouse with Dataflow Gen2Data TypesHandling and Resolving Duplicate, Missing, and NULL ValuesDeduplication: Removing Duplicate DataDeduplication in a Fabric Warehouse with SQLDeduplication in a Fabric Lakehouse with NotebooksDeduplication in a Fabric Lakehouse with Dataflow Gen2Handling NULLs and Missing ValuesHandling NULLs in a Fabric Warehouse with SQLHandling NULLs in a Fabric Lakehouse with NotebooksHandling NULLs in a Fabric Lakehouse with Dataflow Gen2Star Schema for Fabric Lakehouse and WarehouseStar Schema versus Snowflake SchemaImplementing a Star Schema in a Fabric LakehouseImplementing a Star Schema in a Fabric Warehouse with SQLGeneral Principles of Dimensional ModelingDenormalization of DataDenormalizing Tables with Power QuerySummary