Data Studio (new version) tutorial

Tutorial overview

To refine business strategies, you can extract basic profile data—such as geographical and social attributes—from user website behavior, then run scheduled profile analyses for fine-grained traffic operations. DataWorks and EMR together cover the full pipeline: data synchronization, transformation, management, and consumption.

Data Studio

This tutorial requires the new Data Studio in DataWorks. To enable it:

• When you create a workspace, select Use Data Studio (New Version).

• To upgrade from an older version, click Upgrading at the top of the page.

• After February 18, 2025, the new Data Studio is enabled by default for accounts that create their first workspace in these regions:

  China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou), China (Ulanqab), China (Shenzhen), China (Chengdu), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), Indonesia (Jakarta), Thailand (Bangkok), Germany (Frankfurt), UK (London), US (Silicon Valley), US (Virginia)

Procedure

1. Prepare the environment

   Create the EMR cluster and DataWorks workspace required for this tutorial. Then, complete the network configurations for the resource group.

2. Data synchronization

   In DataWorks, configure a data synchronization task to synchronize user information and website log data to OSS. Then, use an EMR foreign table to parse the data in OSS, synchronize it to the attached EMR computing resource, and query the synchronized data.

3. Transform data

   Use an EMR Hive node in DataWorks to transform the data in the user information and access log tables that are synchronized to EMR. This process generates the target user profile data.

4. Monitor data quality

   Configure Data Quality monitoring rules for the tables generated from data transformation. This helps detect and block dirty data early and prevents its impact from spreading.

5. Manage data

   After the user profile analysis task flow is complete, the corresponding data tables are created in EMR. You can then view the data lineage between these tables in Data Map.

6. Consume data

   After the user persona analysis is complete, you can use the DataAnalysis module to create a data visualization of the processed data to quickly extract key information and gain insights into the business trends behind the data.