Forum Discussion
Helper IChoosing the right Fabric architecture
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
Helper IHi DennesTorres
Thank you very much for your reply and insight.
I have heard of data mesh and the medallion architecture and it is for sure something to keep in mind when scaling the solution.
As of now, the primary objective is to get all sources into one source of truth, as the company is still very small. We need to build up an architecture based on an enterprise business model, which was defined together with the business and analytics teams. That means appending / mergeing and cleaning data from all the above sources into an easy to understand kimball star schema. Quickly and at low cost.
Keeping data "future" architecture in mind, using dataflows and a lakehouse would be most appropriate as it can accommodate the principles of data mesh.
Can anyone point me to a cost calculation using the fabric pricing? Really all I need seems to be a couple of dataflows plus a lakehouse, but I am having a hard time finding out what that would incurr in cost.
Power ParticipantHi,
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
Hi Data-Crunch - Thanks for using Fabric Community,
We haven’t heard from you on the last response and was just checking back to see if your query got resolved? Otherwise, will respond back with the more details and we will try to help.- Data-Crunch
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.
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