Skip to main content

Basic Instructional Design

Overview​

This course provides a comprehensive introduction to DPL Studio and Agentic Flow concepts. It blends traditional ETL/ELT workflows with modern AI-driven automation, giving learners the ability to:

  • Connect and extract data from diverse systems.

  • Apply transformations and exports for BI and analytics.

  • Build and monitor automated workflows.

  • Implement AI features such as metadata tagging, alerts, chatbots, and data quality validation.

  • Integrate all components into real-world solutions.

Module 1 -- Introduction

  • Learning Objectives:

  • Define what DPL Studio is.

  • Explain its role in data integration.

Expanded Content:

  • DPL Studio is a data integration and transformation tool that connects to multiple sources, applies queries, and exports results to other platforms (databases, Excel, reporting tools).

  • Key use cases: data aggregation, BI reporting, backend for Excel, and cross-platform integration.

Activities/Interaction:

  • Scenario: "Your company needs to combine sales and inventory data from SQL and Excel. How would DPL help?"

  • Knowledge check: Match DPL features with use cases (integration, queries, exports).

Module 2 -- Installation & Licensing

  • Learning Objectives:

  • Install DPL Studio.

  • Activate application and connector licenses (online & offline).

Expanded Content:

  • Application License Setup:

  • Online: Enter the license key received via email.

  • Offline: Download system config, upload to license portal, and import certificate file into DPL Studio.

  • Connector License Setup :

  • Required for specific databases (SQL, Oracle, Salesforce, etc.).

  • Steps mirror application license activation.

Activities /Interaction:

  • Demo walkthrough video of license activation.

  • Quiz: Learners decide correct step sequence for online vs. offline activation.

Module 3 -- Interface & Navigation

Learning Objectives:

  • Identify main areas of the DPL Studio interface.

  • Perform basic actions using the data pane and toolbar.

Expanded Content:

Interface Areas:

  • Document Area -- workspace for packages, queries, exports.

  • Data Pane -- folders for Connections, Queries, Export Templates.

  • Dynamic Help Pane -- context-sensitive help.

  • Toolbar & Tools Menu -- shortcuts for actions and settings.

  • Status Console -- troubleshooting messages.

  • Basic User Actions: Create/open packages, add connections, view queries, use right-click menu options.

Activities / Interaction:

  • Guided exploration: Learners click on different areas in a simulated interface to discover functions.

  • Drag & Drop exercise: Match interface elements to their role (e.g., "Data Pane → Create queries").

Module 4: Introduction to ETL/ELT in DPL Studio 

Learning Objectives 

  • Understand the concepts of ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform). 

  • Recognize how DPL Studio enables both ETL and ELT workflows. 

Expanded Content 

ETL: Data is extracted from sources, transformed inside DPL Studio (joins, aggregations, functions), then loaded to a target. 

ELT: Data is extracted and loaded into the target system first (e.g., a warehouse), and transformations are executed within the target (SQL pushdown). 

Hybrid Approach: Some transformations in DPL, others pushed down to connectors. 

Key Features 

  • 250+ connectors (via CData ODBC + native). 

  • Visual drag-and-drop interface for ETL. 

  • Pushdown query execution for ELT efficiency. 

Example Use Case  A retail company extracts data from Salesforce (customers) and SQL Server (transactions). 

  • ETL Approach: Join data inside DPL Studio, calculate customer lifetime value, then export to Excel. 

  • ELT Approach: Load raw Salesforce + SQL data into Snowflake, run pushdown SQL queries in Snowflake to generate analytics. 

Module 5: Data Extraction 

Learning Objectives 

  • Connect to multiple structured and unstructured data sources. 

  • Learn best practices for incremental and secure extraction. 

Expanded Content 

  • Supported connectors: Databases (Oracle, MySQL, PostgreSQL, SQL Server), Files (Excel, CSV, JSON, XML), Cloud Apps (Salesforce, Dynamics, NetSuite, Workday), APIs (REST, OData). 

  • Incremental extraction using date filters, IDs, or CDC fields. 

  • Central repository for saving/reusing connections. 

Key Features 

  • 250+ connectors ready for plug-and-play. 

  • Reusable & secure connection repository. 

  • Parameterized extractions for automation. 

Example Use Case  A healthcare provider extracts patient records from an Oracle DB and insurance claims from CSV files daily, filtering only new records by last_updated_date. 

Module 6: Transformations 

Learning Objectives 

  • Apply transformations to clean, enrich, and shape data. 

  • Understand joins, aggregations, and functions in DPL Studio. 

Expanded Content  

  • Joins: Merge multiple sources (cross-DB supported). 

  • Aggregations: Summarize sales, counts, averages, growth metrics. 

  • Functions: Predefined transformations for dates, strings, math, and conditional logic. 

  • User Defined Fields (UDFs): Extend transformations with custom formulas. 

Key Features 

  • Drag-and-drop or advanced query mode. 

  • Pushdown processing (ELT) when supported by connectors. 

  • Real-time data preview. 

Example Use Case : An e-commerce company joins website traffic logs (JSON API) with order data (PostgreSQL), aggregates sessions by region, and applies a function to calculate conversion rate = orders / visits × 100.

Module 7: Data Loading & Export 

Learning Objectives 

  • Deliver data to multiple destinations. 

  • Automate recurring exports with templates. 

Expanded Content 

  • Targets supported: Databases (SQL, Oracle, Snowflake), Files (CSV, Excel, XML, JSON), BI Tools (Tableau, Power BI), Cloud Storage (S3, Azure Blob, Google Drive). 

  • Quick Export for immediate results. 

  • Export Templates for repeatable loads. 

  • Scheduling with DPL/Windows Task Scheduler. 

Key Features 

  • Multi-target export support. 

  • Reusable templates. 

  • Automated scheduling and delivery. 

Example Use Case  A bank exports daily transaction summaries into: 

1 CSV file for auditors. 

2 Power BI dataset for management dashboards. 

3 Azure SQL Warehouse for long-term storage. 

Module 8: ETL/ELT Workflow Design 

Learning Objectives 

  • Combine all steps into structured workflows. 

  • Visualize data pipelines with DPL Studio's Data Flow Graph. 

Expanded Content 

  • Use Packages to group connectors, queries, and exports. 

  • Data Flow Graph for end-to-end workflow visibility. 

  • Modular design for reusability and easier maintenance. 

Key Features 

  • Centralized orchestration. 

  • Visual dependency tracking. 

  • Package-level organization. 

Example Use Case  A telecom company builds a workflow: 

  • Extract call records (SQL) and billing data (SAP). 

  • Transform: Join on customer ID, calculate usage charges. 

  • Load into Snowflake for advanced analytics and export monthly reports to Excel for business units. 

Module 9: Error Handling & Monitoring 

Learning Objectives 

  • Detect, log, and resolve issues in ETL/ELT pipelines. 

  • Learn cache management and retry strategies. 

Expanded Content 

  • Error types: Connection failures, query errors, export mismatches. 

  • Status Console for log monitoring. 

  • Cache flushing to reset workflows. 

  • Restart from failure point. 

Key Features 

  • Built-in diagnostic and logging tools. 

  • Retry and quick recovery support. 

  • Easy debugging for non-technical users. 

Example Use Case  A finance workflow fails due to expired API credentials in QuickBooks. Logs point to authentication failure → credentials updated → only failed loads retried. 

Module 10: Hands-on ETL/ELT Practice 

Learning Objectives 

  • Implement a complete workflow covering ETL and ELT. 

  • Compare approaches and performance. 

Expanded Content 

  • Practice end-to-end flow: Extract → Transform → Load → Export → Validate. 

  • Scenario-driven exercises across industries. 

  • Compare DPL in-studio transformations (ETL) vs pushdown transformations (ELT). 

Key Features 

  • Real-world, multi-source data practice. 

  • Performance tuning with ETL vs ELT. 

  • Checklist-driven assessment. 

Example Use Case 

  • ETL Flow: A logistics company extracts shipment data from Oracle, joins with GPS logs (API), transforms in DPL Studio, and loads into CSV for reporting. 

  • ELT Flow: Same company loads raw data into Snowflake, then executes pushdown SQL queries inside Snowflake to calculate route efficiency. 

Module 11: Understanding AI Workflows with Metadata

Learning Objectives

  • Understand what metadata is and how computers use it.

  • Recognize how AI workflows function like step-by-step recipes.

  • Learn how visual flowcharts represent automated processes.

  • Apply metadata to improve AI decision-making.

Expanded Content

Metadata is 'data about data,' such as file names, tags, or creation dates. It helps AI systems categorize and process information efficiently. AI workflows are sequences of steps executed by agents, similar to recipes. Visual representations like flowcharts make processes clearer, with real-world applications such as email sorting or document filing.

Key Features

  • Visual workflow builders for automation.
  • Metadata tagging for organization.
  • Spreadsheet integration for structured data.
  • Drag-and-drop tools for flow creation.

Example Use Case

A company sets up a workflow where incoming invoices are automatically tagged with supplier names and dates, sorted into folders, and a summary report is generated.

Module 12: Setting Up Alerts and Automation

Learning Objectives

  • Understand the concept of alerts and monitoring systems.
  • Learn how to set up notification rules for business processes.
  • Explore chatbot functionality for routine tasks.
  • Automate responses to business events.

Expanded Content

Alerts are digital notifications triggered by events, helping users stay informed. These can be sent via email, text, or dashboards. Smart filters avoid overload. Chatbots can automate simple customer queries, schedule management, and sales inquiries. If-then logic links alerts to automatic actions, enhancing responsiveness.

Key Features

• Multiple alert channels (email, text, dashboards). • Chatbot builders with drag-and-drop flows. • Smart filters for notification management. • Rule-based automation for common scenarios.

Example Use Case

A retail shop configures a chatbot to handle customer inquiries about store hours and sets up alerts to notify staff when sales drop below a threshold.

Module 13: Data Quality Analysis Made Simple

Learning Objectives

  • Understand the characteristics of good versus poor data.
  • Use beginner-friendly tools to check data consistency.
  • Apply no-code platforms for quality monitoring.
  • Build visual dashboards to track data health.

Expanded Content

High-quality data is complete, accurate, consistent, and up to date. Using tools like Flowise, spreadsheets, and drag-and-drop interfaces, users can validate structured data (CSV, Excel) and unstructured content (documents, images). Dashboards and traffic light indicators make monitoring easy, while reports provide actionable insights.

Key Features

  • No-code data validation tools.
  • Automated duplicate and missing data detection.
  • Simple chart and report generation.
  • Dashboards with traffic-light indicators.

Example Use Case

A healthcare provider uses data validation tools to check CSV-based patient records, highlighting missing fields and generating a weekly data quality dashboard for compliance teams.

Module 14: Putting It All Together

Learning Objectives

  • Combine workflows, alerts, and data analysis into complete systems.
  • Design real-world business solutions using automation tools.
  • Document and present solutions to teams.
  • Plan ongoing maintenance for long-term success.

Expanded Content

Learners integrate skills from previous modules to create business-ready solutions. Projects involve combining workflows, monitoring systems, and dashboards. Documentation, user training, and maintenance planning ensure sustainability of these solutions.

Key Features

  • Integration of workflows, alerts, and analysis.
  • Solution testing and iteration.
  • Documentation and training guides.
  • Maintenance planning for scalability.

Example Use Case

A startup combines automated email sorting, sales alerts, and a chatbot into a single workflow, testing it on live business data and preparing documentation for employee onboarding.

Moodle Activities:​

Moodle activities make learning interactive and engaging. SCORM with xAPI tracks detailed progress, quizzes and assessments check knowledge, while surveys and feedback collect opinions. Forums support discussions, and Level Up adds gamification to motivate learners.

Moodle Activity Description

  • SCORM file with XAPI events A packaged e-learning module that supports tracking learner interactions using Experience API (xAPI), enabling detailed analytics and reporting across platforms.

  • Quiz An interactive activity with various question types (MCQs, true/false, short answer) used to assess learner understanding and provide instant feedback.

  • Assessment A structured evaluation tool designed to measure learner performance against predefined learning objectives, often used for grading or certification.

  • Forum A collaborative discussion space where learners and instructors can post messages, share ideas, and engage in peer-to-peer learning.

  • Feedback A customizable activity that allows instructors to gather targeted input from learners about course content, delivery, or experience.

  • Survey A non-graded activity used to collect opinions, preferences, or feedback from learners to inform instructional decisions or research.

Level up A gamification plugin that tracks learner progress and awards points, badges, or levels to motivate engagement and completion of course activities.

You may reach out to us through any of the following channels

Click on the round blue chat icon and a contact panel will appear with multiple ways to reach us, including:

  • Phone

  • WhatsApp

  • Book a Meeting

  • Submit a Support Form

  • Email

Academy contact

Academy contact