1, the front-end interactivity is more flexible
2, display style diversity.
Disadvantages: 1, Qlikview simple tables are associated with each other by the same field name, if there is a slightly more complex business needs, you must write qlikview script (not sql) to use.
2, Qlikview does not have its own data warehouse, big data processing compared to some business intelligence software, such as FineBI worse. qlikview's working mode is to load the data into the memory through the SQL script statement first and then do analysis in memory. This puts a high demand on the server's memory, which must be freed up for analysis. For large data volumes, other ETL data processing tools must be used.
In contrast, FineBI supports a multi-dimensional database engine, supports cross-database analysis, and has a relative advantage in analyzing and querying large data volumes.
FineBI supports multi-dimensional database engine and cross-database analysis.