Live Online Metabase Course for Data Engineering

Live Course Module: Metabase Course for Data Engineering

Total Duration: 32 Hours (4 Weeks)

---

Week 1: Introduction to Metabase and Data Visualization Basics

Total Time: 8 hours

1. Introduction to Business Intelligence and Metabase (1 hr)

   • What is BI and its role in Data Engineering

   • Overview of Metabase features and architecture

2. Metabase Setup and Installation (2 hrs – Lab)

   • Installing Metabase on local and cloud environments

   • Connecting Metabase to relational databases (PostgreSQL, MySQL, Snowflake)

3. Metabase Interface Overview (1.5 hrs)

   • Navigating dashboards, collections, and admin settings

   • Understanding question types and saved queries

4. Building Basic Visualizations (1.5 hrs)

   • Creating charts, tables, and KPI cards

   • Understanding chart types and use cases

5. Hands-On & Assignment (2 hrs)

   • Build a basic sales dashboard

   • Assignment: Connect a sample database and create first visualization

---

Week 2: Working with Data and Queries in Metabase

Total Time: 8 hours

1. Data Modeling and Schema Understanding (1 hr)

   • Understanding datasets, relationships, and foreign keys

   • Importance of data modeling for dashboards

2. Simple and Custom Queries (2 hrs)

   • Using the Metabase query builder

   • Writing SQL queries within Metabase’s SQL editor

3. Advanced Query Features (1.5 hrs)

   • Filters, aggregations, joins, and custom expressions

   • Field visibility and metadata configuration

4. Data Exploration and Segmentation (1.5 hrs)

   • Using drill-down, filters, and group-by features

   • Creating custom segments and metrics

5. Hands-On & Assignment (2 hrs)

   • Build analytical queries for user behavior or sales trends

   • Assignment: Create a dynamic dashboard with SQL-based visualizations

---

Week 3: Dashboards, Automation, and Sharing Insights

Total Time: 8 hours

1. Building Interactive Dashboards (2 hrs)

   • Dashboard layout, filters, and interactivity

   • Combining multiple datasets into one dashboard

2. Embedding and Sharing Dashboards (1.5 hrs)

   • Public links, embeds, and secure sharing options

   • Permissions and access control

3. Automated Alerts and Subscriptions (1.5 hrs)

   • Setting up email or Slack alerts

   • Scheduled reports and recurring dashboard updates

4. Integrations with External Tools (1 hr)

   • Integration with Google Sheets, Slack, and APIs

   • Using Metabase in production environments

5. Hands-On & Assignment (2 hrs)

   • Create an automated alert for key business metrics

   • Assignment: Embed and share a project dashboard securely

---

Week 4: Administration, Optimization, and Capstone Project

Total Time: 8 hours

1. Metabase Administration (1.5 hrs)

   • User roles and permissions management

   • Data security and governance best practices

2. Performance Optimization (1.5 hrs)

   • Query caching and database indexing

   • Optimizing dashboards for speed and scalability

3. Deploying Metabase in Production (2 hrs)

   • Hosting on AWS/GCP/Docker

   • Backup, migration, and version updates

4. Capstone Project (3 hrs)

   • Build an end-to-end analytics dashboard for a real-world use case

   • Connect → Model → Query → Visualize → Automate

---

🧩 Final Deliverables

• Mini Projects: 3 (Setup, SQL Visualization, Automation)

• Capstone Project: 1 End-to-End Business Dashboard

• Assessments: Weekly quizzes + project evaluation

• Tools Covered: Metabase, PostgreSQL/MySQL, Docker, Slack/Email Integrations