Once your data source is connected, you can begin by creating self-service data sets. FineBI enables users to extract relevant tables and fields and customize the data sets based on their specific analytical needs.

Key operations include:

• Selecting Fields: Choose specific columns to focus on necessary data only.
• Joining Tables: Combine multiple tables using key relationships to enrich your data set.
• Adding Calculated Fields: Define new metrics using formula expressions.
• Applying Filters: Filter out unnecessary records to streamline the data set.

You can preview the results of your operations at any time to ensure the data set meets your analysis requirements.

For cases where data needs to be consolidated from multiple self-service data sets, FineBI offers the Union Data Set feature. This allows you to:

• Merge Multiple Data Sets: Combine similar data sets into one unified source.
• Ensure Data Consistency: Align fields and formats across different departments or systems.
• Apply Further Processing: Perform calculations or filtering on the unified data set.

This is particularly useful when integrating data from different business systems for comprehensive analysis.

VisoraBI supports both row-wise union and column-wise union, giving you flexibility depending on your data structure.

VisoraBI provides a range of built-in data cleaning tools to ensure data quality and consistency:

• Edit Field Names and Types: Standardize field names and data types for clarity.
• Handle Null Values and Duplicates: Replace, remove, or fill missing values and eliminate duplicate records.
• Standardize Values: Ensure values follow a consistent format.
• Sort and Group Data: Organize the data meaningfully to prepare for analysis.

Clean and refined data at this stage helps prevent downstream issues such as incorrect visualizations or misinterpretation of results.