search
    

    Home Microsoft 55061A: Performancepoint 2013 And Mdx Combo Pack

    QUICK

    INFORMATION

    course-duration

    6 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

    PerformancePoint 2013 and MDX Combo training is a six-day course that delivers knowledge to work with PerformancePoint 2013 Services. This course explores the new and improved Business Intelligence Center along with all the exciting new features within the SharePoint 2013 release.

    This course focuses on the SharePoint 2013 business intelligence platform rather than the SQL business intelligence services.

    After completing the course, the participants can make use of Microsoft toolset to get the answers to questions such as sales by quarter, reseller gross profit, and products purchased by geography. They can also create graphical reports and KPIs all without writing a single line of code!

    Module 1: Course Overview

    This module explains the class structure and introduces course materials and additional administrative information.


    Lessons

    • Introduction
    • Course Materials
    • Facilities
    • Prerequisites
    • What We'll Be Discussing

    Module 2: The Microsoft Business Intelligence Stack

    This module explains the three different ways in which business intelligence can be viewed.

    Lessons

    • Business Intelligence in Three Ways
    • SQL 2012 Business Intelligence
    • New 2013 SharePoint Business Intelligence Features
    • New 2013 PowerPivot in Excel Features

    Module 3: SharePoint 2013 Business Intelligence Center

    This module explores the new and improved 2013 SharePoint Central Administration site.

    Lessons

    • New 2013 SharePoint Central Administration
    • New 2013 Business Intelligence Center
    • Permissions and Roles
    • Included Document Library and List Apps

    Module 4: PerformancePoint 2013

    This module describes 2013 PerformancePoint Services features. Dashboard Designer is explored along with many of the objects and connections available within.

    Lessons

    • New 2013 Overview of PerformancePoint Services
    • Dashboard Designer
    • Data Sources
    • Indicators
    • KPIs
    • Visual Reports
    • Filters
    • Scorecards
    • Dashboards

    Module 5: PowerPivot

    This module covers all the new features available in the 2013 release of the add-in.

    Lessons

    • New 2013 PowerPivot Features
    • PowerPivot and Excel
    • PowerPivot and SharePoint
    • Enterprise Business Intelligence and PowerPivot
    • Importing Data
    • Enriching Data
    • SharePoint Sharing

    Module 6: Dashboards

    This module borrows content from the three-day Microsoft course on Dashboards number 50596A. We will discuss monitoring, analyzing, and managing dashboards along with details on how to use them most effectively.

    Lessons

    • Dashboard Migration
    • Three Types of Dashboards
    • Successful Dashboards
    • Tables or Graphs
    • Types of Graphs
    • Choosing a Chart Type
    • Key Performance Indicators
    • Pitfalls in Dashboard Design
    • Microsoft Report Builder 3.0
    • Plan Your Reports
    • Datasets
    • New 2013 SharePoint Designer Features
    • SharePoint Web Apps

    Module 7: Reviewing The Microsoft Business Intelligence Stack

    This module describes how to name, declare, assign values to, and use variables.

    Lessons

    • What Business Intelligence Can Do for Your Organization
    • What to Watch Out for in Implementation
    • The Scope and What Types of Tools Address Each

    Module 8: Getting Started with MDX

    We walk then run. Learn this and you won’t trip.

    Lessons

    • Multidimensional VS. Tabular Space
    • Data Warehouse Data Mart
    • MDX Introduction
    • The Editors

    Module 9: The All-Important Dimensions; The Bearers of Truth

    In this module, you will learn to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Lessons

    • Dimensions
    • Dimension Attributes
    • Hierarchies
    • Referencing Members
    • Tuples
    • Cells
    • Sets
    • Set Functions

    Module 10: Navigation and the Secrets of Relatives

    In this module, you will learn to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Lessons

    • Navigation in Reporting
    • Relatives
    • Navigational Functions
    • Controlling Sorting
    • Filtering the Results
    • How to Combine a Set

    Module 11: MDX Calculations

    In this module, you will learn to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Lessons

    • Expressions
    • Calculated Members
    • Formatting Output Through the WITH Clause
    • Dynamic Expressions
    • IIF Function
    • Statistical Functions
    • Determining Which Tuples Satisfy a Parameter in a Report

    Module 12: Working with Time, Multiple Calendars, and Divergent Horizons

    In this module, you will learn to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Module 13: Business Insights;

    Now Let’s Put It to Work and Get Some Situational Answers This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Lessons

    • OR Logic
    • AND Logic
    • Combining OR and AND Logic from Different Hierarchies
    • Logical AND with Members from the Same
    • Using the NonEmpty Function
    • Moving Averages
    • Last Date with Data
    • ParallelPeriod for Multiple Dates
    • Testing Current Context
    • Options of the Descendants Function
    • Ranking Values

    Module 14: Where Else Will MDX Work? SQL Reports

    This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Lessons

    • Create a SSRS Report
    • Create a Connection into the Cube
    • Create a MDX Query with the Query Designer
    • Create a Custom Query
    • Dashboard Designer of PerformancePoint Services
       

    Module 15: KPIs and MDX in The Business Intelligence Development Studio Editor

    This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array.

    Lessons

    • Use Business Intelligence Development Studio to Create a Named Calculation in the Cube
    • Use Business Intelligence Development Studio to Create KPIs

    This course is intended for:

    • Power Users,
    • Business Intelligence Developers and
    • IT professionals

    involved in designing, developing and maintaining the SharePoint 2013 Business Intelligence solutions.

    Before attending this course, students must have:

    • Basic skills of Microsoft interface such as working with Excel.

    Name Code Fee

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

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