Skip to main content

Data Development Engineer Getting Started Guide

Overview

This learning path is designed for data development engineers and data engineering roles. It builds a complete skill set from foundational data processing to advanced modeling. You will learn how to use Smart ETL for cleansing and integration, how to design data models, and how to improve governance and ETL performance in practical scenarios.

Learning Path

Learning StageTopicFocusGoalHelp DocumentsGuandata Academy
Getting StartedFundamentalsCore BI conceptsUnderstand key Guandata BI conceptsGuandata BI Concept Table/
Getting StartedFundamentalsProduct overviewUnderstand core modules and scenariosProduct IntroductionProduct Overview
Getting StartedData IntegrationLocal filesUpload files and create datasetsLocal Files/
Getting StartedData IntegrationOnline documentsConnect Feishu Sheets and similar online sourcesOnline DocumentsOnline Documents
Getting StartedData IntegrationStandard databasesConnect standard databases and extract dataStandard Database Connection GuideDatabases
Getting StartedData IntegrationDataset managementUpdate datasets, adjust structures, and inspect lineageDataset ManagementDataset Management
Getting StartedData PreparationWhat is Smart ETLUnderstand Smart ETL scenarios and modulesSmart ETL OverviewSmart ETL Definition and Features
Getting StartedData PreparationInput and outputUnderstand ETL data flow and configure Input Datasets and Output DatasetsInput Dataset, Output DatasetInput and Output Datasets
Getting StartedData PreparationField managementFilter, derive, and reconstruct fieldsAdd Calculated Column, Select Columns, Merge ColumnsAdd Calculated Column, Select Columns, Merge Columns
Getting StartedData PreparationRow processingClean and normalize data rowsFilter Data Rows, Deduplicate Data, Replace Values, Replace Null ValuesFilter Data Rows, Deduplicate Data, Replace Values and Replace Null Values
Getting StartedData PreparationData integrationCombine data from multiple tablesAppend Rows, Join DataAppend Rows, Join Data
Getting StartedData PreparationAggregation and reshapingAggregate and transform data structuresGroup Aggregate, Pivot Rows to Columns, Unpivot Columns to RowsGroup Aggregate, Pivot and Unpivot
Getting StartedData PreparationSQL InputUse custom SQL in ETL flowsSQL InputSQL Component
Getting StartedData PreparationETL maintenanceUnderstand refresh policies, governance, and permissionsETL Refresh Policy, Practical Approaches to ETL Governance, ETL Permission ManagementSmart ETL Save and Refresh, Smart ETL O&M Notes
Getting StartedVisualization BasicsBuild DashboardsCreate Dashboards and add componentsCreate Dashboard/
Getting StartedVisualization BasicsBuild chartsCreate common chart typesVisualization ChartsCharts, Tables
Getting StartedVisualization BasicsAdd filtersConfigure filters for analysisFiltersFilter Types
Getting StartedFunction BasicsFunction overviewLearn supported function categoriesFunction ListFunction Categories and Scenarios
Getting StartedFunction BasicsCommon ETL functionsLearn aggregate, date, string, and logical functions in ETLGuandata Function HandbookAggregation Functions, Date Functions
Getting StartedSharing and CollaborationSubscription and deliveryShare Cards, pages, and datasets through subscriptionsCard Subscription, Page Subscription, Merged Subscription, Dataset SubscriptionSubscription
Getting StartedSharing and CollaborationAlertsConfigure threshold-based alertsCard Alerts, Dataset AlertsAlerts
Getting StartedData Application ManagementData ScreenBuild big-screen pagesData ScreenData Screen
Getting StartedData Application ManagementMobile appsPublish Dashboards as mobile appsCreate Mobile AppMobile Light App
Getting StartedPracticeFirst analysis caseBuild an entry-level analysis reportFirst Analysis CaseHow to Quickly Create a Data Analysis Report
AdvancedAdvanced VisualizationDuPont AnalysisBuild complex metric systemsDuPont Analysis ChartDuPont Analysis
AdvancedAdvanced VisualizationGlobal ParametersControl multiple components from one parameterGlobal ParametersView Dataset
AdvancedChina-Style Report ProGetting startedUnderstand core concepts, scenarios, and key featuresChina-Style Reporting Pro Introduction, Usage FlowChina-Style Reporting Pro Intro and Starter Course