Object Storage Service (OSS) is a secure, cost-effective, and highly reliable object storage service that enables you to store, back up, and archive large amounts of data in the cloud. After data is stored in OSS, you can use Data Lake Analytics (DLA) to query and analyze data.

Quick BI is a next-generation business intelligence (BI) service platform. It is designed for users on the cloud. Quick BI allows you to analyze a large amount of data online in real time and perform drag-and-drop operations. It also provides abundant visualization features. You can present the results of data query and analysis in reports. This provides an easy method to analyze and explore business data and generate reports.

This example describes how to use OSS, DLA, and Quick BI to complete a data processing procedure. The procedure includes data storage, interactive data query and analysis, and BI report generation. This feature is suitable for scenarios where query and analysis of logs and transaction records and report generation are required.

Preparations

Before you perform a data processing procedure, make sure that you have made the following preparations.

Note OSS, DLA, and Quick BI must be deployed in the same region. In this topic, the three services are deployed in the China (Hangzhou) region.

OSS

  1. Activate OSS.

  2. Create buckets.

    Recommended directories in the bucket: workshop_sh/trade and workshop_sh/user

  3. Upload data.

    Download the test data and upload the transaction records and account registration information to the workshop_sh/trade and workshop_sh/user directories, respectively.

DLA

  1. Activate DLA.

  2. Manage DLA accounts.

Quick BI

Only Quick BI Pro and Quick BI Enterprise Standard can be added to DLA as data sources.