Business Intelligence and Data Analysis with Metabase Training Course

Introduction

• Comparison of Metabase, Superset, and Tableau for government
• Overview of Metabase features and components for government

Getting Started

• Installing Metabase for government
• Setting up an account for government
• Connecting the database for government
• Exploring the user interface and tools for government

Querying Data

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

Working with SQL

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

Building Visualizations and Dashboards

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

Analyzing and Managing Data

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

Common Issues and Troubleshooting

Summary and Next Steps