Our Solutions Contact Us

4 of 4

Business Intelligence For Professionals

Part of Data Analytics Programme

Module 1

Microsoft Excel: Beginner to Advanced

Module 2

Microsoft Power BI Data Analyst

Module 3

Database Engineering with SQL

Module 4

Business Intelligence For Professionals

Duration

2 Weeks (12+ Hours)

Classes

3 per week (2 Hours each)

Mode

Hybrid (Online & Onsite)

Certificate

Certificate of Completion

About This Module

This module introduces you to business intelligence for professionals and teaches you the essential skills needed to work confidently on real-world projects.

You'll build confidence with practical exercises, guided instruction, and a strong foundation before moving to the next module.

Curriculum Overview

Explore what you'll learn in this module.

1Introduction to Spreadsheet8 Lessons

Introduction to Spreadsheets
Save Workbooks, Access recent workbooks & Pin workbooks
Excel Templates
Tabs, Ribbons & Groups
Cells, Rows, Columns & Ranges
Inputting & Formatting Data
Creating Basic Excel Formulas
Relative & Absolute Cell References

2Structure of an Excel Function7 Lessons

Structure of an Excel Function
SUM() Function
MIN() & MAX() Functions
AVERAGE() Function
COUNT() Function
Adjacent Cell Errors
Auto-sum

3Apply simple Formats3 Lessons

Applying Simple Formats
Conditional Formatting
Named Ranges and Tables

4The IF Command7 Lessons

Datasets
The IF() Function
Nested-IF()
IFS() Function
COUNTIF() Function
SUMIF() Function
IF ERROR() Function

5LookUp, Index and Match8 Lessons

Datasets
VLOOKUP() Function
HLOOKUP() Function
Submit your Assignment
INDEX() Function
MATCH() Function
INDEX() & MATCH() Functions
Submit your Assignment

6Basic Excel Charts A8 Lessons

Datasets
Basic Excel Charts
Pivot Tables
Grouping Pivot Tables
Calculated Fields in Pivot Tables
Filtering Pivot Table Data
PivotCharts
Filtering with Slicers

7Basic Excel Charts (B)7 Lessons

Datasets
Dashboard - 1
Dashboards - 2
PowerPivot
Activating the PowerPivot Add-in
Data Models with PowerPivot
Creating PivotTables from Data Models

8What - IF Analysis5 Lessons

Datasets
What If Analysis - Goal Seek Tool
What If Analysis - Solver Tool
What If Analysis - Data Tools
What If Analysis - Scenario Manager

9Data Cleaning3 Lessons

Datasets
Data Cleaning in Excel
Importing Data from External Sources - Web Example

10Excel Capstone Project2 Lessons

Capstone Project
Submit Project

11Introduction to Power BI6 Lessons

Introduction to business intelligence
Role of a Power BI data analyst
Power BI Desktop and Power BI Service
Navigating the Power BI interface
Importing Excel and CSV datasets
Creating basic visualizations

12Data Preparation and Transformation7 Lessons

Connecting to different data sources
Introduction to Power Query
Changing data types
Handling blanks, errors and duplicates
Splitting and merging columns
Appending and merging tables
Data profiling and validation

13Data Modelling7 Lessons

Understanding fact and dimension tables
Creating table relationships
Primary and foreign keys
Cardinality and filter direction
Star and snowflake schemas
Creating a date table
Basic model optimization

14DAX and Data Analysis7 Lessons

Introduction to DAX
Calculated columns and measures
SUM, COUNT, AVERAGE and DIVIDE
Using CALCULATE
Row context and filter context
Basic time-intelligence calculations
Creating business KPIs

15Reports, Visualizations and Dashboards8 Lessons

Tables, matrices and charts
Cards and KPI visuals
Maps and geographical analysis
Filters and slicers
Drill-down and drill-through
Conditional formatting
Buttons, bookmarks and tooltips
Dashboard design and data storytelling

16Publishing, Security and Capstone Project8 Lessons

Publishing reports to Power BI Service
Creating and managing workspaces
Sharing reports and dashboards
Configuring scheduled refresh
Row-level security
Creating mobile-friendly reports
Building an interactive business dashboard
Presenting findings and recommendations

17Tableau Fundamentals & Data Connection6 Lessons

Tableau interface
Connecting Excel/CSV
Dimensions vs Measures
Data types
Data cleaning
Joins, Relationships & Unions

18Data Visualization6 Lessons

Bar, line, area & pie charts
Tables & heatmaps
Maps & scatter plots
Marks card
Sorting and formatting
Choosing the right chart

19Filters, Parameters & Interactive Analysis6 Lessons

Dimension & measure filters
Date filters
Top N filters
Parameters
Sets
Drill-down and interactive actions

20Calculated Fields & Advanced Analysis7 Lessons

Calculated fields
IF/ELSE & CASE
Date and string calculations
Aggregations
Table calculations
Running totals, rankings & moving averages
LOD expressions

21Dashboard Design & Data Storytelling7 Lessons

Dashboard structure
KPI cards
Containers
Interactive dashboards
Dashboard actions
Executive reporting
Data storytelling and insight presentation

22Business Intelligence Project8 Lessons

Data preparation
Business problem definition
Exploratory analysis
KPI development
Dashboard development
Insight generation
Business recommendations
Final presentation

Some of our students work at

Other Modules in This Programme

Module 1

Microsoft Excel: Beginner to Advanced

Continue building your skills with the next part of this programme.

View Module

Module 2

Microsoft Power BI Data Analyst

Continue building your skills with the next part of this programme.

View Module

Module 3

Database Engineering with SQL

Continue building your skills with the next part of this programme.

View Module

Full Programme

Data Analytics Programme

Unlock all modules and complete the full learning journey.

View Full Programme

Ready to start your journey?

Join thousands of learners building in-demand tech skills.

Enroll Now