Data Analytics Course in Sri Lanka
Turn Raw Data Into Decisions — and Into a Career
Ceylon Open Campus offers a structured data analytics course in Sri Lanka covering Excel, SQL, Power BI, and Python fundamentals. Learn to collect, clean, analyse, and visualise data for business decisions — skills now in demand across every major industry in Sri Lanka and globally.
Why Data Analytics Is One of the Most Valuable Skills in Sri Lanka Today
Sri Lanka's economy is digitising at pace. Commercial banks, insurance companies, telecommunications providers, the garment export industry, and a growing cohort of tech startups all generate vast volumes of data — and they lack enough skilled professionals to make sense of it. A data analyst bridges the gap between raw operational data and strategic decisions made by management.
The Eastern Province is no exception. As Kattankudy and the broader Ampara and Batticaloa districts attract investment in small manufacturing, services, and digital commerce, local employers increasingly need staff who can produce accurate reports, track performance metrics, and identify trends. Completing a data analytics course positions you ahead of most candidates in local job markets and opens the door to remote and international opportunities.
At Ceylon Open Campus, the data analytics program is built around hands-on lab sessions using real datasets. You will not just learn theory — you will produce pivot tables, write SQL queries against live databases, build interactive Power BI dashboards, and handle messy data using Python. Every module ends with a practical assignment graded against industry criteria.
Course Modules: What You Will Learn
Data Foundations and Spreadsheet Mastery
Data types, cleaning techniques, validation, and advanced Excel functions including XLOOKUP, INDEX/MATCH, and array formulas for large-scale datasets.
SQL and Database Querying
Writing SELECT, JOIN, GROUP BY, and subquery statements in MySQL; creating and managing tables; extracting structured reports from relational databases.
Power BI Dashboards and Reports
Connecting Power BI to Excel, SQL, and cloud sources; building interactive visuals; writing DAX measures; designing dashboards for business stakeholders.
Python for Data Analysis
Introduction to Python programming, using pandas for data manipulation, matplotlib for charting, and automating repetitive data tasks with scripts.
Statistics for Business Decisions
Descriptive statistics, distributions, correlation, regression basics, and hypothesis testing applied to Sri Lankan business scenarios.
Data Storytelling and Communication
Structuring analysis reports, presenting findings to non-technical audiences, and designing visualisations that drive clear business action.
Programs, Duration, and Fees
| Program | Duration | Fee (LKR) | Mode |
|---|---|---|---|
| Certificate in Data Analytics | 6 months | 85,000 | Full-time / Part-time |
| Diploma in Data Analytics and Business Intelligence | 12 months | 155,000 | Full-time / Part-time |
Career Outcomes and Salary Ranges in Sri Lanka
Data analytics graduates enter roles across multiple industries. The table below shows realistic monthly salary ranges based on current Sri Lankan market conditions. Senior roles and freelance positions with international clients attract substantially higher earnings.
| Role | Entry (LKR/month) | Experienced (LKR/month) |
|---|---|---|
| Data Analyst (Banking / Finance) | 65,000 – 95,000 | 130,000 – 220,000 |
| Business Intelligence Analyst | 70,000 – 100,000 | 150,000 – 250,000 |
| Reporting Analyst (Telecoms / Insurance) | 55,000 – 85,000 | 110,000 – 180,000 |
| Data Officer (Government / NGO) | 50,000 – 75,000 | 90,000 – 140,000 |
| Freelance Data Analyst (International) | 150,000+ | 300,000 – 500,000+ |
Entry Requirements and How to Apply
The Certificate in Data Analytics requires five O/L passes including Mathematics. The Diploma requires five O/L passes and two A/L passes (or a completed certificate in IT or business). Mature entry is available for working professionals who can demonstrate relevant experience. Both programs welcome students from non-IT backgrounds — accountants, marketing professionals, and school-leavers with strong numeracy regularly succeed in the course.
Enrolment is open throughout the year. Contact the admissions team at Ceylon Open Campus to confirm the next intake date, obtain a prospectus, and complete your application. The process involves submitting your academic certificates and a short enrolment form — no entrance examination is required for the certificate program.
Why Study Data Analytics at Ceylon Open Campus?
Ceylon Open Campus is one of the few institutions in the Eastern Province offering a practical, tool-focused data analytics curriculum. Our instructors are working professionals with industry experience in finance, IT, and business intelligence. Lab sessions are capped to ensure individual attention, and every student leaves with a portfolio of real projects including a completed Power BI dashboard and a SQL-based reporting exercise.
We also provide career guidance, CV preparation, and connections to employers in the region. Students who combine the data analytics diploma with broader IT skills — available through our other technology programs — are especially competitive in the job market.
Frequently Asked Questions
Do I need a programming background to join the data analytics course?
No prior programming experience is required. The course starts from foundational spreadsheet skills and progresses through SQL querying and basic Python for data manipulation. Students with no coding background complete the program successfully by following the structured curriculum and practising in the lab sessions.
What tools and software does the data analytics course cover?
The curriculum covers Microsoft Excel (advanced functions and pivot tables), SQL with MySQL, Microsoft Power BI for dashboard creation, and an introduction to Python using pandas for data wrangling. Students also learn Google Sheets for cloud-based collaboration, which is increasingly expected in local and remote roles.
What are the entry requirements for the data analytics course at Ceylon Open Campus?
The Certificate in Data Analytics requires five O/L passes including Mathematics. The Diploma requires five O/L passes plus two A/L passes or a completed IT or business certificate. Mature students who are working professionals with at least two years of office or data-related experience may apply under the mature entry pathway with supporting documentation.
How much can a data analyst earn in Sri Lanka?
Entry-level data analyst positions in Sri Lanka typically pay LKR 55,000–90,000 per month. Analysts with two or more years of experience working with BI tools and SQL earn LKR 100,000–180,000. Senior analysts and data leads in the banking, telecommunications, and tech sectors can earn LKR 200,000–350,000 per month. Freelance data analysts serving international clients through platforms like Upwork frequently earn the equivalent of LKR 250,000–500,000 per month.
How long does the data analytics course take and what does it cost?
The Certificate in Data Analytics is a six-month program priced at LKR 85,000. The twelve-month Diploma in Data Analytics and Business Intelligence costs LKR 155,000. Both programs are available in full-time and part-time formats. Monthly installment plans are available to make fees manageable for working students.
Is data analytics a good career choice in Sri Lanka right now?
Yes. Sri Lankan businesses in banking, insurance, telecommunications, e-commerce, and the export sector are investing heavily in data-driven decision-making. The Central Bank, commercial banks, and major conglomerates regularly advertise for data analysts and business intelligence professionals. The combination of local demand and strong international freelance potential makes data analytics one of the most financially rewarding tech skills to acquire in 2025.
Enrol in the Data Analytics Course Today
Contact Ceylon Open Campus to check upcoming intake dates and secure your place in the next cohort.
Phone
075 922 0083
coc.ceylon@gmail.com
Campus
Kattankudy, Sri Lanka