• Posted on
  • By
  • In 3CX

Setting Up Reports and Linking Them with BigQuery, PostgreSQL, and Grafana in 3CX V20 U6

3CX is one of the leading platforms in the field of unified communications, providing integrated solutions that help companies and organizations improve the efficiency of both internal and external communication. With the release of version 20 and later, significant improvements were introduced in how reports are set up and linked with data analysis tools such as BigQuery, PostgreSQL, and Grafana. In this article, we will walk through how to configure these reports and connect them effectively.

Introduction to 3CX V20 U6

Version 20 of 3CX represents a major leap in the world of unified communications, offering advanced features that enhance the user experience and increase work efficiency. Among these features is the ability to set up reports and link them with data analysis tools such as BigQuery, PostgreSQL, and Grafana, enabling companies to analyze their data more deeply and make well-informed decisions.

The Importance of Reporting in 3CX

Reports are an essential part of any communications system, as they provide valuable insight into the system’s performance and how it is used. By setting up reports in 3CX, companies can:

  • Analyze call performance and identify trends.
  • Identify potential problems in the system and take the necessary action.
  • Improve the customer experience through a better understanding of their needs.

Linking 3CX with BigQuery

BigQuery is a cloud-based data storage and analysis system from Google that allows companies to analyze large volumes of data quickly and efficiently. To link 3CX with BigQuery, follow these steps:

Step 1: Set Up a Google Cloud Account

Before you begin, make sure you have an active Google Cloud account. You can create a new account if you do not already have one.

Step 2: Enable the BigQuery API

After signing in to your Google Cloud account, enable the BigQuery API from the control panel.

Step 3: Set Up the Connection Between 3CX and BigQuery

The connection between 3CX and BigQuery can be configured through the 3CX interface, where you enter the credentials for your Google Cloud account.

Linking 3CX with PostgreSQL

PostgreSQL is an open-source database management system that offers great flexibility in storing and analyzing data. To link 3CX with PostgreSQL, follow these steps:

Step 1: Install PostgreSQL

First, you need to install PostgreSQL on your server. It can be downloaded from the official website and installed according to the available instructions.

Step 2: Set Up the Database

After installation, create a new database dedicated to your 3CX data. You can use database management tools such as pgAdmin to make this process easier.

Step 3: Configure the Connection in 3CX

Through the 3CX interface, you can enter the database connection details such as the username, password, and database name.

Using Grafana for Data Analysis

Grafana is an open-source tool for creating interactive dashboards, allowing companies to display and analyze their data visually. To link Grafana with 3CX, follow these steps:

Step 1: Install Grafana

You can install Grafana on your own server or use the cloud version. After installation, you can access the user interface through your browser.

Step 2: Set Up the Data Source

In the Grafana interface, you can add a new data source and link it with BigQuery or PostgreSQL. You will need to enter the connection details, such as the server address and credentials.

Step 3: Create Dashboards

Once the data source is set up, you can create new dashboards to display and analyze the data. Charts and tables can be used to present the information visually.

Case Studies and Statistics

Studies have shown that companies using 3CX together with data analysis tools such as BigQuery, PostgreSQL, and Grafana achieve significant improvements in work efficiency and decision-making. For example, one company was able to reduce its call response time by 30% after analyzing call data using these tools.

Conclusion

Setting up reports and linking them with BigQuery, PostgreSQL, and Grafana in 3CX V20 U6 is an important step toward improving work efficiency and analyzing data more deeply. By following the steps outlined in this article, companies can take full advantage of these tools to make informed decisions and improve the customer experience.

Need help with 3CX? Start a free 3CX trial or request a demo — Call 920033987.