Print Course information
Email me when offered
Return to Course Catalog
OLAP Cubes with MS Analysis Server (SSAS) (2.4 CEUs)
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.
to continue searching for courses.
Everett Community College
2000 Tower Street
Everett, WA 98201
425-388-9100 - Need TTY?
Stay Close... Go Far.
IT Help Desk
Maps & Directions
Connect with EvCC
© Everett Community College |
Corporate & Continuing Education Center
Everett Community College, 2333 Seaway Blvd., Everett, WA 98203
Cascadia College, 18345 Campus Way NE, Bothell, WA 98011
Lake Washington Institute of Technology, 11605 132nd Ave. NE, Kirkland, WA 98034
email@example.com | 425-267-0150 | EverettCC.edu/CCEC