Part 3: Data Visualization with Grafana

Hello, in this part you will learn how to visualize data with grafana. I hope you have done read part 1 and part 2

Part 1: Introduction to Data Visualization

Part 2: Create API Bigquery to Postgresql with Nodejs

Photo by Adeolu Eletu on Unsplash

What will we do ?

1. Run Postgresql and Grafana With Docker
2. Setup Config Connection Grafana to Postgresql
3. Create Query and Visualize
4. Analyst

Let Get Started :D

Run Postgresql and Grafana With Docker

1. Open folder bigquery-api-nodejs
2. Run your docker machine with

sudo docker-compose up

Nice !! , Service is running Successfully

Setup Config Connection Grafana to Postgresql

Now open Grafana with :

localhost:3000

Login with default username and password

username: admin
password: admin

If you want change password, change it if no just skip

Now, Go to Configuration and add new data source

• Setting according your postgres config then click save
• Yey, done setting config db in Grafana :D

Create Query and Visualize

Now Create New Dashboard

Next click Choose Visualization and select Graph

Change Mode to Series

Next click Add Query

I usually change it to text mode

Create simple query to show device browser

And Boom it’s show, yeyy :D

This is an simple example, You can explore it again with more complex visualization :D

Analyst

From above graph, we can conclude that from the 1000 existing data, the most users use chrome (712) to access our website, the second is safari (189) and the third is Internet Explorer (21). Because of the many users who access with chrome, of course we must be able to increase and optimize the performance of the website in the chrome browser. After that the other browsers must also be optimized

Thank you for reading :D

And sorry if there an mistake in words, if you have a suggestion or error please comment below :D

Grafana: The open observability platform

rafiudd/bigquery-api-nodejs