Enrolling Now — Limited Seats Beginner to Intermediate

Become an AI-Powered Data Analyst in 18 Weeks

>_Training Bangladesh’s next Data Analysts

No coding background required. Learn Excel, SQL, Power BI and AI on real, messy business data with live mentors — and graduate with a portfolio of dashboards and analyses that gets you hired, locally or remotely.

BDT 2,990

Batch 1

Regular BDT 4,990 Save BDT 2,000

AI Powered Data Analytics Bootcamp

  • 2 days a week: Sunday & Tuesday
  • Time: 8 PM to 10 PM
Enroll in Batch 1

Batch starts:


In this course you get:

  • 18 learning modules
  • 36 live classes
  • 18 weeks of structured learning
  • 72 live learning hours
  • Weekly graded assignments and 3 module projects
  • Final capstone and completion certificate

3,500+

Students Trained

94%

Course Success Rate

800+

Career Placements

14

Countries with Alumni

Free Masterclass

Become an AI-Driven Data Analyst in 2027: Your Complete Career Roadmap

Monday, November 30

9:00 PM – 11:00 PM (Bangladesh Time)

Live on Zoom · 2 hours incl. Q&A

Starts in

00

Days

00

Hrs

00

Min

00

Sec
Course Curriculum

6 Tracks. 18 Modules. 36 Live Classes.

Two live classes per module, one clear skill per module. A job-mapped curriculum built around the four things every analyst job description in Bangladesh asks for — Excel, SQL, Power BI and now AI — with AI woven into every module instead of boxed into one.

Track 1 · 2 modules · 4 live classes

Analytics Foundations

Class 1: What a Data Analyst Actually Does

Class 2: Data Types, Structure & Data Quality

What You'll Cover

  • The analyst workflow from business question to decision, and how the role differs from data scientist and BI developer
  • Job market reality in Bangladesh, remote roles and realistic salary bands
  • Full tool setup: Excel, Google Sheets, PostgreSQL, Power BI and AI accounts
  • Structured vs unstructured data, granularity, keys and writing a data dictionary
  • The seven data quality problems that quietly destroy a report

Class 3: Descriptive Statistics for Business

Class 4: Framing a Business Question & Designing Metrics

What You'll Cover

  • Mean, median, spread, outliers and the situations where the average lies
  • Growth rates, ratios, CAGR and index numbers done correctly
  • Turning a vague manager request into a written, answerable analysis plan
  • Metric definition, dimensions, baselines and success criteria
  • Correlation vs causation, survivorship bias and sampling traps

Track 2 · 3 modules · 6 live classes

Excel & Google Sheets Mastery

Class 5: Excel Core and the Keyboard-First Workflow

Class 6: Cleaning Messy Data in Excel

What You'll Cover

  • Tables, structured references, named ranges and error-proof workbook design
  • Conditional formatting, data validation and controlled inputs
  • Text, date and number functions: TRIM, SUBSTITUTE, TEXTSPLIT, TEXTJOIN
  • Fixing imported date chaos, duplicates, blanks and inconsistent categories
  • Flash Fill, Text to Columns and knowing when to stop cleaning by hand

Class 7: Lookup and Logic

Class 8: Dynamic Arrays and Modern Formulas

What You'll Cover

  • XLOOKUP, INDEX-MATCH and the legacy VLOOKUP files you inherit at work
  • IF, IFS, SUMIFS, COUNTIFS, AVERAGEIFS and multi-condition logic
  • FILTER, SORT, UNIQUE, SEQUENCE and how spill ranges behave
  • LET and LAMBDA for reusable, readable formula logic
  • Systematic debugging with Evaluate Formula, IFERROR and precedent tracing

Class 9: Pivot Tables and the Excel Dashboard

Class 10: Google Sheets, Collaboration & Live Data

What You'll Cover

  • Pivot design, grouping, calculated fields, slicers and timelines
  • One-page dashboard layout, KPI cards and commentary that updates with the filter
  • QUERY, IMPORTRANGE and ARRAYFORMULA for SQL-style work inside a sheet
  • Google Form to Sheet to dashboard: a complete free pipeline
  • Sharing, protected ranges, version history and collaborative review

Track 3 · 2 modules · 4 live classes

Automation & AI in the Spreadsheet

Class 11: Power Query I — Import and Shape

Class 12: Power Query II — Combine and Automate

What You'll Cover

  • Importing from files, folders, web pages and databases
  • Applied steps, data types, splitting, extracting, replacing and filling
  • Append, merge, unpivot, group by and custom columns
  • Parameters, reusable functions and folder-based automation
  • Building a refreshable pipeline that survives a bad source file

Class 13: AI Inside the Spreadsheet

Class 14: Project Studio — The Automated Reporting Pack

What You'll Cover

  • Generating, explaining and correcting formulas with ChatGPT and Claude
  • Claude in Excel, Copilot and Gemini in Sheets for cleaning and modelling
  • AI-assisted categorisation, anomaly detection and auto-written summaries
  • Verification discipline: never ship a number you have not checked yourself
  • Project 1: raw files to a one-click refreshable reporting pack, peer reviewed

Track 4 · 4 modules · 8 live classes

SQL for Analysts

Class 15: Databases and Your First Queries

Class 16: Filtering, Sorting and Conditional Logic

What You'll Cover

  • How relational databases store business data; keys, relationships and ERDs
  • PostgreSQL setup with pgAdmin or DBeaver and the practice database
  • SELECT, FROM, WHERE, aliases and a query formatting standard you will keep
  • IN, BETWEEN, LIKE, NULL handling, ORDER BY and LIMIT
  • CASE statements for banding, flags and encoded business rules

Class 17: Aggregation and Business Summaries

Class 18: JOINs Across Multiple Tables

What You'll Cover

  • COUNT, SUM, AVG, distinct counting, GROUP BY and HAVING vs WHERE
  • Date truncation and grouping by day, week, month, quarter and fiscal year
  • INNER, LEFT, RIGHT and FULL joins explained visually, then practically
  • The join mistakes that silently inflate revenue, and how to catch them
  • Reconciling every aggregate back to the source total before you report it

Class 19: Subqueries, CTEs and Query Structure

Class 20: Window Functions and Analytical SQL

What You'll Cover

  • Subqueries, when to avoid them, and refactoring into readable CTE chains
  • UNION, INTERSECT, EXCEPT and set-based thinking
  • OVER, PARTITION BY, ROW_NUMBER, RANK and reliable deduplication patterns
  • LAG, LEAD, running totals and moving averages
  • Cohort, retention and month-over-month growth analysis in pure SQL

Class 21: Writing, Debugging and Optimising SQL with AI

Class 22: Project Studio — SQL Business Case Study

What You'll Cover

  • Prompting AI to write correct SQL against your actual schema, not a guessed one
  • Explaining, refactoring and optimising an inherited query nobody wants to touch
  • Indexes, logical execution order and reading a query plan
  • Verifying AI-generated SQL before you trust any number that comes out of it
  • Project 2: a multi-part business case answered across five joined tables

Track 5 · 4 modules · 8 live classes

Visualisation & Business Intelligence

Class 23: Visualisation Principles

Class 24: Power BI — Data Model and Star Schema

What You'll Cover

  • Choosing the right chart for the question actually being asked
  • Misleading charts: truncated axes, dual axes, 3D and clutter
  • Power BI Desktop tour and Power Query inside Power BI
  • Star schema: fact and dimension tables, and why flat files eventually fail
  • Relationships, cardinality, filter direction and a proper date table

Class 25: DAX Fundamentals

Class 26: Time Intelligence and Advanced DAX

What You'll Cover

  • Measures vs calculated columns and when each one is correct
  • Row context, filter context and a mental model that actually holds up
  • CALCULATE, ALL, ALLSELECTED, FILTER and context transition
  • Year-to-date, previous period, year-on-year growth and variance to target
  • Variables, ranking, dynamic titles and what-if parameters

Class 27: Interactive Reports, Publishing and Security

Class 28: Looker Studio, GA4 and Marketing Analytics

What You'll Cover

  • Bookmarks, drill-through, tooltips and cross-highlighting
  • Page navigation, mobile layout and a consistent design system
  • Publishing to the service, workspaces, scheduled refresh and row-level security
  • Connecting Google Sheets, Analytics and Ads in Looker Studio
  • GA4 basics: sessions, events, conversions and the reality of attribution

Class 29: Dashboard Design for Decision Makers

Class 30: Project Studio — Executive Dashboard

What You'll Cover

  • One question per screen and the five-second rule
  • KPI selection, targets, variance and avoiding vanity metrics
  • Layout, hierarchy, whitespace and consistent formatting across pages
  • Running a stakeholder feedback session and iterating without starting over
  • Project 3: a modelled, secured and published executive dashboard

Track 6 · 3 modules · 6 live classes

AI-Assisted Analysis & Career Launch

Class 31: AI for Exploratory Data Analysis

Class 32: Prompt Engineering and AI Workflows

What You'll Cover

  • Uploading datasets to Claude and ChatGPT for a fast first-pass exploration
  • Getting hypotheses, segments, correlations and anomalies suggested automatically
  • Where AI is confidently wrong, and the checks that catch it every time
  • Prompt structure that works: context, data, task, format and constraints
  • Chaining prompts into a repeatable weekly reporting workflow

Class 33: AI-Assisted Python for Analysts

Class 34: Forecasting and Trend Analysis

What You'll Cover

  • Notebooks, pandas basics and reading a script AI wrote for you
  • Automating a task Excel genuinely cannot handle, then scheduling it
  • Moving averages, seasonality and trend decomposition explained simply
  • Forecasting in Excel and Power BI, with confidence intervals read correctly
  • Driver analysis, scenario modelling and when not to forecast at all

Class 35: Data Storytelling, Portfolio and Interview Preparation

Class 36: Capstone Presentation and Certification

What You'll Cover

  • Finding, evidence, implication, recommendation — the structure managers respond to
  • Writing an executive summary a busy manager will actually read
  • Portfolio publishing on GitHub, Notion or a personal site
  • Analyst interviews: live SQL rounds, case rounds and take-home test strategy
  • Capstone: raw data to dashboard to recommendation, presented and defended

Want the complete class-by-class syllabus as a PDF?

Mohammad Samiul Islam, Principal engineer (Data, BI & AI Automation) at Brain Station 23 and instructor of the AI Powered Data Analytics Bootcamp at Transfotech Global Bangladesh
10+ Years of Professional Experience
Course Instructor

Meet Your Instructor

Mohammad Samiul Islam

Principal engineer (Data, BI & AI Automation)

Data Analytics & AI Automation Expert

LinkedIn

Mohammad Samiul Islam is a data analytics and AI automation professional with over ten years of experience turning business data into actionable insights. He currently serves as Principal engineer (Data, BI & AI Automation) at Brain Station 23 and previously worked as Senior Analytic Engineer at UTAH Group. His work spans Power BI dashboards, KPI analytics, enterprise data warehousing on Microsoft Fabric and Python-based AI automation. He has led cross-functional data teams and helped businesses make faster, data-driven decisions across manufacturing, FMCG and enterprise projects.

  • Principal engineer (Data, BI & AI Automation) Brain Station 23 Ltd
  • Former Senior Analytic Engineer UTAH Group
  • Microsoft Certified Fabric Data Engineer Associate
  • Expertise Data Analytics, Power BI & AI Automation
Skilled in Power BI Python Advanced SQL Microsoft Fabric AI Automation
Career Support

From Learning to Career, We’re With You

Explore Our Courses

Step 01 of 03

CV & Portfolio Review

We review your CV and portfolio and share practical feedback to help you present your skills more effectively.

Swipe or tap a step to explore

Bonus Internship Opportunities

Relevant internship opportunities may also be available through our sister concerns.

Why This Program

Not Just Another Course. A Career System.

Every element is engineered for one outcome — turning spreadsheet users into hired data analysts.

AI-Powered Curriculum

AI is woven into every module — cleaning, exploration, SQL generation, forecasting and report writing — along with the verification discipline to never ship a number you cannot defend.

Two-Speed Learning

Every class has a core session for beginners and a deeper stretch task for learners who already work with data. Nobody is left behind, and nobody sits bored.

Live Interactive Classes

36 live sessions with real-time Q&A, screen-shared walkthroughs and instant feedback — never just recordings.

Real Business Datasets

Messy, incomplete, genuinely difficult files from retail, banking, e-commerce and marketing. Not clean textbook samples that behave perfectly.

Structured 18-Module Path

Two live classes per module, one clear skill per module. You always know exactly where you are and what comes next.

Lifetime Access

Every recording, dataset, query file, workbook and prompt library stays yours forever — including future updates.

Portfolio Building

Graduate with published dashboards, a SQL case study and a written capstone that a recruiter can click through in two minutes.

Interview Preparation

Live SQL rounds, business case practice, take-home test strategy and salary negotiation coaching with hiring insiders.

Placement Assistance

Direct referrals to hiring partners across Bangladesh, plus vetted remote and freelance opportunities.

International Standard

Curriculum mapped to Microsoft PL-300 objectives and real analyst job descriptions in Bangladesh and abroad.

Learning Roadmap

From Beginner to Job Ready in 4 Phases

A structured path with a clear checkpoint at every stage — you always know exactly where you are and what comes next.

01
Week 1 – 4 Module 1 – 5

Beginner

Data Foundations & Spreadsheet Mastery

  • Analyst mindset, data structure, granularity and data quality auditing
  • Business statistics and framing a vague request into an answerable question
  • Excel cleaning, lookup logic, dynamic arrays and formula debugging
  • Pivot dashboards and Google Sheets collaboration pipelines
02
Week 5 – 7 Module 6 – 9

Core Skills

Automation & Database Querying

  • Power Query refreshable cleaning pipelines across files and folders
  • AI inside the spreadsheet, plus the first graded project
  • SQL foundations: SELECT, filtering, CASE logic and aggregation
  • JOINs across multiple tables without silently breaking the numbers
03
Week 8 – 10 Module 10 – 15

Intermediate

Analytical SQL & Business Intelligence

  • CTEs, window functions, cohort and retention analysis
  • Power BI star schema modelling and DAX from SUM to CALCULATE
  • Time intelligence, publishing, scheduled refresh and row-level security
  • Looker Studio, GA4 and dashboard design for decision makers
04
Week 11 – 12 Module 16 – 18

Job Ready

AI Automation & Career Launch

  • AI-driven exploratory analysis, prompt workflows and AI-assisted Python
  • Forecasting, seasonality, confidence intervals and driver analysis
  • Data storytelling and executive communication under pressure
  • Portfolio publication, mock interviews and capstone defence
Hands-On Projects

Build a Portfolio That Does the Talking

Employers don't hire certificates — they hire proof. Every project uses a real business dataset and produces something you can show in an interview.

Foundations

Data Audit & Cleaning Report

Take a deliberately broken 10,000-row dataset, audit every defect, and deliver a cleaned file with a documented quality report.

Excel + Power Query

Automated Monthly Reporting Pack

Turn a folder of monthly files into a one-click refreshable Excel dashboard, complete with documentation and handover notes.

Excel

Interactive Sales Dashboard

Build a slicer-driven one-page dashboard with KPI cards and commentary that updates with the user's selection.

SQL

SQL Business Case Study

Answer a multi-part business question across five joined tables, reconcile every total, and defend the query line by line.

Analytical SQL

Cohort & Retention Analysis

Build a customer cohort retention table and a month-over-month growth report using window functions.

Business Intelligence

Executive Power BI Dashboard

Model four raw tables into a star schema, write the DAX, and publish a secured executive report with row-level security.

Marketing Analytics

Marketing Performance Dashboard

Build a free, client-ready Looker Studio dashboard blending Google Sheets, Analytics and Ads data.

Capstone

End-to-End Capstone Analysis

Raw data to model to dashboard to a written recommendation, presented and defended live — the centrepiece of your portfolio.

Industry Toolkit

Master the Tools Every Analytics Team Uses

Hands-on work in every tool — not slideshows. You'll be operating these from week one.

  • Excel
  • Google Sheets
  • Power Query
  • PostgreSQL
  • DBeaver
  • Power BI
  • Looker Studio
  • Google Analytics 4
  • Python (pandas)
  • ChatGPT
  • Claude
  • Microsoft Copilot
Student Success

What Learners Say About Transfotech Global Bangladesh.

From manual Excel reporting and non-technical degrees to analyst desks and remote international teams.

Stories from learners across Transfotech Global Bangladesh programmes.

PMP® Exam Prep
"The support and assistance that I got from TransfoTech and you personally is incredible and wonderful. I appreciate every endeavor of Team TransfoTech in reaching my destination."
Abdul Hai Bhuyan, PMP®

Abdul Hai Bhuyan

Senior Manager, Akij Venture Limited

PMP® Certified

PMP® Exam Prep
"The instructors provided exceptional guidance, ensuring a clear understanding of complex concepts and always addressing questions. The mock exams were invaluable, simulating the PMI-PMP question format and boosting my confidence. This combination of expert instruction and practical exam preparation was crucial to my success, and I'm grateful for the comprehensive support that helped me approach the exam with confidence and strategy."
Mohammad Abdul Mannan

Mohammad Abdul Mannan

Manager – Information Technology, Tamishna Group

Course Participant

PMP® Exam Prep
"The instructors here combine exceptional expertise, certifications, and practical experience to deliver top-tier PMP exam preparation. Their in-depth guidance, proven strategies, and structured program ensure a comprehensive learning experience. With expert mentorship and well-designed materials, I'm confident this institution is the perfect place to excel in the PMP exam and achieve success in this challenging journey."
Khaled Salah Uddin

Khaled Salah Uddin

Head of Business, Smart ERP – DataSoft Systems Bangladesh Ltd

Course Participant

PMP® Exam Prep
"Transfotech Global Bangladesh is highly recommended for PMP® exam preparation… The comprehensive, industry-aligned training and practical guidance ensure a deep understanding of project management. I strongly recommend this course for anyone seeking expert preparation for the PMP® exam."
Md. Shams Tibris Kushal

Md. Shams Tibris Kushal

Deputy Manager, Supply Chain & Operations, Bangladesh Edible Oil Ltd

Course Participant

Career Opportunities

The Roles Waiting On the Other Side

Analytics is no longer a specialist function. Banks, telcos, e-commerce, NGOs and agencies in Bangladesh are all hiring people who can turn their data into decisions.

Very High demand

Data Analyst

Bangladesh
৳35K–80K/mo
International
$55K–85K

Global demand · Remote friendly

Very High demand

MIS / Reporting Analyst

Bangladesh
৳30K–70K/mo
International
—

High local demand

High demand

Business Intelligence Analyst

Bangladesh
৳50K–110K/mo
International
$65K–95K

Global demand · Remote friendly

High demand

Marketing / Growth Analyst

Bangladesh
৳35K–85K/mo
International
$50K–80K

Global demand · Remote friendly

High demand

Financial / Business Analyst

Bangladesh
৳40K–100K/mo
International
$60K–90K

Global demand

Growing demand

Freelance Data & Dashboard Consultant

Bangladesh
৳40K–150K/mo
International
$25–60/hour

Global demand · Remote friendly

Everything Included

What You'll Receive — All In One Enrollment

  • 36 Live Classes
  • Verified Certificate
  • Graded Assignments
  • Lifetime Recordings
  • Real Business Datasets
  • AI Prompt Library
  • Private Community
  • 1:1 Career Guidance
  • Mock Interviews
  • Job-Ready Portfolio
  • CV & LinkedIn Templates
  • Mentor Support
Certificate

Earn Your Certificates

Get a shareable Certificate of Completion and a Certificate of Assessment with your scores after meeting the bootcamp requirements.

Sample Certificate of Completion for the AI Powered Data Analytics Bootcamp from Transfotech Global Bangladesh
Certificate of Completion
Sample Certificate of Assessment with scores for assignments, module projects, quizzes and final capstone
Certificate of Assessment
Enrollment Open

Choose the Track That Fits Your Career Goal

AI-integrated, live and mentor-led — everything you need to go from spreadsheet user to job-ready data analyst.

Limited-Time Discount

This offer disappears in

00Days 00Hours 00Mins 00Secs

Lock today's price — enroll before the timer hits zero.

Core Package

Job-Ready Data Analyst Program (AI Integrated)

৳2,990 ৳4,990 Program Fee

Save ৳2,000 · 40% OFF

Flexible payment — two easy installments

  • 36 live classes across 18 structured modules
  • Excel, Power Query, SQL, Power BI and Looker Studio training
  • AI-assisted analysis workflows and a reusable prompt library
  • Real, messy business datasets from live industries
  • Weekly graded assignments with written feedback
  • 3 module projects plus the final capstone
  • Professional CV development (ATS-optimised)
  • Mock interview preparation (technical and HR)
  • Mentorship and private community access
Enroll Now
100% money-back after the first 4 classes bKash, Nagad, cards & bank transfer Free consultation before you decide
FAQ

Every Question, Answered Honestly

Still unsure about something? Message us on WhatsApp — a real counselor replies within minutes.

No. The programme starts from absolute fundamentals — Module 1 assumes you have only used Excel casually. Most learners come from non-technical backgrounds: business, finance, marketing, even arts. What you need is consistency and 8–10 hours a week.

The programme runs for 18 weeks: 18 modules, 2 live classes per module, 36 classes in total. Classes are held every Sunday and Tuesday for 2 hours each (8–10 PM Bangladesh time), plus a weekly 1-hour doubt-clearing lab. Every class is recorded.

Because one class teaches the concept and the second one makes it stick. The first class covers the skill with a guided walkthrough; the second applies it to a real dataset with live problem-solving. Nothing is left as homework you never get feedback on.

No, and this is the part most courses get wrong. Every class has a core session plus a deeper stretch task — for you, the stretch task is the main deliverable and gets reviewed in the next class. You'll also skip the Week 0 orientation and start with a self-assessment instead.

Yes. Both are introduced from zero, with the setup done together on screen. The Week 0 orientation covers tool installation and an Excel refresher before Class 1, so nobody starts behind.

Every session is recorded and uploaded within 24 hours, with lifetime access. You can also bring questions from a missed class to the weekly doubt-clearing lab.

Any laptop with 8GB RAM (16GB recommended) and 20GB free storage. One honest note: Power BI Desktop runs on Windows only. If you use a Mac, we provide a cloud desktop option for the Power BI modules at no extra cost, and everything else runs on any machine.

Yes. Every dataset, SQL script, Excel workbook, Power BI file and prompt template used in class is shared after the session and stays yours permanently.

You receive a verifiable digital certificate from Transfotech Global Bangladesh. More importantly, you graduate with a portfolio of published dashboards and a written capstone — which is what employers actually evaluate in an interview.

The Power BI modules cover a large share of the PL-300 exam objectives, and Module 18 includes guidance on whether the certification is worth taking for your specific career goal. The course is not an exam bootcamp and does not include the exam fee.

From month 2, the career team works with you on your CV, LinkedIn, portfolio and mock interviews. Qualified graduates are referred directly to hiring partners, and vetted remote and freelance opportunities are shared in the alumni group.

No honest academy can guarantee a job. What we can commit to is the system: graded projects, a real portfolio, mock interviews and direct referrals. Learners who complete every project and career sprint are the ones who get offers.

The Core Package (৳2,990) can be paid in two easy installments. bKash, Nagad, bank transfer and cards are all accepted.

Yes. If you attend the first 4 classes and feel the programme is not right for you, we refund 100% of your payment — no questions asked.

Both, and deliberately in that order. AI appears in spreadsheet cleaning, SQL generation and debugging, exploratory analysis, forecasting and report writing. But you learn to verify everything AI produces, because an analyst who cannot check the output is not an analyst.

Dashboard and reporting work is one of the most in-demand freelance categories on Upwork and Fiverr, and it is fully remote-deliverable.

Structure, accountability and feedback. YouTube teaches you features. This teaches you to answer a business question end to end, on messy real data, with a mentor telling you where your logic broke — and a portfolio at the end that proves it.

Classes are taught in a comfortable mix of Bangla and English, while all materials, datasets, queries and reports are in English — preparing you for international workplaces.

Fill out the form on this page or message us on WhatsApp. A career counselor will call you within 24 hours to assess your background and answer every question — completely free, no obligation.

Enrolling Now — Limited Seats

Your Data Career
Starts With One Step.

Seats are limited and this discounted price won't wait — the next intake is months away. Join the free masterclass, or book your consultation now and decide after you have every answer.

  • 100% money-back guarantee after the first 4 classes
  • Free 1:1 consultation — zero pressure, zero obligation
  • Counselor calls you back within 24 hours

Free Career Consultation

Your Data Career Starts With One Call

Talk one-on-one with a career counselor — get a personalised roadmap in 15 minutes, completely free.

Please enter your full name.

Enter a valid Bangladeshi mobile number.

Enter a valid email address.

▾

Select your current background.

▾

Select your current Excel level.

Zero pressure — decide after every answer.