I. Introduction:
Friends rich data analysis system is integrated for data analysis system to help you quickly design complex reports, and get satisfactory performance results. Friends rich powerful data analysis system will enable you to easily solve the data analysis and computing, data mining and a series of problems faced by enterprises.
Friends rich data analysis system consists of two parts: a data extraction system, report design system.
■ data extraction system:
1) limit from the database, you can mount any database application system
2) to graphically generate any SQL statement, not only can guarantee the correctness of SQL design. Meanwhile, the graphic design approach to non-professional and technical personnel to participate in or self-reports required by the terms, so that more valuable data in the database. .
3) to optimize SQL statements, allowing the system to maximize the speed
4) between the different data sources, you can set the field associated to the main structure of the data from the query design is more convenient
■ report design system:
1) EXCEL dialysis perfect reproduction of the data, as long as you drag the mouse can easily get the desired report
2) combined to provide the filtering, sorting, grouping, graphics conversion functions for data mining re-
3) Table type of preservation, transfer EXCEL, printing and other functions
Second, the system features:
1. System supports almost all current mainstream databases, including ORACLE, SQL SERVER, SYBASE, INFORMIX, DB2, MYSQL, etc., companies can invest in the existing information under the most economical solution to get coveted, and extremely high scalability advantage of competitive business intelligence.
2. Supports Windows, Unix, HP Unix, Linux, Solaris and other major operating system platforms
3. For the integration, a powerful argument, the function mechanism to report and any applications can be seamlessly integrated
4. To graphically support the SQL generation to achieve high efficiency in the heavy report design data collection so that the second application of software engineers or those from low-level duplication freed
5. To graphically support "the delay that is" data analysis process and greatly reduce the workload of data analysis
6. Robust, scalable performance
7. Any combination of cross-dimensional analysis between the groups: to provide no limit on the number of rows and columns of data axis dimension combinations, the user can form themselves into any class dimensions to achieve the purpose of analysis, also provides rapid row, column axis data exchange, fast to the purpose of different point of view of data
8. Powerful data performance feature that allows users to easily achieve the desired effect of the data shows, so heavy duplication into a creative process
9. Offers a variety of flexible and user-friendly presentation, including the intuitive multidimensional data tables, a variety of form types used for OLAP analysis and customized graphical display interface (column chart, pie chart, line graph, etc.), allowing users to can be analyzed using the most able to meet the needs of its format and platform to view, process and share information.
10. With the perfect combination of Excel: The system can report the complete results or save the Excel file.