Building a data pipeline/data warehouse in microsoft fabric

[akhaliq7]

I want to use Microsoft Fabric for my data storage.

    1. What is the recommended way to use Microsoft Fabric, should I bring my tables in without doing any transformations and then do the transformations in the warehouse?

Also, the original table I would use just as a base table, I would create new tables based on this base table,

    2. Would I create these new tables in the same or a new warehouse?

    3. Would I have these multiple warehouses in one workspace?

I have noted that one warehouse is like a data model so I am wary about cluttering up one warehouse with too many tables, views, stored procedures, and functions

[amustafa · Accepted solution]

Assuming you have SQL knowlwdge. Create one Datawarehouse, Load your base tabes as staging tables. Run SQLs to transform your data in Prodcution tables then create Views you need for reporting in Power BI. In my experience you can do data transfomrations in Dataflows and Data Pipelines and still need transofmrations in the DW so why not do it all in one place, easier for audinting purposes.