search3
    
    20467D: Designing Business Intelligence Solutions With Microsoft SQL Server

    QUICK

    INFORMATION

    course-duration

    5 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Training

    customize-batch

    Customize Your Batch

    one-o-one

    1:1 Training Available on Demand

    Course Information

    This course is mainly meant for Business Intelligence [BI] professionals. It enhances their skill to plan and design BI solutions based on Microsoft BI Technologies.
     

    Course Objective:
     

    On completion of this course, you will be able to
     

    • Plan a BI solution and SQL Server BI infrastructure
    • Design a data warehouse, extract, transform, and load [ETL] solution
    • Design a reporting services solution, Microsoft Excel-based reporting solution
    • Plan a SharePoint Server BI solution
    • Monitor, Operate, and, optimize a BI Solution

    COURSE OUTLINE

    Module 1: Planning a BI Solution

    • BI Solution Elements
    • BI Project Planning
    • Microsoft BI Platform
       

    Module 2: Planning SQL Server Business Intelligence Infrastructure

    • BI Infrastructure
    • Data Warehouse Hardware
       

    Module 3: Designing a Data Warehouse

    • Data Warehouse Design
    • Dimension Tables and FACT Tables
       

    Module 4: Designing an ETL solution

    • ETL Overview
    • Planning for Data extraction, transformation, and loading
       

    Module 5: Designing Analytical Data Models

    • Analytical data models and its design
       

    Module 6: Planning a BI Delivery Solution

    • Considerations for BI Delivery
    • Reporting scenarios and selection of reporting tools
       

    Module 7: Designing a Reporting Services Solution

    • Design Reports
    • Planning Reporting solutions and its consistency
       

    Module 8: Excel Based reporting Solution

    • Data Reporting and Analysis in Excel
    • PowerPivot and Power View in Excel
       

    Module 9: SharePoint Server BI Solution

    • SharePoint Server as BI Platform
    • Planning of Security, Reporting Services Configuration, PowerPivot Configuration, and PerformancePoint Services
       

    Module 10: Monitoring and Optimizing a BI Solution

    • BI Monitoring
    • Monitoring and Optimizing Data warehouse, Reporting Services
    • Monitoring and Analyzing Analysis Services
       

    Module 11: Operating a BI Solution

    • BI Operations Overview
    • ETL, Data Warehouse, Analysis Services, and Reporting Services Operations

    WHO SHOULD ATTEND

    • Students new to SQL Server 2014 BI technologies
    • BI Professionals who work with SQL Server technologies

    Pre-requisites

    The participants must have the technical knowledge as follows:
     

    • Basic knowledge of dimensional modeling and server hardware
    • Create integration service packages, multidimensional cube with Analysis Services
    • Create basic tabular model with PowerPivot and Analysis Services
    • Create Reporting Services reports with Report Designer
    • Implement authentication and permissions
    • Knowledge of SharePoint Server and Microsoft Office Applications

    Exam

    Name Code Fee
    DESIGNING BUSINESS INTELLIGENCE SOLUTIONS WITH MICROSOFT SQL SERVER 70-467 -

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.