Business/Statistics Degree + Excel/Power BI to Data Analyst
Path to Data Analyst / BI Specialist · Information Technology
Duration
3.0–5.0 yrs
Upvotes
72
Est. Cost
LKR 300k+
Score
66
About This Path
A business-focused path to data analytics: use a commerce or statistics degree, master Excel, SQL, and Power BI, and transition into a data analyst role in the banking, finance, or telecoms sector.
Path Overview
Step-by-Step Detail
- 1Education
A/L — Commerce or Maths Stream
Commerce stream (Accounting, Business Studies, Economics) or Physical Science (Maths) both provide strong analytical foundations for data work.
⏱ 2 years - 2Education
BSc Statistics, Business Management, or Finance
Study quantitative methods, statistics, economics, and business processes. SQL and Excel are often covered in Business IT modules.
⏱ 3.5 years₨ LKR 0University of Colombo (Statistics/Business)University of Sri JayewardenepuraSLIITNSBM - 3Skills
Advanced Excel & SQL
Master Excel pivot tables, VLOOKUP, Power Query. Learn SQL for database queries. These are the two most-required data analyst tools in Sri Lankan job ads.
⏱ 3 months₨ LKR 10,000 – LKR 40,000 - 4Skills
Power BI / Tableau Dashboards
Build interactive dashboards using Power BI (Microsoft) or Tableau. Create 3 portfolio dashboards from public datasets.
⏱ 3 months₨ LKR 15,000 – LKR 50,000 - 5Experience
Finance / Operations Analyst Internship
Work in a business analyst, finance analyst, or operations role. Apply data skills to real business problems. Build an analytics portfolio.
⏱ 6 monthsBanks (HNB, Sampath, BOC)Insurance companiesTelecoms (Dialog, SLT)Retail chains - 6Experience
Data Analyst / BI Analyst
Join a data team in banking, finance, telecoms, or IT. Entry salary LKR 90,000–150,000/month with SQL + Power BI skills.
Commercial BankHNBDialog AxiataJohn KeellsLOLCCargills