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.
At the conclusion of the course, you should be able to
- Describe the principles of business intelligence and apply these principles to real-world projects
- Discuss with business management the best BI tool to purchase which will shed light on your business challenges
- Explain how to build an enterprise level BI data flow
- Identify key performance indicators to measure success in your business
- Save Your Seat
Help us confirm course scheduling. Enroll at least seven days before your course starts.
- Accessing Canvas
Learn more about gaining access to your course on Canvas in our FAQ section.
Accessibility and Accommodation
For accessibility questions or to request an accommodation, please visit Access for Students with Disabilities or email the Extension registrar.
Finance Your Education
Here are ways to pay for your education.
Estimated Cost: TBD
Course Availability Notification
Please use this form to be notified when this course is open for enrollment.
Speak to a student services representative.
Call (408) 861-3860