What kind of data do you report on? Do your analysts create their own reports, or do they ask the DBA, or worse IT Director? Maybe they use Alteryx for reporting? All valid questions and each will lead you down different paths to your actual use cases.
And don’t get wrong about PowerBI, if your handling more generic reports with less interactive visualizations, it can be ideal too.
In 2018, we worked to implement a HEDIS quality measure product for a local Healthcare Information Exchange. The level of compute required over 80 minutes to complete, after ingesting over 14tb of clinical data and on the Tableau reporting server in AWS. That level of analysis required was something we only attempted in Tableau. Mainly due to some scatter/plot reporting features for patient populations, that Tableau has out of the box. PowerBI however, did not and still does not have as much in terms of out of the box functionality.
Where SSRS had more functionality:
- PowerBI is generic.
- PowerBI requires you to purchase add-ons via a 3rd party vendor marketplace.
- PowerBI doesn’t offer 3D plot mapping out of the box.
- PowerBI doesn’t allow scripting like SSRS did.
- Alteryx is a more attractive alternative to Tableau.
- SSRS was free remember?
Consider all the options and talk to us as we can explain the pros and cons of each approach.