Data warehouse is the key and foundation of data mining technology. Data mining technology is on the basis of the existing data, and help users understand the existing information, and on the basis of the current information, business conditions make predictions about the future, on the basis of the data warehouse to data mining, can for the entire enterprise development status and future prospects are relatively complete, reasonable and accurate analysis and forecast.

The important role of data warehouse in the whole process of data analysis is self-evident. However, due to the large amount of data to be processed, the construction of the data warehouse is usually completed by BI tools. Now there are many domestic data warehouse software are done very well, now Xiaobian to SMARTBI as an example to specify.

1. Practical data collection

SmartBi provides powerful data collection functions, which not only reduces the workload of developers, but also meets the data collection needs of business personnel.

SmartBi provides Excel data batch import function, which can easily import Excel data, one key upload and data storage into the database. Through the write back permissions and rule definition, it realizes the use of Excel to design and collect forms and fill in data on Web. The configuration is flexible and convenient. It supports the direct data filling in the report, the data checking by the verification formula, the multi-person filling, and the process approval of countersign and branch.

2. Rich data connection

It is supported to directly upload Excel, CSV, TXT files, data analysis packages and import them into cache libraries or relational data sources. Target relational data sources supported for import are: MySQL, Oracle, DB2_V9, MSSQL; Support access to Java data sources; SmartBI supports large databases such as Presto+Hive, Star Ring, Vertica, Infobright, and more.

3. Strong cross-library integration

The data source types currently supported to cross libraries include: Cache Library, HADOOP_Hive, Star Ring, Vertica, CH, Greenplum, Infobright, Oracle, DB2 V9, MySQL, MS SQL Server, Spark SQL, Teradata_V12, Informix, Impala, PostgreSQL.

Data collection, data connection and cross-library integration, in addition, SmartBI has more powerful features, not only in this aspect of data mining do particularly well, in data analysis, data visualization and data control and other aspects, but also won the industry’s praise.