Visualize Data with Apache Superset (MySQL/MariaDB/PostgreSQL/Druid/Hive/Cratedb/Clickhouse etc) | Amit Singh | Skillshare

Playback Speed


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

Visualize Data with Apache Superset (MySQL/MariaDB/PostgreSQL/Druid/Hive/Cratedb/Clickhouse etc)

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

92 Lessons (2h 58m)
    • 1. Apache Superset-Global Health Monitoring Sample dashboard

      4:17
    • 2. Course Introduction

      2:31
    • 3. What is Data Visualization and What is Apache Superset

      7:03
    • 4. Apache Superset Sample Dashboards

      2:31
    • 5. How to Install Apache Superset in Ubuntu with Command Line-Install OS Dependencies

      0:50
    • 6. How to Install Apache Superset in Ubuntu with Command Line-Install Virtualenv

      0:22
    • 7. How to Install Apache Superset in Ubuntu with Command Line-Install Python3 venv package

      0:41
    • 8. How to Install Apache Superset in Ubuntu with Command Line- Activate python virtual environment

      0:22
    • 9. How to Install Apache Superset in Ubuntu with Command Line-Install Install superset

      0:27
    • 10. How to Install Apache Superset in Ubuntu with Command Line-Initialize database

      0:41
    • 11. How to Install Apache Superset in Ubuntu with Command Line-Create admin user

      0:53
    • 12. How to Install Apache Superset in Ubuntu with Command Line-Load examples

      2:29
    • 13. How to Install Apache Superset in Ubuntu with Command Line-Initialize and runserver

      0:30
    • 14. How to Install Apache Superset in Ubuntu with Command Line-Explore Superset

      2:03
    • 15. How to Install Apache Superset with Miniconda in Ubuntu-Install miniconda

      1:30
    • 16. How to Install Apache Superset with Miniconda in Ubuntu-Install conda package

      2:00
    • 17. How to Install Apache Superset with Miniconda in Ubuntu-Initialize database

      0:34
    • 18. How to Install Apache Superset with Miniconda in Ubuntu-Create admin user

      0:45
    • 19. How to Install Apache Superset with Miniconda in Ubuntu-Load examples

      0:28
    • 20. How to Install Apache Superset with Miniconda in Ubuntu-Initialize and run server

      0:44
    • 21. Apache Superset build from source Part 1 (Additional Video)

      0:29
    • 22. Apache Superset build from source Part 2 (Additional Video)

      0:31
    • 23. Apache Superset build from source Part 3 (Additional Video)

      1:05
    • 24. Apache Superset build from source Part 4 (Additional Video)

      1:58
    • 25. Apache Superset build from source Part 5 (Additional Video)

      0:52
    • 26. Apache Superset build from source Part 6 (Additional Video)

      2:40
    • 27. Apache Superset build from source Part 7 (Additional Video)

      1:42
    • 28. Apache Superset build from source Part 8 (Additional Video)

      5:43
    • 29. How to Install Apache Superset with Docker in Ubuntu-Only for Reference

      7:00
    • 30. How to Install Apache Superset with Helm Chart in Ubuntu-Only for reference

      9:59
    • 31. How to Install Miniconda in OpenSuse

      0:54
    • 32. How to Install Apache Superset in OpenSuse

      0:34
    • 33. How to Initialize Apache Superset database in OpenSuse

      0:34
    • 34. How to Create Apache Superset Admin User in OpenSuse

      0:41
    • 35. How to Load Examples in Apache Superset in OpenSuse

      0:48
    • 36. How to Initialize and Run Apache Superset server in OpenSuse

      0:48
    • 37. How to Explore Apache Superset Dashboard in OpenSuse

      0:31
    • 38. How to Install Miniconda in Fedora Workstation

      1:23
    • 39. How to Install Apache Superset in Fedora Workstation

      0:41
    • 40. How to Initialize Apache Superset database in Fedora Workstation

      0:40
    • 41. How to Create Apache Superset Admin User in Fedora Workstation

      0:40
    • 42. How to Load Examples in Apache Superset in Fedora Workstation

      0:51
    • 43. How to Initialize and Run Apache Superset server in Fedora Workstation

      0:54
    • 44. How to Explore Apache Superset Dashboard in Fedora Workstation

      0:37
    • 45. How to Install Apache Superset in Windows 10 Prov (Experimental)

      4:37
    • 46. How to Upload CSV file in SQlite DB from Apache Superset (Old Method)

      1:54
    • 47. How to Install Apache2 in Ubuntu

      1:13
    • 48. How to Install Mariadb in Ubuntu

      1:59
    • 49. How to Install phpmyadmin in Ubuntu

      1:57
    • 50. How to Import SQL file in Mariadb with phpmyadmin

      1:18
    • 51. Import LibreCalc in MariaDB with phpmyadminV1

      0:42
    • 52. How to Install Database Dependencies for MariaDB/MySQL in Apache Superset

      0:53
    • 53. How to Connect MariaDB with Apache Superset

      1:07
    • 54. How to Upload CSV file in MariaDB from Apache Superset

      1:15
    • 55. How to Install MySQL in Ubuntu

      3:26
    • 56. How to Install MySQL Workbench in Ubuntu

      1:45
    • 57. How to Upload CSV file in MySQL from MySQL Workbench

      2:04
    • 58. How to Connect MySQL with Apache Superset

      1:39
    • 59. How to install PostgreSQL in Ubuntu

      3:01
    • 60. How to Connect PostgreSQL with Apache Superset

      0:54
    • 61. How to Upload CSV file in PostgreSQL from Apache Superset

      1:35
    • 62. How to Install ClickhouseDB in Ubuntu

      1:46
    • 63. How to Connect Apache Superset with ClickhouseDB

      0:55
    • 64. How to Install CrateDB in Ubuntu

      7:42
    • 65. How to Connect Apache Superset Connect with CrateDB

      0:40
    • 66. How to Install Apache drill in embedded mode

      0:34
    • 67. How to Install Database Dependencies for Apache Drill in Apache Superset

      0:38
    • 68. How to Connect Apache Superset with Apache Drill

      1:01
    • 69. How to Connect Apache Superset with Apache Hivehive

      1:34
    • 70. How to Install database dependencies for Apache Druid in Apache Superset

      0:40
    • 71. How to Connect Apache Superset with Apache DruidSuperset connect apache druid

      2:27
    • 72. How to Connect Apache Superset with Cockroach DB

      1:16
    • 73. How to Upload CSV in Cockroach db from Apache Superset

      2:43
    • 74. How to Create Sales Filter in Apache Superset

      2:10
    • 75. How to Create Bar Distribution Chart in Apache Superset

      3:19
    • 76. How to Create Stacked Bar Distribution Chart in Apache Superset

      3:19
    • 77. How to Create Pie Chart in Apache Superset

      2:35
    • 78. How to Create line chart in Apache Superset

      2:34
    • 79. How to Create Time series stacked chart in Apache Superset

      2:43
    • 80. How to Create Partition Diagram in Apache Superset

      4:09
    • 81. How to Create Tree Map in Apache Superset

      2:24
    • 82. How to Create Word Cloud in Apache Superset

      2:25
    • 83. How to Create Big Numbers in Apache Superset

      2:19
    • 84. How to Create Big Numbers with Trend Line in Apache Superset

      2:31
    • 85. How to Create Multi Line Chart in Apache Superset

      2:29
    • 86. How to Create World Map in Apache Superset

      2:50
    • 87. How to Create Table View in Apache Superset

      2:46
    • 88. How to Create Pivot Table in Apache Superset

      2:57
    • 89. How to Create Calendar Map in Apache Superset

      2:22
    • 90. Apache Superset Drag and Drop Dashboard Creation

      4:58
    • 91. How to Export Apache Superset Dashboard

      0:27
    • 92. How to Import Apache Superset Dashboard in another Instance

      0:43
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

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.

104

Students

--

Projects

About This Class

In This Class Participants will learn:

1) About Apache Superset (Incubating)

2) How to Install Apache Superset with Command Line, Docker, Miniconda, Helm Chart and Source.

3) Apache Superset connect with Multiple Databases after installing them.

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

 Time Series Line Chart, Time Series Stacked Chart, Partition Diagram,, Big Numbers, Big Numbers with Trend line, Multi Line Chart, Treemap, World Map, Word Cloud, Calendar Map etc.

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.

Features of Superset:

A rich set of data visualizations

An easy-to-use interface for exploring and visualizing data

Create and share dashboards

Enterprise-ready authentication with integration with major authentication providers (database, OpenID, LDAP, OAuth & REMOTE_USER through Flask AppBuilder)

An extensible, high-granularity security/permission model allowing intricate rules on who can access individual features and the dataset

A simple semantic layer, allowing users to control how data sources are displayed in the UI by defining which fields should show up in which drop-down and which aggregation and function metrics are made available to the user

Integration with most SQL-speaking RDBMS through SQLAlchemy

Deep integration with Druid.io

Databases which Superset Support.


The following RDBMS are currently supported:

Amazon Athena

Amazon Redshift

Apache Drill

Apache Druid

Apache Hive

Apache Impala

Apache Kylin

Apache Pinot

Apache Spark SQL

BigQuery

ClickHouse

Google Sheets

Greenplum

IBM Db2

MySQL

Oracle

PostgreSQL

Presto

Snowflake

SQLite

SQL Server

Teradata

Vertica

You can create 46+ Visualizations with Superset, Please browse through website and Project for Visualization Screenshots.

Superset Project Website and Github give below:

https://superset.incubator.apache.org/

https://github.com/apache/incubator-superset

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. Apache Superset-Global Health Monitoring Sample dashboard : In this video, you are going to see a sample dashboard for global health monitoring created with Apache Superset Apache Superset Now let's get started. first scroll down to get overview of dashboard Now, these are the various visuals which are created with Apache Superset So this dashboard is created with the dummy data for global health. So here you can see this is a partition diagram which reflects global cases break up by region, country, hospital type and hospital name, so you can expand. So this is a treemap, which is for contract tracing by country, scroll up. This is a world map where you can see the global cases by countries Now, this is a global calendar which shows the death, the contact tracing, this is daily contract tracing by region. This is a data for patient by age, which is created with a histogram, this is total cases and recovery by region. So this is the table. So this is the time series stacked chart global bed availability and hospitals. This is the daily cases and recoveries. Scroll up the table view of data. Scroll up, these are various symptoms, global cases, detection, global cases of detection, sources existing conditions of patients, scroll up So these are various line charts, global cases by region cases, by country, total cases by comparison by Period, Scroll up These are the big numbers. This is the markdown which is created. And these are the various filters which you can create for dashboard Now, here you can filter out with the time range or health issues or region or country or source of detection, you can add various filters as per your choice. Now, go to the country and state level visualization, here you can give your time ranges and date specifically so you can create a map for US, Brazil or Belgium and other countries, so you can filter out the results based on the country level or state level. So you are to if you want to filter out what dates you can filter out with the dates. 2. Course Introduction: welcome to my court. In this goes first you will learn what is Apache super set. And you will get a quick overview off a budgie Super sir. Then you will see a command line installation matter in which you will install who has dependencies. You will create the fight and virtual environment. We will install suppressor. You will initialize database. You will create admin user. You will load examples, runs over and explore the super said. Then you will create some of the regulations like filter Bachar Fighter 90. These lanes are trying to the stature partition diagram tree map Big numbers were trend line and you will add to the dashboard while creating the regulation. You can also create dashboard by dragon drop matter what you showed in the video or the end of the course you will have interacted, sees dashboard just like this Would you can fill that out? You can impact with the usual charts so you can making through the group or stats. Bugger. You can interact with the preacher. You can interact with the fine cities Stature, you can drill. Dude, it is with partition diagram. You can show your scenes or returns by remap and you can show you Ringling. Thank you 3. What is Data Visualization and What is Apache Superset: What is data relation? Present graphically big or small information or data or any other fact with the help of graphs. Charge for any other visual element in some Rays manner with the ability to slice for days or further along. Who next level? Let us see some examples. So this is some raw data about a budgie superstar with some features, and the data raise its supposed and who uses it. And this is some draw did about the sales in a stretchy. So both these per chewed. I have just tried to map graphical way with some visuals. So like big numbers were flow. Son Que Charge Model are directed fourth graf. So this is a sample purchase dashboard, which is created with various visions sales dashboard, which is again created with the help of various graph in charge. So another part of CES dashboard and another part of these his dashboard. Now we have seen data regulation. Let's see, what is Apache? Super sir. So here are quick facts about Apache Supercenter. So these are the project starts, which is a little bit or so. Here are quick features, so it's an open source. Free business intelligence or forever supports multiple databases, which which is user friendly. So here you have the various installation options. There are various database trip. Endless is because it's supposed multiple databases there, about 45 plus deregulation. Divergent supports. It is a quick guide how to install a party super surgeon, movinto, which is reflected with the model. So this is directed fourth graf, which reflects the data visit support and who uses Apache Super Second Engine. So here are some quick visuals, which I have creator So Sandberg's trying to these night. Ingle Row's Angel Restructured Lane jer multilane Charge big numbers with the train line partition. Drag them whatever table did you map Donor Chuck Bar distribution group by distribution Stock connected Fools draft. These are the filters. So this is an example of Margo, and these are example of San K and Donor chart. This is an example Forward map. This is an example for work Clothes is the example for big numbers this example for bullet chart and calendar map. So these are variation off line chart box plot multiple later, Nightingale, Rose table view and Fiber Table you. So this is a sample purchase dashboard and this is sample sale is diet food. So for produce and tears. So these are the big numbers. So this is bar distribution chart. So this is stable view and workload this dream up this donor and sand bust this world back five or table tradition diagram samples in this day for so earlier, there was no tap facilities. And now with version point away, you have this facility for our cabs. Now we'll see the total number off regulations which are available there, if you see here. So these are the various regulations which are available in about She's a person with which we can clear our dash boots. 4. Apache Superset Sample Dashboards: in this video, you're going to see some of the new dashboard, which I have created recently. So you was. He sees dashboard, but use dashboard or fully on predict management at school content analytics, Dashwood and and Financial Dodgeball. So it is the first sample. 40 sales dashboard. - No , this is the sample for parties. Dashboard. Now, this is the sample for portfolio and project management, Dashboard. Nothing. Now, this is the sample dashboard for fat content Analytics. This is the sample financial life support. 5. How to Install Apache Superset in Ubuntu with Command Line-Install OS Dependencies: and Steptoe you'll install always dependencies. Suppose that stores data disconnection information in its major databases For that purpose , cryptographic vital levity is used to encrypt connection passwords. Now you need to pace this coming Press enter, give you a possible. This command is very important because it will install all the West dependencies. If this is not successful, will not be able to move for the 6. How to Install Apache Superset in Ubuntu with Command Line-Install Virtualenv: In this video, you're going to learn how to install by 10 virtual environment installed fighting virtual environment like Pip, install virtual and 7. How to Install Apache Superset in Ubuntu with Command Line-Install Python3 venv package: In this video, you're going to install fight and three event package. Who creates virtual environments, successfully know to install by then. Trayvon package typed alone Sudo, April Figured, installed, fight and three and press enter. 8. How to Install Apache Superset in Ubuntu with Command Line- Activate python virtual environment: in this video, you're going to learn how to create and activate by 10 Virtual environment No to create fight on virtual environment type all England and press end up 9. How to Install Apache Superset in Ubuntu with Command Line-Install Install superset: In this video, you're going to install superstate, nor to install superstate type command, pay per install, a party hyphen, super set and breast end up. 10. How to Install Apache Superset in Ubuntu with Command Line-Initialize database: In this video, you will see how to initialize database now to initialize databases, type command super certain space Devi space upgrade and press end up. 11. How to Install Apache Superset in Ubuntu with Command Line-Create admin user: in this video, you're going to create admin user for super sex now to create admin user tight. Come on, exports last. Unless go up, he could do superstar and the next commanders last fab. Create hyphen Edmund, nor type your user name. Type your first name. Type your last name. Type your email type your password and they re deposited for the confirmation and press enter. 12. How to Install Apache Superset in Ubuntu with Command Line-Load examples: in this video you're going to lure example? No, no to load example type command, super set, load, underscore example and press enter. 13. How to Install Apache Superset in Ubuntu with Command Line-Initialize and runserver: in this video, you're going toe initialize, supports it and runs over no to initialize. Suppose it type command super sit in it and then typed below command to run the server in our development mood Now super set will be available at local host. Here's irritable. 14. How to Install Apache Superset in Ubuntu with Command Line-Explore Superset: In this video you were logging into Super Sirte and explored at schools so so percent will be available at local host saving Call in Air zero Devil eight, where you need to report your user name and password. Click on dashboard, click on words, Bang data. So as you can see the Lord off Luger's, which have made this nice work, Silicon Dash moves big on birth. So this is another dashboard. So scroll down. Go see for the visions. So click on nationals become miscellaneous charge alone. Click on dashboard, no logo. 15. How to Install Apache Superset with Miniconda in Ubuntu-Install miniconda: In this video, you are going to learn how to install mini coanda. Now click on download, click save file. And it will take 23 minutes to download. Now once it is downloaded, click bash and mini gonna file name which you have downloaded. Press Enter, press enter. Scroll loan by pressing enter. Now click Yes. President. Press enter. It will take about two to three minutes to install. Enter. Yes, are the dominant. So there are many go undertakes effect. 16. How to Install Apache Superset with Miniconda in Ubuntu-Install conda package: In this video, you will install gone up by GA4GH baggage like gamma1 minus c. So it will take approximately two to three minutes to install the package. 17. How to Install Apache Superset with Miniconda in Ubuntu-Initialize database: In this video you will see how to initialize database, nor do initialize database type gamma1, super-smart space deep space upgrade and press enter. 18. How to Install Apache Superset with Miniconda in Ubuntu-Create admin user: In this video, you are going to create an admin user for superset. Now to create admin user type command, export flask and ASCO app equal to superset. The next command is flash, fab, create, hyphen edwin. No type your username. Type, your firstname. Type, your last name. Type your email. Type your password, and repeat the password for the conformation and press enter. 19. How to Install Apache Superset with Miniconda in Ubuntu-Load examples: In this video, you are willing to lower example. In order to underscore example and press enter. 20. How to Install Apache Superset with Miniconda in Ubuntu-Initialize and run server: In this video, you are going to initialize and runs over, do initialize it. And then do it on the global ocean. 21. Apache Superset build from source Part 1 (Additional Video): in this video, you're going to see out O'Berry Super sex from source. The first clones the repository with this. Come on. 22. Apache Superset build from source Part 2 (Additional Video): and stole the was dependencies with this command. 23. Apache Superset build from source Part 3 (Additional Video): now get into the directory and install by sentry. When now install Wortzel Environment now activated Virtual environment. 24. Apache Superset build from source Part 4 (Additional Video): how initialize the date of this now create default rules and permission with super set in it. 25. Apache Superset build from source Part 5 (Additional Video): now create the Edmund user with last create iPhone. Edmund, give You use that name. Give you first name. Give your last name you feel you made. Give your password and repeat your possible. 26. Apache Superset build from source Part 6 (Additional Video): no load some examples with superstar Lord Underscore examples. - Now start the flask That's over. Supercenters of a level of local owes you zero double it. But you need to be really front and deserts for this log in with your user name and pasta. So where do you see that log in screen is not very good and we need to really front and is it for this? 27. Apache Superset build from source Part 7 (Additional Video): now inside were Children Barbary. Install the external dependencies with these two months. 28. Apache Superset build from source Part 8 (Additional Video): stop the so and Movinto directory Supporter and deserts. Now go build the assets install nor Jess. But these command now install envy in with this. Come on. - Now , install the third party dependencies with this summer and run the developments over. No. With this coming, the once it is finished, you should start this over again with this good man, love into super say with your idea and possible and Rosie National. 29. How to Install Apache Superset with Docker in Ubuntu-Only for Reference: 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 install packages to allow ABD to use our repository over HTTPS with this command. Now add Docker official GPD p. With this command. Now verify that you have the key with the fingerprint with this command. Now use the following command to setup stable repository. Now again, update the system lies pseudo equity get update. Now install Docker Engine community version. Now to test your installation, just type command sudo docker run hello world. In this video, you are going to install Docker compose so that you didn't create the Docker images. Run this command to download the current stable release of Docker compose. Now apply the executable permissions to the binding. And now check the docker-compose version by Docker hyphen compose iPhone, iPhone version. In this video, you are going to install with Docker. So first clone the repository. Now move into the directory and now run this command. Do you need to create your admin user? Firstname, lastName, iPhone compose to Randy. Now you go into localhost. 30. How to Install Apache Superset with Helm Chart in Ubuntu-Only for reference: In this video, you are going to install Cube CTL, mini Q. And now first we will install girl to install girl type sudo AVD, get installed curl and press enter. Now we have installed Curl. You're going to install Cube CTL within native package management by following commands. Udl is already that we will install mini whoever needs. And now virtual machine, single molecule via direct download type this command. Now to add mini cube executable. Now many cube is installed so you can start typing command. It will take about five to ten years to get it started. Now you can start mini cube dashboard by typing mini Q dash. So that superset can be installed with L. L has now installer scripts that will automatically grab the latest version of helpline and install it locally. For type this command to fetch the script, make it executable and type this command to install. It will take two to three minutes to get it installed in it. In this video, you are going to install suppose had withheld jar. Now first clone the repository. With this command. Now get into the repository. And now type this command to deploy superset Wilhelm job. So now you can get the obligation URL by running these guidelines will tell appearing on your screen. Now we'll start the unique law. We again see what is the meaning of IP. So we'll copy this and check the bow. Check the port which is displayed in the odds, which is 30293. Now we need to create the admin user ID, user ID and password to login into super say, the j part. And then hyphen, hyphen, hyphen in it. And I'll give you a username, gives you a firstName, lastName, email ID, password, and repeat the password. So now you get log into superset with the ID and password which you have created. 31. How to Install Miniconda in OpenSuse: In this video, you are going to learn how to install mini coanda. Now click on download, click save file. And it will take 23 minutes to download. Now once it is downloaded, click bash and many conda filename which you have downloaded. Press Enter, press enter, scroll loan. By pressing enter, I will take about two to three minutes to install. And the years are determinant. So that money go undertakes effect. 32. How to Install Apache Superset in OpenSuse: In this video, you are going to install it. 33. How to Initialize Apache Superset database in OpenSuse: In this video you will see how to initialize database. Now do initialize database type gamma1, super-smart space, deep space upgrade and press enter. 34. How to Create Apache Superset Admin User in OpenSuse : In this video, you are going to create an admin user for superset. Now to create an admin user type command export flask under SCO app equal to superset. And the next command is flask, fab, create, hyphen Edwin, nor type your username. Type, your firstname. Type, your last name. Type your email. Type your password, and repeat the password for the conformation and press enter. 35. How to Load Examples in Apache Superset in OpenSuse: In this video, you are willing to Lord, Lord underscore and press enter. 36. How to Initialize and Run Apache Superset server in OpenSuse: In this video, we're going to initialize, initialize, and then do it on the internet. 37. How to Explore Apache Superset Dashboard in OpenSuse: In this video, you login and Geuze, who was her dashboards group would your user name and password? Click on dashboard. Click on words band data. So as you can see, the regions which have made this dashboard. 38. How to Install Miniconda in Fedora Workstation: In this video, you are going to learn how to install many conda. Now click on download, click save file. And it will take 23 minutes to download. Now once it is downloaded, click bash and mini gone Delphi language you have downloaded. Press Enter, press enter, scroll loan by pressing enter. Now click Yes. President. Press enter. It will take about two to three minutes to install MDS or determinant. So there are many ego undertakes effect. 39. How to Install Apache Superset in Fedora Workstation: In this video, you are going to install it. 40. How to Initialize Apache Superset database in Fedora Workstation: In this video you will see how to initialize database. Now do initialize database like gamma1, super-smart space, deep space upgrade and press enter. 41. How to Create Apache Superset Admin User in Fedora Workstation: In this video, you are going to create an admin user for superset. Now to create an admin user type command export flask, and thus go ab equal to superset. And the next command is flask, fab, create, hyphen Edwin, nor type your username. Type, your first name. Type, your last name. Type your email. Type your password, and repeat the password for the conformation and press enter. 42. How to Load Examples in Apache Superset in Fedora Workstation: In this video, you are willing to examine Lord underscore. 43. How to Initialize and Run Apache Superset server in Fedora Workstation: In this video, we're going to do initially. And then they do it. 44. How to Explore Apache Superset Dashboard in Fedora Workstation: And this renewal you login user name and password. Click on dashboard, click on words band data. So as you can see, which I've made this MOOC. 45. How to Install Apache Superset in Windows 10 Prov (Experimental): In this video, you will see how to install Apache sequencer in Windows ten Pro. Now first install many conda. You can download Anaconda as shown in the previous videos. Now double-click many conda installer. Click I Agree. Click just for me. Click Next. Now add Anaconda to my path variable. Click Install. It will take two to three minutes. Click Next. Click Finish. Now Open, dominant. Now install Python package for money going down with this command, it will take two to three minutes. Click Yes. Now install Apache Zookeeper answered by typing. Pip install Apache hyphens and press it into a few minutes to install. Now initially db with this command. Now create the edwin user with these two commands. Gives you a user name. First name, last name, email ID. Give you a password, and confirm the password and press Enter. Now Lord, some examples with this command. Now initially supervisor server and run superset. So localhost 8 thousand ID password and sign into the desert. Click on World Bank data. 46. How to Upload CSV file in SQlite DB from Apache Superset (Old Method): in this video, you're going to learn how to upload CSE file in Super Set. No first click Edit on the database. Scroll down. Click on a Lousy is we upload. Scroll along Lexi. Now click on sources. Click uploaders Years. Three. Give their table name scenes. Brosius Refined. Click Open God alone. Click. See now click on Edit Sales Table. Click on columns. Now click on Edit Order Date Because the data type is date and time, so change the data type right date dying Scroll down. Click on ice temporal Click. See you now click on detail scroll alone, Click See an hour did have 11 for regulation. 47. How to Install Apache2 in Ubuntu: In this video, we are going to install so that you can install VSB, my admin managing Medea dv by dy du 48. How to Install Mariadb in Ubuntu: In this video, you are going to install MongoDB server plus you need to add repository. So you can copy and paste this and press enter. And now update the system by typing sudo EBD. Good update. And now install MongoDB server. By typing sudo ABD install MongoDB. 49. How to Install phpmyadmin in Ubuntu: In this video, you are going to install PHP my admin. Now to install PHP my admin type, sudo APD install PHP my admin and press enter. Now choose a by T2, by pressing Spacebar. And Jews, okay? Click yes. Uv or MySQL password, which is MariaDB password. Now PHP, my admin will be available at localhost slash PHP my admin ID, which is root, and the password would you have said at the time of installation? 50. How to Import SQL file in Mariadb with phpmyadmin: In this video, you are going to load data into MariaDB from SQL file. Now to load the data, first, we need to create a database. So create sales database. Now here go to Import, scroll up, plague, browse, choose SQL file, scroll loan, and Jews go. Now here the data has been imported into the table, sayings, sales data. So this is the structure, and this is the data which is imported into MariaDB. 51. Import LibreCalc in MariaDB with phpmyadminV1: And this video you're going to upload limerick al MariaDB via PHP admin. So now create a database like scenes, ODS, click Create. Now click on import. Scroll up, choose file. And now scroll down. Choose first line of the file contains column name and click go. Now to a file is uploaded, you can see the structure. 52. How to Install Database Dependencies for MariaDB/MySQL in Apache Superset: In this video, you are going to learn how to install MySQL dependencies for superset. But before you install dependencies, there are some prerequisite which we'll be installing with two commands. So the first command will be this one. So press Enter. Your password. In command will be this one. So now we can install MySQL client by pip install MySQL client. 53. How to Connect MariaDB with Apache Superset: In this video, you are going to see how to connect MariaDB with Apache superset. Now to connect Apache superset, click Add named database MariaDB. Give SQL alchemy, URL, MySQL, colon slash slash root colon. Ahmed 1-2-3, which is your password at the rate localhost, colon 3306, which is a port click Test Connection. Scroll down. Click on Allow CSV upload. Allow create table as allow dm will allow multi schema, sprawl down, save it. And now Maria dv is connected to superset. 54. How to Upload CSV file in MariaDB from Apache Superset: And this video, you are going to learn how to upload CSV file in MariaDB. Named the table browser your file. Click database. Name the schema, car loan, click, Save. Click the table. Choose the column. Choose the order, date, and change data type as datetime, score, loan. And savored. 55. How to Install MySQL 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. 56. How to Install MySQL Workbench 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. 57. How to Upload CSV file in MySQL from 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. 58. How to Connect MySQL with Apache Superset: This video, you're going to learn how to connect to co-authored with MySQL, open MySQL Workbench and create a schema by name of sales. And apply. Then again, apply. Now go to superset. I'll click on sources database. Click on Add. Give your database name mysql. And put the URL, MySQL colon slash slash, username, password, localhost colon 3-3, 0-6, or whatever your port number is. And the destination. Click on expos in SQL lab, otherwise it will not be available in SQL lab. Allow CSU upload and click save. Now your MySQL is connected. 59. How to install PostgreSQL in Ubuntu: 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. 60. How to Connect PostgreSQL with Apache Superset: In this video, you will learn how to connect superset with PostgreSQL. Click on Add, give database name. Supposedly SQL, gives you an supposedly SQL colon slash slash. Your username and password. At the rate. Localhost, colon 5432 and Test Connection. Now exposed in SQL lab. Otherwise it will not appear. Allows us, we upload and click on save. Now pose real SQL is connected. 61. How to Upload CSV file in PostgreSQL from Apache Superset: And this video you will learn how to upload CSV file in postgres SQL. Click on sources, click upload a CSV, name the table. Click browse. Choose your file. Use the database as T-SQL. Chlorine, lone, click, save, click, Edit, click columns. You can see the columns which are important. You can change the date and time. For loan. Click is temporal for the date. Savored. 62. How to Install ClickhouseDB in Ubuntu: And this video you will learn how to install glucose dv plus V, D depositories. And now I've made this system. And now I'll give you a buzzword. The user will be default as default. 63. How to Connect Apache Superset with ClickhouseDB: In this video you will see how to connect superset with clay CouchDB. Click on Add. Give database name like cows. Give URL name. Because colon slash slash your User ID, which is default, and your password which you have given at the time of installation. At the rate localhost, A123 slash test. Click Test Connection. Allow written SQL lab allows CSV upload and click on save. Now your connection is added into parser. 64. How to Install CrateDB in Ubuntu: In this video, you are going to learn how to install Create DB. Now before that, you need to have open JDK 11. If you do not have, you can install it by typing the command without appearing on your screen. Now we will download the great divi GPG key by copy and paste this command. Now add the key to APD. Create a configuration like this. Now update the APD. Now you can install by typing sudo apt get install. 65. How to Connect Apache Superset Connect with CrateDB: In this video, you are going to learn how to connect superset with great dB. Click on Add, give database name crate, type URL, create, colon slash slash, localhost, 4200, and Test Connection exposed in SQL lab and allows you to upload. Now click on save. Create dv is added. 66. How to Install Apache drill in embedded mode : In this video, you will learn how to install Apache to click on download now called direct file download. Now type, type command ls, ICAM-1 dot slash, iPhone embedded. Now you are connected to Apache embedded mode. 67. How to Install Database Dependencies for Apache Drill in Apache Superset: And this video you will learn how to install database dependencies for. Now first install good. If you do not have in your system, you need to clone this repository and go into this repository and type this command. It will install all the dependencies further. 68. How to Connect Apache Superset with Apache Drill: In this video, you are going to learn how to connect supersaturated with a budget. Now type ls dot slash hyphen embedded. It will start the embedded server. Now will go to superset and connect. Then click add you the database name as well. Copy and paste below urine exposed in SQL lab so that it is available allows you to upload and click save. Apart. You drill will be added to superset. 69. How to Connect Apache Superset with Apache Hivehive : And this video you will see how to connect Apache Zookeeper shared with Apache Hive. Not like ad. Click Database, Abaci, HIV, click SQL, alchemy, URL, HIV, colon, your username which is high, you then colon password at the rate local host, 10 thousand, slash default and Test Connection. Like OK. Take the willow options. Scroll loan. Savored. Now go to SQL lab. Abaci HIV is available. You can select your schemas and you can check the table if any. 70. How to Install database dependencies for Apache Druid in Apache Superset: In this video, we're going to install database dependency vote, like gamma1, pip installed by Drew and breads NDA. 71. How to Connect Apache Superset with Apache DruidSuperset connect apache druid : And this video you will see how to connect Apache drew with Apache Zookeeper sec. Now check the data sources. Go to superset. Click add. Put the name. Apache drew. Jews broker host as localhost. Record will be 8-0 a2, and cluster name will be drew. Click save. Now click sources, click Group, datasource, click Add. Data Source Name, Wikipedia, clustered rule. Scroll loan. Two's owner. Your name. Scrawled loan. Click save. Now here you can see dataSource. Click sources, scan new data sources. Now here, both the data sources are appearing. No, no check the datasource. Now here you can see the columns. So now all columns are displayed here. Now you are apache root is connected. Now click on data source. It will take you to the Visualization tab where you can visualize the data. 72. How to Connect Apache Superset with Cockroach DB: And this video you will see how to connect Apache Zookeeper exert with calculus dB. Click on Add. Give database name as calculated DB, SQL alchemy URL, click on Test Connection. Scroll down. Jews. The options are shown on screen. Scroll down. Click on save. Now go to SQL, SQL editor. Now suppose are disconnected with cockroach TV. 73. How to Upload CSV in Cockroach db from Apache Superset: In this video, you will see how to upload CSV file in calculus GB. Click on upload CSV file gives him a sense. Choose your file. Scroll down and click on save. Click Edit, Click columns. Column, order, date, datetime. Click, click Save. Click on detail. Click SQL, love you, click Save. Click on SQL lab. Data. Choose database, public, and tables, Kiva, essays. So you can see the same student. 74. How to Create Sales Filter in Apache Superset: In this video, you will see how to create filters for your sales dashboard. So now click regulation tape Stroll along Jews filled evolves, scrotum Those time range custom and shoes 1st January 2018. Okay, score alone. You can choose for controls. So, seeing as the representative place of supply country cord, then I want region and customer name and productive and metrics I need for total sales value. See this inquiry Give a name sales for toes save anarcho Dashwood. So did die for stretch other Children and save it. 75. How to Create Bar Distribution Chart in Apache Superset: in this video, you're going to create bar distribution. Stack chop, Click on sources. Click on tables, click on sale sample data. Congratulations. Tape. Click on time rates. Click Custom Jews 1st January 2080 matrices Total invoice value No cities one. We're not got dignity and I want a breakdown by brought up now run Kuwaiti. No photo visual properties. Click on Stag, but give the exist label. Now click extra controls. Type. The chart name seems by product category buttons here at two Dashboard CNN's Days Goto dashboard, But it die Food straight charge. No, save it. 76. How to Create Stacked Bar Distribution Chart in Apache Superset: in this video, you're going to create bar distribution. Stack chop, Click on sources. Click on tables, click on sale sample data. Congratulations. Tape. Click on time rates. Click Custom Jews 1st January 2080 matrices Total invoice value No cities one. We're not got dignity and I want a breakdown by brought up now run Kuwaiti. No photo visual properties. Click on Stag, but give the exist label. Now click extra controls. Type. The chart name seems by product category buttons here at two Dashboard CNN's Days Goto dashboard, But it die Food straight charge. No, save it. 77. How to Create Pie Chart in Apache Superset: In this video, you will see how to plot the total sales booking by devices with nature. So click on sources. Click on tables, Jews, Jane Sample Jews Regulation tape, juice by a judge, Juice tying range, Jews custom and again who? 1000 Year. Dean January first don't visit. No mattresses will be total sales total invoice value. And I want to grow by the ways. So click then quickly, so ahead it will define how much does Cesar book Woody Radios Devices. So choose You can have option Ford donut also. So you choose category in percentage and put the name scenes. SE is looking by their ways save so situates quest option on our co existing dash for shale samples. She is death. No, I did dash book and stretch and then savored 78. How to Create line chart in Apache Superset: In this video, you will see how deplored daily sales with Times Series line chart. So click on sources. Click on waivers. Click on sales data sample. Click on Table you Flicked in cities. Linenger. Click on Dying Range. Click Custom Jews Date 1st January 2018 Do they visit for matrices? Choose total invoice value as a some save and then great. So no goto visual properties. Click Show Marcus and put X and Y levels. Extend a X and Y axis living, so give the name dailies is click on Say so go charge and see Daily says against Save Traditional. Would you say this dashboard and save and goto dash work. So click edit that word most predict up stretch and save it. 79. How to Create Time series stacked chart in Apache Superset: In this video, you will see how to plot your daily say's Vibe. Rocks. We're time series tag chart. So click on sources. Click on tables. Click sample data, please. Regulation Tape. Spain's It is that Now Choose Time Ridge Custom 1st January 2018. Who did it? No mattresses, which I need is Colton invoice value. Some say which I will do. Group byproduct is an query and had I can see my sales by product by day. What? Various categories. So choose visual properties to have extra controls or the excess labors, so X excess. So dates now give the chart name. So say this about productive. You didn't say saver at two dashboard, so choose sales dashboard and save and go to dashboard now a dash book and scroll down on a stretch so it requires a lot off space. So just stretch to the end on little bit. Donors now save changes 80. How to Create Partition Diagram in Apache Superset: In this video, you will see how to upload your total sales invoice plate by various card. Agree with partition diagram. So click on sources. Click on tables, Lincoln Sample data Congratulations Tape Stroll along and Jews auditioned item So now, too. It's Time Ridge custom. They should be January 1st 2080 So much this is will be so total scenes and waste about you see no head. I need to group it by the 1st 1 will be moored off booking. Then I won't product category brought up now click Run quickie. So here we can see the story in some is divided by moored off booking than products are degree and then so give the chart Name invoice played by movie category. Andra. So click on sale Actor your existing dashboard, says Dashwood and Saving Goto dashboard. So I didn't dashboard, Scroll alone and Stretch and several 81. How to Create Tree Map in Apache Superset: In this video, you will see how Google or your returns by product with Dreamer, click on sources. Click on tables. Click Simple sees Duda Click regulation tape Scroll along, Choose Dream Up, Go to time range custom and the date will be January 1st 2018 matrices, which I need is that Air? Dunn's So Hominy Eater? Dunn's Some save and grew by credits Now, then quit E. So now save charred by But it goes. But right up says a word, and I do dash board. She's Dashwood, Saving guru. So ended Dashboard. Now take this charge up, stretch it and savored. 82. How to Create Word Cloud in Apache Superset: in this video, you're going to present your product category based on the popularity off sales with the World Club. So click on sources. Click on tables. Click sales Sample Leader Click Congratulations Tape whose word cloud you stay in range. Give custom date 1st January 2018 So, CDs I want protect our dignity. So mattresses I want total sales value now run quality. Now choose the presentation, so whether it should be square or flak. But to the Seiss now give the name of the chart word, clothes, proxies David Actor Dashboard, scroll down. 83. How to Create Big Numbers in Apache Superset: In this video, you will see Hotel Greer big numbers, so click on sources. Click on tables. Example Leader. Click Regional Regulation Tape scroll alone to his big number, Jews. Language Custom. Four day for January 2080. Number one Cash Like the total cash back. Some save and run quickly, so 37.8 million is my cash back. It's a scrotum or the self header. Cash back the inquiry again and see an actor. Dashwood Save and go Dash. So click on dashboard, Move this up, shrink the size and savored. 84. How to Create Big Numbers with Trend Line in Apache Superset: and this video, you will see how to compare your numbers Using big numbers were trembling. Click sources click. There was. Let's see a example. Leader. Congratulations. Tape click. Big numbers were friendly. Lift time range. Click Custom Choose Date 1st January 2018. No Mackris's I Want to Compare my sales figure for last 13 days. The Jews. Total invoice values. Some say so comparison, Peter. I want for 13 days. So cheesy color. No save jarred sayings. Combat is in no save and actor dash work Say this Dashwood No, it it national stretch and see. 85. How to Create Multi Line Chart in Apache Superset: in this video, you're going to create Time Cities multilane charge to see your sales on your cash Back side by side, Click on sources. Click on people, click on ST Assemble Data click. Congratulations. Tape Body lying Charge Dame Cities two Time Ridge from 1st January 2080. Now give your first by exists as daily Saiz and second as daily cash and run quickly. Now you you can have your daily say that cash back side they say, give you a chart name. Davy. Say that cash back. Sure, Marcus See and had to die Sport. Sean's death. No stroll down. So did Dash book stretch and save it. 86. How to Create World Map in Apache Superset: In this video, you will see how to plot your say's inward map. So click on sources. Click on tables, click Same sample Leader, Click Regulation Tape Scroll. Oh, click on word Man Jews Time range Jews Custom give date 1st January 2018 Chose country control Scroll alone. Choose country core. Choose country food. Stay C 03 My trick for color. So I need total sales value. Now check the bubble size. Take showbuzz. So now I want based on the quantity Save Jews Max, Bubble Saiz and then quit. So give the name Kuchar Sales by region at the dashboard school dashboard stretch right side and down, so save changes. 87. How to Create Table View in Apache Superset: in this video, you're going to present your sales by way off table. Click on sources. Click on Tabor's Click Sales Sample Leader to Regulation Type of stable view Just Cambridge from 1st January 2018. Now choose group by good luck and dignity. Totally invoice value. Can solution and cash Beckham Run Quite it. Give you shark name. Give you a chart name Papers Go to visual property. Click on Search, Elaine and Tranquillity No SE and actor Dashboard, Slow down dashboard Stretching the chart and save it. 88. How to Create Pivot Table in Apache Superset: in this video you're going to create by word table for your sales data, so click on sources. Click on tables, click on sale sample data, Jews, visual ation tape, Strollo use pirate, even Jews. Time Ridge custom was then very 2018. So mattresses based on total sales value. So the group by credit card agree and column Tiny sales representative to give the papers name sales by representative Save at two days book scroll down. So now brag it to top stretch it and save it. 89. How to Create Calendar Map in Apache Superset: in this video, you're going to present your sales by Ray Off calendar map, Click on sources. Click on tables, Click Sales Amber Later Jews Regulation time Scroll alone. Gettinto Juice Time range. Custom date was generally 2018. Okay, now choose waitresses. Hotel invoice value, goto racial property Do the senses. Who sells reading and run quality? I just decided, according to your choice, give the name sales calendar. Save it actor dashboard. Say this dashboard Stroll along and it dies. Book Stretch it saver. 90. Apache Superset Drag and Drop Dashboard Creation: You can also create dashboard by dragon Drop matter what you showed in the video. Click on there. Give the dashboard name interactive. Sees Dashwood to the owner. See now click on dashboard. Now click on edit Dashboard. Click your charts Now. Our dragon broke your charts one by one to create the dashboard. So first braggin brought filter then dragon drop bar Jack than dragon Drop Peiser, then dragon drop later the dragon drops Then dragon broke Time City stature The dragon drop partition diagram Then dragon brought prima. Then dragon drop Big numbers were trendline and save or the end of the course. You will have interacted. Sees dashboard just like this would you can fill that out? You can impact with the usual charts So you can making through the group or statue. Bugger. You can interact with the preacher. You can interact with the fine cities Stature, you can drill, dude, it is with partition diagram. You can show your scenes or returns by remap and you can show you bring them. Thank you 91. How to Export Apache Superset Dashboard: In this video, you will see how to export dashboard and click on Dashboard. Choose dashboard. Choose Export dashboard. Layer dashboard is export it as JSON file. You have to important another instance. 92. How to Import Apache Superset Dashboard in another Instance: In this video, you will see how to import dashboards in Apache superset. Now click Manage, click Import dashboard, choose filename, click Open, choose database, cockroach TB, and click on upload. So Dashboard as imported by the name of science, click on sales. And the dashboard is imported in super circuit.