Business Intelligence and Data Analysis with Metabase Training Course

Introduction

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

Getting Started

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

Querying Data

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

Working with SQL

• Writing native SQL queries for government datasets
• Creating filter widgets to enhance data exploration
• Adding smart filter widgets for dynamic filtering
• Working with dates in SQL queries
• Using SQL snippets for efficiency
• Simplifying complex queries with Common Table Expressions (CTEs)
• Organizing SQL code using snippets, saved questions, and views
• Combining tables with join operations

Building Visualizations and Dashboards

• Selecting the appropriate chart type for data representation
• Customizing visualization settings to meet government standards
• Setting up and configuring dashboards for government use
• Making dashboards interactive for user engagement
• Adding dashboard filters for tailored insights
• Best practices and tips for effective dashboard creation

Analyzing and Managing Data

• Using time series comparisons for trend analysis
• Building a customer lookup tool for government applications
• Delivering customer-facing analytics to stakeholders
• Embedding charts and dashboards on government websites
• Exploring additional use cases and examples for government

Common Issues and Troubleshooting

Summary and Next Steps