- Overview:
NativeBI is a powerful self service business intelligence platform that allows the business leaders of an organization to visualize, study and analyze all the entity’s data at one place through interactive built-in charts.
NativeBI is totally ad-hoc. Business users can construct completely customized dashboards and reports as per their permissions without the need to having any technical skills or even referring to the IT department.
- Supported Data Sources:
NativeBI currently integrates with the below data sources:
– Oracle Database
– SQL Database
– MySQL Database
– REST JSON APIs
– RSS Feeds (News)
– Excel Sheets
– CSV Files
– Twitter Feeds
– Facebook Feeds
And we are in the process of supporting the below data sources:
– MongoDB
– MariaDB
– Cassandra
– Azure
– Google Analytics
– Google Sheets
– Google Drive
– Dropbox
- Data Extraction:
The solution supports 2 models of data extraction: Live and Cached.
– Live Extraction: The application doesn’t save any data in the warehouse; however, it opens a live connection to the destination data source each time a user opens a dashboard or a report that reads from this data source.
– Cached Extraction: The application replicates the data of the destination data source, cleans it, then cache it inside the warehouse. When the user opens a dashboard or a report that reads from this data source, the application reads the data from its local warehouse without the need to open any live connection.
- Data Refresh:
With the cached extraction model, the data is read and refreshed from the destination data source through a refresh interval that is predefined by the application administrator.
The time intervals that the admin can specify are:
– Every n hours
– Every n days
– Once a week
– Once a month
– Every 3 months
- Types of Users:
NativeBI supports 3 types of users:
1- Admin: Admin user has full control over all the features of the platform. He imports, manages, and synchronize the data sources of the organization. By default, when you signup to the cloud application, you get an admin user with specific organization id.
2- Analyst user: Analysts are the one who builds and manages dashboards, they have full control over all the dashboard building features and can share the dashboards with other users inside and outside the organization.
3- Viewer user: The viewer user is a read-only user that can’t add or edit dashboards and reports. He can only see the dashboards that are shared with him with the ability to visualize and download the dashboard and widgets.
- Solution Features:
Below we list the main features of the solution:
1- Integrate with several data sources like: Oracle Database, SQL Database, MySQL Database, REST JSON APIs, RSS Feeds, Excel sheets …
2- Ability to read data from data sources through 2 ways: Live(online) or Cached(offline)
3- Allow business users to build KPIs, dashboards and reports on the fly through a set of predefined charts and widgets. Business users can get the most of their data without the help of the IT department.
The currently supported widgets are:
- Pie chart
- Bar chart (Stack/NonStack)
- Line chart (Stack/NonStack)
- Counter
- Table
- Performance/Progress
- List
- Map
4- Ability to drill down on any widget inside the dashboard, user can define the drill down attributes by himself.
5- User can define the font color and background color of each cell within a table widget.
6- User can limit the number of records to be displayed at the level of each widget.
7- User can create as many dashboards as he wants, and can set one of them as his favorite which will open by default each time he logs in to the system.
8- User can open the dashboard on full screen and can set the automatic refresh period of it.
9- All data are displayed as per the user’s permission and privilege.
10- User can control the size and position of widgets inside the dashboard.
11- User can build a dashboard that reads from multiple data sources at the same time.
12- User can export a dashboard to PDF.
13- User can assign a permission for other users to view his dashboard.
14- User can share a dashboard publicly to be viewed by other users who don’t have the system.
15- The system provides a free text search box in the home page, which allows the user to search for any keyword in all supported data sources as per his permissions.
16- User can define alerts based on specific criteria. System will automatically notify the user when the alert’s criteria are satisfied.
17- User can define slideshows in order to display multiple dashboards with automatic switch in a full screen mode.