Forum Discussion

Data-Crunch's avatar
Data-Crunch
Icon for Helper I rankHelper I
2 years ago
Solved

Choosing the right Fabric architecture

Hi all I am not sure If I am in the right place for this question , but since it is data ingestion / storage related, I thought I'd give it a try 🙂 As there are quite a number of tools and o...
data engineering
Fundamentals
power bi
  • DennesTorres's avatar
    DennesTorres
    2 years ago

    Hi,

    About the architecture, you can use only a few steps for the ETL to go directly to a kimball star-schema, or you have the option to evolve and clean the data step by step, which would be a combination of the medallion architecture with your final single source of truth.

    Keep in mind the self-service nature of Power BI may end up "moving" from a single source of truth to data mesh before you expect. If this happens without coordination, you end up with data silos.

    About the cost, you buy what are called Fabric Capacities. You buy them on Azure environment. Here is a list of price: https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/

    The challenge will be to discover what capacity will be enough for your processing needs.

    Kind Regards,

     

    Dennes

Data-Crunch's avatar
Data-Crunch
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous thanks for the follow up.

The comments were definitely helpful, but when choosing the right tools to create a capable initial architecture, this is something which I will have to find out by trial and errror I believe. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Data-Crunch ,

Glad to know that you got some insights on your query. We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries

Thanks
Chenna Gopi Krishna