PRODUCT

OQLIS makes it easy to quickly visualise your data without losing any of the detail, at its heart OQLIS is an analytics technology built into a web app, you can build your organisation a completely tailored experience, hosted in the cloud, its accessible through the web, mobile device or embedded into a custom application.

Reliable Source of Truth

A Data platform that ensures reliable metrics and consistent definitions.

Explore All your Data

Anyone can get the whole picture to answer their own questions.

Create a Data culture

Drive Data driven decision making everyday.

CONNECT

MODEL

EXPLORE

SHARE


How will you use OQLIS?

INTERNAL ANALYTICS

Share Insights internally across your entire Team
Build in house Dashboards that support all operations
Perform detailed analysis of Problem areas
Schedule distributed reports on specific intervals

EMBEDDED ANALYTICS

Collaborate with external parties
Share Data with customers and suppliers
Embed Visuals and Analysis into existing applications

 

CORE FEATURES

With auto syntax completing and a schema explorer, build advanced Data Models with raw SQL with ease.

When building a data model, you have the flexibility and complexity of SQL with the advantages of auto completing and beatifying your code as you type, with recognition of table aliases, you can build complex queries in half the time without knowing the schema.

Business Users can leverage the skills of a few to explore Data through a drag and drop interface

Drag measures and group by dimensions to quickly analyse core business issues, change fields and filter by values to dive into insights.

With Multiple Chart types you can visualize your data any which way you want from Bar Graphs to Chlorpleth Maps

Pick from over 30 chart types, stack bars, lines, areas and splines, plot gauges or simple display the data as a table. From single KPI’s to plotting locations on a map, we have you covered.

Embed Charts and Dashboards into external applications with just one line of code.

There’s no need to move your data with embeddable charts and dashboards you can embed directly into your favourite external applications.

Advanced Dashboard filters allow you to drill into specific dimensions.

When building a data model, you have the flexibility and complexity of SQL with the advantages of auto completing and beatifying your code as you type, with recognition of table aliases, you can build complex queries in half the time without knowing the schema.

DataSources

Analyse your Data where it lives

OQLIS executes in database, therefore we do not move subsets of data, so you can access your data quickly and using your own infrastructure

Under the hood

Browser Based UI

Simple, elegant, HTML5-based search interface that
offers search suggestions as you type and creates results,
visualisations and summaries instantly.

Speak Database Language

Building data models from SQL allows technical users to
leverage existing queries and knowledge to build reusable
views for other users to explore

Smart Query Cache

With a smart query cache built in, it reduces the workload
on your database server allowing multiple users to access
the same data instantaneously.

Direct Data Connections

With direct access to the database there is no need to
move or migrate data. All connections can revalidated and
audited from inside the system.

FAQ

What is Business Intelligence (BI) Software as a Service (SaaS)?

Software as a Service business intelligence (SaaS BI) is a delivery model for business intelligence in which applications are typically deployed outside of a company’s firewall at a hosted location and accessed by an end user with a secure Internet connection. Also known as on-demand BI or cloud BI, the technology is sold by vendors on a subscription or pay-as-you-go basis instead of the more traditional software licensing model with annual maintenance fees.

What are the advantages of the OQLIS BI SaaS offering?

  1. SaaS BI lets companies use BI tools without having to install, operate and maintain them on-premise, freeing customers to concentrate on creating BI reports and analytic queries.
  2. Organization’s can potentially start using SaaS BI technology more quickly than waiting for the installation of on-premise software, and the SaaS approach enables them to expand their BI systems as usage grows without having to make any capital-equipment purchases.
  3. SaaS BI can be a good choice when there’s little or no appetite for buying BI software and related hardware. Because there aren’t any upfront purchase costs or additional staffing requirements needed to manage the system.
  4. Total cost of ownership (TCO) is substantially lower than it is with on-premise software.

Is my Data secure when I use OQLIS analytics?

Yes, OQLIS uses the following measures to ensure that data is secure

  1. The OQLIS web site is protected by 256-bit encryption and secure Https authentication.
  2. OQLIS accesses the database with a read only user that is created by the customers’ database custodian, and can be removed at any time.
  3. A single IP address is registered on port 1433 of a customer’s firewall, to ensure that only OQLIS server can connect using a read only user on the database.
  4. The customer designated administrator assigns security rights to all users that log onto the system, this includes the rights to view and change any reports within the system. NO users can alter data.
  5. The customer database architect is responsible for creating query structures for database explore functionality and assigning these rows and tables within the database to the authorised stakeholders.

Who Owns My Data?

You as the customer own your data, OQLIS does not store your data on its servers but only the result at the time at query. This means that your data will remain on your server where the data is housed and does not leave your server.

 Where is the OQLIS platform housed?

OQLIS is housed in the MTN data centre in Gauteng.

Can OQLIS scale as per my business needs?

Yes, the OQLIS platform is designed to scale as per ongoing customers’ requirements, and in theory is unlimited. The only limitation is based on the capacity of the MTN’s data centre infrastructure. Further all queries are conducted on the database at the origin, reducing reliance on bandwidth and infrastructure.

 Does Oqlis offer and on-premise BI Offering?

Yes, we understand that certain customers and industries will not adopted off premise solutions due their industries and legislation.

Which databases does OQLIS connect to?

OQLIS can connect to various databases, MySQL, MySQL SSH, Microsoft SQL, PostgreSQL, Big Google Query, CSV and Excel.

Does OQLIS use a proprietary query language?

No, OQLIS uses SQL queries, thereby ensuring access to skills and not “reinventing the wheel” when it comes to setting up customer explores.