Analyst
Junior Analyst
Project
Meridian Retail Co. · Excel · beginner
The brief
You have been sent the Meridian_Data.xlsx file. Before doing any analysis, take 10 minutes to familiarise yourself with what is in it. How many sheets are there? What columns does the Orders sheet have? What are the distinct order statuses? And what data quality issues can you spot just from browsing?
Document your findings in a new sheet called Data Audit. Flag at least 3 issues.
Independent grading
92/100
Achieved 31 Oct 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more