cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Architecture and Price estimate?

Hello.

Let's say I want to provide SAAS reports to 1,000 customers, gathering data from every customer individually. Meaning 1 customer = 1 company with, different data sources with different internal structure, with different type (can be SQL, can be API from cloud).  I want to have couple of standardizes reports which cusomer presellect. Every customer have approximately 1,000,000 - 5,000,000 fact table rows and 2,000 dimension rows. 

 

Data gathered is of the same type (sales, employees, etc, dim tables). But, because of different internal structure need to be structured and prepared (ELT).

 

I would expect every customer to spend about 2 to 10 minutes browsing the report every day. 

 

If there is anyone with experience of similar scenario implementation or usage, can you please recommend first of all, the general level infrastructure? Like, for example, data lake -> data warehouse -> Analysis Server -> Power BI Embeded. And secondly, what is the rough (even if VERY rough) Azure infrastructure cost per user per month or another costing understarding?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@Skydancer - I think you have the basic components correct. The price is going to vary wildly depending upon how much transformation you need to do, where you do it and what tool you use. For example, Databricks is wildly more costly than Azure Data Factory. Same goes for your data warehouse, are you using Azure Data Warehouse or Azure SQL DB or Azure SQL Managed Instance? Are you going to use Premium or Standard for this stuff? Huge price differences. LRS, ZRS or GRS? Are you including dev and test environments? 

 

Here is an example link: https://azure.com/e/e1020c8e0b034622a82b4ac17eff5ac1

 

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@Skydancer - I think you have the basic components correct. The price is going to vary wildly depending upon how much transformation you need to do, where you do it and what tool you use. For example, Databricks is wildly more costly than Azure Data Factory. Same goes for your data warehouse, are you using Azure Data Warehouse or Azure SQL DB or Azure SQL Managed Instance? Are you going to use Premium or Standard for this stuff? Huge price differences. LRS, ZRS or GRS? Are you including dev and test environments? 

 

Here is an example link: https://azure.com/e/e1020c8e0b034622a82b4ac17eff5ac1

 

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Highlighted

Thank you Greg.

It gives rough understanding of the cost.

Still I am wondireing if the situation described is so rare, that there are no other comments from actual users. 

 

P.S. I just bought your book 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors