Level:
Role:
Beginner
University library database
Design a database for lending, returns and fines, and answer management's questions with SQL.
Steps- Draw the ERD in ERD Studio (student, book, copy, loan, fine)
- Generate the SQL and add 30 rows of sample data
- Write 8 queries: most-borrowed books, late students, total fines…
- Write a README explaining the design and queries
ERDSQLJOINGROUP BY
Beginner
Store sales analysis in Excel
Take a sales dataset (e.g. from Kaggle), clean it, build pivots and a dashboard, and make three recommendations.
Steps- Clean the data: spaces, duplicates, missing values
- Build 3 pivots answering clear questions
- Design a dashboard with 4 KPI cards and 3 charts
- Write a one-page “findings and recommendations”
ExcelPivot TablesKPIsData cleaning
Beginner
Requirements for a room-booking app
Interview 3 students or staff and turn it into a requirements document, user stories and a use case diagram.
Steps- Prepare and run the interviews
- Write the document in the SRS builder
- Add 8 user stories with acceptance criteria
- Draw the use case diagram and a BPMN process
ElicitationSRSUser storiesUMLBPMN
Beginner
A small-office network in Packet Tracer
Design an office network with two departments and a guest network, with subnetting, VLANs and simple firewall rules.
Steps- Plan addressing with the subnet calculator
- Build it in Cisco Packet Tracer (free)
- Isolate guests with a VLAN and test with ping
- Document the diagram and address table
SubnettingVLANPacket TracerDocumentation
Intermediate
A Power BI dashboard on open data
Pick an open government or public dataset, build a star model, DAX measures and a dashboard that tells a story.
Steps- Clean in Power Query
- Build a star schema with a date table
- Write at least 5 DAX measures
- One summary page and one detail page
Power BIDAXPower QueryStar schema
Intermediate
A Python script that builds a report
A script that reads a sales CSV, computes KPIs and outputs a text summary or Excel file, replacing a weekly manual task.
Steps- Read the file with pandas
- Compute totals by month and product
- Handle errors (missing file, odd values)
- Publish on GitHub with a write-up
PythonpandasAutomationGitHub
Intermediate
A complete mock company on Odoo
Set up a mock distributor on an Odoo trial: products, customers, vendors, full sales and purchase cycles, and reports.
Steps- Activate Sales, Purchase, Inventory and Accounting
- Create 10 products, customers and vendors
- Run full sales and purchase cycles with 15% VAT
- Take screenshots and write a short user guide
OdooO2CP2PUser guide
Intermediate
A security risk assessment for a small firm
Assess a small office (real or fictional): assets, threats, vulnerabilities, a risk matrix and a treatment plan.
Steps- Inventory key assets
- Identify threats and vulnerabilities per asset
- Build a likelihood × impact matrix
- Propose controls ranked by priority and cost
Risk assessmentCIAControlsReporting
Advanced
A café ordering system, idea to build
A complete graduation project: SRS, UML diagrams, database, a simple interface and a test plan.
Steps- Feasibility study and SRS
- ERD and database with report queries
- A simple UI (even a Figma prototype)
- Test plan and final presentation
SDLCSRSERDSQLTesting
Advanced
A small data warehouse with ETL
Combine two or three files, build an ETL in Python into a star-schema database, then a dashboard on top.
Steps- Design the star schema and grain
- Write the ETL in Python (extract, clean, load)
- Load into SQLite or PostgreSQL
- Connect Power BI or Looker Studio and present
ETLPythonStar schemaSQLBI
Advanced
An ERP implementation plan for a mid-size firm
A full plan for a fictional company: system selection, fit-gap, data migration, training, go-live strategy and cost.
Steps- Compare 3 systems on clear criteria
- A fit-gap table for 15 requirements
- Migration, go-live and risk plans
- A 5-year TCO and a management pitch
ERP selectionFit-gapMigrationTCO
Advanced
An access and segregation-of-duties audit
On sample user and role data, find segregation-of-duties conflicts and stale accounts, and write an audit report.
Steps- Prepare users, roles and permissions tables
- Write SQL to detect conflicts
- Rate findings by severity
- Write an audit report with recommendations
IT auditSoDSQLReporting