For most companies with their own databases, generating insights from their business in a timely manner is often a tricky or slow task.

Imagine being able to change this reality and be able to follow in real time the update of your data. Believe me, this is possible with the Fourtwo!

In this post you will see how easy it is to connect your favorite analytic or transactional MySQL Database and generate a Dashboard to get an overview of the tool’s capability. Come on?

Step 1

After logging in to Fourtwo, click Connections.:

Step 2

Click MySQL and then Add Connection:

Step 3

Enter the connection data for your database. This step may vary slightly depending on the selected database, for example: When selecting an Oracle Database Fourtwo will request SID which is a required info from this specific SGDB.

Step 4

After registering your database you will return to the list of MySQL Databases. Click on the gear and then “Add Query” to register your Queries, Tables or Views.

Step 5

In this example we use “Query” we search the Top 10 of the most spoken languages in our example database. Fourtwo will automatically try to determine the query metrics and dimensions, and if it misses any fields, the user can correct this at this time.

Click Save and your query will be ready for use!

Step 6

In a blank Dashboard, we add a Column Chart widget and in this widget we select:

  • Data Source: MySQL
  • Host: Choose the desired Database
  • Query: Select the pre-registered query
  • Dimensions and Metrics: Select the dimensions and metrics you want to display.
  • Click on Save

Done, now you can enjoy your Dashboard!

Ready to change the way you create reports?

Read more

10 tips for being more productive on and off your work

Many people think that productivity is always being busy, all the time taken. While in fact, productivity is synonymous with efficiency. That is, doing the same amount of work in less time. Being productive, then, will give you more stress free moments to...

Optimize your Google Ads campaigns with these 3 tips

With so many metrics available, we sometimes forget to focus on some key analytics and apply optimizations that can quickly improve campaign results. We listed 3 tips that can improve the results of your Google Ads campaigns.. 1) Check the time the...

5 Tips to follow on your next Google Ads Report

We've made a list of 5 tips that will help you make a Google Ads report that is objective, conclusive and not least good for the eyes.1. Define report purposeBefore you start writing the report, know your purpose well. It will assist you in the display...

How important is Reporting Automation for Your Digital Agency

How to achieve the highest results the fastest way? How to reuse something that has already been done? What do I get besides time?With a digital marketing reporting automation tool, you gain the scale to produce reports for customers you couldn't before....

5 reasons that confuse your Digital Marketing Report

Tired of spending hours and hours creating your digital marketing report and in the end still feeling that you are not the way you expected? Don’t panic! We are here to help you! With the daily rush, sometimes, it is normal to go straight to production,...

Important topics in a report delivering

Reports are an important tool for tracking results and seeking insights to make decisions.In addition, other topics are important in the process of delivering a report: customer relationship, care and attention. For this reason, we have listed some...