Business Analytics: Excel, SQL & Power BI
Turn raw data into decisions managers act on.
- 4 weeks
- Fresher, any background
- Live online
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 policyHow 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
Starts Jan–Feb 2027