Continue with free course enrollment


Looking for Live Class Room

Enroll For Paid Course

Get Fabricated- Learn Microsoft Fabric, Power BI, SQL, Power Query, DAX, Dataflow Gen2, Data Pipeline

Get Microsoft Fabric-Ready, Learn the Leading Analytics Tool- Power BI.

  • Master Data Flow Gen2 with Power Query, Lakehouse, Warehouse, SQL, DAX, and Data Pipelines.
  • Learn how to use Data Flow Gen2 to transform data for your Lakehouse, Warehouse, SQL, DAX, and Data Pipelines projects.
  • Get hands-on experience with Data Flow Gen2 in this comprehensive course that covers Power Query, Lakehouse, Warehouse, SQL, DAX, and Data Pipelines.
  • Take your data skills to the next level with this free course on Data Flow Gen2, Power Query, Lakehouse, Warehouse, SQL, DAX, and Data Pipelines.
  • Build your own data pipelines and transform data for your Lakehouse, Warehouse, SQL, DAX, and Data Pipelines projects with this self-paced course

Instructor: Amit ChandakLanguage: English

About the course

Get Fabricated with Microsoft Fabric

Accelerate the initiation of your Microsoft Fabric, coupled with comprehensive exploration of Power BI, Power Query, and DAX.

This course amalgamates my extensive collection of videos and blog posts from diverse platforms, meticulously curated to optimize your learning journey.

Enjoy complimentary access until the first week of July.

Course Objectives:
Upon completion of the course, learners will be able to,

  • Understand the key features and functionalities of Microsoft Fabric
  • What is LakeHouse
  • What is Warehouse
  • What is Dataflow Gen2
  • What is Data Pipeline
  • How run Incremental ETL on Fabric

Complete Power BI course
https://www.youtube.com/watch?v=cN8AO3_vmlY
1.    Introduction
2.    Basic Concepts 
3.    Download and Install Power BI
4.    Quick Look at Power BI Desktop Dec 2022
5.    Create Power Bi Login
6.    Login/Sign in to Power B
7.    Power BI EcoSystem
8.    Power Bi Licenses 
9.    Power Bi Desktop Overview
10.    Power BI Options & Settings
11.    Covid Data Analysis 
12.    Download the data 
13.    Overview of Data
14.    Load Data into Power BI
15.    Column Tools 
16.    Data Model Property Pane
17.    Check No Join issue
18.    Single Vs Bi-Directional Join
19.    Update Power BI Theme
20.    Create Calculated Columns and Measures
21.    Calculate with and Without filter 
22.    Expression Functions SUMX,MINX, MAXX
23.    isfiltered, hasonevalue
24.    Table Visual
25.    Gradient Conditional Formatting 
26.    Rule based Conditional Formatting 
27.    Data Bars
28.    URL Icon 
29.    Matrix Visual 
30.    Switch Values to Row
31.    Stepped Layout off
32.    Desc Sort on Matrix Column 
33.    Bar Visual 
34.    Concatenate Label off
35.    Measure Based Conditional Formatting
36.    Pie/Donut Visual
37.    Line Visual 
38.    Area Visual
39.    Tree Map Visual 
40.    Stacked Visual 
41.    Combo Visual
42.    Small Multiples 
43.    Card Visual
44.    Multi Row Card
45.    Scatter Visual 
46.    Scatter Visual with quadrants conditional formatting
47.    Map, Shape Map, Filled Map, Security Settings
48.    Decomposition Tree
49.    Q&A Visual
50.    DAX Earlier
51.    Date Table
52.    Date Table FY Columns
53.    DAX Search, Find
54.    DAX containsstring, containsstringexact
55.    DAX Left, Right, Mid
56.    calculatetable
57.    Summarize
58.    Summarize Vs Groupby
59.    Summarize in Measures
60.    SummarizeColumns, Except, Distinct
61.    Generateseries 
62.    Generate, Cross join
63.    all, allselected, removefilters
64.    allexcept
65.    rankx, topn
66.    dynamic topn with numeric parameters
67.    Firstnonblankvalue, Lastnonblankvalue
68.    Distinct count using values/summarize  
69.    Power BI Time Intelligence Setup 
70.    totalmtd, datesmtd, datesqtd, datesytd
71.    Last datesmtd, Last datesqtd, Last datesytd
72.    Trailing Day, Week, Month, Qtr, Year, Year Week
73.    Previousmonth, previousquarter, previousyear 
74.    Week on Week, WTD
75.    Half(custom period) Till Date, HoH,Period on Period
76.    DAX offset
77.    DAX isinscope 
78.    DAX window
79.    DAX Index
80.    Power BI Visual Interaction
81.    Power BI Bookmarks 
82.    Field Parameter, Measure Slicer, Axis Slicer
83.    Drill Through 
84.    Tooltip 
85.    Introduction to Power Query
86.    Use First Row As a header, Remove Blank and Duplicates
87.    Power Query UnPivot Data
88.    Power Query Pivot Data
89.    Power Query Transpose Data
90.    Power Query Fill Up, Fill Down
91.    Power Query Replace Values
92.    Power Query Text Operations
93.    Power Query Append Tables
94.    Power Query Merge Tables
95.    Power Query Custom Column
96.    Power Query Extract Data
97.    Column Quality, Profile and Distribution
98.    Clean Power BI File
99.    Publish Power BI File, Analyze on Power Bi Service
100.    Create Report in Power BI Service
101.    Power Bi Service Dashboard
102.    Power Bi Service App
103.    Power BI Dataflow
104.    Power BI Live Connection
105.    Power Bi Tenant Setting
 

Syllabus

Meet Biworld

Join an exclusive members-only community, get high-quality structured courses, memberships, and much more.

What do we offer

Live learning

Learn live with top educators, chat with teachers and other attendees, and get your doubts cleared.

Structured learning

Our curriculum is designed by experts to make sure you get the best learning experience.

Community & Networking

Interact and network with like-minded folks from various backgrounds in exclusive chat groups.

Learn with the best

Stuck on something? Discuss it with your peers and the instructors in the inbuilt chat groups.

Practice tests

With the quizzes and live tests practice what you learned, and track your class performance.

Get certified

Flaunt your skills with course certificates. You can showcase the certificates on LinkedIn with a click.

Reviews and Testimonials

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
𝕏
Biworld 2024 Privacy policy Terms of use Contact us Refund policy