Earlier quoted context omitted.
We're going through the process of getting a BI solution. There are many players and Tableau doesn't fair well against them. I can see them holding on to existing customers because switching is hard, but they absolutely have a lot of competition for new sales.
Would you share the ones you found worthwhile? Our business wants PowerBI, but the sys admin side sounds like a pain : it seems we need: 1) a consultant to setup the visualisations 2) either a vm running windows server or create a db on azure to update manually because powerbi doesn't allow aws databases 3) the api automation capabilities are unclear says the expert (eg: create a new dashboard for a new customer ? Up…
The adoption has been extremely painless and business users are very comfortable creating reports and discovering new ways to represent their data.
In response to your points above... 1) A consultant is not required to set up visualisations. With minimal training (a few hours) most users understand the fundamentals and are ready to go.
2) We use AWS Redshift. You have the option to import data into Power BI or do a direct query from the cloud platform to Redshift with odbc.
3) what are you trying to do with the API? To automate reports you normally set up a gateway connection to your data source and schedule the refresh in powerbi cloud. No API required normally.
It also can use office 365 or Azure AD for single sign on, making sys admin activities a breeze.
Send me a message if you want to discuss anything specific and I'd be happy to help you out.