![]() I used to work for a company that built the "automagic ETL" kind of solution. I agree, the "one database at a time" approach is the way vendors ignore the harder problem of connecting data across platforms. Also, you don't to work on a always-modifying dataset while fine-tunung your analysis methods. Second, you want to keep the intermediate results anyway - for caching as well as to have an audit trail and reproducibility of the results.įor example, you don't want the performance of operational system be affected by for how many analysis tools it is used at a point in point. First, these are very different tasks, where different specialized tools will evolve anyway. It usually makes no sense to combine those phases into a single overall tool. More precicely, it is a common pattern to split the analtics into three parts: 1) Collecting the data (using lots of adapters) into a "data lake", 2) filter and preprocess that data lake into a uniform data structure whose structure is determined by the analysis goal rather than the operational system, 3) analyze that uniform data with statistical and other tools. However, you still want to copy & combine your data into a single database. Almost every company has some legacy systems around, or simply uses different tools for different jobs. Even you can get the ability of custom services from Helical Insight team directly at very affordable costs.You will have N databases no matter what. ML and NLP integration, thus allowing Google search like interface to create reports.UI driven workflow engine with data pipeline capabilities.Perpetual license option with distribution Support. ![]() Perpetual license option without distribution.Subscription license option with distribution.Subscription license option without distribution.Completely responsive and can be accessed from any device any screen size.– Ability to add your own chart, your own chart customization, your own DBfunction, your own aggregate function – Placeholders to allow injecting of your own custom HTML, CSS, SQL, Groovy code etc – API support for each and every frontend function, thus allowing to automate things and build custom UI also. Caching and pagination for better performance.An ability to specify exporting config with specific config (like paper size, width, header, footer, custom code on export etc) Various kind of exporting options like pdf jpeg png excel csv etc.Create map based analytics, infographs, reports etc with filters, drill down, drill through etc - Canned report allowing multipager document kind of reports like invoice, salary slip, bank statement etc.Support of more than 30+ visualization options and map.Dashboard designer module with drag drop interface to create dashboard.Self service drag drop interface allowing a no code platform.Row level data security based on the user, role, org, profile etc thus ensuring people see only their own data.User role management: Providing 4 layers of security like organization, role, user and profiles.Embedding and SSO : Embedding options like iframe, webservices, object tag, embed tag etc - Single Sign On support with options like CAS, LDAP, AD, ADFS, JWT, oAuth etc.DataSource: Support of variousdb including RDBMS, Columnar DB, Flat files, NoSQL db like MySQL MariaDB Postgrss SQLserver PrestoDB Vertica DynamoDB Mongo etc.A powerful OPENSOURCE alternative which might be worth looking at.ĭisclaimer: I am one of the cofounder of open source BI product Helical Insightīelow some of the key features which we have are
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |