awesome-business-intelligence

is really well. If you would add support for calculated fields, you'd offer a compelling E-Commerce controlling solution. One issue I noticed though is that your nesting seems to be unlimited. I could open an infinite "table" tree if I start from the order_lines or product view --> order_lines --> order --> order_lines --> product --> seller --> orders/ products... ad infinitum. You want to make sure that this drilldown into FK relationships does not lead to loops. Also I think some visual support where in the nest tree one is at (orders --> order_lines --> product --> sellers) would be great, otherwise it's quite easy to get lost. Other than that honestly congrats on doing a lot of things right in terms of data viz, responsiveness, sharing capabilities. Really like your work! [1]: https://github.com/thenaturalist/awesome-business-intelligen...

ake takes all the pain that one might experience in Redshift away (manual tuning of sort & dist keys, tuning of coupled storage & compute clusters). Again, if you have good data engineering resources readily available it might make sense to look into a comparative cost analysis of the three in more detail. Notably, Snowflake has Snowpipe, a native API allowing you to stream data into the DB. Data modeling: You mentioned you use Kimball. In my experience while this is the definite choice for analytical querying and modeling, in an enterprise setup it might make sense to draw a Data Vault model layer between your raw sources and your dimensional model layer. Data Vault is more modular and easily extensible, will allow you to model history (compliance or GDPR readiness) and through the latter might very well serve you to expand/ extend your dimensional model. Not my own thought originally, very good read can be found here [0]. Data integration: A standard enterprise integration tool which comes to mind is Talend, although licenses are also pretty expensive and it feels very antiquated as well. Talend bought Stitch last year [1], which follows a much more modern approach. Worthy to take a look at, not sure if it can cover all of your requirements. Another modern solution provider for integration more geared towards enterprise would probably be alooma [2]. There is also Fivetran [3]. ETL: While some of the tools above can effectively be used for ETL, I'd take a good look at dbt by Fishtown Analytics [4]. It's SQL only but does a lot of things right in terms of being a module in a fragmented data stack which does its job really well. The thinking that goes into dbt is universally a good approach imho. A player geared towards enterprise is Matillion [5]. Visualization: The most empowering solution for general business users I know of is hands down Looker [6]. Of course there is Tableau and many other more mature solutions out there, but being able to write SQL is always a prerequisite to getting results there. I acknowledge this is a personal, strongly biased opinion, so don't take my word alone for it. Looker can be deployed on prem as well, has LDAP & SSO, and a bunch of other features which would make me consider it enterprise ready from a pure deployment perspective. In general I try to stay on top of the most common tools in the BI space, and maintain a repository of tools here: https://github.com/thenaturalist/awesome-business-intelligen... I am not associated in any form with any one company mentioned here or listed in the repo. 0: https://medium.com/rv-data/overhauling-our-data-warehouse-wi... 1: https://www.stitchdata.com 2: https://www.alooma.com 3: https://fivetran.com 4: https://www.getdbt.com 5: https://www.matillion.com 6: https://looker.com