bolt Elite Certification

Business Intelligence

A 24-week, advanced course in business intelligence. Trainees master data modelling, dashboards, and reporting in Power BI, Tableau, and Looker Studio, and prepare for BI certifications.

Duration 24
Contact Hours 432 Hrs
Level Intermediate
Format Full time
Enroll in Program Browse Courses
school

Course Introduction

This course builds the technical and analytical skills of a Business Intelligence professional. It is aligned with the Microsoft Power BI Data Analyst Associate and Tableau credentials. It emphasises data modelling, ETL, dashboard development, business reporting, and data-driven decision-making. Learners work with Power BI, Tableau, Google Looker Studio, Excel BI, SQL, and Power Query. They build executive dashboards and apply BI to sales, finance, HR, and marketing. Later modules cover performance optimisation, Power BI Service, report automation with Power Automate, and advanced analytics. The final weeks are certification preparation with mock exams. Cross-cutting modules cover data storytelling, CV and portfolio building, freelancing (dashboard-as-a-service for SMEs), and AI prompts for generating insights. It prepares learners for BI Analyst, Reporting Manager, and Data Visualization Expert roles.

Learning Outcomes

psychology

Explain BI architecture, data warehousing, and ETL pipelines

code

Use Power BI, Tableau, Google Looker Studio, and Excel BI

hub

Connect and model data from multiple sources

rocket_launch

Develop compelling dashboards for executive reporting

forum

Interpret and communicate data-driven insights for business growth

rocket_launch

Prepare for Microsoft Power BI, Tableau Desktop Specialist, and Looker credentials

science

Apply BI skills in marketing, finance, operations, and project domains

Target Audience

  • group ICT graduates and data professionals aiming to specialise in BI
  • group Freelancers looking to offer dashboard and reporting services
  • group Early-career professionals interested in data analysis and visualisation
  • group Anyone seeking skills in Power BI, Tableau, or Looker

Certification Criteria

  • check Minimum 80% attendance
  • check Completion of all lab tasks, reports, and assignments
  • check Final score of 80% or above
  • check Presentation of a capstone BI dashboard and documentation
Assessment Strategy
Assignments (weekly) 20%
Mid-Term Exam (Week 12) 20%
Final Exam (Week 22) 20%
Capstone Project (Weeks 19–21) 40%
Enroll in Program

24 Duration.

Course Modules

24 weeks · 18 contact hours per week · 432 contact hours

01

BI Overview (Week 1)

BI lifecycle, OLAP vs OLTP, data types

02

Data Sourcing (Week 2)

Connecting databases, APIs, and files (SQL, Excel, JSON)

03

Data Modeling (Week 3)

Star schema, DAX, relationships

04

ETL & Power Query (Week 4)

Data cleaning, M language

05

Visualization I (Week 5)

Charts, maps, KPI cards

06

Visualization II (Week 6)

Drill-down, bookmarks, custom visuals

07

DAX Formulas (Week 7)

Measures, calculated columns, filters

08

SQL for BI (Week 8)

Joins, aggregations, subqueries

09

Excel BI & Pivot Tables (Week 9)

Slicers, VBA basics, formulas

10

Google Looker Studio (Week 10)

Dashboards, connectors, embedding

11

Data Storytelling (Week 11)

Design for impact, colour theory

12

Performance Optimization (Week 12)

Query folding, indexing, caching, Midterm Exam

13

Power BI Service (Week 13)

Workspaces, sharing, scheduling

14

Report Automation (Week 14)

Subscriptions, triggers, Power Automate

15

Advanced Analytics (Week 15)

Forecasting, clustering, outlier detection

16

Freelancing & BI Consulting (Week 16)

Scope documents, client KPIs, sample gigs

17

Industry Use Cases (Week 17)

BI in Sales, Finance, and HR

18

Capstone Planning (Week 18)

Dataset selection, business questions

19

Capstone Execution (Weeks 19–20)

Dashboard building and documentation

20

Capstone Presentation (Week 21)

Insight walkthrough, report submission, panel review

21

Final Review & Certification Prep (Weeks 22–24)

Power BI, Tableau, and freelancing guidance; mock exams; Final Exam

Tools & Platforms

Stack

BI Development: Power BI Desktop, Tableau Public, Looker Studio

Stack

Data Sources: Excel, SQL Server, MySQL, Azure SQL, Google Sheets

Stack

ETL & Data Prep: Power Query, Alteryx (intro)

Stack

Report Automation: Power Automate, BI Gateways, Power BI Service

Stack

Collaboration & Careers: Microsoft Teams, Google Workspace, Upwork, Fiverr

Stack

Certification Support: Microsoft Learn, Tableau Learning Hub

Capstone Project

“Developing an Executive Dashboard for Business Decision-Making.” Trainees choose a domain such as finance, marketing, or HR. They collect, clean, and model a real or simulated dataset. They build interactive dashboards in Power BI or Tableau that highlight KPIs, trends, and recommendations. They present the live dashboard with a business narrative and a technical report.

check_circle

Selected domain, dataset, and business questions

check_circle

Cleaned and modelled dataset

check_circle

Interactive executive dashboard in Power BI or Tableau

check_circle

KPIs, trends, and recommendations

check_circle

Technical report and documentation

check_circle

Live presentation with a business narrative to a panel

Ready to lead the Digital Revolution?

Join the next cohort and master the technologies shaping the future of global enterprise.

Start Your Application Check Eligibility