Skip to main content
 
advanced search options ›
Last Viewed

Power BI Certificate

ID : 19518   
« back to classes page
This certificate consists of three consecutive four-week courses. Completion of the course includes required discussion board participation each week and other requirements indicated at the start of the class. This is a non-credit course. Students may earn CEU, PD, CE or Certificate of Completion at the end of the course.
 
Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI 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.

INTRODUCTION TO POWER BI
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. 

Unit 1 Overview
  • Power BI Components
  • Install Power BI Desktop (free software)
  • Getting started
Unit 2 Connect with Data Sources
  • Types of data sources
  • Import Excel and text files
  • Connect to databases (Access)
  • Import data from the Web 
Unit 3 Transform Data
  • Introduction to Power Query
  • Shape data
  • Filter data
  • Understand the Data Model
Unit 4 Creating Reports
  • Overview
  • Create visuals
  • Format reports
  • Share your files
INTERMEDIATE POWER BI
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.

Unit 1 Power Query
  • Review the ETL Process
  • Insert columns using different methods
  • Group, Summarize, Pivot, and UnPivot data
  • Merge and Append queries
Unit 2 Data Modeling
  • What Data Modeling is
  • Modeling Options
  • Create and manage relationships
  • Create Date table
Unit 3 DAX
  • Introduction to DAX
  • Calculate columns and measures
  • Time Intelligence functions
  • Quick Measures
Unit 4 Reports
  • Filters versus Slicers
  • Visual Hierarchies and Drill downs
  • Drillthrough
  • Define visual interactions
  • Apply conditional formatting
ADVANCED POWER BI
Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.

Unit 1 Power Query
  • Utilize Column profile, distribution, and quality
  • Perform fuzzy match
  • Duplicate versus Reference queries
  • Debug errors
Unit 2 Data Modeling
  • What a Star Schema is
  • Understand relationship types
  • Manage relationships
Unit 3 DAX
  • Understand contexts
  • CALCULATE function
  • COALESCE function
  • Compute visual totals accurately
Unit 4 Reports
  • Insert Objects
  • Create Bookmarks
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.

What You Will Do
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

For best learning, you should make one or more comments at 2-3 different times each day. 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 of the 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.

Completing the Course
Completion of class participation requirements is required to earn the Certificate of Completion, CEU and/or PD Hours at the end of the course.
Add To Cart » Send to Friend »

Class Details

Session(s)
Online 24/7

Location
NA - Online

CEUs : 4.8

 

Notice

Please read:  This course qualifies for a 50% discount through the Noncredit Workforce Grant. Call 815-224-0427 for details.

Tuition: 

$495.00

Registration Closes On
Friday, May 2, 2025 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
2/3/2025 - 5/2/2025 Online 24/7 12:00 AM - 12:00 AM N/A - Online

Other Class Offerings

Power BI Certificate
ID: 19519

04/07/25 - 06/27/25
Online 24/7

Location
 

Instructor
Marion Williams

Add To Cart »
Send to Friend »
Power BI Certificate
ID: 21512

06/02/25 - 08/29/25
Online 24/7

Location
 

Instructor
Marion Williams

Add To Cart »
Send to Friend »

Featured Classes

You may also be interested in these classes

Recommended Classes

IVCC Continuing Education & Business Services
continuingeducation@ivcc.edu | (815) 224-0427
815 N. Orlando Smith Road
Oglesby, IL 61348
Disclaimer | Privacy Statement | Consumer Information | Copyright