Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Course details

This workshop 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.

• Lesson 1: Planning a BI Solution
• Lesson 2: Planning SQL Server Business Intelligence Infrastructure
• Lesson 3: Designing a Data Warehouse
• Lesson 4: Designing an ETL Solution
• Lesson 5: Designing Analytical Data Models
• Lesson 6: Planning a BI Delivery Solution
• Lesson 7: Designing a Reporting Services Solution
• Lesson 8: Designing a Microsoft Excel-Based Reporting Solution
• Lesson 9: Planning a SharePoint Server BI Solution 
• Lesson 10: Monitoring and Optimizing a BI Solution
• Lesson 11: Operating a BI Solution

Prerequisites

Before attending this course, students must have:

• A basic understanding of dimensional modeling (star schema) for data warehouses.
• 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.