Beginners Guide how to Install Superset (Opensource BI platform) on EC2 AWS instance
Why SuperSet?
Superset is a data exploration platform designed to be visual, intuitive and interactive, the main objective is to slice, dice and visualize data easily. It is open-source BI platform which can be deployed on every virtual server with no usage costs. Some of the main advantages are:
- it is maintained by Apache foundation and supported by AirBnB
- Many visualization and ability to edit the code
- Support geolocations and uses mapbox
- Able to cache data for dashboards visualizations
- Admin panel available with very detailed settings
- Able to access many SQL and NoSQL databases
- Easy and friendly user interface
According to GitHub repo, Superset is currently being used by Airbnb, Twitter, GfK Data Lab, Yahoo!, Udemy and many others.
We at ShopUp decided to give a try of that great platform and noticed that as products driven by the community, sometimes there is missing documentation. We have met some difficulties in setting up the platform on EC2 instance, therefore decided to share the steps and to contribute. Also there is a video on our channel where we did all steps and if you prefer to watch rather than read that is your place.
Let’s start
Video
Open AWS console
Once you log in find EC2 services and enter into EC2 instance
- Launch instance
- Select Ubuntu free-tier eligable – t2.micro
- Select storage, we choose 8 GB
- Security group – choose all traffic
- Assign key to the instance
- Launch it
Log into EC2 Instance:
You can select option connect from the menu where the instance is something like
"ssh -i "your_certificate.pem" ec2-user@ec2-25-193-24-151.eu-central-1.compute.amazonaws.com"
Get root access
sudo -i
Installations
We are starting with seting up the environment like update Python and PIP versions on EC2 (Amazon AMI) and installing other required packages
sudo apt-get update
sudo apt-get install build-essential libssl-dev libffi-dev python3.6-dev python-pip libsasl2-dev libldap2-dev
Create Python virtual environment
It is recommended to install Superset inside a virtualenv. Python 3 already ships virtualenv.
apt-get install python3-venv
pip install virtualenv
python3 -m venv venv
. venv/bin/activate
Superset installation and initialization
Follow these few simple steps to install Superset.:
# update to latest version
pip install --upgrade setuptools pip
# Install superset
pip install apache-superset
# Create an admin user (you will be prompted to set a username, first and last name before setting a password)
export FLASK_APP=superset
flask fab create-admin
# Initialize the database
superset db upgrade
# Load some data to play with
superset load_examples
# Create default roles and permissions
superset init
#Start screen session
screen
#Start the web server on port 8080, use -p to bind to another port
fabmanager run --app superset
Then you need to detach from the screen and use keyward combination – Ctr+A + Ctr + D and you are ready for the next step.
Access the webserver
Copy external IP of EC2 and add port 8080, like “3.126.245.134:8080” and paste it on your browser.
Your first report can visualize csv data, so for that reason you need to enable CSV upload.
Enable Upload CSV – Go to Sources -> Databases and edit examples database -> Check Allow CSV upload
Conclusion
We hope that you found what you were looking for.
Now you are able to create your first visualization of any data, it is better to refer to some of templated dashboards and to watch different videos and manuals, also the platform can be personalized with your retailer or ecommerce name and logo.
That is all for now, please let us know what you like and what else you want to hear.
Analyze and predict physical customers’ patterns in Hypermarkets with high precision using the latest advancement in technologies | ShopUp
April 13, 2020 @ 9:08 am
[…] are also considering migrating some of our old visualization dashboard onto the opensource platform SuperSet, which is scalable and able to deal with huge amounts of data. We expect that during the time […]
January 11, 2023 @ 9:30 am
I’m now not sure where you are getting your information, however great topic.
I must spend a while studying more or working out more.
Thank you for fantastic info I used to be looking for this information for
my mission.
January 27, 2023 @ 1:37 pm
Hello there! This article could not be written any
better! Reading through this post reminds me of my previous
roommate! He always kept preaching about this. I most certainly will send this
post to him. Fairly certain he’ll have a good read.
Thanks for sharing!
January 31, 2023 @ 12:45 pm
Howdy! I just wish to give you a huge thumbs up for the great information you have here on this
post. I am coming back to your blog for more soon.
May 19, 2023 @ 11:06 pm
Pretty! This has been an extremely wonderful article.
Thank you for supplying this info.
July 30, 2023 @ 6:23 pm
Hey There. I discovered your blog using msn. This is a very smartly written article.
I’ll make sure to bookmark it and return to read extra of your helpful info.
Thanks for the post. I’ll definitely comeback.
September 9, 2023 @ 7:39 am
Oh my goodness! Impressive article dude! Thanks, However I am encountering problems with your RSS.
I don’t know the reason why I can’t join it. Is there anybody having similar RSS issues?
Anybody who knows the solution can you kindly respond? Thanks!