Dimensional Modeling · Beginner

Dimensional Modelling for Analytics

Design star schemas that make reporting fast, consistent and trustworthy.

Learn Kimball-style dimensional modelling: grain, facts, conformed dimensions and slowly changing dimensions, and turn them into semantic models business users can rely on.

Duration
16 hours
Mode
Live online
Next batch
To be announced
Schedule
Weekday evenings, 7–9pm IST

Who it is for

BI developers, analysts and data engineers who build reporting models.

Prerequisites

Basic SQL.

What you will be able to do

  • Declare the grain and design fact tables
  • Design conformed dimensions and slowly changing dimensions
  • Build a bus matrix for an enterprise data warehouse
  • Translate a star schema into a semantic model

Course contents · 4 modules · 16 hours

01
Foundations

Business processes, grain, facts and dimensions

3 h
02
Facts

Transaction, periodic and accumulating snapshots; additivity

4 h
03
Dimensions

Conformed dimensions, SCD types 1, 2 and 3, junk and role-playing dimensions

5 h
04
Delivery

Bus matrix, semantic models, modelling review with the trainer

4 h

Hands-on approach

30% concepts, 70% hands-on labs on realistic business scenarios. AI practice support between sessions; every project is reviewed by the trainer.

Keep exploring
SnowflakeIntermediate

Snowflake Data Engineering Bootcamp

For data engineers and SQL developers who want to build reliable, cost-aware pipelines on Snowflake.

Duration
24 hrs
Mode
Live online
Starts
To be announced
Syllabus · 5 modules · Sat–Sun, 10am–1pm IST
  1. Snowflake architecture and setup · 4h
    Storage, compute and services layers; warehouses; databases and schemas; roles and cost basics
  2. Loading data · 5h
    Stages, file formats, COPY INTO, Snowpipe, semi-structured data with VARIANT
  3. Transformations and ELT · 6h
    Streams, tasks, dynamic tables, MERGE patterns, incremental loads, time travel
  4. Security and governance · 4h
    RBAC design, masking and row access policies, tagging, data sharing
  5. Performance, cost and capstone · 5h
    Clustering, query profile, resource monitors; end-to-end capstone reviewed by the trainer
You will be able to: Design Snowflake databases, schemas and warehouses for a real workload · Load batch and continuous data with COPY, stages and Snowpipe · Build incremental ELT with streams, tasks and dynamic tables · Apply role-based access, masking and cost controls · Review AI-assisted SQL critically before it runs
Fees on requestEnquire for fees and the next batch
View course detailsEnquire
DatabricksIntermediate

Databricks Lakehouse Engineering with PySpark

Build medallion-architecture pipelines on Databricks with PySpark and Delta Lake.

Duration
30 hrs
Mode
Live online
Starts
To be announced
Syllabus · 5 modules · Weekday evenings, 7–9pm IST
  1. Lakehouse fundamentals · 4h
    Workspace, clusters, notebooks, Delta Lake basics, medallion architecture
  2. PySpark for data engineering · 8h
    DataFrames, joins, window functions, UDF trade-offs, performance basics
  3. Delta Lake in depth · 6h
    MERGE, change data feed, schema evolution, OPTIMIZE and Z-ORDER, time travel
  4. Governance and quality · 5h
    Unity Catalog, expectations and data quality checks, lineage
  5. Orchestration and capstone · 7h
    Workflows, parameters, monitoring; capstone pipeline reviewed by the trainer
You will be able to: Build medallion (Bronze, Silver, Gold) pipelines with PySpark and Delta Lake · Handle incremental and historical loads, schema evolution and data quality checks · Govern data with Unity Catalog · Orchestrate and monitor jobs with Databricks Workflows
Fees on requestEnquire for fees and the next batch
View course detailsEnquire
AI for Data TeamsIntermediate

AI for Data Teams: LLMs, RAG and Reviewing AI Output

Use AI productively in data work, and know when not to trust it.

Duration
16 hrs
Mode
Live online
Starts
To be announced
Syllabus · 4 modules · Sat–Sun, 10am–2pm IST
  1. LLM basics for data people · 3h
    How models work, strengths, failure modes, hallucination
  2. Prompting for data work · 4h
    SQL generation, documentation, data quality rules, STTM drafts
  3. Retrieval and vector search · 4h
    Embeddings, chunking, RAG over metadata and documentation
  4. Safe use and review · 5h
    Data privacy, human gates, review checklists, measuring quality; capstone reviewed by the trainer
You will be able to: Explain how LLMs work and where they fail · Design prompts for SQL, documentation and data quality tasks · Build a simple retrieval (RAG) pipeline over your metadata · Set up review gates so AI output is checked before use · Keep personal and sensitive data out of AI tools
Fees on requestEnquire for fees and the next batch
View course detailsEnquire