I'm currently helping a large company with their transition from Tableau/SAP/Excel to Power BI.
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.
Our business users already hired the consultant and I'm trying to make sense of his answers, but he does seem to be knowledgeable only on using a mouse.
We want to create a template dashboard of visualisations, which would be duplicated for each of our customers, each one having its own data source and workspace. New customer creation should be automated through API calls and we would prefer centralize our resources on AWS. That's it.
The consultant has been so fuzzy that it seemed utterly complex to set-up, but by reading all the answers things are starting to make sense. Redshift would be great, thanks for the pointer!
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.