How to Excel at Data Analysis Using AI? | AI Office Essentials 02

Complete the Entire Data Analysis Process in Three Steps

When conducting data analysis, three things are most frustrating: data scattered across multiple spreadsheets, inconsistent values for the same metric across different files, and time-consuming, labor-intensive data cleaning.

This issue will demonstrate how to use Qwen Office to achieve a full data analysis workflow in just three steps: importing data from multiple sources, intelligent data cleaning, and structured analysis—ultimately delivering an interactive report, clean data tables, and standardized documentation.

01 Import Foundational Data from Multiple Sources

Data for business analysis is often scattered everywhere: sales details stored in Excel, payment records in CSV format, user growth and inventory each in separate tables.

Step one: simply drag all these files into the chat interface. Whether it's sales details, payment records, or inventory sheets, differences in formats don't matter—Qwen Office automatically parses them and applies unified processing based on your business context.

In addition to local files, data exported from DingTalk documents or internal systems can also be directly integrated. The storage location isn’t important—any readable data can be imported.

Prompt Template (copyable):

I've uploaded the [attachments]. Please first parse the [attachments], then perform a comprehensive data quality audit by checking: ① Metric inconsistencies (whether sales and payment metrics are comparable), ② Time granularity (whether monthly/weekly/daily/timestamps align), ③ Units and formats, ④ Duplicate records, ⑤ Other items requiring confirmation. For each item, clearly indicate: where the problem lies, which metrics are affected, and recommended actions. List them for my review—I’ll approve each one before any changes are made. Do not modify the data directly. After cleaning, generate a "Data Standardization Document" (including metric definitions, calculation methods, data sources, and reporting timestamps), then produce a Q3 business analysis report based on the cleaned data: total sales, product mix, channel distribution, trend insights—with each conclusion citing its data source.

02 Clean Data and Standardize Analytical Definitions

Before cleaning, allow the AI to thoroughly inspect the data to avoid misjudgments. Once data from multiple sources is merged, discrepancies become immediately apparent:

For example: sales figures are reported on a tax-inclusive basis, while payments reflect transactional cash flow—these two cannot be directly compared; inventory data represents point-in-time values (e.g., September 30), whereas sales cover a period (entire Q3), leading to mismatched time granularities; duplicate entries exist in detailed records, and unit formats are inconsistent.

At this stage, Qwen Office performs a full-scale data quality check covering metric consistency, time granularity, unit formats, and duplicate detection. Each identified issue includes its location, impact scope, and requires your confirmation before correction.

After cleaning, a "Data Standardization Document" is generated: clearly defining each metric’s definition, calculation method, data source, and reporting timestamp—creating a traceable, standardized reference. When others ask, “Where does this number come from?” you can simply share this document.

03 Generate Interactive Analytical Reports

Once data definitions are aligned and content is cleaned, analysis efficiency increases dramatically.

The "Q3 Business Analysis Report" generated by Qwen Office includes core insights such as total sales, product mix, channel distribution, and trend analysis. Every conclusion cites its data source, and clicking on it traces back to the original table.

If the report doesn’t meet expectations, you can continue asking follow-up questions—the system will conduct deeper analysis using the same dataset.

Finally, the report can be instantly published as a web link and shared with team members. No need to send files or manage versions—opening the link always shows the latest content.

04 Two Advanced Tips

Tip One: Long-term Memory Turns Analysis Workflows into Assets

The entire analysis process—from imported tables and defined metrics to report structure—can be saved by Qwen Office. Next quarter, simply replace the data and reuse the entire workflow without reconfiguration. Accumulated analytical logic becomes a long-term data asset for your team.

Tip Two: Scheduled Dashboards Turn One-time Analysis into Automated Monitoring

Set up the business analysis as a scheduled task: every week, the system automatically pulls the latest data, reruns the analysis, updates the dashboard, and sends alerts upon detecting anomalies. You no longer need weekly manual operations—just focus on the changes themselves.

That concludes all content of Issue 2 of the Essential AI Office Skills series. The next issue will continue unlocking more high-efficiency application scenarios with Qwen Office.

Stay tuned to the official "Qwen Office" WeChat account for real-time updates.

We dedicated to serving clients with professional DingTalk solutions. If you'd like to learn more about DingTalk platform applications, feel free to contact our online customer service or email at This email address is being protected from spambots. You need JavaScript enabled to view it.. With a skilled development and operations team and extensive market experience, we’re ready to deliver expert DingTalk services and solutions tailored to your needs!