Want to make creations as awesome as this one?

Transcript

Explore Data in Insights

Now, we are going to learn how to navigate and use the Superset tool to explore our data and create charts.

Superset is composed of 5 tabs:
- Home: overview page
- Data: you will find the list of DB (one per client, and the DB "Insights" used for POCs) and the list of datasets (tables)
- Charts: where all the charts used in our dashboards are stored
- Dashboards: the list of dashboards
- SQL Lab: a tool to build SQL query to explore the data stored in your tables


👉 Log in to superset with your credentials
👉 Click on Dashboards and open "Télécom sur étagère - FttH v2"
👉 Navigate through the different tabs in the dashboard and try to modify the filters

Explore your tables with the SQL Editor

The dashboard "Télécom sur étagère - FttH v2" uses the DB "Insights-Analytics". Let's explore the data that compose the dashboard.

👉 Go to the SQL Lab and choose SQL Editor.
👉 Choose the DB "Insights-Analytics"
👉 Choose the schema "tse_ftth"
👉 Try to select one of the tables, you will see the columns that compose this table on the left
👉 Write your first SQL query to explore the data.
For ex. "SELECT * from tse_ftth.interventions;" to see all the data in the table intervention

Explore your tables with the SQL Editor

👉 How many rows and columns do you find?
👉 Try to write a SQL query to to see all the data in the table context.
👉 Can you add a condition to your query to only see the data before the 22/02/2020?



Create a dashboard

👉 Go to the tab dashboards and click on the top right button "+ Dashboard" to create a new dashboard
👉 Give your dashboard a name (use your name)
👉 Add a markdown component to your dashboard and write "Welcome to my first Insights dashboard". Click save and go back to the list of dashboards. Can you see the dashboard that you have just created?

Now we need to add the first chart to our dashboard:






Create a chart

👉 Go to the tab charts and click on the top right button "+ chart" to create a new chart
👉 Choose the dataset tse_ftth.interventions
👉 Choose the big number visualisation type and create the chart
👉 Remove the time range filter and click "run". Which number do you find? What does this number represent?
👉 Give an appropriate title to your chart
👉 Click save and add this graph to your dashboard. Click save and go to dashboard.







Improve your dashboard

👉 Now is the time for you to add more interesting graphs to your dashboard ! Try to build at least 5 additionals graphs (using the different tables, different visualisation types, different metrics, and use the customize tab to format your charts properly).
👉 You can click on the three dots next to a chart in your dashboard and view chart in Explore to edit the graph. You can create a new chart by doing so (beware to click on save > save as to create a new chart and not overwrite the precedent chart)







View chart in Explore