Live Chat Icon For mobile
Live Chat Icon

Bring Twitter analytics into your dashboard

Bring Twitter analytics into your dashboard

Introduction

Twitter is a social networking service that lets users post messages known as tweets and interact with them, an activity known as engagement. This service can act as a social medium to improve the reach of your business. With Twitter activity data, you can measure your business’s reach and brand awareness based on tweet impressions, engagements, likes, replies, and retweets, and then use these metrics to grow your business. Visualizing such Twitter analytics data through a dashboard saves people in your organization time by streamlining the processes of collecting data and then transforming it into structured tables based on needed metrics, refreshing the data periodically, and repeating these steps on a daily basis.

In this blog, we’ll see how to bring analytics data from Twitter through the CData Cloud Hub connector and then create a live, interactive dashboard using Bold BI to visualize the data. CData Cloud Hub allows you to create a virtual database for all supported connectors and make it available as a standard SQL interface. Refer to this blog post for more details about CData Cloud Hub connector integration with Bold BI.

Creating a virtual database for a Twitter data source in CData Cloud Hub

In your CData Cloud Hub, click the Twitter data source and create a virtual database by logging in to your Twitter account.

Selecting Twitter in CData Cloud Hub
Selecting Twitter in CData Cloud Hub
Connecting with a Twitter Account
Connecting with a Twitter Account
Authorizing App for CData Connection
Authorizing App for CData Connection
Showing Available Databases in CData Cloud Hub
Showing Available Databases in CData Cloud Hub
Getting MySQL Endpoint Details from CData
Getting MySQL Endpoint Details from CData

Once you’ve authorized and saved the Twitter virtual database, connect to Bold BI with the MySQL endpoint.

Creating a Twitter analytics dashboard

To create dashboard, first connect to the Bold BI MySQL data source using the MySQL endpoint in CData Cloud Hub. It fetches the data from the database server by executing the query every time, and the dashboard shows the latest metrics in real time for live connections.

Selecting MySQL Data Source in Bold BI
Selecting MySQL Data Source in Bold BI
Configuring the MySQL Server Connection
Configuring the MySQL Server Connection

Once you’ve connected to the MySQL data source, a predefined list of tables and views will be displayed. Drag and drop the required tables or views to the canvas and save the data source.

Dragging and Dropping a Table onto the Canvas
Dragging and Dropping a Table onto the Canvas

Now you are all set to create a dashboard. Check out the How to Create a Dashboard video tutorial to get started with dashboard creation.

Streaming Twitter Analytics Dashboard
Streaming Twitter Analytics Dashboard
Filtering Tweets Based on Country
Filtering Tweets Based on Country

In the above sample dashboard, you see the metrics of total tweets, total users, trending tweets, and tweets by country. You can also filter the data by selecting a specific country on the map widget. Finally you can share your dashboard with your team and start collaborating on the Bold BI dashboard online.

If you have any questions, please post them in the comments section below. You can also contact us by submitting your questions through the Bold BI website, or if you already have an account, you can log in to submit your support question. Bold BI dashboards now come with a 15-day free trial with no credit card information required. We welcome you to start a free trial and experience Bold BI for yourself.

Start your free 15-day trial today

3 comments

  1. Hammad
    Hammad
    December 6, 2019 at 6:37 am

    Awesome it Was really helpful.

  2. Mohan
    Mohan
    December 6, 2019 at 6:38 am

    Nice

  3. Vidya
    Vidya
    December 6, 2019 at 7:18 am

    Helpful

Leave a Reply