Querytech Academy Querytech Academy Academy
Part of the Data Intelligence Architect Pathway

Certified Data Intelligence Specialist CDIS

Data Warehousing, BI, and ETL

Enroll via the Data Intelligence Architect Pathway

Level 1: Beginner

Beginner level of Certified Data Intelligence Specialist

"Build solid Python engineering fundamentals — syntax, structure, and tooling — purpose-built for data workflows."

Included Modules
Python Syntax & Control Structures
Functions & Modular Programming
File Handling & Automation Scripts
Error Handling & Logging
Object-Oriented Programming
Virtual Environments & Dependency Management
Performance Profiling

"Master high-speed data manipulation using DataFrames and array computation to clean, transform, and analyze real datasets."

Included Modules
DataFrames & Array Computation
Data Cleaning & Transformation
Handling Missing Values
Grouping & Aggregation
Merging & Reshaping Datasets
Performance Optimization for Large Datasets

"Build statistical visualizations and automate reporting scripts that turn raw data into shareable insight."

Included Modules
Plotting Fundamentals
Statistical Visualizations
Trend Analysis Visuals
Automated Reporting Scripts

"Extract data programmatically from the web using ethical scraping principles and automate the full extraction pipeline."

Included Modules
HTTP Requests & APIs
HTML Parsing Concepts
Ethical Scraping Principles
Data Cleaning Automation
Scheduling Scripts

"Master the SQL that feeds every data pipeline, from analytical queries to performance-aware extraction."

Included Modules
Advanced Analytical SQL
Query Optimization for Pipelines
Working with Semi-Structured Data
Database Connectivity from Python

Professional Competencies

Coming soon.

Industry Tools

Coming soon.

Level 2: Intermediate

Intermediate level of Certified Data Intelligence Specialist

"Understand the architectural concepts behind big data systems: distributed computing, data lakes, and governance at scale."

Included Modules
Structured vs Unstructured Data
Batch vs Streaming Processing
Distributed Computing Fundamentals
Data Lakes vs Data Warehouses
Data Governance Fundamentals
Apache Spark Awareness

"Design and build ETL pipelines with proper orchestration, validation, and lineage tracking for production reliability."

Included Modules
Extract-Transform-Load Workflow Design
Data Transformation Logic
Workflow Orchestration Concepts
Pipeline Orchestration with Airflow (Awareness)
Data Validation & Quality Checks
Data Lineage Tracking

"Design and optimize cloud data warehouses using Google Cloud and Snowflake, including schema design and cost control."

Included Modules
Warehouse Schema Design (Star & Snowflake)
Partitioning & Clustering
Query Performance Tuning
Managing Large-Scale Datasets
Access Control & Security
Cost Optimization Strategies

"Build data quality and observability into pipelines so downstream models can trust their inputs."

Included Modules
Data Quality Dimensions
Automated Data Testing
Data Observability & Monitoring
Anomaly Detection in Pipelines

"Process data in real time using streaming architectures for low-latency analytics and event handling."

Included Modules
Streaming Fundamentals
Message Brokers & Event Streams
Windowing & Stateful Processing
Lambda & Kappa Architectures

Professional Competencies

Coming soon.

Industry Tools

Coming soon.

Level 3: Advanced

Advanced level of Certified Data Intelligence Specialist

"Build a rigorous foundation in machine learning: training, evaluation, and the bias-variance tradeoff that governs model quality."

Included Modules
Supervised vs Unsupervised Learning
Training vs Testing Data
Feature Engineering
Bias & Variance
Model Evaluation Metrics
Cross-Validation
Hyperparameter Tuning

"Build regression and time-series forecasting models to predict continuous business outcomes."

Included Modules
Linear Regression
Regularization Concepts
Time-Series Basics
Forecast Evaluation

"Build classification models and evaluate them rigorously using precision, recall, and ROC analysis."

Included Modules
Logistic Regression
Decision Trees
Model Accuracy, Precision & Recall
ROC Curves

"Take a trained model from notebook to production: serialization, API deployment, and ongoing performance monitoring."

Included Modules
Model Serialization
API-Based Prediction Services
Monitoring Model Performance
Concept Drift Awareness
Ethical AI Considerations

"Operationalize the models you build with versioning, automated retraining, and production monitoring."

Included Modules
Feature Stores
Model Versioning & Registries
Automated Retraining Pipelines
Production Model Monitoring

"Process massive datasets with distributed computing using Spark for both batch and large-scale transformation."

Included Modules
Spark Architecture & RDDs
Spark DataFrames & SQL
Distributed Transformations
Spark Performance Tuning

Professional Competencies

Coming soon.

Industry Tools

Coming soon.

Ready to Start?

This program is part of the Data Intelligence Architect Pathway. You'll pick your starting cohort for Certified Data Intelligence Specialist — the first program in the pathway — on the next step.

Reserve Your Spot