Course Outline

Introduction

  • Metabase vs Superset vs Tableau
  • Overview of Metabase features and components

Getting Started

  • Installing Metabase
  • Setting up an account
  • Connecting the database
  • Exploring the UI and tools

Querying Data

  • Adding a question (simple and custom)
  • Creating explorable charts
  • Using custom expressions
  • Joining tables in Metabase
  • Aggregating multi-level queries

Working with SQL

  • Writing SQL queries (native query)
  • Creating filter widgets
  • Adding smart filter widgets
  • Working with dates in SQL
  • Using SQL snippets
  • Simplifying queries with CTEs
  • Organizing SQL codes (snippets, saved questions, views)
  • Combining tables with joins

Building Visualizations and Dashboards

  • Choosing a chart type
  • Customizing visualization settings
  • Setting up and configuring dashboards
  • Making dashboards interactive
  • Adding dashboard filters
  • Best practices and tips

Analyzing and Managing Data

  • Using time series comparisons
  • Building a customer lookup tool
  • Delivering customer-facing analytics
  • Embedding charts and dashboards to websites
  • Other use cases and examples

Common Issues and Troubleshooting

Summary and Next Steps

Requirements

  • An understanding of data analytics and database concepts

Audience

  • Data analysts
  • Data scientists
  14 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (3)

Related Courses

Big Data Business Intelligence for Govt. Agencies

  35 Hours

Big Data Business Intelligence for Telecom and Communication Service Providers

  35 Hours

Related Categories