Skip to content
OrionStats
Log inStart learning
Data Analytics Academy · Professional Certification

Learn to think with data.
Then prove you can.

OrionStats teaches data analytics from first principles — SQL, spreadsheets, Power BI, Tableau, Python, statistics and business analytics — through detailed lessons and realistic projects. Separately, three independent certifications test whether you can do the work.

Start learning — freeExplore certification
published lessons
47
practice questions
250
project briefs
34
rows of practice data
526k
Educational philosophy

Understanding first. Tools second. Decisions always.

Most courses teach buttons. Analysts are paid for judgement: knowing which number answers the question, whether it can be trusted, and what the business should do about it.

Every OrionStats lesson follows the same progression — understand → see it worked → apply → practise → evaluate → professional application → examination — and every SQL example in a lesson is executed against real practice databases, so the results you read are the results you will get.

A · OrionStats Academy

Learn from absolute beginner to professional

  • Structured pathway: course → module → subject → chapter → lesson
  • Write and run real SQL against six relational practice databases
  • Exercises with explanations, lesson quizzes, module exams
  • Progress, bookmarks, weak-area detection and recommendations
Browse the Academy
B · Professional Certification

Independent assessment of real capability

  • Published blueprints, rubrics and passing rules
  • Written exam with minimum scores in every domain
  • Practical cases graded by OrionStats examiners
  • Public verification with unique ID and QR code
See the certifications
Three separate achievements

Each level is a different job, not a longer exam

I

Data Analyst Associate

Junior analyst who can retrieve data with SQL, clean it, calculate correct KPIs, build a basic dashboard and explain the result.

Practical: Retail performance pack
II

Data Analyst Professional

Independent analyst who takes an unfamiliar requirement through cohorts, segmentation, statistics and an executive dashboard to costed recommendations.

Practical: Telecom retention case
III

Data Analytics Expert

End-to-end problem solver: feature engineering, XGBoost and time-series forecasting without leakage, a working Streamlit app — and a live technical defense.

Practical: Demand forecasting & decision app
Curriculum

Fifteen modules, one pathway

Full syllabus and coverage
  1. 01Data Analytics Foundations
  2. 02SQL
  3. 03Excel and Google Sheets
  4. 04Power BI and Power BI Service
  5. 05Tableau
  6. 06Python for Data Analytics
  7. 07Statistics and Mathematics
  8. 08Business Analytics
  9. 09Financial Analytics
  10. 10Marketing, Sales and HR Analytics
  11. 11Predictive Analytics and Machine Learning
  12. 12Business Logic and Decision-Making
  13. 13Advanced Application Development
  14. 14Automation and Productivity
  15. 15Professional Skills, Agile and Documentation
Learning pathway

How a beginner becomes certifiable

  1. 1
    Foundations

    Analytical thinking, data, requirements (M1)

  2. 2
    Core tools

    SQL, spreadsheets, statistics (M2, M3, M7)

  3. 3
    Business analytics & BI

    KPIs, segmentation, dashboards (M4, M5, M8–M10)

  4. 4
    Advanced

    Python, ML, forecasting, apps (M6, M11–M14)

  5. 5
    Prove it

    Projects, mock exams, certification

Practical project laboratory

Work that looks like the job

beginner
Plan–Fact Analysis for Orion Retail Stores
SQL · Excel
intermediate
Lead Generation and Lead Behaviour
SQL · Power BI or Tableau
intermediate
ABC/XYZ Inventory Classification
SQL · Excel · Python (optional)
intermediate
RFM Customer Segmentation
SQL · Python or Excel
intermediate
Linear Prediction of Monthly Revenue
Excel · Python
intermediate
Profit and Loss Analysis
Excel · SQL
All projects
Examination system

Questions that make you do the analysis

You write SQL that is executed and compared with the correct result. You calculate, interpret and recommend. Exams are generated from a growing question bank with controlled topic and difficulty mix, timed, autosaved and scored on the server.

Questions

Do I need any experience?+

No. Module 1 assumes no prior knowledge, and every lesson lists what you should know first. SQL and Python start from zero.

Does finishing the Academy give me a certificate?+

No. Certification is independent: you must pass the official written examination and an examiner-graded practical assessment for each level. Learning and certification are deliberately separate so that certificates mean something.

Which tools do I need?+

A browser is enough for SQL practice — every practice database runs inside OrionStats. For BI work you choose Power BI Desktop (free, Windows) or Tableau Public (free); for Python, a free local install or a notebook service.

Is OrionStats accredited?+

OrionStats certificates are independent professional credentials. They are not accredited by a government or third-party accreditation body, and we do not claim otherwise. What we publish instead is exactly how candidates are assessed: blueprints, rubrics and passing rules.

Will a certificate get me a job?+

No credential can promise that. A certificate shows employers verified evidence of specific skills — the decision to hire is theirs. Your portfolio of projects matters as much.

How do employers check a certificate?+

Every certificate has a unique ID and QR code linking to a public verification page that shows the holder's verified name, level, issue date and current status.

Start with Module 1. It's free.

Create an account to save progress, run SQL in the browser and track your readiness for certification.

Create free accountLog in