If you want a junior data analyst portfolio Riyadh that gets attention, build projects that mirror real hiring tests. Focus on data cleaning, simple dashboards, and a short case study that shows how your work changed a decision. Employers in Riyadh often give take-home tests or short in-person tasks that look like the examples below.
Start with the right project types
Keep each project short and clear. Employers in Riyadh want to see results fast. Do 3–5 projects, each with a one-page summary and a link to code or a dashboard.
- Data cleaning and validation: Show a messy dataset and your steps to fix it. Explain rules you used and list assumptions.
- Exploratory data analysis (EDA): Use charts to find trends and outliers. Add one paragraph that says how a business could act on your findings.
- Simple forecasting or trend report: Use a basic time-series method and explain the limits. Employers want logical thinking, not perfect models.
- Interactive dashboard: Build a small dashboard that answers 3 business questions. Use Power BI, Tableau, or a web notebook with charts.
- Mini case study: Take one problem from start to finish — data, method, result, and business recommendation.
Sample tasks employers use in Riyadh
Use these as templates for projects you add to your data analyst portfolio Riyadh. Each task mirrors common hiring tests.
Task 1 — Sales data clean-up and summary
Dataset: 6 months of sales with missing prices and wrong dates. Your job: fix date formats, remove duplicates, and impute missing prices. Deliverables: cleaned CSV, 1-page notes, and 3 charts that show top products, revenue by region, and a weekly trend.
Task 2 — Customer churn EDA
Dataset: customer accounts, transactions, and support tickets. Your job: find signals that link to churn. Deliverables: a short report with 5 charts and one feature you think predicts churn. Explain how a call centre could use your finding.
Task 3 — Dashboard for store managers
Dataset: daily sales by store. Your job: build an interactive dashboard with filters for date and store. Deliverables: a published Power BI or Tableau dashboard and a 200-word guide that tells a manager how to use it.
Task 4 — Quick forecasting task
Dataset: daily demand for a product. Your job: create a 4-week demand forecast and a confidence band. Deliverables: forecast chart, short explanation of method, and a note on risks (holidays, promotions).
How to present each project
Use a clean folder for each project. Include these items so a recruiter can check your work fast.
- One-page summary with the business question and outcome.
- Code or notebook link (GitHub or GitLab). Keep scripts tidy and commented.
- Screenshots or a public link for dashboards.
- A short note on assumptions and limitations.
Tools and file types to show
Show tools that Riyadh employers ask for. List the files so hiring managers can run your work.
- Excel or CSV for raw and cleaned data.
- Jupyter notebook or Python scripts for analysis.
- Power BI or Tableau for dashboards.
- SQL query files or saved queries.
Where to link your portfolio and one smart trick
Host code on GitHub. Host dashboards on Power BI Public or Tableau Public when possible. Put a single README at the top that lists each project and the main file to open first. This saves the recruiter time.
Skills employers look for in Riyadh and nearby cities
Below are common skills recruiters test. We compare Riyadh with a few nearby job markets so you know what to emphasise.
Riyadh (Saudi Arabia)
Employers expect SQL, Excel, and one visualization tool like Power BI. They like clear business writing and quick EDA. Public sector and finance firms may test data privacy and basic reporting skills.
Jeddah (Saudi Arabia)
Similar to Riyadh but more demand in retail and logistics. Show retail metrics and time-series work. Demonstrate how analytics helps operations.
Dubai and Abu Dhabi (United Arab Emirates)
These cities often ask for cloud basics and dashboarding. You may see small technical tests plus a case study. If you plan to apply across the Gulf, add one cloud or API example to your portfolio.
To browse roles, consider checking open information technology jobs in Riyadh. This helps you match projects to real job ads. You can also review information technology jobs in Dubai and information technology jobs in Jeddah for differences in tests. For UAE hiring patterns, see information technology jobs in Abu Dhabi.
Certifications and short courses that help
- Microsoft Certified: Data Analyst Associate (Power BI) — shows dashboard skills.
- Google Data Analytics Professional Certificate — good for fundamentals and projects.
- Tableau Desktop Specialist — useful if you build Tableau dashboards.
Realistic salary expectations (estimate)
Junior data analyst pay in Riyadh varies by industry and firm size. Typical entry monthly pay is often between SAR 4,000 and SAR 10,000, depending on benefits and experience. Use this only as a rough guide. Check current job ads and confirm with recruiters.
How employers grade these projects
Recruiters usually look for clear steps and repeatability. They score work on:
- Data handling and cleaning (30%).
- Correct use of SQL or code (20%).
- Clarity of charts and dashboards (20%).
- Business insight and recommendation (20%).
- Documentation and reproducibility (10%).
Related jobs you can move into
- Data engineer — works on pipelines and data storage.
- BI developer — builds dashboards and reporting systems.
- Database administrator — manages databases and access.
- QA analyst — tests data flows and reports.
- Business analyst — translates data into business requirements.
Final checklist before you submit
- Three to five polished projects. One line summary for each.
- Public links to code or dashboards. Or attach a zipped folder.
- Short README that tells a reviewer where to start.
- One file that recreates the main result in 5 minutes or less.
Next steps
Pick one of the sample tasks above. Finish it with clear notes and a demo. Then add it to your portfolio and apply to local roles. For live openings, check information technology roles in Riyadh to match your projects to job tests.
Frequently Asked Questions
What should be in a junior data analyst portfolio for Riyadh employers?
Include 3–5 short projects: a data-cleaning task, one EDA, a short forecasting example, an interactive dashboard, and a mini case study. Each project needs a one-page summary, code link, and a note on assumptions.
How many projects does a junior data analyst need to get hired in Riyadh?
Aim for three to five solid projects. Quality is more important than quantity. Make sure each project shows a clear result and a short business recommendation.
Which tools do Riyadh employers test for junior data analysts?
Commonly tested tools are SQL, Excel, Power BI or Tableau, and Python for basic scripts. Employers also value clean notebooks and reproducible code.
Can I use GitHub for my portfolio in Riyadh?
Yes. Host your code on GitHub and include clear READMEs. Add links to dashboards or screenshots. Recruiters like folders they can scan in a few minutes.
Do Riyadh companies prefer certifications for junior data analysts?
Certifications help but are not enough on their own. Useful ones are Microsoft Certified: Data Analyst (Power BI), Google Data Analytics, or Tableau Desktop Specialist. Pair them with real projects.