Print Course information
Email me when offered
Return to Course Catalog

Course Catalog

Business Intelligence and Dashboards Using Excel 2016   NEW!

Installed with Excel 2016 is a powerful business analysis tool set called the Power BI Suite. These tools let you analyze data, discover insights, and build detailed dashboards. In this class you will learn to create data models using the Power BI tools that mimic relational databases. These models will be used to generate PowerPivot pivot tables, charts, graphs, and KPI’s to further analyze the data. Students will also learn how to import data from multiple data sources using Power Query for use in reporting. You will also learn to write basic formulas using Excel’s DAX Calculation Language to transform data. In addition, you will learn how to create reports and dashboards in Power BI Desktop and later uploaded to PowerBI.com. Dashboard techniques throughout the class include pivot tables, pivot charts, slicers, conditional formatting, spark lines, and best practices for design and layout. Bring a USB flash drive (minimum 2 GB) to class.

NetID account is needed for this class. To create your account, please go to https://www.bellevuecollege.edu/netid/default.aspx.

Prerequisites: Basic knowledge of Excel (at least Level 2) and data warehouse concepts and design is recommended.

See our detailed course information including course content, learning objectives, and prerequisites.

Students must have a Bellevue College NetID before the first class session. Please click here to create your NetID account.

 

No classes currently available. Click here to continue searching for courses.
LATEST NEWS & TRENDS

View all Latest News & Trends >>




Copyright © Bellevue College Continuing Education, 14673 NE 29th Place | 425.564.2263 | Main Campus, 3000 Landerholm Circle SE