Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (M20467)

Course ID

91100

Course Description

In this course, you will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2014. You

Prerequisites

  • 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


    • Audience

    BI professionals such as BI architects or database professionals who need to design BI solutions

    Course Content

  • 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

    • For More Information

    For training inquiries, call 850-308-1376

    or email us at eramos@gbsi.com

    Course Details

    Duration - 5 days
    Price - $3095.00 USD


    (Discounts may apply. Call for more information.)

    Course Actions

    Schedule

    Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.