Metabase

Hadoop HDFS Big-data analysis

Please feel free to contact us

Go
img

About

Metabase the classiest, simplest and fastest way to provide business intelligence and analytics to each person working in the company. Pushing data is one of the things in which it has achieved a great level. It is written in Clojure and offers multiple options such as Mac application, Docker image, cloud images and a jar file which are designed specifically for particular use cases.

Miri Infotech is launching a product which will configure Metabase to a wide variety of statistical (linear and nonlinear modelling, classical statistical tests, time-series analysis, classification, clustering) and graphical techniques which is embedded pre-configured tool with Ubuntu 16.04 and ready-to-launch AMI on Amazon EC2 that contains Hadoop, Hbase and SQL interface.

Now, while going through the information, the most important question arises is that why we choose metabase?

And to answer this is that, we should understand a concept of Pulses! It’s a feature in metabase that gives you the ability to automatically send regular updates without any intervention to your teammates to keep a full track on the changes that are done to the metrics which matters you the most.

The Metabase application has two basic components

1. A backend written in Clojure which contains a REST API as well as all the relevant code for talking to databases and processing queries.

2. A frontend written as a JavaScript single-page application which provides the web UI.

Supported Databases

  • Postgres
  • MySQL
  • Druid
  • SQL Server
  • Redshift
  • MongoDB
  • Google BigQuery
  • SQLite
  • H2
  • CrateDB
  • Oracle
  • Vertica
  • Presto

You can subscribe to Metabase, an AWS Marketplace product and launch an instance from the Metabase product's AMI using the Amazon EC2 launch wizard.

  • To launch an instance from the AWS Marketplace using the launch wizard
  • Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
  • From the Amazon EC2 dashboard, choose Launch Instance.
  • On the Choose an Amazon Machine Image (AMI) page, choose the AWS Marketplace category on the left. Find a suitable AMI by browsing the categories, or using the search functionality. Choose Select to choose your product.
  • A dialog displays an overview of the product you've selected. You can view the pricing information, as well as any other information that the vendor has provided. When you're ready, choose Continue.
  • On the Choose an Instance Type page, select the hardware configuration and size of the instance to launch. When you're done, choose Next: Configure Instance Details.
  • On the next pages of the wizard, you can configure your instance, add storage, and add tags. For more information about the different options you can configure, see Launching an Instance. Choose Next until you reach the Configure Security Group page.
  • The wizard creates a new security group according to the vendor's specifications for the product. The security group may include rules that allow all IP addresses (0.0.0.0/0) access on SSH (port 22) on Linux or RDP (port 3389) on Windows. We recommend that you adjust these rules to allow only a specific address or range of addresses to access your instance over those ports.
  • When you are ready, choose Review and Launch.
  • On the Review Instance Launch page, check the details of the AMI from which you're about to launch the instance, as well as the other configuration details you set up in the wizard. When you're ready, choose Launch to select or create a key pair, and launch your instance.
  • Depending on the product you've subscribed to, the instance may take a few minutes or more to launch. You are first subscribed to the product before your instance can launch. If there are any problems with your credit card details, you will be asked to update your account details. When the launch confirmation page displays

Usage/Deployment Instruction

Note: Please open the following Security Ports in the instance:
5601, 9200, 54323, 9093, 2181, 9092, 5902, 5901, 3000, 8091, 54321, 4040, 8787, 8080, 8088

Step 1: Open Putty for SSH

Step 2: Open Putty and Type <instance public IP> at “Host Name” Type "ubuntu" as user name Password auto taken from PPK file.

Step 3 : Use following Linux command to start Metabase

Step 3.1 : $ sudo vi /etc/hosts

Take the Private Ip address from your machine as per the below screenshot and then replace the second line of your command screen with that Private ip address


Step 3.2: Change ssh ‘ubuntu’ user to ‘root’

>> sudo su

Step 3.3: First remove ‘metabase’

>> docker rm metabase

Step 3.4: Start metabase with docker

>> docker run -d -p 3000:3000 --name metabase metabase/metabase


Step 3.5: Now Metabase start in Browser.

Open the URL: http://<instance ip address>:3000

Example: http://54.165.94.231:3000


Step 4: Register with Application


First Name : <Any Name>

Last Name: <Any Name>

Email Address: <Your Email Address>

Create a password: <InstanceID>

Confirm password: <InstanceID>

Your company or team name: <Team name>

Note: Email address is mandatory but storing data in your running application email address not to send anywhere else.


Step 4.1: Select database.


Step 4.2: Installation Complete


All your queries are important to us. Please feel free to connect.

24X7 support provided for all the customers.

We are happy to help you.

Submit your Query: https://miritech.com/contact-us/

Contact Numbers:

Contact E-mail:

Submit Your Request





    Input this code: captcha

    The Apache Hadoop software library allows for the distributed processing of large data sets across clusters of computers using a simple programming model. The software library is designed to scale from single servers to thousands of machines; each server using local computation and storage. Instead of relying on hardware to deliver high-availability, the library itself handles failures at the application layer. As a result, the impact of failures is minimized by delivering a highly-available service on top of a cluster of computers.

    Hadoop, as a scalable system for parallel data processing, is useful for analyzing large data sets. Examples are search algorithms, market risk analysis, data mining on online retail data, and analytics on user behavior data.

    Add the words “information security” (or “cybersecurity” if you like) before the term “data sets” in the definition above. Security and IT operations tools spit out an avalanche of data like logs, events, packets, flow data, asset data, configuration data, and assortment of other things on a daily basis. Security professionals need to be able to access and analyze this data in real-time in order to mitigate risk, detect incidents, and respond to breaches. These tasks have come to the point where they are “difficult to process using on-hand data management tools or traditional (security) data processing applications.”

    The Hadoop JDBC driver can be used to pull data out of Hadoop and then use the DataDirect JDBC Driver to bulk load the data into Oracle, DB2, SQL Server, Sybase, and other relational databases.

    Front-end use of AI technologies to enable Intelligent Assistants for customer care is certainly key, but there are many other applications. One that I think is particularly interesting is the application of AI to directly support — rather than replace — contact center agents. Technologies such as natural language understanding and speech recognition can be used live during a customer service interaction with a human agent to look up relevant information and make suggestions about how to respond. AI technologies also have an important role in analytics. They can be used to provide an overview of activities within a call center, in addition to providing valuable business insights from customer activity.

    There are many machine learning algorithms in use today, but the most popular ones are:

    • Decision Trees
    • Naive Bayes Classification
    • Ordinary Least Squares Regression
    • Logistic Regression
    • Support vector machines
    • Ensemble Methods
    • Clustering Algorithms
    • Principal Component Analysis
    • Singular Value Decomposition
    • Independent Component Analysis

    Highlights

    • icon

      Quickly installable,usable by everyone

    • icon

      Ability to store and resuse filter definitions Metrics

    • icon

      The ability to store and reuse aggregation definitions.

    Application Installed

    • icon Metabase
    • icon apache
    • icon linux
    • icon java
    • icon hadoop