Data Analytics Training in Nepal
Excel, SQL, Power BI, Tableau and Python for confident, data-driven decisions.
- 3 Months
- Mode: Online, Hybrid & Physical Live Classes
- Beginner
Learn directly from Rohan Aryal
AI IntegratedTotal fee
Rs. 10,000
Start with
Rs. 5,000
Course overview
Every organisation needs people who can turn data into clear answers. This Data Analytics program makes you confident with the tools analysts use every day: advanced Excel, SQL, Power BI, Tableau and Python.
You will clean messy data, build data models, write DAX, design interactive dashboards and present insights to decision makers. You will also learn to use AI copilots to speed up reporting. The course is practical from day one and ends with a portfolio of dashboards built on realistic business data.
What you will learn
- Use advanced Excel formulas, pivot tables and Power Query
- Write SQL queries to extract and summarise data
- Model data and write DAX measures in Power BI
- Design interactive dashboards in Power BI and Tableau
- Analyse data with Python and Pandas
- Present insights clearly to business stakeholders
Tools covered
Some of the major industry-relevant tools you will work with in this course:
- Excel
- Power Query
- Power BI
- DAX
- SQL
- MySQL
- Tableau
- Python
- Pandas
- Google Sheets
- Copilot
Curriculum
The complete syllabus for Data Analytics: every lesson, section and topic you will cover. Download it as a PDF to read offline or share it.
8 lessons · 23 sections · 64 topics
- What data analysts do
- Descriptive, diagnostic, predictive and prescriptive analytics
- Roles in a data team
- Types of data and data sources
- Data quality and common problems
- Asking the right business questions
- Excel, SQL, Power BI, Tableau and Python
- Setting up your analytics toolkit
- Cell references and named ranges
- Logical functions: IF, IFS, AND and OR
- Lookup functions: XLOOKUP, VLOOKUP, INDEX and MATCH
- Text and date functions
- Sorting, filtering and conditional formatting
- Pivot tables and pivot charts
- What-if analysis and Goal Seek
- Cleaning and combining data with Power Query
- Building an interactive Excel dashboard
- Slicers and timelines
- Tables, rows, keys and relationships
- Installing MySQL and using a SQL client
- SELECT, WHERE, ORDER BY and LIMIT
- Aggregation with GROUP BY and HAVING
- Joins across multiple tables
- Subqueries and CTEs
- Window functions
- CASE expressions and date functions
- Writing reporting queries
- Connecting to Excel, CSV and databases
- Transforming data with Power Query
- Star schema and relationships
- Calculated columns vs measures
- DAX essentials: SUM, CALCULATE and FILTER
- Time intelligence with DAX
- Visuals, slicers and drill-through
- Designing clear dashboards
- Publishing and sharing reports
- Row-level security basics
- Connecting data sources
- Dimensions, measures and marks
- Calculated fields
- Filters and parameters
- Maps and geographic analysis
- Dashboards and stories
- Publishing to Tableau Public
- Variables, lists and loops
- Functions
- Loading and exploring data
- Cleaning and transforming data
- Grouping and pivoting
- Charts with Matplotlib and Seaborn
- Automating Excel reports with Python
- Descriptive statistics for business
- KPIs and metrics
- Trends and simple forecasting
- Using Copilot and ChatGPT for analysis
- Writing formulas and SQL with AI
- Checking AI output for accuracy
- Data storytelling
- Presenting to managers and clients
- Working with a real business dataset
- Cleaning, modelling and analysis
- Executive dashboard
- Insight presentation
- Internship readiness evaluation
What you get
- Live instructor-led classes
- Recorded video of every session
- Hands-on projects and assignments
- 1:1 mentor support and doubt sessions
- Internship pathway after evaluation
- Verifiable completion certificate
- Learner community on Discord
- Career guidance and portfolio review
Fees & payment plan
3 Months program. Choose the class type that suits you. The curriculum, mentors, recordings and certificate are the same in every mode.
Online
Live, interactive classes over video, from anywhere in Nepal or abroad.
Rs. 10,000
Enroll online| Payment plan | Online | Hybrid | Physical |
|---|---|---|---|
First installment (50%) Payable at enrollment | Rs. 5,000 | Rs. 5,000 | Rs. 5,000 |
Second installment (50%) Payable when you are promoted to the internship | Rs. 5,000 | Rs. 5,000 | Rs. 5,000 |
| Total | Rs. 10,000 | Rs. 10,000 | Rs. 10,000 |
Your mentor
Rohan Aryal
Mentor
Rohan mentors Leafclutch Academy's AI and data programs, guiding learners from their first lines of Python to building agents, generative AI applications, machine learning models and analytics dashboards, with a strong focus on hands-on projects.
Who can join
- Basic computer and Excel familiarity
- No programming experience required
Career opportunities
- Data Analyst
- Business Analyst
- BI Analyst
- MIS Executive
- Reporting Analyst
Earn a high-value industry certificate
Complete Data Analytics and receive a certificate from Leafclutch Academy. Add it to your LinkedIn profile, resume or CV to stand out to recruiters. Every certificate carries a unique code that employers can check online.
Already earned a certificate? Verify it here
Related courses
Learners who viewed Data Analytics also showed interest in these courses.
Frequently asked questions
Do I need programming skills?
No. The course starts with Excel and SQL. Python is introduced gently later in the course.
Which is taught: Power BI or Tableau?
Both. Power BI is covered in more depth because it is the most requested tool in Nepal's job market.
Is this course good for people already working?
Yes. Many learners are accountants, bankers and administrators who want to automate reports and move into analytics roles.
Start Data Analytics this month
Talk to our counsellors for free. We will help you choose the right course, mode and batch.