LERN 1540: Intermediate Power BI
Effective date
January 2022
Department
LERN UGotClass
School
Continuing Studies
Description
Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports.
This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see: http://yougotclass.org/index.cfm/VCC
Year of study
General Interest
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Utilize the ETL process to shape your data
- Know how to Pivot and Unpivot your data
- Create a Data Model
- Design a Drillthrough report
- Use Visual Hierarchies and Drill Downs
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 16
Total Hours: 16
Grading System
Satisfactory/Unsatisfactory
Passing grade
S - based on:1. Make at least one comment every week in the discussion.. 2.Take every Unit self-quiz. 3Completion timeline The requirements should be done by the last day of the course..
Course topics
- Power Query
- Data Modeling
- DAX
- Reports
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/.
- To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.