Introduction to Power BI (LERN 1530)

Gain insights into your data! Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free.
In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions.
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 1530

Credits: 0.0

Tuition: $279^*

Length: 16 hours

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

Campus: Online

Schedule†

LERN 1530 schedule for programs:

LERN

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor	Register
30902		October 5, 2020 to October 30, 2020			Register Register /applying/apply-now/registering-to-cs/

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
1	2020-08-01 00:00:00.0	[empty string]	30-Oct-2020	2020-08-01 00:00:00.0	[empty string]	30902	1000	202093	Y	0	[empty string]	[empty string]	ONLINE	2020-10-30 00:00:00.0	[empty string]	[empty string]	A	2020-10-05 00:00:00.0	05-Oct-2020	Lecture/Practical

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 = '1530' 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

array

struct
1	30902
2	[empty string]

array

struct
1	LERN
2	30902
3	[empty string]

Additional Information

What you will learn

Overview
Connect with Data Sources
Transform Data
Creating 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.

Introduction to Power BI (LERN 1530)

Schedule†

LERN 1530 schedule for programs:

Additional Information

Ask a question