Forum Discussion
On premise IT managed data model business develop report
We have one template per model/dataset. We do have a couple of different tempaltes for our more complex data sets which are functionally oriented. So you pick the right template for the functional area you are looking at, or the aspect of a dataset you are looking at.
We monitor the performance of the SSAS cubes with a mix of perfmon metrics that we gather off the servers and SSAS Monitor and SSAS Events Analyzer (both on sqlbi.com) the perfmon metrics we lift are based on the MS Tabular whitepaper and some blog articles. Mashing them together is pretty untidy. Oddly enough we do it in PowerBI :-)
The approved views are a conventional BI solution (DB backend to Tabular Model) that runs through the usual specification, version control, change management etc. So way slower than the users like but better managed and more rigourously tested/designed. The eternal trade off... Cheap, Fast, Right, pick any two!
S
stpnet thanks for the feedback and excelent visuals on the tightrope.
Great idea with the template PBIX with the connections details.
Keen to know:
- how you manage the template (is it one template per view?)
- how you manage the approved views
- how you manage the performance as it is direct query
We have one template per model/dataset. We do have a couple of different tempaltes for our more complex data sets which are functionally oriented. So you pick the right template for the functional area you are looking at, or the aspect of a dataset you are looking at.
We monitor the performance of the SSAS cubes with a mix of perfmon metrics that we gather off the servers and SSAS Monitor and SSAS Events Analyzer (both on sqlbi.com) the perfmon metrics we lift are based on the MS Tabular whitepaper and some blog articles. Mashing them together is pretty untidy. Oddly enough we do it in PowerBI :-)
The approved views are a conventional BI solution (DB backend to Tabular Model) that runs through the usual specification, version control, change management etc. So way slower than the users like but better managed and more rigourously tested/designed. The eternal trade off... Cheap, Fast, Right, pick any two!
S
Thanks again for the ideas. We'll check these out and see how well this works.