Portland Community College | Portland, Oregon

BA216A Data Analytics with Excel

Campus contacts [opens in new window]

Explores the preparation, analysis and visualization of data using Excel and Tableau to design and create accurate performance workbooks, data models, and dashboards for industry professionals. Covers the examination and visualization of data by creating and formatting PivotTables and Pivot Charts. Analyzes data with business intelligence tools by retrieving, querying, and connecting information via Data Models. Includes the visualization and analyzation of Excel data in Tableau by creating Smart Dashboards containing map presentations, with 3D Maps and Chart types. Prerequisites: (WR 115 and RD 115) or IRW 115, CIS 120 or BA 106. Audit available. (See course content and outcomes [opens in new window].)

Credits: 4

Class schedule definitions

Cost:

cost is based on the number of credits – see tuition and fees

Books:

$0 or <$40 means low cost books (doesn't include other supplies like calculators)

Register:

use the CRN to register in MyPCC – see how to register

Class types:

see more about class types

• In-person: classes take place at specific times and locations. Attendance in person is required.
• Online: classes do not have meeting times. Regular online interaction is required and there are weekly assignments.
• Remote: classes take place at specific times online. Students must be logged in during class meeting times.
• In-person and remote: classes meet both in-person and remotely. Attendance at both is required.
• In-person and online: classes meet in-person with additional online activities required.
• Remote and online: classes meet remotely with additional online activities required.