Applied AI-Powered Business Tools

Build a Business Analytics Dashboard

Last reviewed

Beginner

What you'll learn

~35 min
  • Ask an AI tool, in plan mode, for a dashboard page that shows a year of sales by region and quarter from a CSV file (a spreadsheet saved as plain text)
  • Read its plan for what the totals will count: every order read, including rows typed in another format, and nothing filled in where a number is missing
  • Check the dashboard's totals against figures on this page, and confirm your sales file is unchanged
  • Decide what a blank in the data counts as, with whoever owns the records, before any total goes to anyone

The story, and what you will end up with

It is Monday 5 January 2026, and you are an analyst intern on the sales team of a small office-supply distributor with four regional offices: North, South, East and West. The sales manager wants 2025 sales by region and by quarter on one page for Thursday’s planning meeting. Sales operations has exported the year’s 50 orders into one file.

The export is not tidy. The West office keeps its orders in a spreadsheet of its own, and its rows came across as they were typed there: amounts with dollar signs and commas, dates written month first. And two orders have a cost but no revenue.

By the end of this lesson you will have a dashboard page that opens in your browser and shows the year’s headline figures (KPIs) and its totals by region and quarter, with charts and a table, from that file. You build it by asking your AI tool in plain English, and you check it against figures on this page. Then you decide what the two orders with no revenue should count as.

🔍Words used in this lessonclick to expand
  • CSV (comma-separated values): a spreadsheet saved as plain text, one row per line, with commas between the columns. Excel and Google Sheets open it.
  • KPI (key performance indicator): a figure that shows how something is doing, such as revenue or profit margin. A dashboard puts a few of them at the top of the page.
  • Calendar quarter: Q1 is January to March, Q2 April to June, Q3 July to September, Q4 October to December. Some companies count quarters from a different month; this one counts the calendar year.

Before you start

First, if your AI tool is still open, leave it: type /exit and press Enter (if you use Antigravity, press Ctrl+D with nothing typed instead), and wait until you see the $ or % prompt. The next line goes there, in the terminal, not in the AI tool. It makes a new folder for this lesson inside your course folder, next to the practice folder from setup, and goes into it:

Terminal window
mkdir -p ~/mis-workbench/01-sales-dashboard && cd ~/mis-workbench/01-sales-dashboard

Start your AI tool with the start line you kept from the setup lesson, the one with approval prompts off. Then ask it to set the folder up:

Set this folder up so we can undo any change you make, download https://learn.intellimetrics.net/starters/mis/01/sales-2025.csv into a data folder, and save a checkpoint.

Look for it saying three things: the folder is set up with Git (the program that saves snapshots, from setup), the file is saved as data/sales-2025.csv, and a first snapshot, your checkpoint, is saved. Later you can ask whether the file has changed since then. If it does not mention one of them, ask: “Did you save a checkpoint with the file in it?” If the download does not work, download sales-2025.csv in your browser, check where it went (the browser’s list of downloads shows the folder), and tell your AI tool, for example: “sales-2025.csv is in my Downloads folder. Copy that one file into a data folder here, and save a checkpoint.” In Windows PowerShell or a desktop app, “my Downloads folder” works as is; only say “my Windows Downloads folder” if you use Ubuntu (WSL) on Windows, which keeps its own Downloads folder apart from Windows.

The company, its offices and every order in the file are made up for this course. No real company’s figures are in it, and none should go into this folder.

Open this box once, because it says what the codes used further down stand for.

ℹWhat is in sales-2025.csvclick to expand

A spreadsheet file (it opens in Excel) with one row for each of the 50 orders of 2025. Each order has a code, SO-1001 to SO-1050, in date order. The columns are Order, Date, Region, Product, Units_Sold, Revenue, Cost and Profit. The five products are copy paper by the case, toner cartridges, office chairs, standing desks and label printers, each at one price all year.

RegionOrdersHow its rows are written
North13Dates as 2025-05-13, amounts as 1113.00
South13The same
East12The same
West12Dates as 01/19/2025 (month first), amounts as “$3,174.00”, with a dollar sign and a comma

Two orders have a cost but no revenue and no profit:

OrderDateRegionProductUnitsCost
SO-101613 May 2025NorthStanding desk3$1,113.00
SO-104810 December 2025EastCopy paper, case238$7,497.00

Every other order’s profit is its revenue minus its cost.

Switch to plan mode

Your AI tool is already open. Switch to plan mode now: Shift+Tab until it says plan, or /plan (the keys for each tool). In plan mode it usually reads your file, asks its questions and shows you a plan before it builds anything; the order can vary.

The conversation

Each message below is an example. Say it your own way.

Say what you want

Say what you are doing, which file to use, and what you want from it:

I'm putting together 2025 sales by region and quarter for our sales manager. Help me build a dashboard page that reads data/sales-2025.csv and shows the totals and charts. Ask me what you need first.

Your AI tool usually reads the file and comes back with questions. It may also point out what it noticed: the West rows written differently, and the two orders with no revenue. It may offer to fill those two in at each product’s usual price. The price is right there in the file, so the offer looks safe. But a December order with no revenue may simply not be invoiced yet, and a May one may be a free replacement or a typing slip. The file cannot tell you which; the order records can.

Answer its questions

Answer each in a sentence. These are questions the tools often ask, with one way to answer each. Yours may ask them in a different order or show a list of choices:

If it asksYou might say
Two orders have no revenue. Fill them in from the price, leave them out, or count them as zero?Leave them out of revenue and profit, and list them on the page. I’ll ask the sales manager about them.
Keep those two orders’ cost in the totals, or leave it out too?Leave it out, and show their cost separately beside the profit.
Which figures: revenue only, or also cost, profit, units and the number of orders?Revenue, cost, profit and units.
Calendar quarters, or a fiscal year (a company’s own twelve-month accounting year, which can start in any month)?Calendar quarters.
A page on your computer, or one hosted online and shared?A page on my computer that shows this file when it opens.
Which charts, and anything beyond the totals?Revenue by region and revenue by quarter, so the manager sees which region leads and how the year moved.
Any company colours or branding?Clean and neutral.

If it asks several questions at once, answer the one about the two orders yourself, in a sentence, and for the rest say that its suggestions are fine. If it asks something not listed here, answer it the same way, in a sentence. If it does not ask about the two orders at all, the plan is where you bring them up.

Say “nothing hosted or shared online” even if it does not ask, because a company’s sales figures do not belong online.

Read the plan

Next it usually shows you a plan: what it will build and how it will check it. Read it for five things:

  1. Every order is read, West included. Amounts with a dollar sign and a comma are read as numbers, and none of the West rows is dropped or counted as zero. The West dates are read the right way round, and the page says which reading it used. You can tell from the values: a number above 12 can only be a day, and every West date has one in the middle (01/19/2025), so they are month first. Where no value in a column is above 12, the data cannot tell you, and someone who knows the export has to say.
  2. Totals by region and by calendar quarter, so Q1 is January to March, and the page names the file it read and the period its orders cover.
  3. Nothing is filled in. The two orders with no revenue are handled the way you said, and the page says how many orders its totals use and names the ones it left out.
  4. Your sales file is read and left as it is. Any cleaning happens inside the dashboard, not in the file.
  5. The figures stay on your computer. The page reads the file in your browser and sends it nowhere.

A first plan often leaves one of these out, most often the two orders, or your file. Say so in a sentence, in your own words, for example:

Don't change my sales file. Do any cleaning inside the dashboard.

When the plan has all five, approve it: if your AI tool offers a choice to go ahead, pick it; otherwise say “Yes, go ahead and build it.” In Codex, press Shift+Tab first to leave plan mode. In Copilot, saying it brings up a choice to go ahead; pick that. Let it build. It may check its own figures as it goes. When it has finished, ask it: “Did you install anything, and where?” Nothing, or something inside this lesson’s folder, is fine for these lessons. If it names anywhere else on your computer, ask it what that is for, and to remove it if you do not want it there.

Look at what it built

Ask it to open the page:

Open the dashboard in my browser.

Your AI tool may open the page straight from its file, or start a small program on this computer that shows the page at a local address, one ending in a number, such as http://127.0.0.1:8000/ (127.0.0.1 means this computer); either is fine. If it gives you an address or a file’s location without opening it, copy it into your browser’s address bar and press Enter. If it says the address is already in use, say: “Something else is using that address. Don’t stop it. Use a different address for my page.” If it started a program for the page, leave it running while you look; when you are done, ask your AI tool to stop it. If your AI tool does not take a message after opening the page, wait a minute. If it still does not, close the terminal window, open a new one, type this lesson’s folder line again, start your tool, and say: “Start the page again so it keeps running while we talk.” The page and your saved work are files in the folder, so nothing is lost.

If the page asks you to choose a file, choose sales-2025.csv in this lesson’s data folder. If you cannot find that folder in the window that opens, say: “I can’t find the data folder from the browser. Make the page show data/sales-2025.csv when it opens.”

Your dashboard will be laid out in its own way. Check it for these:

  • The page says its totals use 48 of the 50 orders in the file, and names the two it left out: SO-1016 (North, 13 May) and SO-1048 (East, 10 December).
  • The page names the file it read and the period it covers, 16 January to 22 December 2025, taken from the order dates in the file, not from today’s date.
  • Total revenue is $175,036.00.
  • Beside the profit, a note says whether it includes the cost of the two orders left out, for example: “excludes two orders with no revenue recorded; their cost of $8,610.00 is not in this profit”.
  • Revenue by region: West $54,354.00, North $41,506.00, South $39,741.00, East $39,435.00. West comes first. If West shows nothing, or far less, the page has not read the West amounts.
  • Revenue by quarter: Q1 $42,288.00, Q2 $38,721.00, Q3 $41,013.00, Q4 $53,014.00.
  • When you ask “Has my sales file changed since the checkpoint?”, your AI tool compares it with the checkpoint and says no.

The note matters because the two orders’ cost, $8,610.00, was really spent. Left out, profit is $52,554.50 on a cost of $122,481.50, a margin of 30.0%; kept in, it is $43,944.50 on a cost of $131,091.50, a margin of 25.1%. Until someone who owns the records says why those two have no revenue, neither figure is complete without the note. Which figure your page shows is a decision for you and the sales manager; whichever it is, the note sits beside the number. If there is no note, tell your AI tool: “Next to the profit, say whether it includes the cost of the two orders left out, and show that cost.”

If something on the list is not true, tell your AI tool in a sentence what you see and what you expected, for example: “West shows no revenue, but its rows have amounts like $3,174.00. Read amounts with dollar signs and commas as numbers.” Fix the dashboard, not the file: the next export from the West office will be written the same way.

Notice what one blank can do

Now see what filling the two in would have done:

Make a copy of the sales file in this folder. In the copy only, fill in the two missing revenues and profits at each product's usual price. Then tell me how the region and quarter totals change.

Your AI tool may list the new totals without saying what they do to the order of the regions. Before you read on: on your dashboard, which region came last?

East did, at $39,435.00. In the copy, the December order adds 238 cases at $42, $9,996.00, to East’s fourth quarter, and East moves from last to second, at $49,431.00, ahead of North and South. The May order adds $1,587.00 to North. Total revenue rises to $186,619.00. One filled-in blank decides where a region ranks, and the sales manager would plan Thursday around that ranking.

Your dashboard can find the orders with no revenue and name them; whether a blank counts as zero, as an estimate or as unknown until someone checks is a decision for you and whoever owns the records, and the page should say which.

Counting a blank as zero is a decision too: it records SO-1048’s 238 cases as bringing in nothing, and it pulls the average order down. The file shows only that no revenue was recorded; why is for someone who owns the records to say. So the step before this page goes to the sales manager is yours: ask about SO-1016 and SO-1048, and keep the page as it is until you have the answer. When you have looked, remove the copy: “Delete that copy; I’m done with it.”

One real run

Here is part of what one AI tool said after the experiment above, with Claude Code on 11 November 2026. Yours will word it differently; check your dashboard against the list above, not against this.

**What this means for the story:**
- **Region ranking:** East jumps from **last to second**. The order goes
from West, North, South, East to **West, East, North, South**.
- **Quarters:** Q4 rises from $53,014 to **$63,010**, so the year-end peak
is much sharper. Q2 rises from $38,721 to $40,308 but is still the
lowest quarter.
So the East copy-paper order decides where East ranks. That's worth
settling with the sales manager before the dashboard is shared.

The orders and figures in this output are the made-up ones from the practice file.

How real sales data differs

A real export raises the same questions, and more, and the answers are in your company’s systems and with the people who run them, not in the file:

  • What “revenue” means in the export. An order system may hold orders booked, orders invoiced, or both, and they differ for any order not yet billed. Ask sales operations which one the column is before you total it.
  • Which year and which quarters. Some companies count a fiscal year that does not start in January. The sales manager’s quarters are the ones your page should use.
  • Returns and credits. A real export may carry them as separate rows with negative amounts, or not at all. Ask how they appear before you decide what a total includes.
ℹMIS Connection: two of the three steps of ETL

Your dashboard does two of the three steps of ETL (extract, transform, load). Reading the file is extract. Turning “$3,174.00” into a number, reading the West dates the right way round and setting aside the orders with no revenue is transform. Load means writing the cleaned rows into the database or data warehouse table where they are kept and queried from. This dashboard has no load step: it keeps nothing, and cleans the file again each time it opens.

Keep going

Small changes do not need plan mode. Say each in a sentence, then look at the page again:

  1. “Add revenue by product, with the same totals.” The products are in the file already.
  2. “Let me download the region-by-quarter table as a CSV.” The sales manager can then paste it into a slide.
  3. Try your dashboard on a public CSV, such as the Superstore sample on Kaggle or one from data.gov. Download it in your browser, tell your AI tool its name and that it is in your Downloads folder, and ask it to copy that one file into the data folder here. Then load it in the page; if the page has no way to load another file, ask your AI tool to add one. If its columns have other names, tell your AI tool which ones hold the date, the region and the amount.
  4. “Save a checkpoint.” Your AI tool saves a snapshot you can return to.

When you want to use the dashboard on your company’s or your course’s real sales files, use the finished page. It runs on your real files by itself, with your AI tool closed, so your AI tool never sees them. Do these steps in order; the first three happen now, while your AI tool is open and this folder still holds only the practice file:

  1. Go through the data check, the questions in setup about what the data is, who decides how it is used, and which AI tool would see it. Company figures are your employer’s or your instructor’s to decide on. Go on only if they allow this use.

  2. Decide on a folder of its own for your real sales files, outside this course folder, for example ~/sales-reports. Nothing has to be in it yet. Ask your AI tool for the exact line that starts the page and the address it opens at, for example: “Write me the exact line to start this dashboard myself, and its address, so I can load a sales file from ~/sales-reports.” Use your own folder’s name, written out in full from your home folder as above. If it offers to copy your real file into this folder instead, say no.

  3. Copy the line and the address it gives you into a note. They will look something like these, though yours may differ:

    Terminal window
    python3 ~/mis-workbench/01-sales-dashboard/dashboard.py

    and the address http://127.0.0.1:8000/. Read the line left to right: python3 starts Python, which runs the program; next comes the program your AI tool wrote to show the page, in this lesson’s folder. ~ means your home folder; your line may write it out in full instead. The address is where the page appears in your browser while that program runs. If your page opens straight from its file, you may get the file’s location instead of a line; write that down. Write down too how the page loads another file. If you are unsure about any part, ask your AI tool now, while it is still open.

  4. Ask your AI tool to stop anything it started for the page, then leave it the way you did at the start of this lesson.

  5. Put your real file in that folder. At the $ or % prompt, type this lesson’s folder line again, then paste the line from your note and press Enter. Open the address in your browser and load your real file the way your note says.

Try another case

Before the quiz, write two or three sentences for yourself. A student club’s treasurer gives you a year of event sales and asks for average ticket revenue per event. Of 20 events, 3 have attendance recorded but no revenue. What does your dashboard show, and what do you ask the treasurer before you report an average?

A good answer sees that the average changes with the choice: leaving the three out divides by 17, counting them as zero divides by 20 and pulls the average down. It names the three events on the page, and it asks the treasurer whether they were free events, unrecorded sales or missing paperwork before reporting either figure.

Key takeaways

  • Ask briefly, and let your AI tool ask back. Say what you are doing, which file to use and what you want from it; its questions fill in the rest.
  • Read the plan for what the totals will count: every row read in whatever format it came, and nothing filled in for you.
  • Check the totals against figures you can verify, region by region and quarter by quarter; a region missing from a total is the error that looks like a result.
  • A blank is your decision, not your AI tool’s. The page names what it left out until whoever owns the records answers.
  • Practice data stays practice data: real figures go to the finished dashboard, with your AI tool closed, after the data check.

Portfolio suggestion

Keep the dashboard in a folder of its own, with a screenshot of it showing the practice data or a public dataset, never a company’s figures. In a few sentences beside it, say what the page does, how you checked its totals, and how it handles a blank. The blank is the part that shows you checked what the totals count, not only that they add up.

KNOWLEDGE CHECK

Your dashboard shows 2025 revenue from 48 of 50 orders. Two orders, one in North and one in East, have a cost but no revenue. Your AI tool offers to fill them in at each product's usual price. What do you do?

What’s next

In the next lesson you build a Database Schema Designer, which turns plain-English descriptions of a business’s records into an entity-relationship diagram, the SQL that creates the tables, and sample data.

intellimetrics · Arlington, VA
© 2026 intellimetrics.net
Search lessons