Salta al contenuto

Documentation BI4H (EN)Documentation BI4H (EN)

  • Quick Start
  • Navigation
  • Interactions
  • Charts
  • Tables
  • Filters
  • Modules
  • Data Explorer
  • Self service
  • Quick Start
  • Navigation
  • Interactions
  • Charts
  • Tables
  • Filters
  • Modules
  • Data Explorer
  • Self service
  • Quick start

    • Start up

    • Profile

    • Top tool bar

      • Change theme layout
      • Language selection
    • Elements of BI4H

    • What is the HUB

    • What is the APP

    • What is a module

  • Navigation

    • Tiles & child buttons

    • Navigation bar

    • Stepper

    • Sidenav

    • Bookmarks

    • Schedule

    • Global search

  • Interactions

    • Point & click interaction

    • Change chart type

    • Export widgets

    • Fullscreen

    • Additional details

    • Modal windows

  • Charts

    • Lines

    • Colums

    • Composed lines-columns

    • Bars

    • Area

    • Bubble

    • Pie

    • Heatmap

    • Funnel

    • Treemap

    • Geographical maps

    • Gauge

    • Scatter plot

    • Range

    • Sankey

    • Radar

  • Grids

    • Grids option

    • Simple grids

    • Group grids

    • Pivot

  • Filters

    • Smart Filter Bar

    • Filter layout

      • Single filter
      • Group filter
      • Expanded filter
      • Tree filter
      • Builder filter
      • Search filter
    • Filter types

    • Filter options

    • Interactions

  • Modules

    • Numbers

    • Tab

    • Buttons

    • List Indicator

    • Street maps

    • Aid to interpretation

  • Data Explorer

    • Introduction

    • Configuration

      • Edit module -> Generals
      • Edit module -> Aspect
      • Edit module -> Sharing
    • Create a new query

      • Add fields from Univers
      • Add fields from tables/snippets
      • Conditions sections
      • Advanced mode
    • Existing query

      • Run an existing query
      • Create a query using existing query
    • Sharing

      • Share a query
      • Run a shared query
    • Export results

    • Query category

  • Self service

    • Your first dashboard

      • Adding a new page to the app
      • Adding modules to the page
    • Edit Module -> DATA tab

      • Dimension & Alternative Dimension
      • Measures & Alternatives Measures
      • Categories for alternative data
      • Name of dimensions & Measures
      • Sorting of Dimensions & Measures
      • Visibility of Dimensions & Measures
      • Measures Formatting
      • Measures Threshold
    • Edit Module -> ASPECT tab

      • Title customization
      • Show Legend & Customization
      • Box colors
      • Split module
      • Box Options
      • X Axis
      • Y Axis
      • Chart Colors
      • Type (Rotate, Invert, stack)
      • Zoom
      • Tooltip
      • Average
      • Values
      • Change type
      • Other (Aspect)
    • Edit Module -> INTERACTIVITY tab

      • Action
      • Filters
      • Data
      • Other (Interactivity)
    • Edit page - Generals tab

    • Edit page - Options tab

      • Options (Page)
      • Filters (Page)
    • Edit page - Info tab

    • Edit page - Other tab

    • Rendering examples

      • Column chart combined with a line
      • Stacked chart
      • Chart with opposite axis
      • Chart with a constant line
  1. Docs
  2. Data Explorer
  3. Introduction

Introduction

Reading time:

Updated to V5.3.0

BI4H has integrated an innovative data exploring tool , to make the data usable in a completely customizable and free way.

Using a user friendly editor, it is possible to create queries without having data model knowledge and skill on SQL.

All information (dimensions and measures) presented in the dashboard is available in data explorer via Universe. They are ready to exploit.

Conditions can be applied to filter the results with “AND” and “OR” logics, even for groups of variables. It is also possible to create custom variables with SQL syntax.

The results are shown in a paginated navigable table , with optimized rendering even on large amounts of results. The resulting table can also be exported in the following formats: xlsx, csv.

The configuration of the extraction performed (tables, variables, conditions) can be saved in views for future executions.

Last update: 3 April 2025
Views: 277

© 2025 Documentation BI4H (EN)

Powered by WordPress

All'inizio ↑ Su ↑