|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 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.