News for hackers. Stuff that matters.
Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by tensor on Monday December 10, 2018 @02:42PM (#18650601)
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.
Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by aceregen on Tuesday December 11, 2018 @10:25AM (#18655878)
Hello Tensor! Will you like to review what our team has built at Holistics (www.holistics.io)? We are listed in the Gartner FrontRunner Quadrant for Business Intelligence Oct 2018.

Here's a customer case study we've just published recently: https://www.holistics.io/customers/floship-ecommerce-fulfill...

Love to get your feedback on how you find us relative to the tools you are currently evaluating! Send me a note at v(@@)holistics.io or our team at hello(@@)holistics.io]!

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by feydaykyn on Monday December 10, 2018 @03:08PM (#18650809)
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 ? Update all the visualisations through a script? Etc)

PowerBI feels so Microsoftish, I'm really on the market for something else

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by cosmie on Monday December 10, 2018 @05:19PM (#18651609)
> 2) either a vm running windows server or create a db on azure to update manually because powerbi doesn't allow aws databases

I believe this is a misunderstanding. You can totally connect to AWS databases with PowerBI, assuming your AWS database is routable. You can't set up the connection through the web interface, but you can use PowerBI Desktop to set up virtually any database that has an ODBC driver as a source[1]. And once you publish it to the Azure-hosted PowerBI instance, it'll use that connection string to connect directly to the data source and automatically update/refresh like any other data source.

As for a VM running Windows Server - that's the option if your AWS database isn't routable by the Azure-hosted PowerBI service. You install a gateway for PowerBI to hop through, and configure all of the data sources within that gateway. That way your internal AWS databases are not publicly routable, and you can lock down and centralize the connection between PowerBI and AWS via that gateway box[2]. Data Gateway is a Windows-only application at the moment, so that part is a pain. But it's a relatively minor pain in the grand scheme of BI implementations.

[1] https://docs.microsoft.com/en-us/power-bi/desktop-connect-to...

[2] https://docs.microsoft.com/en-us/power-bi/service-gateway-ge...

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by feydaykyn on Tuesday December 11, 2018 @04:53AM (#18654220)
Yes exactly, so the only way to have a non public database is to run a Windows vm on AWS, I would rather avoid that, especially because we need one vm per customer. Thanks for the detailed write up!
Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by cosmie on Tuesday December 11, 2018 @01:36PM (#18657566)
Is there a reason you need one VM per customer, and can't use a single Data Gateway to manage multiple data connections?

On that note, you don't have to use the official data gateway application. It certainly has a lot of ancillary benefits, but isn't critical. You can just as effectively create a bastion linux host and use ssh to remote forward the connection to AWS database[1]. I've done that plenty of times in the past, to access databases like Redshift and Dynamo that were within non-public VPCs. Easier to manage and cheaper to run per client, if that's a hard requirement.

You could also use something like QuickSight, if you're purely AWS. But I'd only recommend that if you expect to allocate a large amount of development resources for support. PowerBI is a lot more user friendly for business users to be self-sufficient, and sometimes it's less of a hassle to deal with the up-front complexity of that than to deal with the non-stop application support needs of business users.

[1] https://www.ssh.com/ssh/tunneling/example#sec-Remote-Forward...

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by go_prodev on Monday December 10, 2018 @04:33PM (#18651338)
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.

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by feydaykyn on Tuesday December 11, 2018 @05:43AM (#18654425)
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!
Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by mbesto on Monday December 10, 2018 @04:16PM (#18651224)
PowerBI is really an amazing for the price point (free-ish for O365 accounts) for most businesses out there (10~300 employees). It's not one size fits all and YMMV.

1) You have this problem regardless

2) Huh? Why not just the cloud version? Are you trying to report directly on a productive transactional database for a software app? See #3 about source of data.

3) Depends on your source data. I build a dashboard for sales in with data from SalesForce in like 2 hours.

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by kthejoker2 on Monday December 10, 2018 @10:25PM (#18653143)
1) nope, it's a 100% self service tool, no outside assistance needed.

2) PowerBI uses AWS just fine, you may need a gateway depending on how you expose your AWS DB for external access, but that'd be true of any tool connecting to it.

3) why an expert? Here's the API spec, it's not hiding ...

https://docs.microsoft.com/en-us/rest/api/power-bi/

Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by feydaykyn on Tuesday December 11, 2018 @05:09AM (#18654275)
Many thanks for the API link, the expert was completely unclear on what may be possible on the automation side (full api configuration without using a mouse).
Re:Tableau Software Threatened? Rival Growing at 70% Just Ra... by mjirv on Monday December 10, 2018 @03:25PM (#18650919)
Looker's API functionality is pretty extensive if that's something you care a lot about.