In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Multidimensional OLAP cubes to support Business Intelligence (BI) solutions. You will learn about the Microsoft SQL Server Visual Studio development environment (SQL Server 2008 Business Intelligence Development Studio (BIDS), SQL Server 2012/2016 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 take delegates through building a multidimensional cube in its simplest form through to extending the features within the cube by 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, but basic administration and security of cubes are also covered. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.
This course does not require any prior experience with Analysis Services 2008/2012/2014. It is assumed that delegates have working experience with SQL Server 2005, 2008, 2012 or 2014 and basic relational database concepts such as tables, queries, and indexing.
A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.
|All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260|
|All prices are per person and are subject to VAT|
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)
"Very clear instruction and presentation."
"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"
"I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo. Thanks to Megan & Debra for sorting out the admin side and looking after me. "