Intermediate Power BI (LERN 1540)
This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see: http://yougotclass.org/index.cfm/VCC
Prerequisites
Introduction to Power BI
Schedule†
LERN 1540 schedule for programs:
- LERN
| CRN # | Instructor | Dates | Day/Time | Instructor | Register |
|---|---|---|---|---|---|
|
30932
|
October 5, 2020
to October 30, 2020 |
In progress | |||
|
11131
|
January 3, 2021
to March 26, 2021 |
Register
Register /applying/apply-now/registering-to-cs/ |
|||
|
11165
|
March 1, 2021
to March 26, 2021 |
Register
Register /applying/apply-now/registering-to-cs/ |
| query | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| CACHED | false | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 32 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 >= 202070 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| array | |||||||
|---|---|---|---|---|---|---|---|
| 1 |
| ||||||
| 2 |
| ||||||
| 3 |
| ||||||
| array | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| 1 |
| ||||||||
Additional Information
- Power Query
- Data Modeling
- DAX
- Reports
This course is offered as part of a VCC program only.
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.
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.
Email lern@vcc.ca
* 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.
Facebook
Twitter
Instagram
YouTube
Flickr
RSS
More accounts