- International Fees
International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
Following on from COMP 2156 , and parallel to COMP 3157, this hands-on advanced course was designed for Business Intelligence and Data Analysts. Students who already know how to use Power BI to build and publish reports begin with an in-depth introduction to Star Schema and its relevance to optimal Power BI data modeling. COMP 3156 in-class labs and exercises focus on specific strategies to optimize large complex Power BI data models and how to leverage Power BI Service in the cloud for fast performing reports. Topics include relational data modeling in Power BI, Designing Import, DirectQuery, and Composite Data Models. There is also an in-depth explanation of Power BI Service Performance Monitoring. Tabular Editor and DAX Studio are also discussed. Labs and assignments include managing security permissions, data visibility based on role as and leveraging specialized third-party tools. Tabular Editor and DAX Studio are used to monitor and evaluate data model performance. Participants must provide their own current model PC capable of running Windows 11 and MS Excel, with an i5 or higher equivalent processor, 8 GB minimum RAM, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. COMP 3156 is an elective in several BCIT Computing credentials including the CST Diploma (FLEX), and the Applied Data Analytics Certificate (ADAC). By the end of this course, successful students will be able to build advanced, optimized data models and use the Power BI Service cloud environment. This course will be offered in the Winter (January) and Spring (April) terms.
Prerequisite(s)
- 60% in COMP 2156
Credits
1.5
Domestic fees
$376.36
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Describe Star Schema and its relevance to developing optimized Power BI data models.
- Implement various techniques to reduce data model size and improve model performance.
- Describe the implications of import, direct-query and composite data models.
- Diagnose and troubleshoot common data relationship issues with your Power BI data model.
- Conduct performance testing to identify opportunities for optimization.
- Manage Row-Level Security (Dynamic & Static).
- Describe the data architecture of Power BI Service.
- Monitor a Power BI environment as a Power BI administrator for a Power BI Service in the cloud.
Effective as of Fall 2022
Related Programs
MS Power BI Optimization (COMP 3156) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Computer Information Systems (ACIS)
Associate Certificate Part-time
- Applied Data Analytics
Certificate Part-time
- Applied Database Administration and Design
Associate Certificate Part-time
- Computer Systems
Diploma Part-time
- Data Visualization with MS Power BI
Microcredential Part-time
Course Offerings
Spring/Summer 2025
Below is one offering of COMP 3156 for the Spring/Summer 2025 term.
CRN 68721
Dates
May 21 - Jun 25 Full
- CRN 68721
- $376.36 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| May 21 - Jun 25 | Wed | 18:30 - 21:30 | Online |
Duration
6 weeks
Instructor
Ahmad Chamy
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Internet delivery format.
- Departmental approval needed
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- Please email cstflex@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 18 hours synchronous online classes. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Late registration is not permitted.
Status
Full
This course offering is full. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.
Programs and courses are subject to change without notice.