Data Builder Onboarding Guide

Overview

Role Description

Data Builders are mainly responsible for data integration, data preparation, job scheduling, and other work related to data warehouse development, usually IT or data teams.

Learning Objectives

If you are a Data Builder, here are the essential skills you can master through this learning path. You will learn:

• Familiarize yourself with Guandata BI's data integration methods and understand the process for connecting different data sources.
• Learn about data preparation tools and techniques, including data cleaning, transformation, and integration.
• Master the basic operations and configuration of job scheduling to ensure stable data flow.

Learning Path

Learning Stage	Checkpoint Introduction	Specific Checkpoint	Help Document
Getting Started from Scratch	Basic Guide	Guandata BI Concept Table	Guandata BI Concept Table
		Guandata BI Core Features Overview	Core Features Overview
	Data Integration	Try Integrating an Excel File	Excel Data Integration Introduction
			Integrate a Store Sales Table
		Create a Data Account at the Same Time	Data Account Introduction
			Create a New Data Account
		Integrate a Standard Database, e.g., MySQL	MySQL Data Integration
	Data Preparation	Learn What Smart ETL Is	Smart ETL Overview
		Perform a Simple Two-table Join and Output a New Dataset	ETL Table Join Configuration
	---	After joining two tables, create a self-service wide table for frontline business consumption	What is Self-service Data Query?
Advanced Attempt	Advanced	Data filtering, deduplication, value replacement, and other data editing	ETL Data Editing
		Column-to-row, row-to-column, and other column operations	ETL Column Operations
		Input SQL queries and process data	ETL SQL Input
		Batch replace ETL datasets	Batch Replace ETL Dataset
		Grant access to the current ETL task to other users	ETL Permission Management
	Function Calculation	Function Description and Usage Scenarios	Video - Function Introduction
		Window function introduction and calculation usage	Window Function Introduction
			Window Function Basic Usage
			Window Function Practice Case_Store Sales Analysis
		Array function introduction and calculation usage	Array Function Introduction
			Array Function Practice Case_Cumulative Value Calculation
			Array Function Practice Case_Supplier Analysis
Advanced Requirements	Data Warehouse Development	Connect to external databases such as cloud vendors and domestic databases	External Database Integration
		Advanced configuration options for Smart ETL tasks	ETL Advanced Configuration
		Return BI analysis assets to the enterprise's business systems and data warehouses	Data Writeback Function Description
		Task orchestration for complex business scenarios, meeting real-time analysis needs at low cost	Advanced Scheduling Function Description