Apache Zeppelin-Install, Explore, Query & Visualize Data (MariaDB/MySQL/PostgreSQL) | Amit Singh | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Apache Zeppelin-Install, Explore, Query & Visualize Data (MariaDB/MySQL/PostgreSQL)

teacher avatar Amit Singh, Multi Technology Trainer

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

27 Lessons (59m)
    • 1. Course Intro

      1:17
    • 2. Dashboard Demo-Created with Apache Zeppelin

      3:16
    • 3. How to Install Apache Zeppelin by downloading binary in Ubuntu

      0:27
    • 4. Start Apache Zeppelin

      0:30
    • 5. How to Install Docker Engine in Ubuntu

      1:53
    • 6. How to Install Apache Zeppelin with Docker in Ubuntu

      0:49
    • 7. How to Build Apache Zeppelin from Source-Install Prerequisites

      5:45
    • 8. How to Build Apache Zeppelin from Source Part 2

      2:29
    • 9. How to Install Apache Web Server (Command Line) in Ubuntu

      1:13
    • 10. How to Install MariaDB (Command Line) in Ubuntu

      1:59
    • 11. How to Install phpmyadmin (Command Line) in Ubuntu

      1:57
    • 12. How to configure interpreter for MariaDB to connect with Apache Zeppelin

      1:43
    • 13. How to create database and load SQL file in MariaDB table with phpmyadmin

      1:18
    • 14. How to create interactive note and use MariaDB database in Apache Zeppelin

      1:41
    • 15. How to Install MySQL (Command Line) in Ubuntu

      3:26
    • 16. How to Install MySQL Workbench (Command Line) in Ubuntu

      1:45
    • 17. How to load CSV data in MySQL with MySQL Workbench

      2:04
    • 18. How to configure interpreter for MySQL to connect with Apache Zeppelin

      2:15
    • 19. How to Install PostgreSQL with PGAdmin4 (Command Line)

      3:01
    • 20. How to configure interpreter for PostgreSQL to connect with Apache Zeppelin

      1:29
    • 21. How to Install Apache Cassandra and Connect with Apache Zeppelin

      3:33
    • 22. How to create table Visualization in Interactive note with simple SQL Command

      1:52
    • 23. How to create Bar Chart Visualization in Interactive note with simple SQL Command

      3:36
    • 24. How to create Pie Chart Visualization in Interactive note with simple SQL Command

      2:42
    • 25. How to create Area Chart Visualization in Interactive note with simple SQL Command

      2:25
    • 26. How to create Line Chart Visualization in Interactive note with simple SQL Command

      1:35
    • 27. How to create Scatter Chart Visualization in Interactive note with simple SQL Command

      2:50
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

28

Students

--

Projects

About This Class

In This Class Participants will learn:

1) About Apache Zeppelin

2) How to Download and start Apache Zeppelin in Ubuntu 18.04 LTS (Operating System) on their Deskop

or Laptop.

3) How to Create Visualizations and add to Sales Dashboard for Sample Sales Data i.e Table, Bar Chart,

Line Chart, Pie Chart, Area Chart, Scatter Chart.

If Participants do not have Ubuntu system then they can use Oracle VM Virtualbox to Install Ubuntu as Virtual Operating System, If they need support then they can ask me anytime.

About Apache Zeppelin:

Apache Zeppelin
Web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.

Multi-purpose Notebook
The Notebook is the place for all your needs

Data Ingestion
Data Discovery
Data Analytics
Data Visualization & Collaboration


Multiple Language Backend
Apache Zeppelin interpreter concept allows any language/data-processing-backend to be plugged into Zeppelin. Currently Apache Zeppelin supports many interpreters such as Apache Spark, Python, JDBC, Markdown and Shell.

Zeppelin supports 20+ different interpreters.

Apache Spark integration
Especially, Apache Zeppelin provides built-in Apache Spark integration. You don't need to build a separate module, plugin or library for it.

Apache Zeppelin with Spark integration provides Automatic SparkContext and SQLContext injection
Runtime jar dependency loading from local filesystem or maven repository.

Data visualization

Some basic charts are already included in Apache Zeppelin. Visualizations are not limited to SparkSQL query, any output from any language backend can be recognized and visualized.


Pivot chart

Apache Zeppelin aggregates values and displays them in pivot chart with simple drag and drop. You can easily create chart with multiple aggregated values including sum, count, average, min, max.


Dynamic forms
Apache Zeppelin can dynamically create some input forms in your notebook.

Collaborate by sharing your Notebook & Paragraph
Your notebook URL can be shared among collaborators. Then Apache Zeppelin will broadcast any changes in realtime, just like the collaboration in Google docs.


Apache Zeppelin provides an URL to display the result only, that page does not include any menus and buttons inside of notebooks. You can easily embed it as an iframe inside of your website in this way. If you want to learn more about this feature, please visit this page.


100% Opensource

Apache Zeppelin is Apache2 Licensed software

Apache Zeppelin Project Website:

https://zeppelin.apache.org/

Meet Your Teacher

Teacher Profile Image

Amit Singh

Multi Technology Trainer

Teacher

Amit Singh-Qualified CA with 21+ years of Industry Exp specializing in the area of SAP Training's, SAP Pre and Post Implementation Reviews, SAP Roll out, SAP Support, SAP Taxation, SAP Presales, SAP Project Management, SAP Data Analytics and SAP Testing 

Certified in SAP ISU/PPM/PS/SD/MM/PM/PP/FI/CO/TERP10/SRM/BI/BW/Business One from SAP AG 

Trained in Oracle Big Data Overview & Fundamental/BI Publisher/BI for EBS/Essbase from Oracle India/SAP S4HANA Analytics/Simple Finance/Dashboard/Lumira/Predictive Analytics/Logistics Innovation Training's from SAP through Learning Hub/Other Big Data Trainings from Cognitive Class.AI.

Industry Covered:
Utility, Telecom, Retail, Service, Healthcare, Education, BPO, Travel, Trading and Manufacturing. 

Tech... See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Course Intro: welcome to my course, getting started with a Budgie Zeppelin and this course you will cover what is a party Zeppelin. Then you will have overview off dashboard created with Apache Zeppelin. Then you will download Apache Zeppelin. Binaghi the new will install a party s over. Then you will install Maria Devi, the Newell install PSP, my Edmon. Then you will configure the interpreter for Maria Levy with a Party Zeppelin. Then you will create a interactive note in a party Zeppelin. Then you will create various in both visual elation like pie chart, Bachar, Scatter, Chart line, chart and spectra. You can ask any questions during or after the course. Thank you. 2. Dashboard Demo-Created with Apache Zeppelin: In this video, you will see a small demo off sales dashboard created with Apache Zeppelin. Now, this is a sample since dashboard, which is created with a body, happen. So this is a table for Mart. But you get soared a certain and discern when you click setting. So it's a pirate table you can drag and drop. You know, this is the pie chart again, which can be converted into various in Berlin regulations. - Now this is a thr again. It can be converted into varies in relation. This is a line chart and this is this Got a job. 3. How to Install Apache Zeppelin by downloading binary in Ubuntu: in this video, you're going to download a party's airplane by injury. Click on buying repackaged with all interpreters. Click here, Click on save file, click on OK. 4. Start Apache Zeppelin: In this video, you're going to start Apache Zeppelin to start a party's airplane, going to the Party Zeppelin directory and type command dot slash bin slash Zeppelin hyphen Damon dot shh Start and press enter now, but he's a plan will be of a level art Local host 800 5. How to Install Docker Engine in Ubuntu: In this video, you are going to install Docker engine so that you can run the Docker images on your system. So now first update your system by a pseudo APD get update. Now installed packages to allow ABD to use our repository over HTTPS with this command. Now add Docker official GPG key. With this command. Now verify that you have the key with the fingerprint with this command. And I use the following command to setup stable repository. Now again, update the system via sudo equity get update. Now install Docker Engine community version. Now to test your installation, just type command sudo docker run hello world. 6. How to Install Apache Zeppelin with Docker in Ubuntu: And this video, you will learn how to install Apache Zeppelin with Docker. Now to install Apache Zeppelin with Docker, type this command and press enter. It will take approximately four to five hundreds based on your internet speed to download the image and run the image. Running it. Once you download and run the image, Apache Zeppelin will be our labor on local host, 800. 7. How to Build Apache Zeppelin from Source-Install Prerequisites: In this video, you are going to burn Apache Zeppelin from source node. To build Apache Zeppelin from source, you need to install various prerequisite. You will be seeing how to install various prerequisite for building Apache Zeppelin from source. So let's get started. In this video, we are going to install open JDK. To install open JDK type command sudo APD get installed open JDK hyphen eight, hyphen JDK, and press enter. Now open JDK is installed in your system. In this video, you are going to install now to install Git type command sudo apt-get install Git and press enter. Now get is installed in your system. In this video, you are going to install NodeJS. And NodeJS first install to install curl type command, sudo APD get installed curl and press enter. Now Curl is installed. Now type this command to install the repository. And now type commands sudo, APD get installed, hyphen y NodeJS to install NodeJs in this system and press enter. Now NodeJS is installed in your system. And this video, you are going to install live phone config. To install live phone config type command, pseudo ABD, get, install, lift for conflict, and press enter. In this video, you are going to install our based development. Now to install RVs development type command, sudo apt-get install our iPhone base, iPhone dev and press enter. Now are based development is installed in your system. Now, in this video, you're going to install our credit evaluate to install our current evaluate type command sudo ABD, and install our grand evaluate and press enter. Now, our current evaluate is installed on your system. In this video, you are going to install Apache Maven. Now to install Apache Maven type below. Come on, so that you can download Apache move in and move into the relevant directory and make it executable. Once it is installed, you can check the Apache MVA inversion by typing command M VN minus version. It will show you the Apache Maven version along with the Java version. In this video, you are going to clone Apache Zeppelin repository. Look loan Apache Zeppelin repository, type a command and press enter. Now once Apache Zeppelin repository is clone, move into Apache Zeppelin directory so that you can start building from source. 8. How to Build Apache Zeppelin from Source Part 2: In this video, you are going to vary from source, Apache Zeppelin. Now you have already installed all the prerequisite for building Apache Zeppelin from source. Now tile the below command so that you can update all PWM dot xml file to use Gala 2.11 version and press enter. Now to burn Zeppelin with all the interpreters type below command and press enter. It will take approximately 15 to 20 minutes to build from source and where all the interpreters, once Apache xy-plane is winning from so successfully, it will show you the message as shown on your screen. And now you can move into the directory to check the well from source. In this video, you will see how to start Apache Zeppelin server after building from source. Now to start Apache Zeppelin server, move into the directory when LS And now type command, dots, backslash, plane, iPhone, daimon, dot SH, and start and press Enter. Once it shows, ok. The Apaches, I believe it will be available on localhost 800. 9. How to Install Apache Web Server (Command Line) in Ubuntu: in this video, you're going to install a party votes over so that you can install PHP My admitted for managing Maria TV know to install a party observer type pseudo a pretty get install a party to and breast end up. 10. How to Install MariaDB (Command Line) in Ubuntu: in this video, you're going to install Maria TV silver to install Maria Levi's over what you need to add repository so you can add repository with these three commands. So first copy and paste discovered. Now enter this. Come on and press Enter Now enter this. Come on and press painter. Now update the system by typing pseudo a pretty get update And now install Maria TV silver by typing command pseudo a pretty install Maria tv so 11. How to Install phpmyadmin (Command Line) in Ubuntu: in this video you're going to install BSP my admin know to install PSP my Edmund day pseudo a pretty install. PSB my Edmund and breast end up now Choose a party to by pressing space but and use. Okay. Click. Yes. Give her my sequel Password, which is Maria TV password. No PSP. My admin will be available are local host Flash PSB my Hedman give your I d which is root. And the password which you have set a detained off installation. 12. How to configure interpreter for MariaDB to connect with Apache Zeppelin: in this video, you're going to configure Interpreter for Maria TV so that you can connect a Party Zeppelin with Maria TV not to configure interpreter, click on integrator. Click on three. Give the name off Interpreter, which is Maria TV. Give that a separate a group J D. B C. Because you will be connecting with dirty, greasy driver scroll down. So give the name of default braver for Maria TV, which is all dot Maria de video. BC driver Then the default you are give the default user, which is root and the art effect. 13. How to create database and load SQL file in MariaDB table with phpmyadmin: in this video, you're going to lure data into Maria TV from SQL File now to load the data. First, we need to create a date of it. So create sales did of it. Now here, go to import. Scroll up. Click grows a school. Fine. Grow alone and just go. Now here The data has been imported into the table scenes. Say this dude up. So this is the structure, and this is the data which is important in two more years living. 14. How to create interactive note and use MariaDB database in Apache Zeppelin: In this video, you will create new note and used the database, which is Maria Levy, not to create a new note. Click on create new note. Give the note name and it digs Jews. The default in the operator Maria TV and click Create. Now, once you detail, I wasn't age Maria TV The next lane, they sure did Abuses and run paragraph so it will fetch the data ways which are available in the Maria Levy. Now you have the table which you have uploaded seriously, AWS and do the DW So say this so no, they come alone. Use Saiz so that it can use the savings rate of this. 15. How to Install MySQL (Command Line) in Ubuntu: In this video, you will click on Download, Community Edition. Click on Download. And then I'll give you a buzzword. And then OK via sudo update. And so it will take few minutes to install. It should be a strong password. 16. How to Install MySQL Workbench (Command Line) in Ubuntu: And this we are doing, you are going to learn how to install MySQL Workbench. Link download. Scroll down to the operating system, Linux. Click download. So minus i. And if I limb, it might show you some processing data. Now double click the connection, gives you a password, and click OK. Now you are connected with MySQL. 17. How to load CSV data in MySQL with MySQL Workbench: In this video, you will see how to upload CSV file in MySQL with MySQL workbench. Now to upload CSV file. First create a schema by name of sales. Click Apply, click Apply. Close. Go to tables. Now import table data. Now choose your file. C is open. Click Next, click Next. Click Next. We want to change the data. Click Next, Next. Next. Finish. They'll go to tables and refresh the data. Click on tables. Nick says data. Now choose columns. Now select rows. Change the query. Select star from sales, and press enter run query. So the data has been imported into MySQL. 18. How to configure interpreter for MySQL to connect with Apache Zeppelin: In this video, you will see how to configure interpreter for MySQL. Now click on interpreter. Click on create those interpreter name MySQL, interpreter grow JDVC. Scroll down. Now give the default driver name for MySQL. Give the password. Give the default URL for MySQL. Give the artifact for MySQL. Ligand save. Scroll up. Type MySQL. Now it is activated. Now click on Create node type node name MySQL, Jews interpreter MySQL. Click create a type MySQL, and then type for databases and run play. It will show the databases. 19. How to Install PostgreSQL with PGAdmin4 (Command Line): In this video, you are going to install both SQL with BG admin for. Now to install postgres SQL. First import the repository key with this command. Now create a list with this command. Now update the package list by pseudo APT get update. And now install SQL 11 when VGS. Now you need to start the database hour-by-hour command. And then you need to run these systems UDL command to run the server. For type sudo minus you pose risks. Psu will take this command, alter user Postgres password, and then give you a password and press Enter one PGA admin password. Now BG Edwin four is connected with Postgres. 20. How to configure interpreter for PostgreSQL to connect with Apache Zeppelin: In this video, you will learn how to configure interpreter for postgres SQL, create, note, and connect to pose risks will now click on integrator. Click Create, give interpreter name P SQL. Give interpreter group as JDVC. Now default driver is already given, give the password, give the username. Default URL is already there. Scroll down. Give the artifact name proposed re SQL, and save it. Now scroll up. Go to Node work, create new node, gives the name, goes gray SQL and default integrator as P SQL. And click Create. Now you are connected with bows VSB. 21. How to Install Apache Cassandra and Connect with Apache Zeppelin: In this video, you will see how to install Apache Cassandra and connect with uveitis Chaplin. Now to install Apache Cassandra, type this command to install the repository. Now type this command to add the repository keys. Now update the system by a pseudo ABD get update. Now add the public key with this command. Now install Apache Cassandra with this command. Now run the Apache Cassandra server with this command. And this command, you can check the status of a budget goes on the server and create a node. The node name Cassandra. And choose default interpreter as Cassandra. Click Create, nor type Cassandra. And next lane. Help. And Dundee, better graph. 22. How to create table Visualization in Interactive note with simple SQL Command: In this video, you will see how to first the records as a table with simple sequel command. So now, to show the records as a table day, first short tables and Randy Paragraph so that it can show you the tables, which are available in sales straightaways. So as you can see the Saints data ways. As you can see, sales data is your table not to first the record as a table type command select star. So which means you are not selecting any column as off no from sales data and limit 1000. Now you can see the output, which is shown as a table. Now you can, as it exist e size like this. Now you can add the title so you can give title a sane stable. 23. How to create Bar Chart Visualization in Interactive note with simple SQL Command: In this video, you will create bar chart with a simple sequel Command not to create the bar chart. Like the sequel Command Select Product Underscore Category, which is a column name product. Goma Total Underscore Invoice and the school Value. So here you are selecting three columns from the sales deductible. No group by product, your degree and then ordered by total Underscore invoice or the school value. So here you are, grouping by the product category and ordering by the total invoice value. No randy paragraph. Now here you can see the output, which is based on the product are degree, product and totally invoice value. Now click on Bar Chart Consulting Now to move this and dragged the total invoice values into the value Call. Now 40 product into the group, and key is a productive activity. Hey, you can have the group and stature on Oakley consenting to reduce the size and hide. The editor now at the Titan says they read up our dignity 24. How to create Pie Chart Visualization in Interactive note with simple SQL Command: In this video, you will create pie chart now to create a pie chart now from Table Select Sales Representative Comma Total Invoice Value and Groupe Urd by sales representative Soto. Write it in a sequel. Former Select Sales underscore representative Comma Total Underscore Invoice in the School Value, which are the column name from sales data, which is the table name Groupe Urd by states. Underscore representative so that you won't group it by sales representative and poor Delimit off 4000 and Runde Berruga. Now click on settings No, by TRD is created with sales representative and total invoice value. Heidi Anita just the size at their title. 25. How to create Area Chart Visualization in Interactive note with simple SQL Command: In this video, you will create area chart no to create areas are alright. Secret Command. Select more comma order underscored a comma total. Underscore invoice, underscore value from sales data and run the batter. - Click on settings juice keys as ordered it and grew by more on values as total invoice value. Now click on settings. Hide the editor, add the title daily sales by more and adjust the size of each other. 26. How to create Line Chart Visualization in Interactive note with simple SQL Command: In this video, you will create a line chart, but to create Ranger clone the pattern and right the common Select product Underscored Category Comma order Order Scored eight Comma Garden Total Underscore Invoice Underscore Value from Sales data and Randy Barracuda, Jews Lane Chart Joe Asserting Jews, Productive Degrees Groups Strollo Click on Zoom Scroll up, Click Inserting Idea, Tito. Other title daily says What product? A degree. 27. How to create Scatter Chart Visualization in Interactive note with simple SQL Command: In this video, you will create scatter chart to create a scatter chart. Cloned the paragraph. Oh, create a new battery and type equals Come on. Selected returns Coma cash back from cheese duda. - Now click on scatter chart. Click on settings No sort things out. Okay, idea. Ditto. Stretch the chart at the title. They have guns and cash back.