Course

Course Summary
Credit Type:
Course
ACE ID:
MLS-0105
Organization:
Location:
Online
Length:
26 weeks (190 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 2 Excel fundamentals
Lower-Division Baccalaureate 3 data analysis
Description

Objective:

This course is offered through Coursera, which is an ACE Authorized Instructional Platform.

The course objective is to engage with the key concepts of Power BI, transforming data into meaningful insights and creating compelling reports and dashboards. Students will learn to prepare data in Excel for analysis in Power BI, form data models using the Star schema, perform calculations in DAX, and more.

In the final project, students will showcase new Power BI and data analysis skills using a real-world scenario. They will have tangible examples to talk about in job interviews and also be prepared to take the industry-recognized PL-300: Microsoft Power BI Data Analyst certification exam.

Learning Outcomes:

  • Illustrate proficiency in using Power BI to connect to data sources and transform them into meaningful insights.
  • Utilize the visualization and report capabilities of Power BI to create compelling reports and dashboards.
  • Prepare Excel data for analysis in Power BI using the most common formulas and functions in a worksheet.
  • Demonstrate your new skills with a capstone project and prepare for the industry-recognized Microsoft PL-300 Certification exam.

General Topics:

  • Data Analysis with Microsoft Excel
  • Harnessing the Power of Data with Power BI
  • Extract, Transform and Load Data in Power BI
  • Data Modeling in Power BI
  • Data Analysis and Visualization with Power BI
  • Creative Designing in Power BI
  • Deploy and Maintain Power BI Assets
  • Microsoft PL-300 Exam Preparation and Practice
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Discussion
  • Lectures
  • Practical Exercises
  • Project-based Instruction
  • Work-based Learning

Methods of Assessment:

  • Quizzes

Minimum Passing Score:

70%
Supplemental Materials