Viie Edu · Phase 2 · Build with AI · Lesson 12

Build a business analytics workbook that you can really use.

What you need to do today: turn the promotional data into a well-formulated workbook, a separate analysis section and a brief overview for management.

25 to 30 minutes. Has CSV and workbook frameI have a job to do.✅ Start: workbook analysis

1. The original data

2. The formula

3. Analysis of the situation

4. Look at the management

YOUR TASK

1. A good file doesn't start with a graph

You have data on eight promotions. Which programs actually add value after the cost of communication?

What should you do first?

The following table shows the results of the tests:

2. Download data and workbook frame

📄

promotion-data.csv

Original data from eight promotions.

📊

promotion-workbook-starter.xlsx

Table 4 sheet: Original data → Calculation → Analysis → The look of management.

Download the workbook

The original data should be kept private and not edited silently. Any changes, cleaning or computation should take place in another part of the workbook.

The second step is to:

Logic key before AI fills the file

Production growth
(Production when promoted / Background production) - 1

The margin increases after the media
Margin when promoting - Background margin - Communication costs

ROI is promoted
Margin increases after media / Media costs

Which ROI is best suited to the goal of the post?

The FIGS are not

Fourth, pass on the AI part with clear rules.

Use this CSV file and workbook frame. Requests: - Keep the sheet Du_lieu_goc intact. - All calculation indicators must use a formula, not input the results. - Characteristics: production growth, sales growth, margin increase, margin increase after media and promotion ROI. - If the background value is 0, do not automatically increase %. - Do not delete programs with negative ROI. - Sheet Phan_tich synthesized by promotion type. - Sheet Goc_nhin_quan_ly only keeps the most noteworthy indicators and programs. Before completing the file, stop and list the main formulas for me to check.

You're here.

The data stayed the same. The formula was locked. Now AI can do the repetitive part: fill the formula, synthesize it and format it. You just have to keep the test score before you get to the conclusion.

How to Get Started

Don't rank by sales growth alone.

A program can:

Production is on the rise.
Sales are up
But the margin behind the audio media

What management needs to know:

Does growth add value?
How much does it cost to buy growth?
What kind of promotion gives more stable results?

Choose up to three notable programs. For each program, write down: - output growth; - sales growth; - margin increase after media; - ROI; - why it's notable; - questions that need further testing.

4 - The whole world

6. What should the final sheet help the steward to see?

The scale
How many shows are rated?

Added value
What's the total margin increase after the media?

Points to Consider
What program is productive but not marginal?

The management sheet is not the place to keep all the numbers. It's the place to let the reader know. What's important and what's next for you to decide?.

The Red Cross

7. Check the workbook before using

The original data sheet retains the source data.

The calculation indicators use formulas, not hard drives.

The negative ROI is still retained and clearly displayed.

Sheet management doesn't just rank by sales growth.

Can be traced from the index in the management section on the spreadsheet and the source data.

Write down the two most important management points from the workbook.

✓

You've completed Lesson 12.

You've built a workbook with raw data, formulas, analytics and management perspectives instead of just using AI to create an Excel file.

One sentence to carry: AI can build files very quickly, but the computational logic and management questions that the files have to answer still need you to lock them first.