Our features provide you with a convenient and professional data analysis experience.
Force-directed graphs present clear hierarchical relations using connecting lines. Just define the parent and child relations of data to create the graph. Measures can be displayed as well if added.
Other than exporting dynamic PPTX files, Dashboards can be exported as static images in PowerPoint files. It can be used to save the data of a certain time period.
Users can subscribe to a Dashboard page. After the system manager approves, subscribers can regularly receive subscribed pages through the Scheduling module.
Achieve ETL through Smart eVision. Writing back the data which has been organized with Data Views is possible.
Newly developed with .Net Core, our software can run on different server operating systems (Windows, Max, Linux). No need to be limited by the server OS. Users can view and design pages on different browsers.
Unified dashboard interface for DW and OLTP data sources. With a clear tool bar, more intuitive designing with visuals becomes possible.
In the database connection interface, databases and data views are displayed as icons to allow more intuitive designing. Data relations can also be seen more easily.
Three new advanced calculations are available for data warehouse data sources: DataFixed, DataInclude and DataExclude. These functions can analyze single child levels directly.
On top of the existing incremental building function (only rebuild newly added data), users can now assign the date and cycle at which they want to update data. Only data after the designated date will be rebuilt, decreasing time spent on data updating.
In the Dashboard, visuals including charts, gauges, Gantt charts and heat maps can be embedded into the DataGrid, allowing more diverse data display.
Arrange and save visuals into a combination set. Designers can reuse these combination sets elsewhere.
HTML can be coded inside this component to display HTML content.
A mirror bar chart can be created with one dimension and two measures that require comparison. The order of the dimension can be adjusted.
The 80/20 chart (Pareto chart) is one of the 7 tools of quality control. By dragging and dropping the desired dimensions and measures into place, a graph with an aggregate percentage line will automatically be created, and measures will be ordered from large to small.
The sunburst chart is added to the TreeMap visual. It can display data's hierarchical status with donut-like charts. Just drag and drop parent-child dimensions and the desired measures. The sunburst chart displays values by default. When users click on a certain section, the measure of that section would appear.
Organize all the enterprise's critical KPI analysis into the same Cockpit. Dashboard, Query/Report, and Analysis pages can all be viewed in the Cockpit. We provide diverse display modes to satisfy different user preferences, including 3D , 2D and Cover Flow display.
We support a variety of data source connections, which are listed as follows: 1. Single files: Excel, XML 2. OLTP data sources: SQL Server, Informix, Sybase, DB2 on AS400,, Progress, MySQL, Dbase, Lotus Notes, Access , MongoDB, SAP, Rest Data 3. OLAP data sources
Data views can help organize heterogeneous data with functions such as calculation, R prediction, filter, group, join, union, classify, crosstab, and order. The views result can be further applied to other data views, providing an even more flexible process.
By storing data in the server memory using In-Memory data technology, Smart eVision can rapidly calculate large amounts of data. Its efficiency is faster than those of OLTP data sources, where data has to be extracted from the backend. Therefore, In-Memory can save the time spent waiting for a large data source to load. Also, designers has data loading options to help distribute server resources.
Automatic data warehouse building or updating can be done via Scheduling, saving time for related staff. Users can always get access to the newest data.
The data warehouse time series helps create a hierarchy for time fields, assisting the application of the time dimension.
Originally, real-time monitoring is limited to OLTP data sources. However, with Real-time DW, the same effect can be applied to other data types as well when used along with Scheduling.
Incremental data building only builds new data. Old data will not be rebuilt in order to save server resources.
Enterprises often apply colors to certain columns or have commonly used calculation fields. These settings and new calculation fields can be built into the data warehouse, saving designers the time spent on configuring the same settings with every new page.
Partial loading helps decrease the loading time needed when querying a large data source, allowing users to view query results instantly.
Smart eVision provides various calculation functions ready for designers to utilize. Functions can be applied to the system, data, events, mobile, and scheduling. Advanced functions include operation symbols, judge and data type conversion, string, math, date, aggregation, data detail.
R language prediction is available for statistical analysis, illustrations and data mining.
Add data bars to measure cells to make comparisons rapidly. The longer the bars, the larger the value, and vice versa.
Users can back up and restore page models on the browser.
All DWs in the system can be found on a list, which illustrates the loading condition and properties of each DW. (DW name, time built, loading time, memory capacity, user.)
After the DW is organized and ready for analysis, users can do complex calculations with a right mouse click. Functions include member calculation (script, achievement rate, growth rate), aggregate calculation (sum, aggregation, average, percentage, aggregate percentage, order, count, maximum value, minimum value), periodic calculation, and periodic aggregation.
The system gives hints about SQL coding errors whenever it detects one, helping designers find errors in the data flow. Information such as elapsed time, number of data items, number of columns, and data flow are also displayed to assist designers in data managing.
Users can color different fields and text according to the conditions they set. For example, green can be set to sales amounts that are higher than those of the previous period; red can be set to sales amount that are lower than those of the previous period. This allows viewers to immediately spot statistics that need attention.
Icons can be applied to measure fields according to preset conditions. With icon sets such as red, yellow and green lights, viewers can easily find the statistics they want to pay attention to. Also, with just one click, designers can reverse the order of icons without further manual adjustments.
For data from data warehouses, designers can assign colors to different dimensions and measures in order to easily distinguish them from one another. These color settings will be applied to all Dashboard, Query / Report, and Analysis pages with the same data warehouse source.
Cockpit themes are available for designers to choose from. After applying, visuals will change its colors according to the chosen theme. Enterprises are also free to design custom themes to suit their enterprise style. Themes include: Simple, Classic Blue, Technology, Water Blue, Night Blue, Metallic White.
MQTT data is also a possible data source of Smart eVision. Our exclusive backend engine can directly connect to the MQTT server, allowing real-time data monitoring through a faster protocol.
Through MQTT, client data can be directly transmitted to Smart eVision's Dashboards and Cockpit without going through databases.
With the auto-backup mechanism, sensor data can be automatically backed up to a database connection of the user's choice.
Whenever exceptional conditions occur, messages can be sent to phones with Smart eVision via LINE, email, WeChat, and SV apps.
Without any coding, users can already keep a record of exceptional conditions for tracking problems.
When problems occur during data transmission or backup, they will be recorded in the log records.
Regardless of whether Smart eVision browsers are opened or not, Smart eVision service will run alongside with the IoT service 24/7.
IoT can be used along with Smart eVision's exclusive Real-time Data Warehouse (DW) to analyze large amounts of data in Analysis. There is not need to rebuild data warehouses for updates.
IoT monitoring can be integrated into Dashboard, providing functions such as push data, refresh, and video-wall auto-play.
Data debug helps you go through your data designing process to find errors.
Users can set the frequency of page data refreshing (unit: seconds). The system will regularly extract the newest data from the database.
The learner's guide provides instructions and strategies for the rich functions of Smart eVision, helping users utilize the software to their best ability.
Manage dimensions/measures authorizations of designers and users in Data Warehouse Management.
Queries, Reports and Dashboards can all be exported as Excel, PDF and PPT files. However, the most common issue is data security. Enterprises wouldn't want their exported files to be accessed by unrelated personnel. Smart eVision's exported files can be encrypted. Users need passwords to gain access.
A watermark can be added onto reports to meet the enterprise's data security policies or prevent information from being stolen.
Smart eVision provides various authentication and authorization models to meet enterprise requirements. Regarding data browsing authorization, convenient management tools are provided: 1. Windows Active Directory (AD) authentication 2. Database authentication and authorization 3. Log records, which keeps a record of logins and usage conditions of pages 4. Role-based management, which permits system setting functions to authorized personnel 5. Detailed authorization settings, which manages the detailed function authorizations of a page 6. OLAP and DW data authorization management, which limits the data browsing access of different users
Administrators can test the authorizations of each user type by simulating their roles.
In version control, Smart eVision provides audit and deployment mechanisms for administrators to manage both official pages and pages under development.
Common authentications utilized by enterprises are available, allowing enterprises to smoothly combine Smart eVision with internal systems.
Smart eVision pages can be embedded to enterprises websites by using ASP.NET, ASP and WinForm.
Role-based Management provides various different roles for administrators to flexibly set different authorization settings.
The log keeps a record of page usage conditions and can analyze which pages are opened the most often and therefore the most popular.
The multi-language settings satisfies the language demands of international enterprises. Users of different regions can use interfaces of different languages.
Administrators can view the online usage conditions of Smart eVision pages. Information including user ID, IP addresses, roles, login time, operation time, session time, and time until timeout are all recorded. When needed, administrators can manually terminate a user's connection as well.
Enterprises can design their own login and home pages to match individual enterprise styles.
Drill-down can be applied to fields and controls for users to drill down to detailed reports from overall analysis pages.
The following are the file types available for export for each page type: Dashboard: Excel, Word, PPT, PDF, XML, PNG. (Online PPT: Connects back to the server; Offline PPT: Visuals remain interactive) Query: Excel, XML, TXT. Report: Excel, Word, PDF, HTML.
Dashboard page sizes can be adjusted to your specifications.
Dashboard components can automatically adjust to best fit on PCs, tablets and phones. Scaling options: uniform scaling, scale by width, adjust by length and width.
Designers can enable users to subscribe to pages they need.
When default conditions such as "current month" or "current day" are set, query is automatically executed as soon as the page is opened.
Deleted pages can be retrieveded from the Recycling Bin.
When designing pages for the PC, tablet or phone, designers can preview the page on the emulator.
The data model exporting tool can export users, page model and authorization data to SQL Server and Oracle databases.
Auto-play all Cockpit pages. The duration of each page can be set to your specification.
Export pages in the Cockpit as PPT, Word and PDF files.
A color scale divided according to the minimum and maximum values can be applied to measures. The colors are divided into 10 shades.