Duration: Two Days

Course Overview

This course is designed for learners who are ready to move beyond Dataiku fundamentals and deepen their data transformation and automation skills. Participants will work with advanced visual recipes and formulas, write SQL recipes to perform more complex data transformations, and gain an introduction to Python notebooks within Dataiku. The course also focuses on automating end-to-end workflows using scenarios, enabling learners to create repeatable, reliable data processes. Through hands-on labs and guided exercises, students will learn how to build more powerful, efficient, and scalable data pipelines in Dataiku.

Focus:

  • Advanced visual recipes and formulas
  • Writing SQL recipes for transformations
  • Intro to Python notebooks in Dataiku
  • Automating workflows with scenarios

Audience

  • Data Analysts
  • Power Data Users

Recommended Prerequisites

Excel Level 2

Query and Modify Data with SQL

Using Data Science Tools in Python

Learning Objectives

  • Combine datasets using SQL and visual recipes
  • Create custom charts and simple scripts
  • Automate workflows and manage data pipelines

Course Outline

  1. Advanced Data Preparation Techniques
  2. SQL Recipes and Query Optimization
  3. Python Basics in Dataiku (Notebooks & Scripts)
  4. Building Scenarios for Automation
  5. Data Visualization Best Practices