BigQuery-Powered Data Analytics with Metabase: From SQL to Dashboards

Module 1: SQL ও Metabase পরিচিতি

1.1 SQL কী?

• Relational Database ধারণা
• Table, Row, Column
• Primary Key, Foreign Key

1.2 Metabase কী?

• Business Intelligence টুলের ধারণা
• Metabase-এর কাজ
• ব্যবহারের ক্ষেত্র (Sales, Marketing, Finance, SaaS Analytics)

1.3 Database Connection

• Metabase-কে বিভিন্ন ডাটাবেসের সাথে যুক্ত করা:
  • PostgreSQL
  • MySQL
  • SQL Server
  • SQLite
  • BigQuery / Snowflake

Hands-On

• Metabase ইনস্টলেশন (Cloud / Docker)
• Sample Database সংযোগ

Module 2: SQL Fundamentals

2.1 Basic SQL Syntax

• SELECT, FROM, WHERE
• Filtering, Sorting
• Alias ব্যবহার

2.2 Aggregation

• GROUP BY, HAVING
• SUM, COUNT, AVG, MIN, MAX

2.3 Joins

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN

2.4 Data Types & Operators

• Numeric, Text, Date, Boolean
• Arithmetic & Logical Operators

Hands-On

• Metabase SQL Editor-এ Query লেখা
• Sales Summary তৈরি
• Multi-table Join Query

Module 3: Intermediate SQL

3.1 Subqueries

• Inline View
• Nested Subquery

 

3.2 Window Functions

• ROW_NUMBER, RANK
• Running Total
• Moving Average

3.3 Common Table Expressions (CTE)

• WITH স্টেটমেন্ট
• Multi-CTE Query Structure

3.4 Date & Time Functions

• Date Extraction
• Time Zone Handling

Hands-On

• CTE ব্যবহার করে Complex Query
• “Top 10 Customers” Analysis
• Running Total

Module 4: Metabase Query Builder

4.1 Query Builder ব্যবহার

• Simple Question
• Summaries এবং Aggregations
• Custom Column

4.2 Filtering & Field Types

• Category Fields
• Foreign Key Relationship
• Auto-join Ability

4.3 Visualization

• Bar Chart
• Line Chart
• KPI Card
• Pivot Table
• Funnel Chart

Hands-On

• Dashboard Visualization তৈরি
• একই Query-এর SQL vs UI তুলনা

 

Module 5: Dashboards & Analytics

5.1 Dashboard Creation

• Layout Design
• Global & Local Filters
• Drill-down Interaction

5.2 Alerts & Subscriptions

• Email Reports
• Slack Alerts

5.3 Embedding Analytics (Advanced)

• Public Link
• Signed Embed
• White-Labeling (Enterprise Edition)

Hands-On

• সম্পূর্ণ Executive Dashboard তৈরি
• Filter Widget Add করা
• Automatic Reporting Schedule

Module 6: Advanced SQL + Metabase

6.1 Analytical SQL

• Cohort Analysis
• Retention Analysis
• Basic Churn Modeling

6.2 Models & Materialized Views

• কখন Model তৈরি করবেন
• Reusable Dataset
• Clean Business Logic Layer

6.3 Security & Permissions

• User Groups
• Data Sandboxing
• Row-level Permissions

Hands-On

• Cohort Dashboard তৈরি
• Reusable Data Model Build