search
    

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

    QUICK

    INFORMATION

    course-duration

    5 Day(s) Course

    courseware

    Official Courseware

    exam-voucher

    Exam Voucher

    certified-trainer

    Certified Trainer

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    Customize Your Batch

    ABOUT

    THE COURSE

    This five-day expert level course teaches the deployment of Microsoft SQL Server to implement self-service Business Intelligence (BI) Solutions & Big Data Analysis Solutions. Not only this, but the course also imparts knowledge of deploying various Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft 365 to build self-service models and reports. The Training will also describe how to use Pig and Hive for Big Data Analysis using Windows Azure HDInsight.

    Note* - This training is part 2 of the series of two courses for MCSE: Business Intelligence Solutions with SQL Server 2014. Participants need to achieve certification for both the course exams to earn the credentials of MCSE.

    Module 1: Planning a BI Solution
    This module teaches students to plan the components of a BI Solution.

    Lessons

    • Elements of a BI Solution
    • Planning a BI Project
    • The Microsoft BI Platform

    Module 2: Planning BI Infrastructure
    This module explains how to use plan appropriate BI Infrastructure gave a set of BI Parameters.

    Lessons
    • Considerations of BI Infrastructure
    • Planning Data Warehouse Hardware

    Module 3: Designing a Data Warehouse
    This module explains how to design a data warehouse given a set of user requirements.

    Lessons
    • Data Warehouse Design Overview
    • Designing Dimension Tables
    • Design FACT tables

    Module 4: Designing an ETL solution
    This lesson explains how to design an extract, transform and load (ETL) solution.

    Lessons
    • ETL Overview
    • Planning for Data Extraction
    • Planning for Data Transformations
    • Planning for Data Loading

    Module 5: Designing Analytical Data Models
    This module explains how to design analytical data models for specific BI scenarios.

    Lessons
    • Introduction to Analytical Data Models
    • Designing Analytical Data Models

    Module 6: Planning a BI Delivery Solution
    This module explains how to choose an appropriate delivery solution for a given scenario.

    Lessons
    • Considerations for BI delivery
    • Common Reporting Scenarios
    • Choosing a Reporting Tool

    Module 7: Designing a Reporting Services Solution
    This module describes how to design a reporting services solution.

    Lessons
    • Planning a Reporting Solution
    • Designing Reports
    • Planning Report Consistency

    Module 8: Designing an Excel-Based Reporting Solution
    In this module, students will learn how to design a reporting solution using Excel.

    Lessons
    • Using Excel for Data Reporting and Analysis
    • PowerPivot in Excel
    • Power View in Excel

    Module 9: Planning a SharePoint Server BI Solution
    This module introduces the use of SharePoint Server as a BI solution.

    Lessons
    • Introduction to SharePoint Server as a BI Platform
    • Planning Security for a SharePoint Server BI Solution
    • Planning Reporting Services Configuration
    • Planning PowerPivot Configuration
    • Planning for PerformancePoint Services

    Module 10: Monitoring and Optimizing a BI Solution
    At the conclusion of this module, you will be able to optimize and monitor a BI solution.

    Lessons
    • Overview of BI Monitoring
    • Monitoring and Optimizing the Data Warehouse
    • Monitoring and Analyzing Analysis Services
    • Monitoring and Optimizing Reporting Services

    Module 11: Operating a BI Solution
    At the conclusion of this module, you will be able to plan management and maintenance operations of a BI solution.

    Lessons
    • Overview of BI Operations
    • ETL Operations
    • Data Warehouse Operations
    • Analysis Services Operations
    • Reporting Services Operations

    The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.

    This course requires that you meet the following prerequisites:

    • Knowledge of data warehousing and data modeling principles.
    • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

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

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.