DEV Community: Ramy Gamal

Build INTERACTIVE Analytics Dashboards | METABASE. Part2: Connecting to Database

Ramy Gamal — Sat, 14 Aug 2021 15:14:37 +0000

After submitting your profile information you will need to provide database connection so metabase can process your data.

Metabase supports wide range of databases including:

MySQL
PostgreSQL
MongoDB
SQLServer
Oracle
And more! you can check list of officially supported databases

In this tutorial we will use MongoDB sample database as our data source.

Connecting to MongoDB

We will need to get database connection string. So in your ATLAS dashboard press on Connect, then get the connection string.

You will have a connection string similar to this one

mongodb+srv://DB_USER:*******@cluster0.4i388.mongodb.net/sample_analytics?retryWrites=true&w=majority

So copy it and replace the placeholders and then provide the connection string to metabase.

Important Note

Make sure to whitelist all the IPs in your ATLAS configuration so metabase can access it.

Now the database is added as a data source in metabase and automatically metabase started generating some charts for you.

It was pretty easy right? In the next post we will discuss how to create custom charts in metabase.

📊 Build INTERACTIVE Analytics Dashboards | METABASE

Ramy Gamal — Sat, 14 Aug 2021 14:22:56 +0000

There actually exists a free, open source and cool service that helps you visualize your own data. Welcome to Metabase!

Metabase is a powerful platform that allows you to ask question about your data, then it will do some science and eventually you will see your question is answered with generated charts.

Getting Started

Although there exist enterprise (paid) plans on metabase, but you can still build it locally by following this guide. Or you can deploy it on heroku with a press of a button.

We will go with the heroku approach. Once you press the deploy to heroku button you will be redirected to heroku. Enter the application name and hit the deploy app button.

There is an authentication system that is built in metabase. So in your first time accessing your platform you will add your account details you will use to access your dashboard in the future.

In the next post we will discuss connecting to your database. So let me know in the comments what do you think about metabase and if you know similar platforms!

My Great Project !

Ramy Gamal — Wed, 20 May 2020 16:14:40 +0000

Home Eats

Home Eats is our first Mobile Application ever! We had like only 2 weeks to learn android, firebase and deliver a working project, and that we did 💪

We are a team of Software Engineering students in Ain Shams university, Egypt. We had a project that is required to be built in android and have interactions with google services as Firebase, maps,..etc.

We had no idea about how to build a mobile application. We split ourselves into 2 teams, one team is responsible for building the UI of the application and user interactions, and the other team was responsible to build the firebase database and write the backend code that interacts with the database, maps and other services.

In the first week we had to learn many concepts and fundamentals on how to build a mobile application. and the second week was the coding part.

We built a library that we called Firebase Dao. It was responsible for handling all our interactions with the firebase database. you can find it here:
https://github.com/islammohsen/FirebaseDao

I am very proud of this project and I believe it was my best one!

You can find the project here:
https://github.com/polamokh/HomeEats-Android

Stickers Programming Quotes

Ramy Gamal — Wed, 20 May 2020 15:56:52 +0000

Hello all 👋

I am Ramy, Software Engineering student in Egypt.🐫

I run a small business here which is responsible for creating cool STICKERS for developers and other categories.

I am looking forward to hear from you some short, and funny quotes that can fit in a sticker and you would be happy to have it STICKED on your laptop!

Quotes Example: I wear 👓 Because I don't C#.

Be creative and don't hesitate to comment even if it is a silly quote 😹

Egypt's First Hacktoberfest Event !

Ramy Gamal — Wed, 30 Oct 2019 18:28:45 +0000

who are we ?

We are Open Source Community -casually we call it OSC-, a student community that resides in Computer Science - Ain Shams University, Cairo, Egypt.
We organise many events during the year as we make workshops, help students install linux and many other events.

Get to Git

We are proud to organise the first Hacktoberfest event in Egypt ! The event was called " Get to Git " on 28 October.
It included a talk about open source, other talk about an introduction to git and GitHub and how are they used and at last a session to help students start using git.

You can check the event photos and slides.

If you have any question leave me a comment :D.