Hi. Of course! If you have data classes, you can enable Analytics for your namespace, create a data cube, and then create various pivot tables in Analyzer. This will allow you to create visualizations.
 
Take a look at this docs
https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI.Page.cls?KEY=PAGE_bi
 
And this group of articles covers all the necessary features of analytics.
https://community.intersystems.com/post/basics-creating-dashboards-pivot-tables-and-widgets-iris-bi-platform
https://community.intersystems.com/post/basics-using-architect-efficient-data-management-and-analysis-intersystems-iris-data-platform
https://community.intersystems.com/post/basics-using-analyzer-effective-data-management-and-analysis-intersystems-iris-data-platform
https://community.intersystems.com/post/example-building-analytics-drilldown-static-report-interactive-dashboard
https://community.intersystems.com/post/how-develop-iris-bi-also-change…
 
And this app. With this package you have more options to visualize your data
https://openexchange.intersystems.com/package/DeepSeeWeb
 
Keep in mind that this app only works with this API  
https://openexchange.intersystems.com/package/MDX2JSON
 

I'm not familiar with HealthShare, but if you're just talking about SQL and the ability to create visualizations based on it, take a look at %DeepSee.KPI https://docs.intersystems.com/iris20253/csp/documatic/%25CSP.Documatic…

Working examples can be found here.

https://github.com/evshvarov/samples-bi-demo/blob/master/src/BI/Model/K…

And here

https://github.com/evshvarov/samples-bi-demo/blob/master/src/HoleFoods/…