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

Ғылым және технология

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 Жыл бұрын

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

  • @RADACAD

    @RADACAD

    Жыл бұрын

    It is awesome to hear that Oscar! Thanks :)

  • @rossgh76
    @rossgh768 ай бұрын

    Thank you Reza for providing a clear overview of Fabric

  • @MrRskpsannaksr
    @MrRskpsannaksr9 ай бұрын

    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

    9 ай бұрын

    Glad it was helpful!

  • @ranjanroy1623
    @ranjanroy1623 Жыл бұрын

    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

  • @BernardoRomeroC
    @BernardoRomeroC Жыл бұрын

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

  • @RADACAD

    @RADACAD

    11 ай бұрын

    Glad to hear it makes sense. Thanks Bernardo

  • @CarlosMunoz-zz6qm
    @CarlosMunoz-zz6qm10 ай бұрын

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

  • @RADACAD

    @RADACAD

    9 ай бұрын

    thanks for your kind words. Cheers

  • @standardio8270
    @standardio8270 Жыл бұрын

    Good explanation. It was very clear. Thanks.

  • @RADACAD

    @RADACAD

    Жыл бұрын

    Glad it was helpful!

  • @rashidanwar7831
    @rashidanwar7831 Жыл бұрын

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

  • @RADACAD

    @RADACAD

    Жыл бұрын

    Glad it helped!

  • @tahseenfiroz4243
    @tahseenfiroz4243 Жыл бұрын

    Does it work for all the tenant? Like Torus etc

  • @asn85uk
    @asn85uk11 ай бұрын

    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

    11 ай бұрын

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

  • @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 :)

  • @dumisaralane
    @dumisaralane Жыл бұрын

    Love it!

  • @yupity
    @yupity Жыл бұрын

    this is great, can you add KQL db?

  • @RADACAD

    @RADACAD

    Жыл бұрын

    We'll have videos about KQL database soon

  • @Car_Fanatic
    @Car_Fanatic Жыл бұрын

    ❤tyvm you helped my career so much

  • @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.

  • @Car_Fanatic
    @Car_Fanatic Жыл бұрын

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

  • @RADACAD

    @RADACAD

    Жыл бұрын

    I like that one too :D

Келесі