Welcome to your comprehensive guide on how to set up and use Turnilo! Turnilo is a powerful business intelligence tool designed for Apache Druid. Its user-friendly interface makes data exploration a breeze, particularly beneficial for non-technical users. This article will help you get started with Turnilo, from installation to usage, along with troubleshooting tips.

What is Turnilo?

Turnilo is a web application for data exploration and visualization, created as an open-source fork of Pivot. It was born out of the necessity to simplify Apache Druid’s interface for everyday users, thereby promoting wider adoption across industries. The core focus of Turnilo is to present a clean, intuitive interface that allows users to drag and drop data components effortlessly.

Getting Started

Prerequisites

• Node.js version 14.x or 16.x
• Use npm for dependency management (avoid using yarn)

Installation

To install Turnilo, use the following command:

npm install -g turnilo

Running Turnilo

Start Turnilo with example datasets and open your browser to http://localhost:9090:

turnilo run-examples

Connecting to Druid

To connect Turnilo to your existing Druid broker, use this command:

turnilo connect-druid http[s]:druid-broker-hostname[:port]

Understanding the Code: An Analogy

Think of Turnilo as a well-organized library. In this library, the different types of books represent data types. When you want to explore a topic (like COVID-19 data), you simply walk up to the shelf and pick the relevant books (data sets) you want to explore. The intuitive interface of Turnilo allows anyone, even those who don’t consider themselves ‘data literate,’ to navigate through this library with ease.

Testing and Debugging

Running Tests

You can run all unit tests with the following command:

npm run test

For specific tests, use:

npm run test:common

npm run test:client

npm run test:server

Debugging the Server Module

If you encounter any issues, you can debug using WebStorm or IntelliJ. Set a new configuration with the following parameters:

--examples

For a detailed guide, refer to JetBrains documentation.

Troubleshooting

• Ensure that you have installed the correct version of Node.js.
• If connections to Druid fail, verify that the hostname and port are correct.
• In case of build issues, run npm install to ensure all dependencies are up-to-date.
• For more insights, updates, or to collaborate on AI development projects, stay connected with fxis.ai.

Conclusion

By following this guide, you should now have a smooth setup and operational experience with Turnilo. Its user-centric design encourages effective data visualization and exploration, making it an exemplary choice for non-technical users.

At fxis.ai, we believe that such advancements are crucial for the future of AI, as they enable more comprehensive and effective solutions. Our team is continually exploring new methodologies to push the envelope in artificial intelligence, ensuring that our clients benefit from the latest technological innovations.