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]

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.
Fee: $279

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8320 Fri., Nov. 10West CountyMark Ratliff
E8420 Tues., Jan. 9West CountyMark 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.
Fee: $279

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8321 Fri., Nov. 17West CountyMark Ratliff
E8421 Tues., Jan. 23West CountyMark 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.