Microsoft Fabric Data Engineering Analyze data in a data warehouse скачать в хорошем качестве

Microsoft Fabric Data Engineering Analyze data in a data warehouse

Microsoft Fabric Data Warehouse Lab Objective: Build a data warehouse in Microsoft Fabric using T-SQL and visual tools to manage and analyze relational data. Duration: 30 minutes Prerequisites: Microsoft Fabric trial, web browser Lab Steps: Create Workspace Sign in to Microsoft Fabric Select Workspaces from left menu Create new workspace with descriptive name Choose Trial licensing Click Create Create Data Warehouse In workspace, click Create button Select Warehouse from Data Warehouse section Provide unique name and create Wait for deployment completion Create Tables and Insert Data Open T-SQL editor in warehouse Execute CREATE TABLE for DimProduct Refresh to confirm table creation New query: INSERT three product records Verify data in Explorer pane Load full schema from GitHub script Confirm four tables exist Query Tables New query joining FactSalesOrder and DimDate Calculate sales revenue by year and month Add customer region to analysis Group by year, month, and region Create View Modify query to CREATE VIEW vSalesByRegion Remove ORDER BY clause Refresh to view creation Test view with SELECT statement Visual Query Select New visual query from Home menu Drag FactSalesOrder to canvas Add DimProduct table Merge queries on ProductKey Expand DimProduct for ProductName Filter for Cable Lock Use visualization or export options Data Model Click New semantic model Name model and include all tables Position FactSalesOrder centrally Create relationships: FactSalesOrder.ProductKey to DimProduct FactSalesOrder.CustomerKey to DimCustomer FactSalesOrder.SalesOrderDateKey to DimDate Confirm star schema structure Clean Up Return to workspace Open settings via ellipsis menu Select Remove this workspace Confirm deletion Conclusion: Deployed data warehouse, created tables and views, executed analytical queries, utilized visual tools, and established data relationships. Established core skills for Microsoft Fabric analytics solutions.