Data Science & Analytics Internship Online

Free demo task

Find a useful insight in a tiny sales table

20 minutes | Free | No login needed

Analyse this fictional three-day café dataset using paper, a spreadsheet or Python. Monday: 20 cups at ₹50 each. Tuesday: 30 cups at ₹50 each. Wednesday: 25 cups at ₹50 each. Find the total revenue and explain one observation.

• Create a table with Day, Cups sold, Price per cup, and Revenue columns.
• Calculate daily revenue as cups sold multiplied by price per cup.
• Add all three daily revenues and identify the day with the highest sales.
• Write one observation and one limitation. Do not assume three days prove a long-term trend.

Sample answer

Monday: 20 × ₹50 = ₹1,000 Tuesday: 30 × ₹50 = ₹1,500 Wednesday: 25 × ₹50 = ₹1,250 Total: 75 cups and ₹3,750 revenue. Observation: Tuesday had the highest sales in this small dataset. Limitation: Only three days are shown. We need more dates and context before making decisions about staffing or demand.

This practice does not include a certificate or mentor review.