Microsoft Fabric-Fundamentals and Power BI Workflow

425 Learners

Course Overview

Course Overview to be entered here

Skills Covered

  • Fabric Fundamentals
  • Lakehouse & Delta
  • Paginated Reports
  • Fabric Setup
  • Power BI Reporting
  • Fabric Fundamentals
  • Fabric Setup
  • Lakehouse & Delta
  • Power BI Reporting
  • Paginated Reports
  • Fabric Fundamentals
  • Fabric Setup
  • Lakehouse & Delta
  • Power BI Reporting
  • Paginated Reports

Course Curriculum

Course Content

  • Microsoft Fabric: Fundamentals and Power BI Workflow

    Preview
    • Lesson 01: Microsoft Fabric for Beginners – How to Get Started

      04:58:25Preview
      • 1.01 Fabric in a Nutshell and Key Terminologies
        04:16
      • 1.02 Enable the Fabric Trial Capacity
        02:36
      • 1.03 Our First Tour in the Microsoft Fabric SaaS Platform
        11:29
      • 1.04 The Fabric Workspace and Important Configuration Settings
        10:53
      • 1.05 Lakehouse Create Your First Fabric Item
        07:29
      • 1.06 Creating Delta Tables in Microsoft Fabric Lakehouses
        06:49
      • 1.07 Exploring the New Dataflow Gen 2 in Microsoft Fabric
        18:18
      • 1.08 Fabric Data Pipelines - How to Use Them to Create Delta Tables in Fabric
        07:07
      • 1.09 Data Pipeline Activities in Microsoft Fabric
        07:20
      • 1.10 Exploring the Fabric Lakehouse SQL Endpoint Using External Tools
        04:37
      • 1.11 Testing SQL and No Code SQL with the SQL Endpoint in MS Fabric
        12:04
      • 1.12 Auto Visualizing Data in Fabric with Power BI
        13:26
      • 1.13 Using Microsoft Fabric Items as Power BI Data Sources
        07:56
      • 1.14 Introduction to Warehouses in Microsoft Fabric
        16:15
      • 1.15 Data Engineering Notebook Introduction in Microsoft Fabric
        13:15
      • 1.16 PySpark and Pandas Examples in MS Fabric Notebooks
        09:38
      • 1.17 Parameterized Notebooks with Fabric Data Pipelines
        16:28
      • 1.18 Introduction to Version Control in Microsoft Fabric
        15:09
      • 1.19 Version Control for Power BI Reports in Microsoft Fabric
        12:02
      • 1.20 Exploring the Fabric One Lake File Explorer - The OneDrive for Fabric
        04:38
      • 1.21 Data Virtualization in MS Fabric - Create Your First Shortcuts
        07:26
      • 1.22 PySpark Without Code in Fabric - How to Use the DataWrangler in MS Fabric
        12:23
      • 1.23 Default Python Packages and Environment Configuration for Notebooks in Microsoft Fabric
        12:08
      • 1.24 Paginated Reports in Microsoft Fabric
        12:17
      • 1.25 Semantic Link in Fabric - Using Power BI Semantic Models in Notebooks
        15:34
      • 1.26 Refresh Power BI Semantic Models within Notebooks
        07:20
      • 1.27 Real-time Streaming and Eventhouses in Microsoft Fabric
        14:58
      • 1.28 The Powerful Version History Attribute of Delta Tables in MS Fabric
        14:34
    • Lesson 02: Prerequisites – Microsoft Power BI within Microsoft Fabric

      25:43
      • 2.01 Microsoft Fabric for Power BI Developers
        00:54
      • 2.02 Key Terminologies in Microsoft Fabric
        02:51
      • 2.03 Getting Started with Power BI in Microsoft Fabric – Setting Up the Workspace
        12:10
      • 2.04 Creating Our First Fabric Item – The Data Storage
        09:48
    • Lesson 03: Data Preparation for Power BI Inside Microsoft Fabric

      01:15:55Preview
      • 3.01 Getting Data into Fabric Leveraging Dataflow Gen 2
        09:54
      • 3.02 A Brief Introduction to Dataflow Generation 2
        05:55
      • 3.03 Extending the Dataflow with Relevant Web Data
        04:30
      • 3.04 Dataflow Gen2 Data Preparation Walkthrough
        26:59
      • 3.05 Table Changes and Dataflow Gen 2 Special Features
        07:25
      • 3.06 Convert Uploaded Excel Files to Delta Tables in Microsoft Fabric
        08:27
      • 3.07 New Append Option in Dataflow Gen 2 Step by Step
        03:51
      • 3.08 Building Our Semantic Model for Power BI Reports
        08:54
    • Lesson 04: Power BI Report Creation in Microsoft Fabric

      23:41Preview
      • 4.01 Automatic Power BI Report Creation in Microsoft Fabric
        05:11
      • 4.02 Create Power BI Reports Tailored to Your Own Specific Needs
        04:26
      • 4.03 Fabric Semantic Model Report Creation with Power BI Desktop
        04:32
      • 4.04 Paginated Reports with Microsoft Fabric without Report Builder
        09:32
    • Lesson 05: Power BI Connection Modes and Local Model Extension

      39:53
      • 5.01 New Power BI Connection Modes with Direct Lake
        10:20
      • 5.02 Connection Modes and Extending Fabric Semantic Models with Additional Data
        11:30
      • 5.03 Explicit Measures and a Quick Time Intelligence DAX Check
        05:01
      • 5.04 Local Models Many to Many Relationship and Snowflake Schemas
        13:02
    • Lesson 06: Further Power BI Related Concepts and Important Items in Fabric Related to Power

      29:12Preview
      • 6.01 Introduction to Task Flows in Fabric Power BI Experience
        07:38
      • 6.02 Lakehouse Connection Modes from Power BI Desktop
        06:42
      • 6.03 The One Lake File Explorer for Windows
        01:37
      • 6.04 Using External Tools to Connect to the SQL Endpoint of Microsoft Fabric Lake
        03:15
      • 6.05 Semantic Model Synchronization to One Lake Delta Tables
        10:00
    • Lesson 07: Bonus: Power BI SharePoint Connection – Best Practices

      03:48
      • 7.01 Power BI SharePoint Connection Best Practices
        03:48

Why Join this Program

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts
  • Acknowledgement
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.