Skip to content
Bussinly
All bootcamps
Data

Business Analytics: Excel, SQL & Power BI

Turn raw data into decisions managers act on.

  • 4 weeks
  • Fresher, any background
  • Live online
Enrol now
Business Analytics
From ৳3,000was ৳6,00050% off

Starts Jan–Feb 2027

Taught by:
Industry data analyst
Track:
Data
Next cohort:
Jan–Feb 2027

Who it's for

BBA, economics, CSE and other graduates aiming for Business Analyst, Data Analyst, MIS or Reporting Executive roles.

What you'll learn

  • Asking the right business question
  • Advanced Excel: pivots, lookups, Power Query
  • SQL basics: SELECT, filtering with WHERE, sorting
  • SQL aggregation: GROUP BY, HAVING, COUNT, SUM, AVG
  • SQL joins: INNER, LEFT and combining tables
  • SQL window functions: ranking, running totals, ROW_NUMBER
  • Data cleaning in SQL and Power Query: duplicates, nulls, formats
  • Power BI dashboards
  • KPIs and basic statistics
  • Data storytelling
  • AI-assisted analysis

Week-by-week curriculum

1Week 1Business questions and advanced Excel

Live sessions

  • Turning a vague ask into a clear question
  • Pivots, XLOOKUP and conditional logic
  • Power Query basics

Assignment

Answer three business questions from a sales workbook

2Week 2SQL: filtering, sorting and aggregation

Live sessions

  • SELECT, WHERE, AND/OR, IN, LIKE
  • ORDER BY, LIMIT and CASE WHEN
  • COUNT, SUM, AVG with GROUP BY and HAVING

Assignment

Queries on an orders table, ending with monthly sales totals

3Week 3SQL: joins, window functions and data cleaning

Live sessions

  • INNER and LEFT JOIN across multiple tables
  • ROW_NUMBER, RANK, running totals and CTEs (WITH)
  • Cleaning data: duplicates, NULLs, text and date formats

Assignment

Clean and join a messy dataset, then rank top customers per month

4Week 4Power BI, storytelling and job prep

Live sessions

  • Power BI: data modelling, basic DAX and KPIs
  • Data storytelling and AI-assisted analysis
  • Analytics interview and SQL test practice

Assignment

Capstone dashboard presented to a mock management panel

Capstone project

Clean and analyse a realistic dataset (for example, e-commerce sales) and present a Power BI dashboard with three recommendations to a mock management panel.

What you leave with

  • A published dashboard
  • An SQL portfolio
  • An analytics-specific mock interview

How every bootcamp works

  • Live on Zoom or Google Meet: two evening sessions a week plus one weekend lab

  • Class materials, assignments and your capstone are on the Bussinly app

  • Small cohorts of 25–40 students, with a dedicated TA for doubt-clearing (WhatsApp or Discord group)

  • Real portfolio project in every course, plus mock interviews

  • Bussinly certificate when you finish

Taught by

Industry experts

Experienced engineers and analysts from Bussinly's delivery network. Every course follows the same Bussinly curriculum and job-readiness standard.

Project & delivery lead

PMP-certified Scrum Master with 13+ years in IT delivery at leading Bangladeshi tech companies; manages a large distributed team today.

Questions

Are classes live or recorded?

Classes are live, not recorded. Class materials and assignments are on the Bussinly app, so you can revise or catch up if you miss a session.

When are classes?

Two weekday evening sessions plus one weekend lab each week.

How do I get the certificate?

Attend at least 80% of sessions, submit all assignments and present your capstone. The top 3 students in each cohort get a 1:1 mentorship session and a LinkedIn recommendation.

Is this an official PMI or Scrum certification?

No. Course content is aligned with industry standards, but the certificate is issued by Bussinly.

How do I pay?

Send the full course fee via bKash Send Money to 01955747864, then submit the enrolment form with your Transaction ID.

What if I need a refund?

You get a full refund if you ask more than 3 days before your cohort starts, and 70% up to the end of week 1. After week 1 there's no refund, but you can move to the next cohort once.

Read the refund policy
How big are the cohorts?

25–40 students, with a TA in every cohort.

Do I need a coding background?

Only for Flutter. Vibe Coding is designed for non-coders.

Ready to start?

Business Analytics: Excel, SQL & Power BI

Enrol now
From ৳3,000was ৳6,00050% off

Starts Jan–Feb 2027

Enrol now