Overview
This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.
Pre-Requisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- A basic understanding of dimensional modeling (star schema) for data warehouses
- Basic server hardware knowledge
- The ability to create Integration Services packages that include control flows and data flows
- The ability to create a basic multidimensional cube with Analysis Services
- The ability to create a basic tabular model with PowerPivot and Analysis Services
- The ability to create Reporting Services reports with Report Designer
- The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
- Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel
Day(s):5
Course Code:M20467
Delivery Methods:
Public Classroom
Online Training
Want to find out more about this course? Apply below and you will get a breakdown of the content.