Build Real Skills. With Real Data.
Download a dataset, read the brief, and solve a real business problem from scratch. No guided walkthroughs — just you, the data, and what you know how to do.
1
Project available now
5
Skills practiced
Free
No sign-up required
Excel Projects
E-Commerce Sales Analysis
Used as the capstone project in Verken's Excel for Professionals cohorts. Now available to everyone.
The Scenario
You have just been hired as a Data Analyst at Verken Superstore. Your manager has handed you two messy CSV files and needs clean, reliable reports for the CEO and an investor presentation — by end of week.
Instructions arrive via internal company emails from different stakeholders. Requirements evolve. Data has quality issues. That's the job.
Project Phases
Clean up the mess
Import both CSV files using Power Query. The dates aren't consistent, there are duplicates, and some values look wrong. Fix it before anything else.
Pull meaning out of the SKU column
Every SKU encodes a style and size — but they're all in one field. Use text functions to split them into separate columns you can actually filter by.
Connect the two files
The sales data has no prices. The product file does. Use XLOOKUP to bring category and unit price into every row so you can calculate revenue.
Give the CEO his numbers — no PivotTables
He doesn't trust them. Build the summary sheet using SUMIFS and COUNTIFS only, formatted well enough to hand to someone who will print it out.
Make it interactive for the investors
Plans changed. Now it needs to be a live dashboard they can click through during a presentation. PivotTables, charts, slicers — the full thing.
Skills Practised
What's Included
- Project brief delivered as internal company emails
- Sales data CSV — 500+ transactions with intentional quality issues
- Product info CSV — 26 SKUs with categories and pricing
Read the brief first. Everything you need — including the data files — is on that page.
Read the BriefMore Projects Coming
SQL and Power BI Next
Projects for the rest of the Data Analyst Path are in progress. Add your email below if you want to be notified.
Retail Database Analysis
Query a relational database of customer orders and product inventory to answer business questions from the ops team.
Sales Performance Dashboard
Connect to a multi-table data model and build an executive dashboard with drill-through, bookmarks, and dynamic titles.
Get notified when the next project drops.
No spam. Just a message when something new is ready.
Ready to Go Further?
Projects show you what you know. The course fills the gaps.
Excel for Professionals covers every skill in this project — and 90 more hours of real workplace scenarios, from scratch.