In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Tabular PowerPivot Models to support Business Intelligence (BI) solutions. You will learn about the Microsoft SQL Server Visual Studio development environment (SQL Server 2012/2014 Data Tools) for design, creation and deployment of SQL Server BISM (Business Intelligence Semantic Model) Tabular Mode projects, and SQL Server Management Studio for the management of Tabular Models. Delegates will be introduced to the concepts of Transactional Relational Databases, Data Warehouse Relational Databases, other sources of data, and Tabular (PowerPivot) Models fundamentals, becoming familiar with terminology such as Tables, Data Sources, Relationships, Hierarchies, Calculations and Measures. The course will take delegates through building a Tabular Model in its simplest form through to extending the features within the model by implementing DAX calculations and measures, and Key Performance Indicators (KPIs). The main emphasis of the course is on the design and creation of Tabular Models, but basic administration and security of models are also covered. An introduction to the DAX language will provide an insight into extending data models by adding simple aggregate type measures and calculations to the model through to complex Time-Intelligence based measures, such as parallel period calculations, year to date, month to date, etc. This course also covers the interrogation of Tabular Models from Microsoft Excel 2010/2013 through Pivot Tables and Charts, and the use of Tabular Models as data sources for SQL Server Reporting Services (SSRS). This course is suitable for delegates working with SQL Server 2012 and SQL Server 2014.
This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of the SQL language to the level of the SQL Server Database Querying course.
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.)
"The whole experience was great. Trainer and staff were extremely helpful and approachable."
Faithful & Gould
"Our needs and expectations were surpassed."
"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. "