cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Skydancer
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
Greg_Deckler
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
Greg_Deckler
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

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.