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
 

Testimonials

Related Courses

Business Intelligence in MS SQL Server 2008

 14 hours

Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of

55232-A: Writing Analytical Queries for Business Intelligence

 21 hours

This three-day instructor led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis - in other words, making

AWS QuickSight

 14 hours

AWS QuickSight is a business analytics service by Amazon. It provides tools for building data visualization, performing ad hoc analysis, and getting business insights from different data sources. This instructor-led, live training (online or

Sisense Business Intelligence

 14 hours

Sisense is a Business Intelligence tool that provides user-friendly solutions for managing, visualizing, and modifying multiple big data sets quickly and efficiently. This instructor-led, live training (online or onsite) is aimed at developers

Big Data Business Intelligence for Govt. Agencies

 35 hours

Advances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of

Big Data Business Intelligence for Telecom and Communication Service Providers

 35 hours

Overview Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow

Qlik Sense for Data Science

 14 hours

Qlik Sense is a cloud-based data analytical software for analyzing and displaying data. With Qlik Sense, users will be able to gain impactful insights by connecting to different data sources and creating advanced visualizations. This

Big Data Business Intelligence for Criminal Intelligence Analysis

 35 hours

Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these

Datameer for Data Analysts

 14 hours

Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion. In this instructor-led,

IRIS: Document Classification and Data Capture

 7 hours

IRIS is an Enterprise Content Management (ECM) system. With IRIS, users can automate document classification and data capturing. This instructor-led, live training (online or onsite) is aimed at content managers who wish to optimize and update

Power BI Dashboards

 14 hours

Learn how to Get & Transform Data to Prepare Interactive Dashboards Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which

Pentaho Open Source BI Suite Community Edition (CE)

 28 hours

Pentaho Open Source BI Suite Community Edition (CE) is a business intelligence package that provides data integration, reporting, dashboards, and load capabilities. In this instructor-led, live training, participants will learn how to maximize

Qlik: Advanced Topics in Design and Development

 14 hours

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this

QlikView Server Administration

 14 hours

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this

Business Intelligence with SSAS

 14 hours

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client