System maintenance is scheduled for Sunday, Sept. 29, 2019, 10 a.m. – 4 p.m. PDT. This will affect your access to Canvas, the online system hosting your course materials. We’re sorry for the interruption. Please plan ahead.
Business Intelligence Solutions
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.
- Introduction to business intelligence concepts
- Survey of tools used in the industry
- Introduction to the Power Pivot Data Model Manager
- Importing data from different data sources, including SQL Server databases
- Using Power Query to clean and transform data
- Creating calculations and measures with DAX (Data Analysis Expressions)
- Making a dashboard using pivot tables and pivot charts
- Building reports and dashboards with Power BI Desktop
- Final project, where you will design an interactive dashboard for your personal portfolio
Sections Open for Enrollment:
|Date:||Start Time:||End Time:||Meeting Type:||Location:|
|Sat, 09-14-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 09-21-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 09-28-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 10-05-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 10-12-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 10-19-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 10-26-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
|Sat, 11-02-2019||9:00 a.m.||12:00 p.m.||Lab with Online Materials||SANTA CLARA|
Ask us any questions you may have about this course.