In this course, students will learn how to design and implement Multidimensional OLAP cubes to support Business Intelligence (BI) solutions. The course will focus on SQL Server 2012/2014 Data Tools for design, creation, and deployment of SQL Server BISM (Business Intelligence Semantic Model) Multidimensional Mode projects and SQL Server Management Studio for the management of Multidimensional databases. The course will cover the building of a multidimensional cube in its simplest form to extend features within the cube, implementing MDX calculations, Key Performance Indicators (KPIs), Actions, and Dimension/Cube Intelligence. The main emphasis of the course is on the design and creation of cubes, however, basic administration and security of cubes are covered as well.
- Create/manage OLAP cubes
- ID and manage Key Perf Indicators (KPIs)
- Manage actions, hierarchies, and calculations
- Config and deployment of cubes