وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

DP-600 Implementing Analytics Solutions Using Microsoft Fabric

سرفصل های دوره

1. Understand Microsoft Fabric Administration
  • 1. Introducing Microsoft Fabric
  • 2. Understand OneLake Architecture
  • 3. License and Explore Fabric - And Power BI
  • 4. Explore the Admin Settings
  • 5. Other Administrative Dev Tools
  • 6. CHALLENGE

  • 2. Perform ETL Ops with Dataflows Gen2
  • 1. Introducing Dataflows
  • 2. Extract Data
  • 3. Aggregate Data
  • 4. Merge Data
  • 5. Filter Data
  • 6. Rank Data
  • 7. Publish Data to a Lakehouse
  • 8. Schedule Automatic Data Refreshes
  • 9. CHALLENGE

  • 3. Perform Complex ETL with Data Pipelines
  • 1. Introducing Data Factory Pipelines
  • 2. Create a Data Source in Azure
  • 3. Create Your Dataflow to Transform Data
  • 4. Prep the Data Destinations
  • 5. Set the Data Destination and Create a Pipeline
  • 6. Validate and Run the Pipeline
  • 7. CHALLENGE

  • 4. Implement and Explore Lakehouses
  • 1. Introducing Fabric Lakehouses
  • 2. Recall Why OneLake and Lakehouses Matter
  • 3. Get Some Sample Data
  • 4. Create a Lakehouse and Upload Data Files
  • 5. Load Data Into Delta Tables
  • 6. Explore the SQL Analytics Endpoint
  • 7. Create a Shortcut
  • 8. CHALLENGE

  • 5. Build Queries and Reports on Lakehouse
  • 1. Introducing Lakehouse Frontend Data Analysis
  • 2. Understand Where Frontend Analytics Comes In
  • 3. Create a Visual Query
  • 4. Filter and Organize Data
  • 5. Transform and Add Columns
  • 6. Work with Semantic Models
  • 7. Create Reports
  • 8. CHALLENGE

  • 6. Work with Data Warehouses
  • 1. Introducing Data Warehouses
  • 2. Creating a Data Warehouse
  • 3. Perform DDL Operations
  • 4. INSERT and UPDATE Operations
  • 5. Alter Tables... Sort of
  • 6. Update Records with Calculations
  • 7. Copy Data From External Sources with COPY INTO
  • 8. CHALLENGE

  • 7. Work with Spark Notebooks
  • 1. Introducing Fabric Notebooks
  • 2. What Spark Really Is
  • 3. Load Data Into Spark Notebooks
  • 4. Set and Alter Schema Data Types and Columns
  • 5. Filter Data
  • 6. Aggregate, Group, and Sort Data
  • 7. CHALLENGE

  • 8. Integrate Spark Notebooks with Lakehouse
  • 1. Introducing Data Querying and Writing in Notebooks
  • 2. Join Dataframes
  • 3. Write Files to a Lakehouse
  • 4. Write Data to Delta Tables
  • 5. Querying with SQL and Python
  • 6. Scheduling and Orchestrating Notebooks
  • 7. CHALLENGE

  • 9. Begin Work with Semantic Models
  • 1. Introducing Semantic Models
  • 2. Get Some Data
  • 3. Create Semantic Model Relationships
  • 4. Auto-Generate a Report from Your Model
  • 5. Create DAX Measures
  • 6. Connect to Fabric with Power BI Desktop
  • 7. Connect to the SQL Analytics Endpoint
  • 8. Publish Apps
  • 9. CHALLENGE

  • 10. Design Semantic Models
  • 1. Introducing Semantic Model Design
  • 2. Dimensions and Facts
  • 3. Star and Snowflake Schema
  • 4. 1st Form Normalization
  • 5. 2nd and 3rd Form Normalization
  • 6. What Works Best for Analytics
  • 7. Merge Queries in Power Query
  • 8. CHALLENGE

  • 11. Learn DAX Fundamentals
  • 1. Introducing DAX and DAX Studio
  • 2. Install DAX Studio
  • 3. EVALUATE
  • 4. ORDER BY and FILTER
  • 5. SUMMARIZECOLUMNS
  • 6. Basic DAX Aggregations
  • 7. DEFINE
  • 8. Iterator - or X Functions
  • 9. CALCULATE
  • 10. Datetime Functions
  • 11. CHALLENGE

  • 12. Use External Semantic Modeling Apps
  • 1. Introducing External Modeling Tools
  • 2. DAX Studio Performance Analysis
  • 3. DAX Studio VertiPaq Analyzer
  • 4. ALM Toolkit
  • 5. Install and Browse Tabular Editor
  • 6. Use Tabular Editor Best Practices Analyzer
  • 7. Object Level Security
  • 8. Row Level Security
  • 9. CHALLENGE

  • 13. Implement Calculation Groups
  • 1. Introduction
  • 2. Understand Measure Sprawl
  • 3. Create a Calculation Group
  • 4. Create Calculation Items
  • 5. Use Calculation Groups in a Report
  • 6. Add Field Parameters to Switch Measures
  • 7. Create Calculation Groups in Power BI
  • 8. CHALLENGE

  • 14. Leverage the XMLA Endpoint
  • 1. Introducing the XMLA Endpoint
  • 2. Understand the Point of XMLA
  • 3. Governance and Configuration
  • 4. Connect and Query with SSMS
  • 5. Download and Deploy Models with Tabular Editor
  • 6. Query Models with DAX Studio
  • 7. Compare and Ship Models with ALM Toolkit
  • 8. CHALLENGE
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 42975
    حجم: 3749 مگابایت
    مدت زمان: 682 دقیقه
    تاریخ انتشار: ۲۹ دی ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید