Intermediate Power BI (LERN 1540)

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

Course code: LERN 1540

Credits: 0.0

Tuition: $0^*

Length: 16 hours

Course outline: https://www.vcc.ca/cfm-files/course-outline.cfm?subject=LERN&number=1540

Campus: Online

Prerequisites

Introduction to Power BI

No schedule is currently available. Please check again later.

query

RESULTSET

query
	BEGIN_TIME_ROUND	DAY_OF_WEEK	END_DATE	END_TIME_ROUND	SIRASGN_PIDM	SSBSECT_CRN	SSBSECT_SEATS_AVAIL	SSBSECT_TERM_CODE	SSBSECT_VOICE_AVAIL	SSBSECT_WAIT_COUNT	SSRBLCK_BLCK_CODE	SSRMEET_BEGIN_TIME	SSRMEET_BLDG_CODE	SSRMEET_END_DATE	SSRMEET_END_TIME	SSRMEET_ROOM_CODE	SSRMEET_SCHD_CODE	SSRMEET_START_DATE	START_DATE	STVSCHD_DESC

CACHED

false

EXECUTIONTIME

SQL

SELECT ssbsect_crn, ssbsect_term_code, ssrblck_blck_code, ssrmeet_start_date, ssrmeet_end_date, TO_CHAR(ssrmeet_start_date, 'DD-Mon-YYYY') AS start_date, TO_CHAR(ssrmeet_end_date, 'DD-Mon-YYYY') AS end_date, ssrmeet_begin_time, ssrmeet_end_time, TRUNC( TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as begin_time_round, TRUNC( TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as end_time_round, DECODE(ssrmeet_sun_day, 'U', 'Sun ', '') || DECODE(ssrmeet_mon_day, 'M', 'Mon ', '') || DECODE(ssrmeet_tue_day, 'T', 'Tue ', '') || DECODE(ssrmeet_wed_day, 'W', 'Wed ', '') || DECODE(ssrmeet_thu_day, 'R', 'Thu ', '') || DECODE(ssrmeet_fri_day, 'F', 'Fri ', '') || DECODE(ssrmeet_sat_day, 'S', 'Sat ','') AS day_of_week, ssrmeet_bldg_code, ssrmeet_room_code, sirasgn_pidm, ssbsect_seats_avail, ssbsect_wait_count, ssbsect_voice_avail, ssrmeet_schd_code, stvschd_desc FROM ssbsect INNER JOIN stvschd ON ssbsect_schd_code = stvschd_code AND ssbsect_schd_code NOT IN ('PLA', 'CL', 'CB', 'CI', 'T') LEFT OUTER JOIN ssrblck ON ssrblck_term_code = ssbsect_term_code AND ssrblck_crn = ssbsect_crn LEFT OUTER JOIN ssrmeet ON ssrmeet_term_code = ssbsect_term_code AND ssrmeet_crn = ssbsect_crn LEFT OUTER JOIN sirasgn ON sirasgn_crn = ssbsect_crn AND sirasgn_term_code = ssbsect_term_code WHERE ssbsect.ssbsect_subj_code = 'LERN' AND ssbsect.ssbsect_crse_numb = '1540' AND ssbsect.ssbsect_term_code >= 202060 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn

Additional Information

What you will learn

Power Query
Data Modeling
DAX
Reports

How do I apply for this course?

This course is offered as part of a VCC program only.

How does the course work?

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom. You will have a password and use your email address and password to gain access.
Once inside the online classroom, here’s what you can expect.
Participate when you want
You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.
There are no live real-time requirements or meetings. You decide when you participate.
For the best learning, participants should log into the course on 2-3 different days of the week.

For each Unit, you will:
Read the print readings (about 20 pages a week)
Have the option of accessing the online readings
Listen to the audio presentation for the Unit and view the slides
Have the option of taking a self-quiz to see how much you have learned
Engage in written online discussion with your instructor and other participants
For best learning, you should make one or more comments at 2-3 different times each week.
The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

What are the completion requirements?

As non-credit, in which case you can participate as little or as much as you like;

For completion and recognition, the requirements are as follow:

a) Make at least one comment every week in the discussion.
- The comment should show thought and be more substantive than just “Yes, I agree.” There is no length required for comments.
- Replies to other comments, responses to other participants, count as comments (in most cases your instructor value replies and responses as comments).
- Questions and online discussion facilitative comments also count as well as long as there is some thought to them.

b) Take every Unit self-quiz.
- Take every Unit self-quiz for the course and get at least 80% score.
- You may retake any self-quiz as often as you need to get to the 80% level.

-The requirements should be done by the last day of the course.

-Individual instructors may extend the deadline upon request.

-If, for any reason, you are not able to complete the requirements during the course, we are pleased to provide you with our Course Transfer Option. You may retake any or all of the same UGotClass online course at a future offering within the next 12 months, and you can do so at no extra cost.

How is competition recognition awarded?
-For individual courses, a pdf transcript is issued showing completion.
-For certificates and certification, a pdf certificate is issued showing completion.

What is the LERN refund policy?

If, for any reason, you are not able to complete the requirements during the course, we are pleased to provide you with our Course Transfer Option.You may retake any or all of the same UGotClass online course at a future offering within the next 12 months, and you can do so at no extra cost.

Want to know more?

Email lern@vcc.ca

Frequently asked questions

cstudies@vcc.ca

Meet with an advisor

604.443.8484

International students

* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Intermediate Power BI (LERN 1540)

Prerequisites

Additional Information

Ask a question