Setup Metabase and connect to the database

Moureen Caroline — Thu, 15 Sep 2022 16:04:02 +0000

*What exactly is Metabase? *

In a nutshell, it's a free and open source business intelligence tool. Some might describe it as a reporting and dashboard tool. Metabase enables you to easily ask questions of your data and view it in a variety of logical formats.

I came across this amazing tool during my recent Data Analysts technical challenge. I had heard of it but had never used it. Every day is a learning cup, and learning never stops.

Instructions;

I was given the task of importing a spreadsheet into a database and connecting it to Metabase.
Visualize the data by route and time of departure.
Using whatever tools you have at your disposal, forecast which routes and departures are the most profitable, making recommendations on which to expand and which to cancel.

Before adding a new App, one must first create an account with Heroku then new App → Resources → search for ClearDB. I had to use cleardb to connect Heroku to my MySQL workbench using a csv file.

ClearDB MySQL should be expanded in the settings section expose configuration parameters This will enable us to connect to the local database and view the following information;

mysql://b176c32991cf37:14187ffe@us-cdbr-east-**

USER NAME = **

PASSWORD = *

HOST = us-cdbr-east-*

DATABASE NAME = heroku_*

You run heroku config to get the CLEARDB DATABASE URL, which should look like this:
CLEARDB_DATABASE_URL => mysql://[username]:[password]@[host]/[database name]?reconnect=true
So you basically just look at your own url and get everything you need from there. That is how I configured mysql workbench.

'mysql://b0600ea495asds:9cd2b111@us-cdbr-hirone-west-
06.cleardb.net/heroku_4a1dc3673c4114d?reconnect=true'
This will then be your database credentials. (Extracted from the URL above)

USER NAME = b0600ea495asds

PASSWORD = 9cd2b111

HOST = us-cdbr-hirone-west- 06.cleardb.net

DATABASE NAME = heroku_4a1dc3673c4114d

The screenshot shows that the connection between the MySQL workbench and the remote database was successful.

I received an error during the csv file import process, as shown in the screenshot, indicating that it was unicode (utf - 8) with BOM, despite the fact that MySQL supports unicode (utf - 8) so I had to convert it to unicode (utf - 8) as shown in the series of screenshots, then import it again.

I was able to successfully import both my local and remote databases, as shown in the screenshots.

Visualize the data by route as well as departure time for the first question. The number of routes taken in a given period of time.

Routes with multiple counts and representative times

Exploring Metabase using a sample database

Various visualisation features

Query to SQL Conversion

Visualization

My experience setting up a react-native environment on Ubuntu OS

Moureen Caroline — Mon, 02 Dec 2019 16:59:28 +0000

Am a few months old in to serious programming with a background in java that I recently had to change to python due to the application that was assigned to me so am busy trying to understand python and how it works and boom little did I know then I was put on the team building a react- native application , now let’s get this clear i have not done anything in java-script or ES6 nor have I done any react of sorts, yeah confusing right ? yeah I surely was. Now it reaches a time to setup a react native environment on my Intel Pentium machine. So i get access to the react-native documentation and the instructions looked pretty straight forward , so I was like let’s do this!!!! The very thing was going on awesomely until I reached the step that had Android SDK tools that’s where everything became real right before I even wrote a single line of “Hello World ” in react-native. Tried everything possible on the internet but still things were not working out for at least 5 good days straight and the fact that i was installing on an Ubuntu machine did make anything easier since there are a few documents on the same errors that I was facing trying to setup the environment. But I finally got the breakthrough at the end .
Before proceeding, be sure to install the latest version of the following on Linux ( Ubuntu 18.04):
Node (V 12.10 as of writing)
Npm (V 6.10.3 as of writing)
Android SDK tools
Yarn
Git
Genymotion
Virtual-box
others :
USB cable
Mobile phone

After installing the virtual-box and confirming that it’s up and running

Creating the environment for the Android SDK tools;
$nano/etc/profile

Confirm that Android SDK is installed run the following;
echo $JAVA_HOME
echo $ANDROID_HOME

After one has configured an environment variable called ANDROID_HOME, run the following command to accept all the licenses.
yes | $ANDROID_HOME/tools/bin/sdkmanager — licenses

In case one is using Java version 10 and above, you will have trouble running the command above.First run the;
sudo update-alternatives — config java

To downgrade the Java to Java version 8 so that you can be in a position to run the command once again to get all the SDK licenses up-to-date.

Open up two different terminals
Run react-native start
Run react-native run-android
One will notice the execution is at 99% and its stuck at app:installDebug, why!! Cause its running the Genymotion Android Tools (default). You need to change the radio-button to Use custom Android SDK tools ( put the path of your sdktools)

walalalalalalala we got it baby and we are good to GO.
React-Native Here we come BABY!!!

DEV Community: Moureen Caroline

Setup Metabase and connect to the database

My experience setting up a react-native environment on Ubuntu OS