Qlikview Business Intelligence

After studying QLIKVIEW for three months, I feel like I am using EXCLE for ORACLE and SQL SERVER for 4 years.

It is fast. First, it is from the neglect of Unqualified Data (other data warehouses need to be extracted and cleaned, converted and finally loaded, modeled, and presented). This tool, data can be directly loaded without any ETL. Second, memory-based storage and compression. The same values in a field are stored as a value, the others are references to the address in the memory, so redundancy is reduced. The third is when dealing with internal and external joins (left join, right join, inner join, you do not need to pass the parameter because the parameter passing action is completed by default during the LOAD operation. The JOIN tables with these settings are joined by the keyword by default, it makes up a SET. Therefore, when referenced, it is a SET and a table.

 

 

 

Data comes from the virtual environment and has no practical significance.