UMSL logo

Computer Education & Training Center

Power BI

Power BI Data Analysis Classes

Power BI is a set of software analytical tools to help you gain insights into your data. It can be used to bring together data from a variety of sources and create interactive reports, visualizations, and dashboards to share with others in your organization. Learn to use this software by taking an instructor-led class from the Computer Education & Training Center at UMSL. [More on Power BI]

Virtual Classes: Our Power BI classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. In addition, if you don't have Power BI installed on your machine, you can remote into one of our computers.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

Introduction to Power BI

(Prerequisite: Intermediate Excel and Introduction to SQL or experience with any database.) Power BI allows users to bring their business information to life. Visualize data through interactive tools designed to deliver fast, meaningful insights into the needs and goals of an organization. Discover how to connect to a wide variety of data sources. Learn the terminology associated with data analysis and explore the Power BI interface. Manage data in workbooks containing multiple worksheets, each displaying a different visualization. Explore ways to sort and filter a variety of data types. Manipulate date data to further enhance data analysis. Turn information into maps based on geographical data. Display data visualizations in interactive dashboards for a quick, easy view of what matters most. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3204 Wed., Sept. 14Virtual/WCMark Ratliff
E3271 Tues., Oct. 4Virtual/WCMark Ratliff
E3334 Fri., Nov. 4Virtual/WCMark Ratliff
E3401 Tues., Dec. 6Virtual/WCMark Ratliff
E3505 Wed., Jan. 11Virtual/WCMark Ratliff
E3627 Thurs., Feb. 2Virtual/WCMark Ratliff

Intermediate Power BI

(Prerequisite: Introduction to Power BI or equivalent experience.) Improve your Power BI skills as you work with more complex data. Learn to use Data Modeling in Power BI to create the foundation for your reports and visualizations as well as to manage your data relationships. Understand naming conventions and best practices for importing your data. Use the Query editor to shape, cleanse, and query your data. Learn how to import Data Models from PowerPivot. Incorporate date and time intelligence to filter your data and discover how key metrics change over time. Understand how to work with dates and calculate month-to-date or year-to-date sales or compare similar time periods between two years. Additional topics include grouping data, and working with visualizations including dual axis charts, scatter charts, and gauges. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3205 Thurs., Sept. 15Virtual/WCMark Ratliff
E3272 Tues., Oct. 11Virtual/WCMark Ratliff
E3335 Fri., Nov. 11Virtual/WCMark Ratliff
E3402 Tues., Dec. 13Virtual/WCMark Ratliff
E3506 Wed., Jan. 18Virtual/WCMark Ratliff
E3628 Thurs., Feb. 9Virtual/WCMark Ratliff

Advanced Power BI: Level 1

(Prerequisite: Intermediate Power BI or equivalent experience.) Use Power BI to shape and cleanse data, preparing it for output to visualizations and reports. Learn to work with more advanced data models, and to create and use data hierarchies. Understand how to create/apply reference lines using the Analytics panel, and how to create and use measures. Learn to make calculated columns using Data Analysis Expression (DAX) functions and to use DAX to calculate across multiple tables. Discover the CALCULATE function to generate multiple criteria filters, the RANK function to order data, and other functions to manage date arithmetic. Understand how to use logical functions to create alerts and custom groups. Topics include in-depth calculated columns and measures, and creating end-user parameter controls. Additonal topics include advanced aggregation and filtering using the X functions (SUMX, AVERAGEX, MINX, MAXX, COUNTX). [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3171 Thurs., Sept. 1Virtual/WCMark Ratliff
E3206 Wed., Sept. 21Virtual/WCMark Ratliff
E3273 Tues., Oct. 18Virtual/WCMark Ratliff
E3336 Fri., Nov. 18Virtual/WCMark Ratliff
E3403 Tues., Dec. 20Virtual/WCMark Ratliff
E3507 Wed., Jan. 25Virtual/WCMark Ratliff
E3629 Thurs., Feb. 16Virtual/WCMark Ratliff

Advanced Power BI: Level 2

(Prerequisite: Advanced Power BI: Level 1 or equivalent experience.) Take your Power BI skills to the next level and work with larger data models. Discover how to generate fiscal quarters and years to target planning and projections. Use a calendar table to store and utilize date and time functions more efficiently. Understand how to create and use functional measures to calculate percentages. Learn basic and advanced techniques for un-pivoting tables. Understand how to import and cleanse data from a web source. Additional topics include custom visualizations and using another application such as the R data language to create visualizations in Power BI. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3172 Fri., Sept. 9Virtual/WCMark Ratliff
E3207 Thurs., Sept. 22Virtual/WCMark Ratliff
E3274 Tues., Oct. 25Virtual/WCMark Ratliff
E3337 Fri., Dec. 2Virtual/WCMark Ratliff
E3404 Tues., Jan. 10Virtual/WCMark Ratliff
E3508 Wed., Feb. 1Virtual/WCMark Ratliff
E3630 Thurs., Feb. 23Virtual/WCMark Ratliff

Advanced Power BI: Level 3

(Prerequisite: Advanced Power BI: Level 2 or equivalent experience.) Delve deeper into Power BI data modeling concepts and discover how to take a large single-source flat file and identify fields to break out and use as dimension/lookup tables. Learn to effectively use time intelligence to manipulate data using time periods and do week-over-week analysis and parallel period analysis. Understand how to create a cumulative total and compare your results against the same period last year. Discover more custom visuals including a word cloud. Learn to combine your results using the Set functions in DAX: Union, Intersect, and Except. Topics include data modeling basics, the star schema data model, and data model properties. Additional topics include handling multiple relationships and dealing with mismatched tables. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3173 Fri., Sept. 16Virtual/WCMark Ratliff
E3208 Wed., Sept. 28Virtual/WCMark Ratliff
E3275 Tues., Nov. 1Virtual/WCMark Ratliff
E3338 Fri., Dec. 9Virtual/WCMark Ratliff
E3405 Tues., Jan. 17Virtual/WCMark Ratliff
E3509 Wed., Feb. 8Virtual/WCMark Ratliff
E3631 Thurs., Mar. 2Virtual/WCMark Ratliff

Advanced Power BI: Level 4

(Prerequisite: Advanced Power BI: Level 3 or equivalent experience.) Continue your journey to mastery of the Power BI tool. Discover additional means of data analysis by creating a moving average, sampling, time series forecasting, and Pareto analysis. Learn to utilize running total and period-to-date measures. Explore techniques for using Power BI Bookmarks and the Page Navigator. Understand how to enhance conditional formatting using Unicode characters. Learn to include a visual showing the last refresh date/time. Additional topics include employing a custom composite KPI visualization.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3174 Fri., Sept. 23Virtual/WCMark Ratliff
E3209 Thurs., Sept. 29Virtual/WCMark Ratliff
E3276 Tues., Nov. 8Virtual/WCMark Ratliff
E3339 Fri., Dec. 16Virtual/WCMark Ratliff
E3406 Tues., Jan. 24Virtual/WCMark Ratliff
E3510 Wed., Feb. 15Virtual/WCMark Ratliff
E3632 Thurs., Mar. 9Virtual/WCMark Ratliff

Using Power Automate with Power BI

(Prerequisite: Advanced Power BI: Level 1 or equivalent experience. Experience with Power Automate is not required.) This class introduces you to the "power" of combining the best of Power BI and Power Automate. Learn how to pass data from Power BI to Power Automate to automate processes and pass information to other apps. Understand how to create buttons in Power BI and use them to email summary data. Learn to output data from Power BI and write to an Excel spreadsheet. Use Excel as an intermediary to update data from other applications. Learn to write data from Power BI to a SharePoint list so that it can easily be shared with colleagues. Understand how data is handled by a Power Automate flow as you work with single values and collections. Topics include setting up your manual trigger for a flow and using the field well to make data available to your flow in Power Automate.
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3395 Thurs., Dec. 15Virtual/WCMark Ratliff

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are also available in SQL (Structured Query Language) commands which can be used in a variety of client/server database systems.

For more information, please email info@cetc.umsl.edu.