Superset

Hi, I am currently evaluating which BI tool will be implemented across the company. In my earlier companies I have used Superset where I wrote SQL queries for each dashboard or insight requirement and created a visualisation directly from them. I realised that in Power BI I can't write SQL queries directly, I can only connect directly to the database tables and do the transformation inside Power BI. A workaround would be to write sql queries separately and create a view in my db and then connect power BI to the view to create a dashboard. I want to ask for your opinions on this. 1. Should I move to a tool where I can write queries and make visualisations. 2. Use views with power BI. 3. Simply abandon SQL queries and just do transformations entirely in power BI.

Can anyone shed some light about the deal? - How much was the deal? - Why so low? If they had 24K colleges on their platform? - What's the larger play of Great Learning? How much is their conversions