Illustration of an analyst at a desk with a dashboard of bar, line, donut and funnel charts, and two colleagues mapping a process flow on a whiteboard behind a glass wall
Courses / Business Analytics

Business analyst and BI courses online

Every Skill-Lync course for business analyst, BI analyst and MIS roles (requirements, Excel, Power BI, Tableau and SQL) with fees, hours, projects and which ones overlap.

8
courses
₹40,000
per course
12
weeks per course
2 to 24
hours of video

As of 21 Nov 2026 · Fees are the list price on each course page, inclusive of all charges

Skill-Lync teaches the business analyst and BI toolkit in 8 online courses of 12 weeks each: Business Analyst Fundamentals for Beginners, two Power BI courses (Business Intelligence using Power BI and Effective Dashboards using Power BI), data analysis and visualization courses in Excel and in Tableau, SQL for Data Science, and construction management versions of the Excel and Power BI courses. Here they all are with fees, hours and projects, which ones repeat each other, and which fits a business analyst, BI analyst or MIS job. For machine learning, see the data science courses.

Every Skill-Lync course that teaches Business Analytics

CourseLevelDurationProjectsFee
Business Analyst Fundamentals for BeginnersShort course12 weeks3₹40,000
Business Intelligence using Power BIShort course12 weeks2₹40,000
Data Analysis and Visualization using ExcelShort course12 weeks2₹40,000
Data Analysis and Visualization with TableauShort course12 weeks2₹40,000
Effective Dashboards using Power BIShort course12 weeks2₹40,000
Effective Dashboards using Power BI for Construction ManagementShort course12 weeks2₹40,000
Excel Skills and Data Analysis for Construction Project ManagementShort course12 weeks2₹40,000
SQL for Data ScienceShort course12 weeks2₹40,000

Projects is the number of industry projects listed on the course page. Programs also include the courses' smaller assignments. EMI figures are the lowest monthly plan shown on the course page.

Which one should you pick?

  1. You want a business analyst (requirements) role. Business Analyst Fundamentals for Beginners is the only course here on the requirements side, and it has 2 hours of video for ₹40,000. Treat it as an orientation: what the job is, agile vs waterfall, a BRD and an FSD, JIRA and flowcharts, with 3 short projects. Add SQL for Data Science (22 h) or the Excel course so you can pull and check numbers yourself.
  2. You want an MIS or reporting analyst job. Data Analysis and Visualization using Excel (24 h) runs from functions and pivot tables through Power Query and PowerPivot to macros, VBA and email automation, which is most of daily MIS work. Then SQL for Data Science (22 h), whose last two weeks connect MySQL to Excel and to Python.
  3. You want a BI analyst or Power BI developer role. Take Business Intelligence using Power BI (23 h): DAX over three weeks, Power Query and M, publishing and row-level security. Effective Dashboards using Power BI (7 h) covers the data model and DAX more briefly, with projects on supply-demand gaps and vaccination trends instead of cyber-security data. Buy one Power BI course, not two.
  4. Your target employers use Tableau. Data Analysis and Visualization with Tableau (24 h) goes from shelves and filters to joins, relationships, nested LOD expressions, maps and forecasting, with two public-data dashboards as projects. If you have not chosen yet, check which of Power BI or Tableau the job posts you want ask for; the skills transfer between them.
  5. You work in construction planning or project controls. Excel Skills and Data Analysis for Construction Project Management (19 h) is the Excel course cut to 10 weekly topics, with date functions such as NETWORKDAYS and labour S-curve and pivot-report projects. Its Power BI partner (7 h) has the same syllabus and projects as Effective Dashboards using Power BI. Both are inside the PG Program in Construction Project Management (₹2,75,000).

What is Business Analytics?

Business analytics is using data to answer business questions: which region is losing money, which feature to build next, why deliveries are late. Three jobs share the word and are easy to confuse. A business analyst works on requirements and process: talks to stakeholders, writes the business requirements document, draws the process flow and checks that what gets built is what was asked for. A data or business intelligence (BI) analyst pulls numbers with SQL and Excel and builds the dashboards managers read; MIS executive is the older Indian title for the reporting side. A BI developer builds and maintains the plumbing behind those dashboards: data models, DAX measures, refresh schedules and access rules. Job posts in India blur the three, so read the duties, not the title.

Every industry uses the same few tools on its own data. The projects in these courses show the range: sales of an automobile maker summarised with pivot tables, a loan applicants dashboard for a lender, user behaviour on a consumer-to-consumer e-commerce site queried in SQL, labour productivity on water supply projects plotted as S-curves for a construction planner, COVID-19 vaccination trends by country and age in Power BI, patterns in reported software vulnerabilities, and literacy rates across Tamil Nadu in Tableau.

SQL is where most of that work starts. Take a table of 4 customers (two in North, one in South, one in East) and 6 orders worth ₹5,500 in all, none of them from the East customer. The query SELECT c.region, COUNT(o.id), SUM(o.amount) FROM customers c LEFT JOIN orders o ON o.customer_id = c.id GROUP BY c.region returns North: 5 orders, ₹4,000; South: 1 order, ₹1,500; East: 0 orders and a revenue of NULL, not zero. Two small changes give wrong answers that look right. Write COUNT(*) instead of COUNT(o.id) and East shows 1 order, because the empty joined row is counted. Write JOIN instead of LEFT JOIN and East disappears: 2 rows, and a region with no sales silently drops off the report.

Dashboards have their own version of this trap. Three product lines sold ₹1,00,000 at ₹30,000 profit, ₹10,000 at ₹5,000 and ₹40,000 at ₹4,000: margins of 30%, 50%, 10%. Store margin as a calculated column (computed row by row) and the total row of a report shows either the average, 30%, or the sum, 90%. Both are wrong. The true margin is total profit over total sales, ₹39,000 ÷ ₹1,50,000 = 26%, which is what a Power BI measure such as DIVIDE(SUM(Profit), SUM(Sales)) returns, because a measure is evaluated for whatever rows the visual is showing. "Calculated columns vs measures" is a week-6 topic in Effective Dashboards using Power BI.

The requirements side has arithmetic too: prioritising what to build. RICE scores a feature as reach × impact × confidence ÷ effort, on Intercom's published scales (impact 3, 2, 1, 0.5 or 0.25; confidence 100%, 80% or 50%; effort in person-months). Assume four requests for a claims portal: bulk invoice upload (2,000 users a quarter, impact 1, 80% confidence, 2 person-months) scores 800; mobile photo capture (1,200, impact 2, 80%, 3) 640; WhatsApp status alerts (5,000, impact 0.5, 100%, 4) 625; a duplicate-claim check (600, impact 3, 50%, 1.5) 600. The feature with the biggest impact comes last, held down by low confidence. Run a pilot that lifts that confidence to 100% and it scores 1,200, first by a distance. The score is only as good as the estimates, and the useful work is arguing about those inputs with stakeholders.

What a Business Analytics course covers

  1. Business analysis basics. What a business analyst does and the key skills, waterfall and agile methods, gathering requirements from stakeholders and documents, the BRD, FSD and project plan, planning in JIRA, flowcharts in draw.io; then cloud service models, monolith vs microservices, REST and SOAP APIs with Postman, and chatbot (NLP) basics. Projects: a RACI matrix, a product concept, requirements gathering for a migration.
  2. Excel for analysis and MIS. Relative and absolute references, SUMIFS, COUNTIF and IFERROR, text functions, pivot tables and pivot charts, VLOOKUP, INDEX-MATCH and XLOOKUP, UNIQUE, FILTER and SORT, Power Query, PowerPivot data models and KPIs, what-if analysis, data validation, DSUM and SUBTOTAL, macros, VBA and email automation.
  3. Power BI. Query Editor transforms, merging and appending queries, the relational data model, cardinality and cross-filtering, DAX from calculated columns vs measures to CALCULATE, time intelligence, running totals and ranking, report visuals, slicers, drill-through, bookmarks and what-if parameters, the M language, publishing, row-level security and the Power BI Service.
  4. Tableau. Live and extract connections, shelves, marks and the analytics pane, dimensions and measures, filters and context filters, table calculations, parameters and action filters, stories, joins, blending, unions and relationships, set actions, nested LOD expressions, maps, trend lines, clustering and forecasting, and publishing.
  5. SQL. RDBMS basics, constraints and the ER model, creating and altering tables, SELECT with WHERE, wildcards and LIMIT, string and date functions, GROUP BY with aggregates, UNION and sub-queries, inner, left, right and self joins, NULLs and outliers in data exploration, indexes, views, transactions, CASE expressions, stored procedures and cursors, and MySQL from Excel and Python.

The courses in detail

Business Analyst Fundamentals for Beginners

Short course12 weeks2 h of video₹40,000

A 2-hour overview of the business analyst role: key skills, waterfall and agile, requirements gathering, the BRD, FSD and project plan, JIRA and flowcharts in draw.io, then cloud service models, software architecture, REST and SOAP APIs with Postman, and chatbot basics. Projects: a RACI matrix, a product concept, requirements for a migration.

Projects include: Plan task with RACI Matrix; Form a product concept as a Business Analyst; Requirements gathering for migration projects.

Business Intelligence using Power BI

Short course12 weeks23 h of video₹40,000

Power BI in 23 h: data sources and formatting, visuals, filters and calculated fields, DAX from basics to advanced, dashboards and reports, Power Query and M, publishing and sharing. Projects use cyber-security data.

Projects include: Analysis of Reported CVEs Pattern; Behavioral Analysis of Android Ransomware Attacks.

Tools: Power BI

Data Analysis and Visualization using Excel

Short course12 weeks24 h of video₹40,000

Excel for analysis: functions, formatting and templates, conditional and lookup functions, pivot tables, Power Query and PowerPivot, large data sets, macros, VBA and email automation.

Projects include: Data Cleaning and Transformation using Pivot Table and Charts; Report Creation using PowerQuery, Macro VBA, List functions, and Data Validation Functions.

Tools: MS Excel

Data Analysis and Visualization with Tableau

Short course12 weeks24 h of video₹40,000

Tableau from shelves and cards to dashboards: sorting, grouping, filters and table calculations, joins, blending and relationships, parameters and set actions, nested LODs and mapping, publishing.

Projects include: Developing a Dashboard on Tableau - Women in STEM Fields; Developing a Dashboard on Tableau - Literacy Rate in Tamilnadu.

Tools: Tableau

Effective Dashboards using Power BI

Short course12 weeks7 h of video₹40,000

A short (7 h) Power BI course: query editor transforms, the relational data model, DAX basics and advanced functions, and interactive reports. Projects on supply-demand gaps and COVID-19 vaccination trends.

Projects include: Supply and Demand Gap Analysis; COVID-19 Vaccinations Trend Analysis.

Tools: Power BI

Effective Dashboards using Power BI for Construction Management

Short course12 weeks7 h of video₹40,000

The same syllabus as Effective Dashboards using Power BI (7 h): Query Editor transforms, the relational data model, DAX basics and advanced functions, interactive reports and the Power BI Service. Same two projects (supply-demand gap, COVID-19 vaccination trends); nothing in the syllabus is construction-specific.

Projects include: Analysis of Supply and Demand Gap Using Power BI; Vaccinations Trend Analysis.

Tools: Power BI

Excel Skills and Data Analysis for Construction Project Management

Short course12 weeks19 h of video₹40,000

The Excel analysis course in 10 weekly topics (19 h): functions, formatting and date functions (NETWORKDAYS, EOMONTH), conditional and lookup functions, pivot tables, Power Query and PowerPivot, large data sets, data validation, list functions, macros and email automation. Projects: labour charts and S-curves for water supply projects, and a pivot-table report.

Projects include: Data Cleaning and Transformation Using Charts and S-Curves in Excel; Data Analysis Using Pivot Tables and Report Creation.

Tools: MS Excel

SQL for Data Science

Short course12 weeks22 h of video₹40,000

MySQL for analysis: creating and changing databases, SELECT queries, joins across tables, data exploration, indexes, views and transactions, stored procedures, and SQL from Excel and Python.

Projects include: C2C E-Commerce User’s Behaviour Analysis; Analyzing the choice of career for the Alumni of Engineering College..

Tools: MySQL, Python, Anaconda

Jobs after a Business Analytics course

Typical job titles: business analyst and associate business analyst (IT services, product and consulting firms), MIS executive or reporting analyst, data analyst, BI analyst, Power BI or Tableau developer, and planning or project controls engineer on the construction side. Employers are IT services and consulting firms, banks, fintechs and insurers, e-commerce and logistics companies, market research and analytics firms, and the MIS teams inside manufacturers.

From Skill-Lync's own placement records (as of 21 Nov 2026, 3,905 placements): 73 have an analyst, MIS or BI job title: 51 data analyst, 11 MIS, 8 business analyst or business analytics, 2 Power BI developer and 1 other analytics role. 68 report a salary: median 4 LPA, range 1.5 to 6.85 LPA, placed 2021 to 2025; 59 were freshers. Business analyst titles alone: n = 8, median 4 LPA (7 with a salary; two of the eight share an employer and a date and may be one learner); MIS titles: n = 11, median 3.8 LPA. Employers in these records include Flipkart, Ola Electric, Capgemini and eClerx.

Read those numbers with care. All 73 came from PG programs, 67 of them from the PG Program in Data Analytics and Data Science, which bundles four of these courses with Python, statistics and machine learning and whose pricing lists career services; none came from a short course on this page alone. They are learners who told us they were placed, so treat them as a starting point, not as today's market rate. More: data analyst salaries.

Free Business Analytics tutorials

Start here before you pay for anything. These are written by Skill-Lync learners and engineers:

Before you pay

Business Analyst Fundamentals has 2 hours of video. It is priced at ₹40,000 and listed as 12 weeks like the 24-hour courses, its syllabus has 7 weekly topics, and 4 of them are on cloud computing, software architecture, APIs and chatbots. It does not list user stories, use cases, process modelling notation or user acceptance testing. If you want a full business analysis course, this is not it.

The two Effective Dashboards courses are the same course. The construction management version has the same 11 weekly topics and the same two projects (supply-demand gap, COVID-19 vaccinations) as the general one, 7 hours each, with nothing construction-specific in the syllabus. Buy one.

The two Excel courses mostly repeat each other. The construction version (19 h) is the general course (24 h) in 10 weeks instead of 12: it drops the text functions and the VBA basics week, adds date functions (NETWORKDAYS, EOMONTH, EDATE) and uses construction labour data in a project. Do not buy both.

No certification exam is included. Microsoft's Power BI Data Analyst Associate needs exam PL-300: 100 minutes, a score of 700 to pass, four skill areas (prepare, model, visualise and analyse the data, manage and secure Power BI), renewed every 12 months by a free online assessment. Its April 2026 skills list includes Copilot, Direct Lake and calculation groups, which our Power BI syllabi do not. IIBA's ECBA needs no prior experience; its CBAP asks for 7,500 hours of business analysis work in the last 10 years and is a 120-question, 210-minute exam. The exam fees are separate and set by Microsoft and IIBA.

Everything about Database 2.0 is left out. It is a database course for developers (ER design, normalisation up to 5NF, MongoDB, Redis, PL/SQL, locking, replication and sharding) and sits in the full-stack programs. For analyst work, SQL for Data Science covers the queries. It is listed on the full stack web development courses page.

Programs already contain these courses. The PG Program in Data Analytics and Data Science (₹2,75,000) includes SQL, Excel, Tableau and Effective Dashboards using Power BI; it is on the data science courses page with the machine learning courses. The PG Program in Construction Project Management (₹2,75,000) includes both construction courses. If you buy a program, do not also buy its courses here.

Business Analytics course FAQs

What is the fee for a business analyst course at Skill-Lync?

As of 21 Nov 2026, each of the 8 courses on this page is ₹40,000, inclusive of all charges, and each is listed as 12 weeks online. Hours differ a lot: Business Analyst Fundamentals has 2 hours of video, while the Excel and Tableau courses have 24 hours each.

What is the difference between a business analyst and a data analyst?

A business analyst defines what should be built or changed: gathering requirements from stakeholders, mapping processes and writing requirement documents. A data analyst answers questions from data with SQL, Excel and dashboards. Many Indian job posts mix the two, and an analyst who can query data can apply for both kinds of role.

Do I need coding to become a business analyst?

Not programming in the software sense, but SQL helps a great deal. Requirements-focused analysts mostly write documents, process flows and user stories. Analyst roles that report numbers expect SQL queries, Excel formulas and a dashboard tool. Skill-Lync's SQL for Data Science course teaches MySQL queries, joins and aggregates over 12 weeks.

Should I learn Power BI or Tableau?

Learn the one your target employers ask for; both build interactive dashboards from the same ideas of data models, filters and calculated measures. Power BI is a Microsoft product that works closely with Excel. Skill-Lync's Business Intelligence using Power BI has 23 hours of video and the Tableau course 24.

Do these courses prepare me for PL-300 or IIBA certification?

They cover part of the ground but include no exam. Microsoft's PL-300 tests preparing, modelling, visualising and securing data in Power BI, including Copilot features the courses do not teach. IIBA's ECBA needs no experience; CBAP needs 7,500 hours of business analysis work. Exam fees are paid to Microsoft or IIBA.

What do business analyst interviews ask?

Expect three kinds of question: scenarios about gathering and prioritising requirements from conflicting stakeholders, documents such as a BRD or user stories, and, for data-facing roles, an SQL query or an Excel task such as a pivot table or lookup. Practise explaining a prioritisation method such as RICE or MoSCoW with numbers.

Get the syllabus and fee plans

Talk to a counsellor.

Tell us your branch and year. We will send the syllabus for the Business Analytics course that fits and explain the payment plans.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.

Talk to a career counsellor

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.