Gain insights into your data by mastering Microsoft's business intelligence service - Power BI. In this online certificate program, you will enhance your skills in data analysis, gain greater insight into your organization¿s performance and increase your ability to make more informed decisions.
The Program
Introduction to Power BI (16 hours)
Overview
Connect with Data Sources
Transform Data
Creating Reports
Intermediate Power BI (16 hours)
Power Query
Review the ETL Process
Insert columns using different methods
Group, Summarize, Pivot, and UnPivot data
Merge and Append queries
Data Modeling
What Data Modeling is
Modeling Options
Create and manage relationships
Create Date table
DAX
Introduction to DAX
Calculate columns and measures
Time Intelligence functions
Quick Measures
Reports
Filters versus Slicers
Visual Hierarchies and Drill downs
Drillthrough
Define visual interactions
Apply conditional formatting
Advanced Power BI (16 months)
Power Query
Utilize Column profile, distribution, and quality
Perform fuzzy match
Duplicate versus Reference queries
Debug errors
Data Modeling
What a Star Schema is
Understand relationship types
Manage relationships
DAX
Understand contexts
CALCULATE function
COALESCE function
Compute visual totals accurately
Reports
Insert Objects
Create Bookmarks
HOW IT WORKS
An invitation into the online classroom will be emailed to you the Wednesday before the class begins. The subject of the email invitation will be "Lern – Classroom Invitation". Please click to accept the invitation, and from there you will create a password and will be able to access the classroom. If you haven't received an invitation by the Thursday before the course begins, please forward your confirmation email to info@ugotclass.org, and a staff member will resend your invitation.
Once inside the online classroom, here's what you can expect:
Participate When You Want
The online classroom is open 24 hours a day, seven days a week. There are no live real-time requirements or meetings. For the best learning, participants should log into the course on 2-3 different days of the week.
What You Will Do
Each course is composed of several units. For each unit, you will:
- Access the online readings
- Listen to the audio presentation for the unit and view the slides
- Take a self-quiz to see how much you have learned
- Engage in written online discussion with your instructor and other participants
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.
Discussion
The discussion for each unit lasts one week. All comments are made in writing and can be made at any time, day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
COMPLETION REQUIREMENTS
1. 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 and responses to other participants count as comments (in most cases your instructor values replies and responses as comments).
- Questions and online discussion facilitative comments also count as long as there is some thought to them.
2. Take the self-quiz at the end of every unit.
- You must score 80% or higher.
- You may retake any self-quiz as often as you need to get to the 80% score.
COMPLETION TIMELINE
- The requirements should be completed 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, UGotClass will provide you with their Course Transfer Option. The course Transfer Option allows you to retake any or all of the same UGotClass online course at a future offering within the next 12 months at no extra cost.
RECOGNITION
A pdf Certificate of Completion is issued by Learning Resources Network, Inc. and will list Green River College as its partner organization.
HELP
Once the program has started, please direct all questions to info@ugotclass.org
