Lakehouse VS Warehouse VS Datamart The Difference Between The Three Fabric Objects

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 มิ.ย. 2023
  • Three types of objects in the Microsoft Fabric have similarities in what they can do for an analytics system. These three are; Lakehouse, Data Warehouse, and Power BI Datamart. All three objects provide storage for the data, which can be loaded into them using an ETL process and read using something like a Power BI report. In this article and video, I'll explain the actual differences and how to choose the best option for your implementation and architecture.
    Read my article about it here:
    radacad.com/lakehouse-vs-ware...
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 27

  • @oscarzapatajr2
    @oscarzapatajr2 ปีที่แล้ว +9

    By the way Reza, I believe you are doing a fantastic job covering fabric content... I follow quite a few Power BI TH-cam channels and I believe your coverage on fabric is first class 👌

    • @RADACAD
      @RADACAD  ปีที่แล้ว +1

      It is awesome to hear that Oscar! Thanks :)

  • @rossgh76
    @rossgh76 9 หลายเดือนก่อน

    Thank you Reza for providing a clear overview of Fabric

  • @MrRskpsannaksr
    @MrRskpsannaksr 10 หลายเดือนก่อน +1

    This is of great help I had a dilemma of what need to be purchased for our organization and the explanation from a persona perspective helped a lot!! Thanks a ton

    • @RADACAD
      @RADACAD  10 หลายเดือนก่อน

      Glad it was helpful!

  • @ranjanroy1623
    @ranjanroy1623 ปีที่แล้ว +3

    Very Informative as always Reza, Looking forward for next session I would also learn a bit more around Direct Lake and what it offers .If you have any links/ sources about Direct Lake pls share !
    One more thing, your video picture is hiding certain details on the presentation page , especially on the comparison table chart ,
    I've learned a lot today from this session, many thanks

  • @rashidanwar7831
    @rashidanwar7831 ปีที่แล้ว

    Very helpful! Thank you and keep up the good work!

    • @RADACAD
      @RADACAD  ปีที่แล้ว

      Glad it helped!

  • @BernardoRomeroC
    @BernardoRomeroC ปีที่แล้ว

    Great explanation Reza. I'll use the analogy to the cars often

    • @RADACAD
      @RADACAD  ปีที่แล้ว

      Glad to hear it makes sense. Thanks Bernardo

  • @standardio8270
    @standardio8270 ปีที่แล้ว

    Good explanation. It was very clear. Thanks.

    • @RADACAD
      @RADACAD  ปีที่แล้ว +1

      Glad it was helpful!

  • @CarlosMunoz-zz6qm
    @CarlosMunoz-zz6qm 11 หลายเดือนก่อน

    There is no way to explain it better, greetings from Chile

    • @RADACAD
      @RADACAD  11 หลายเดือนก่อน

      thanks for your kind words. Cheers

  • @dumisaralane
    @dumisaralane ปีที่แล้ว

    Love it!

  • @oscarzapatajr2
    @oscarzapatajr2 ปีที่แล้ว

    Thanks, this was really helpful, Reza, I have a question, if I am a Powerbi power user who want to explore the Data Science space, I guess the lakehouse is the best choice right?
    I can manage the ETL to the lakehouse via dataflows (power query online) because I already know how to use it and I work with small data, and then leverage the Spark notebooks and AutoML for data science or ML practices right?
    Once the results of the data Science predictions are on a column or a table in the lakehouse I can also incorporate those to the Powerbi reports via the direct lake connection correct?
    I am really excited for this, fabric seems to give small companies and Powerbi power users the opportunity to explore Data Science in a integrated and simplified framework...
    Also, it seems cost competitive using F2 for about $300 a month plus maybe 3-5 powerbi pro license s...
    What do you guys think?

    • @RADACAD
      @RADACAD  ปีที่แล้ว

      For a Data Scientist persona, yes, we think also that the Lakehouse would provide more benefits. the ability to work with Notebook is a big help for sure. and the Power BI side would also works great with the SQL endpoint of it.
      Yes, pricing for F2 is great :)

  • @asn85uk
    @asn85uk ปีที่แล้ว

    Rezajan thanks for the review. just to be on the secure side, can we use fabriw synapse dw instead of azure dw ? my company in the way of full migration and would be great to know

    • @RADACAD
      @RADACAD  ปีที่แล้ว

      Yes, you can
      And in the future that would be your only option, to do it from Fabric

  • @tahseenfiroz4243
    @tahseenfiroz4243 ปีที่แล้ว

    Does it work for all the tenant? Like Torus etc

  • @VirtousStoic
    @VirtousStoic ปีที่แล้ว

    ❤tyvm you helped my career so much

  • @yupity
    @yupity ปีที่แล้ว

    this is great, can you add KQL db?

    • @RADACAD
      @RADACAD  ปีที่แล้ว +1

      We'll have videos about KQL database soon

  • @ajmorgan591
    @ajmorgan591 ปีที่แล้ว

    Does that microphone actually work or is it just for show? I've always wondered because of the room echo.

    • @RADACAD
      @RADACAD  ปีที่แล้ว

      That is the microphone recording the voice in all the videos.

  • @VirtousStoic
    @VirtousStoic ปีที่แล้ว

    I like ur skeleton glasses more. Ofc wear what makes you happy, just voting hehe

    • @RADACAD
      @RADACAD  ปีที่แล้ว

      I like that one too :D