Fabric for retail client

[AdamMichael]

I have a requirement for retail client. Where I have to implement warehousing and give end reports to client where now they reley on excel spread sheets for reporting 

I have basic knowledge how it works.

Can suggest what subscription and pricing for my project where I usually have 10k transactions per day. If you give brief details about and best practices and how to proceed that would be great

[v-pgoloju]

Hi @AdamMichael,

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @AdamMichael,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @suparnababu8  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[suparnababu8 · Accepted solution]

Hi @AdamMichael 

Based on your requirement (10k transactions per day),  You can go with entry level capacity licenese, such as F2 or F4 to support warehousing, reporting, and concurrency. You can estimate your requiremnet here Fabric Capacity Estimator | Microsoft Fabric and If you would like to know about pricing , pls check this Microsoft Fabric - Pricing | Microsoft Azure

While coming to best practises,

• You can use Lakehouse (OneLake) to ingest the raw data from your source.
• If your data in un-cleaned format, you may use DataflowGen2(low code) or Notebooks(Pro code) and by using data piplines you can push it to Warehouse.
• Then create a star schema sematicmodel in Fabric Warehouse for reporting.
• With Power Bi you can connenct  to your semnatic model and build your reportign needs.
• Then Implement row level security (RLS) as per your requirement. 

Please go through below links, it might helps you

Performance Guidelines - Microsoft Fabric | Microsoft Learn

OneLake, the OneDrive for data - Microsoft Fabric | Microsoft Learn

Data Factory end-to-end tutorial introduction and architecture - Microsoft Fabric | Microsoft Learn

Please let me know if it helps you!!

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!