Re:Sisense Acquires Periscope Data
by acidbaseextract on Wednesday May 15, 2019 @06:42AM
(#19918077)
I agree that these BI tools are not a trivial investment and are not trivial to use, but in defense of building on a SQL data warehouse:
> Of course there's ANOTHER company to help me generate the scripts to popular 3rd parties :P
> I guess what I want is some powerful individual-use product that has some easy analytics automation on spreadsheets / APIs.
The point is that everything speaks SQL, so vendor lock-in becomes much harder and there's no data source that "is not currently in our plans to support" — if you can get the data into the warehouse, it's supported. Definitely a higher barrier to entry for an individual, but I wouldn't do business BI without it.
We've done some insane things, joining across data from 4+ different systems (CRM, email open tracking, analytics, primary app database, email to a blessed account) in ways that would be impossible for an "off the shelf" solution.
> Of course there's ANOTHER company to help me generate the scripts to popular 3rd parties :P
> I guess what I want is some powerful individual-use product that has some easy analytics automation on spreadsheets / APIs.
The point is that everything speaks SQL, so vendor lock-in becomes much harder and there's no data source that "is not currently in our plans to support" — if you can get the data into the warehouse, it's supported. Definitely a higher barrier to entry for an individual, but I wouldn't do business BI without it.
We've done some insane things, joining across data from 4+ different systems (CRM, email open tracking, analytics, primary app database, email to a blessed account) in ways that would be impossible for an "off the shelf" solution.