- This event has passed.
20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2014
March 12 @ 8:00 am - March 16 @ 5:00 pm
One event on June 4, 2018 at 8:00am
Live Online Instructor Led
About this course
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.
This course is not designed for students who are new to SQL Server 2014 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
At course completion
After completing this course, students will be able to:
- Plan a BI solution.
- Plan SQL Server BI infrastructure.
- Design a data warehouse.
- Design an extract, transform and load (ETL) solution.
- Design analytical data models.
- Plan a BI delivery solution.
- Design a Reporting Services solution.
- Design a Microsoft Excel-based reporting solution.
- Plan a SharePoint Server BI solution.
- Monitor and optimize a BI solution.
- Operate a BI solution.