Designing Business Intelligence Solutions with Microsoft SQL Server 2014
9.00am to 5.00pm
80 Jurong East Street 21 #04-04
Devan Nair Institute
S$3,000 (excl of G.S.T)
|2019 Course Dates
29 Jul – 2 Aug 2019
23 – 27 Sep 2019
25 – 29 Nov 2019
|None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.|
|Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device.|
This five-day instructor-led course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform.
This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.
After completing this course, students will be able to:
• Plan the components of a BI solution.
• Plan a BI infrastructure.
• Design a data warehouse.
• Design an ETL solution.
• Plan analytical data models.
• Plan a BI delivery solution.
• Design a Reporting Services solution.
• Design an Excel reporting solution.
• Plan a SharePoint Server BI solution.
• Monitor and optimize a BI solution.
• Plan for BI operations.
Module 1: Planning a BI Solution
Module 2: Planning SQL Server Business Intelligence Infrastructure
Module 3: Designing a Data Warehouse
Module 4: Designing an ETL Solution
Module 5: Designing Analytical Data Models
Module 6: Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
Module 8: Designing a Microsoft Excel-Based Reporting Solution
Module 9: Planning a SharePoint Server BI Solution
Module 10: Monitoring and Optimizing a BI Solution
Module 11: Operating a BI Solution
Click here for full course Outline