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/la...

[@oscarzapatajr2]

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

[@RADACAD]

It is awesome to hear that Oscar! Thanks :)

[@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

[@MrRskpsannaksr]

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]

Glad it was helpful!

[@rossgh76]

Thank you Reza for providing a clear overview of Fabric

[@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]

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]

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]

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

[@tahseenfiroz4243]

Does it work for all the tenant? Like Torus etc

[@standardio8270]

Good explanation. It was very clear. Thanks.

[@RADACAD]

Glad it was helpful!

[@BernardoRomeroC]

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

[@RADACAD]

Glad to hear it makes sense. Thanks Bernardo

[@CarlosMunoz-zz6qm]

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

[@RADACAD]

thanks for your kind words. Cheers

[@yupity]

this is great, can you add KQL db?

[@RADACAD]

We'll have videos about KQL database soon

[@dumisaralane]

Love it!

[@rashidanwar7831]

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

[@RADACAD]

Glad it helped!

[@VirtousStoic]

❤tyvm you helped my career so much

[@ajmorgan591]

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

[@RADACAD]

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

[@VirtousStoic]

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

[@RADACAD]

I like that one too :D