Hands-on exercise · EX 4.2 · Module 4
Analyse a dataset and write up your findings
You analyse a retail sales dataset by asking Julius AI questions in plain English, then turn the results into 3 insights, 2 charts and a short summary a shop manager could act on.
Time1.5 hours
ToolsJulius AI (free tier), Retail sales CSV (provided by your tutor), Google Docs or Word
Pass mark3 of 4 criteria
You hand inA short report with your list of prompts, 2 labelled charts, 3 insights with recommended actions, and a 150-word plain-language summary.
↓ Files for this exercise
Download these first. Fill them in on your computer or print them.
- DOCXData analysis report templateTurn AI data analysis into 3 insights, 2 charts and a plain-language summary for a manager.Download 119 KB
- DOCXModule 4 exercise workbookPrintable worksheets for every exercise in this module.Download 126 KB
Step by step
You will practise: explore and analyse a CSV file using natural-language prompts; identify the top 3 business insights and back them with numbers; create 2 suitable charts and write a 150-word plain-language summary.
1Load and explore the data15 min
2Ask focused questions30 min
3Create 2 charts20 min
4Write your insights and summary25 min
!Tips and safety
- No dataset from your tutor? Ask an AI tool to create a fictional retail sales CSV
- Never upload real customer data to a free tool without checking its terms
- If a chart needs a long explanation, choose a simpler chart
?Reflection questions (answer them when you submit)
- Which question gave you the most useful answer, and why?
- Did the AI get anything wrong or misread the data? How did you notice?
- How would a manager use your summary to make a decision?
- What would you do differently if the data contained personal information?
✓How your work is assessed
- At least 5 specific, well-phrased prompts are documented
- Two charts of the right type, each with a clear title and labels
- Three insights that name a number, a period and a recommended action
- A 150-word summary in plain language, with one result checked by hand
You pass with at least 3 of the 4 criteria met (60%). You can improve and resubmit at any time.
Submit your work
Please log in and enrol in this module to submit your work.
You are learning as a guest. Everything here is open to you. Create a free account to take the quizzes, save your progress and earn your module badges and the Re-AI certificate.