Skip to main content

MS Power BI Optimization COMP 3156

Computer Systems Course

Course details

​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 10 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.

Prerequisite(s)

Credits

1.5

Cost

$356.79 - $389.11 See individual course offerings below for actual costs.

Course offerings

Fall 2023

Below are two offerings of COMP 3156 for the Fall 2023 term.

CRN 50626

Duration

Wed Oct 25 - Wed Nov 29 (6 weeks)

  • 6 weeks
  • CRN 50626
  • $356.79
Class meeting times
Dates Days Times Locations
Oct 25 - Nov 29 Wed 18:30 - 21:30 Online
Instructor

Ahmad Chamy

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$356.79

Important information
  1. Internet delivery format.
  2. Departmental approval needed
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  4. 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. Late registration is not permitted.
Status

CRN 49619

Duration

Fri Sep 15 - Fri Oct 20 (6 weeks)

  • 6 weeks
  • CRN 49619
  • $389.11
Class meeting times
Dates Days Times Locations
Sep 15 - Oct 20 Fri 18:30 - 21:30 Burnaby
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$389.11

Important information
  1. Departmental approval needed
  2. 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 on campus. Late registration is not permitted.
Status

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

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:

School of Computing and Academic Studies

  1. Applied Computer Information Systems (ACIS)
    Associate Certificate Part-time
  2. Applied Data Analytics
    Certificate Part-time
  3. Applied Database Administration and Design
    Associate Certificate Part-time
  4. Computer Systems
    Diploma Part-time
  5. Data Visualization with MS Power BI
    Microcredential Part-time

Contact Us

If you have a question or comment about this course, please complete and submit the form below.

  • Privacy Notice: The information you provide will be used to respond to your request for BCIT program information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5G 3H2, email: privacy@bcit.ca.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of MS Power BI Optimization (COMP 3156)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.