Course Catalog

OLAP Cubes with MS Analysis Server (SSAS)

More and more self-serve reporting software is using OLAP cubes as their data source. That’s because OLAP cubes are specially designed to retrieve report data quickly and efficiently. In addition, cube developer can create dimensional models that include hierarchical structures and KPI members that make advanced reporting and charting a breeze. In this online, interactive class, you will learn how Microsoft's Analysis Server (SSAS) allows you to create professional cubes and dimensions. While in class you will learn by doing, as you create several dimensions and cubes in SSAS that exemplify real-world scenarios. Topics include: Data Source Views, Cube and Dimension designs, hierarchies, KPIs, calculated and derived members, cube deployment and partitioning, and much more. Prerequisites: SQL Programming level 2 and DW Design or equivalent knowledge; ETL with SSIS recommended. Required text: Pro SQL Server 2012 BI Solutions ISBN: 978-14302-3488-3.

Click here to continue browsing the catalog.

Email learn@everettcc.edu if you don't see a class that you are looking for.

Some Title

Everett Community College
2000 Tower Street
Everett, WA 98201
425-388-9100 - Need TTY?

Stay Close... Go Far.

Emergency Information
Campus Calendar
Intranet
IT Help Desk
Jobs
Maps & Directions
Room Rentals
Rule Making
Security
Gainful Employment

Connect with EvCC

Corporate & Continuing Education Center
Everett Community College, 2000 Tower Street, Everett, WA 98201

learn@everettcc.edu | 425-267-0150 | EverettCC.edu/CCEC