FineBI, developed by Fanruan Software Co., Ltd., is a modern business intelligence (BI) software that empowers users to fully harness data insights. With its robust engine, users can conveniently create data visualizations by dragging and dropping, and analyze data freely to unlock maximum business value.
As a modern self-service BI tool, FineBI enables enterprises to swiftly establish a comprehensive data analysis platform. It empowers each team member to independently analyze and comprehend data, facilitating decision-making and improving business performance. With a complete BI solution, FineBI encompasses everything from data preparation and data processing to visual analysis of data and data sharing. It simplifies intricate technologies, enabling users to intuitively obtain information, discover insights, and share knowledge.
Traditional data analysis
Data layer: design users create data sources.
Application layer: design users create dashboards; admins manage user profiles and access permissions.
Display layer: Users can visualize and share dashboards through the front-end interface for editing and viewing.
FineBI runs on pure Java and employs B/S architecture. You can refer to the technical architecture diagram displayed below for more information:
FineBI offers multiple core features, including New Analysis Paths, Data Management, Data Editing, Powerful Functions, Data Visualization, Data Collaboration and Sharing, and Enterprise-Level Application.
FineBI presents users with subjects to streamline data, components, and dashboards for an in-depth analysis. With a clear operation path, users can grasp analysis skills effortlessly and immerse themselves in data exploration.
1. Data Integration
FineBI supports the connection with over 30 big data platforms and SQL data sources, and allows for Excel file datasets. With FineReport Designer, users can even access more diverse data sources like multi-dimensional databases and program datasets.
2. Data Space
FineBI offers two modules to store data: Public Data and My Analysis.
Public Data is the enterprise's data repository, which users can utilize for analysis. Additionally, users can publish their own analysis to Public Data for other users to use.
My Analysis is primarily for personal data analysis and dashboard creation.
This framework helps admins efficiently manage public data, enhance data reliability, and minimize production of duplicate datasets.
3. Data Classification
FineBI employs a folder-based approach to data management, enabling users to classify data according to various business package subjects. It also provides a wealth of information related to data, making it simpler to comprehend the data users have.
4. Data Modeling
With FineBI's data modeling function, admins can easily model the data based on the relationships in users' data warehouse. Users can also manually configure the linkage, including support for composite primary key linkage configuration.
Once users have this model established, they can simply use FineBI's self-service datasets to explore data and perform joint analysis on related datasets without the need to manually configuring linkages.
FineBI provides visual data analysis that helps users easily and intuitively identify data issues. With a user-centric visualization analysis style, the system can recommend visual effects depending on the data chosen by the user, thus speeding up data analysis.
FineBI's self-service dataset offers functionalities such as adding columns, grouping summaries, filtering, sorting, merging up and down, merging left and right, etc., allowing users to streamline data processing with minimal learning costs. Thus, IT personnel can be more focused on preparing basic data, while the experienced business analysts take up actual data analysis and processing.
1. Basic Functions
Basic functions include logical functions (IF, AND, SWITCH, OR), mathematical and trigonometric functions (MIN, MAX, RAND), date functions (MONTH, YEAR, TODATE), and text functions (SUBSTITUTE, FORMAT, LEFT). Users can choose the desired functions for calculations based on the field type or calculation logic.
2. Advanced Functions
a. Aggregation functions: Users can use these functions to summarize data, and their post-aggregation values are usually utilized for further calculations. Different aggregation functions correspond to unique methods of summarization, such as sum, average, median, maximum, minimum, standard deviation, variance, distinct count, and count. The calculated field will automatically adjust with the dimension whenever you switch the analysis dimension.
b. DEF function: This function includes both nested combination (def-add\def-sub) and sorting combination (rank-add\rank-sub) functions. Users can use these functions to generate any desired calculation indicator, regardless of the level of complexity, by simply combining them with basic functions.
1. Multi-Dimensional Exploratory Analysis
FineBI automatically recognizes dimensions and indicators based on their data types and offers extensive analysis capabilities for both. You can adjust drilling levels, re-group data, and apply various calculation methods, including summation, median, cumulative value, ranking, and proportion, to explore and compute basic data.
Based on The Grammar of Graphics, FineBI design its logic of visualization analysis, providing limitless visual analysis options with endless charts, property mapping, and facet analysis.
FineBI's visualization feature simplifies data analysis for business professionals while also removing chart type limitations. An array of shapes, such as column chart, point, line, area, rectangle block, pie chart, text, funnel chart and so on can be tailored to combine with color, size, prompt, label, and fine-grained resulting in visually stunning data displays.
FineBI also offers charts such as Color Table, and KPI Indicator Card. The data processing engine and chart rendering mechanism can handle large data volumes and display data up to millions of levels on the front-end.
With the dashboard function, users can merge various analytic data and generate a unified report for effortless monitoring of crucial indicators and production of work reports.
Dashboards come equipped with adaptive layouts, theme style customization, web components, and multiple tab components, and other features to help users effectively exhibit and communicate data analysis findings. In addition, filters allow for data filtering, component linkage enables related analysis, and a jump function makes it possible to combine multiple dashboards into a single larger subject.
4. Data Collaboration and Sharing
FineBI offers three data collaboration and sharing modes: Collaboration, Data Sharing, and Dashboard Sharing.
Subject collaboration: FineBI integrates self-service datasets, components, and dashboards into subjects, enabling users to collaborate and share viewing and editing permissions with others on these subjects.
Data sharing: In Public Data, users can find fundamental datasets such as DB tables and SQL datasets added by admins. Moreover, users can publish self-service datasets from My Analysis to Public Data. Upon submission of a dataset for publication, it undergoes a review process by an admin and is then authorized for publishing to the appropriate folder, allowing for smooth data sharing.
Dashboard sharing: After analyzing data on the dashboard, users can create a public link or request to publish it to Public Data to grant access to other users. Additionally, users can share it directly for viewing.
FineBI's data development module features powerful data preprocessing capabilities. It offers a low-code approach to visually cleanse multiple sources of heterogeneous data from various business systems. Its high-performance ELT/ETL dual-core engine ensures standardized and clean data, directing it straight to the ETL dataset of FineBI. Along with data synchronization, data transformation, SQL-based data query, task scheduling, and more, the data development module is designed to provide users with clean data for subsequent self-service data analysis.
1. High Concurrency and Availability
a. Business data availability: FineBI's cluster includes synchronous and asynchronous nodes. Even if there is only one operational synchronous node available, users can enjoy complete data availability and robustness. If a data update interruption (such as node failure or downtime) occurs, FineBI's recovery mechanism restores ongoing sub-processes to their pre-execution states and restarts them, ensuring high business update availability.
b. High-quality concurrent query: Users can use multiple nodes to make queries simultaneously provide query services, ensuring efficient load balancing. Additionally, the query concurrency scales linearly with the number of nodes, allowing users to effectively handle an increase in query traffic.
c. Improved update throughput: Users can significantly enhance update performance by adding nodes. More nodes mean less time required for updates.
2. High-Performance Computing Engine
a. Analyze large datasets with minimal structure
FineBI minimizes disk I/O through advanced columnar storage, and reduces data storage space with powerful compression technology, saving your disk space. With memory computing and ETL logic, FineBI enables fast computation and processing of large data volumes, enabling analysis of both real-time and historical data.
b. Make data preparation efficient
FineBI makes data preparation efficient and flexible with its high-performance incremental update feature. This ensures quick and efficient updates for all types of data scenarios, reducing the time for update and alleviating pressure on the database server. For users dealing with large historical data volumes, they can update the historical data in batches into FineBI through single table incremental updates.
3. Enterprise-Level Permission Management
FineBI's decision-making system features two aspects of permission management: permission and permission recipient.
FineBI's permission system refers to assigned objects such as dashboards, platform management, templates, and data connections. Users can use templates and data connections during remote design.
Permission recipient refers to the individuals or departments/roles that can be granted permissions via FineBI's role-based permission allocation system. Additionally, FineBI also provides a specialized permission setting function for specific allocation needs among individual users.
4. Availability Across Screens
FineBI seamlessly integrates with mobile apps, optimized for mobile device operations, including page zooming. Additionally, templates can be shared between the PC and mobile versions, saving valuable development time.
Our DataAnalyst app is user-friendly and available on both IOS and Android systems. It includes interactive gestures within charts and drill-down linkage to enhance users; experience. For security purposes, the app supports hardware address binding, VPN, single sign-on, password protection, and other robust security settings to keep your information safe.