Re:Stripe Sigma
by genericpseudo on Thursday June 01, 2017 @05:02PM
(#14464691)
Running a data warehouse is a full-time commitment. Tons of real businesses have no software engineers.
This is a great-looking product.
Re:Stripe Sigma
by fraserharris on Friday June 02, 2017 @04:58AM
(#14468504)
With modern data warehouses like BigQuery & Snowflake, this is no longer true. We at Fivetran get people setup with a BI tool, warehouse and data pipelines in a day. From there, its all SQL with little to no management of the underlying system.
Note: I'm specifically excluding Redshift which requires active management
They moved to Stripe for payments years ago, and it's helped them out a lot with simpler integration and more data. Sigma looks great for them.
They're not a big outfit, they don't have a dedicated engineering3 dept or developers on staff. Their main business is making chocolate after all.
With Sigma they can more easily query their transaction data and get all sorts of insight. My friend has degrees in Chemical Engineering and Nutrition, she's a smart woman and can do a lot more with excel that I can muster. Although she learned some coding in engineering school, using the APIs directly is a lot to ask. SQL is much more accessible, and was originally developed for business professionals just like her. So I expect something like this will help her go from periodic data imports and excel-based analysis to much more frequent, maybe daily, reports and analysis.