Microsoft Power BI

Overview

The Microsoft Power BI course at CTS College will teach students how to unlock the full potential of data. This comprehensive programme is designed to equip participants with the skills to convert raw data into clear, actionable insights and reports, including the development of dynamic dashboards and interactive visualisations.

Our practical approach ensures you'll:

• Engage in hands-on learning through real-world projects and exercises
• Master Power BI's intuitive drag-and-drop interface (no coding required)
• Benefit from expert-led training by industry professionals
• Explore everything from data modelling to advanced DAX functions
• Discover industry-specific applications across business, finance and marketing
• Learn seamless integration with Excel, SQL, SharePoint and Azure

Whether you're a business professional, data analyst, or IT specialist, this course will empower you to make smarter, data-driven decisions with confidence. You'll learn to harness Microsoft Power BI to analyse trends, monitor performance, and communicate data visually for maximum business impact.

Benefits

Upon completion of this programme, students would be able to:

• Analyse and visualise data using Power BI’s tools and dashboards
• Build interactive reports that help businesses make data-driven decision
• Connect and transform data from multiple sources
• Write DAX formulas to perform advanced data analysis
• Publish and share reports securely within an organisation to the workspace
• Optimise performance of reports for large datasets

Features

Below are some of the main features of this course:

• Short duration - can be completed in only 3 weeks with 2 classes per week
• Competitive rates with flexible payment plans
• Experienced lecturer with excellent student support
• Online classes which are also recorded for further review
• Support group via WhatsApp with the lecturer, programme manager and students

Target Audience

This course is perfect for:

• Business Analysts
• IT Professionals
• Data Analysts
• Project Managers
• Finance and Marketing Professionals
• Anyone interested in data visualisation and business intelligence

Entry Requirements

In order to enrol for this programme, students are expected to be computer literate. A basic understanding understanding of the following would also be useful, but is not mandatory:

• Microsoft Excel (PivotTables, Formulas and Basic Data Functions)
• SharePoint Lists
• Data Management Concepts

Course Content

This course covers the following:

1: Introduction to Power BI

• Overview of Business Intelligence and Data Analytics
• Understanding the Power BI ecosystem: Power BI Desktop, Power BI Service, Power BI Mobile
• Power BI vs. Excel vs. other BI tools

2: Data Sources and Transformation

• Connecting Power BI to different data sources: Excel, SQL, SharePoint, Dataverse and Web Data
• Cleaning and transforming data using Power Query
• Introduction to the ETL (Extract, Transform, Load) process

3: Data Modeling & Relationships

• Understanding tables, relationships, and cardinality
• Creating and managing data models
• Introduction to DAX (Data Analysis Expressions)

4: Data Visualisation and Dashboards

• Designing interactive reports and dashboards
• Using charts, graphs, maps, and slicers
• Conditional formatting, drill-through, and hierarchy visuals

5: Advanced Data Analysis with DAX

• Introduction to calculated columns, measures, and aggregation functions
• Using IF statements, SUMX, and time intelligence functions
• Optimising performance with best practices for DAX queries

6: Power BI Service and Cloud Integration

• Publishing reports to the Power BI Service
• Creating and sharing dashboards
• Setting up scheduled data refreshes and gateways

7: Security and Access Control

• Role-based security & user access permissions
• Row-level security (RLS) for restricted data access

8: Power BI and AI Features

• AI-powered data insights and natural language queries
• Using AI visuals like Decomposition Tree and Key Influencers

9: Real-World Projects and Case Studies

• Business intelligence use cases for finance, sales, and marketing analytics
• End-to-end Power BI dashboard development

10: Deployment and Best Practices

• Report performance optimisation
• Troubleshooting common issues
• Power BI licensing and enterprise deployment options

Schedule

Course Offering

Day	Time	Duration	Contact Hours	Cost	Lecturer
Monday, Thursday	06:30 pm to 09:00 pm	3 Weeks	18 Hours	$1,400.00	Mr. Damian Felix

*SPECIAL OFFER: Sign up for all 4 modules (Microsoft Power Apps, Microsoft Power Automate, Microsoft SharePoint, Microsoft Power BI and get $1,100 OFF ($4,500 for all 4 modules)

Session - Monday, Thursday (06:30 pm to 09:00 pm)

Session	Start Date	End Date
2025 - Session 1 - Online Classes	Monday, August 25, 2025	Monday, September 15, 2025
2025 - Session 2 - Online Classes	Monday, February 23, 2026	Thursday, March 12, 2026

Delivery Mode

Online Classes

This course will be delivered via live online classes. Students will be provided with a link to join the class as well as other relevant instructions at least one day before the start of each class. These classes are also recorded - therefore students have the option to review the course content as often as they like.

Additional Info

Assessment

Students would be required to complete the following assessment(s) for this course:

• Final Practical Assignment

Certification

In order to receive the CTS College certificate of completion or participation for this course, students must attend a minimum of 75% of classes and pay any outstanding fees. Where applicable, students who do not meet the necessary assessment requirements, but attended the required number of classes would receive a CTS College certificate of participation.

Certificates would be provided in digital format which would allow students to access, print and share their certificates 24/7 on demand. For more information on our digital certificates please click here.

Resources

A Microsoft Business Standard License (1 month subscription) priced at USD $12.50 will be required.

Interactive Course Calendar

Explore our comprehensive Interactive Course Calendar, with a list of all our courses and their costs and delivery modes offered throughout the year.

View Calendar »

Fees & Payment

Cost

This course is offered at the affordable price of $1,400. In order to start the course, students must pay a minimum of 50% before the first class.

Payment Plans

Students can be given a payment plan where the initial downpayment is made, with an arrangement for the remaining balance to be paid over the duration of the course. Please feel free to contact us to discuss a payment plan customised for you.

Payment Methods

The following table shows the details for the 4 convenient ways to pay the CTS College fees for this programme:

Payment Method	Details
Linx	Paid at the Administration Office
Credit Card	Paid at the Administration Office
Cheque	Paid at the Administration Office Made Payable to CTS College
Online Bank Transfer	Paid via Online Banking Click to view full instructions »

Student Support

Facilitator

At CTS College, we believe in crafting an extraordinary student experience. This is why we have selected Mr. Damian Felix to facilitate the Microsoft Power BI course. Mr. Felix not only imparts knowledge, but creates a learning experience where students feel valued and appreciated. He is also committed to shaping a transformative learning journey and creating an educational adventure that goes beyond the ordinary.

With over 10 years’ experience in the IT field, Mr. Felix has honed his technical skills through extensive work with Microsoft platforms such as SharePoint, Power Automate, Power Apps and Power BI, helping streamline business processes while equipping management with strategic decision-making capabilities. He also brings deep expertise in application development, management, and administration.

Currently overseeing Business Intelligence Operations, Damian holds a background in Computer, Network, and Telecommunications Engineering, along with a BSc (Hons) in Information Technology and an MBA specialising in Digital Technology Management. His responsibilities include not only managing digital technology and organisational platforms but also driving digital transformation by developing, implementing, and overseeing innovative technological solutions.

Programme Management

The programme management team is responsible for the management of this course. If you would like further information or clarification on this programme please contact:

Mr. Matthew Christian
Programme Manager
Phone: (868) 720-2939 / (868) 740-9095

E-mail: Certificationshidden@CTSCollege.com