Master business intelligence tools like Power BI to analyze data and drive smarter business decisions.
In this comprehensive course aimed at business intelligence (BI) developers and analysts, students get to review BI tools in a hands-on environment. You will learn to convert relevant information into knowledge that supports better strategic decisions through the exploration of various business intelligence tools capable of integrating multiple data sources, processing data analysis, and building interactive dashboards. You will also work with databases that are often used with data management, reporting, and analytics capabilities.
Using the Microsoft BI stack as an example platform, you will learn how to create supercharged pivot tables with Power Pivot, a Microsoft Excel add-in application and a data model that makes Power Pivot perform amazingly fast allowing you to analyze the data in new and interesting ways.
We’ll also use Power Query to do some data munging—shaping, cleaning and transforming data using intuitive interfaces without having to use code. Additionally, we’ll build dashboards, charts, and maps using Power BI, Microsoft’s premiere analytics and reporting tool.
By the end of the course, you will have experience building BI solutions with multiple data sources using popular tools.
Note that while SQL Server experience is not required, the basic concepts of relational database design will not be covered in this course.
Online Self-Paced courses have a structured learning environment where students are allowed to complete the work at their own pace. Students may complete the coursework early or use the entire duration of the course. This course is largely self-study with instructor guidance and includes online learning modules, assignments, and/or quizzes. All course materials and assignments will be available at the beginning of the course on Canvas, our learning management system.
For this section, student access begins on January 6, but you may still enroll until February 10. All course work must be completed by 11:59 pm on April 7, 2026.
You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
Recommended Texts:
Microsoft Business Intelligence Tools for Excel Analysts, Michael Alexander, et al. Publisher: Wiley, 2014 ISBN: ISBN-10: 1118821521; ISBN-13: 978-1118821527
Beginning Power BI: A Practical Guide to Self-Service Data Analytics Edition: 3rd Edition, Dan Clark Publisher: Apress Media, LLC, 2020 ISBN: ISBN-10: 1484256190; ISBN-13: 978-1484256190
Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI &Power Pivot in Excel 2010-2016 Edition: Second Edition, Rob Collie and Avichal Singh Publisher: Holy Macro, 2016 ISBN: ISBN-10: 1615470395; ISBN-13:978-1615470395
Beginning Microsoft SQL Server 2012 Programming, Paul Atkinson, Robert Vieira Publisher
