PDP Url

End to End Business Intelligence using SharePoint 2013 - MS-55045

This five-day instructor-led IT Ops Training is a comprehensive high-level expedition of the Microsoft Business Intelligence stack. The Microsoft End to End Business Intelligence Course is an advanced training that introduces participants to SharePoint Business Intelligence and SQL 2012 BI services.

Virtual

Learning Style

Intermediate

Difficulty

5 Days

Course Duration

5 Days

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
When you subscribe, you get:
Master subscription plan gives you access to this course PLUS:

  • high impact technical, end user and leadership courses
  • Includes courses in multi-modality - online self-paced + Virtual Classroom courses
  • Peer to peer learning and access to expert mentors
  • Learner and Manager Analytics
  • Access to Cognitive Learning Research platform to troubleshoot project issues
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
This five-day instructor-led IT Ops Training is a comprehensive high-level expedition of the Microsoft Business Intelligence stack. The Microsoft End to End Business Intelligence Course is an advanced training that introduces participants to SharePoint Business Intelligence and SQL 2012 BI services.

Course Information

About this course:

This five-day advanced course is a high-level exploration of the Microsoft Business Intelligence load. It delivers students about the SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence services consisting on presentation Point Service, Excel Services, Business Connectivity Services, Visio Services and the Business Intelligence Center emphasizing on their interdependency. Each one of the modules of this IT Ops Training is separate permitting for customization of the course for those individuals that possibly will not have a concern in a definite service. Each conception is demonstrated with a video prior to the exercise on that idea, so first you will have the small lecture then see the idea demonstrated then do it yourself. Keep in mind if you can’t do it you didn’t study it. Each one of the videos, and there are around 13 hours of them, is proposed as a carry away from the class for each one student.

The professional SharePoint Administrator earns an average of $100,719 per year.

Course Objective:

After carrying out this course, students will be capable to: 

  • Surf the data inside the cube by means of SQL Server Management Studio

  • Surf data by means of Visual Studio 2013

  • Join to a tabular basis, import tables, and discover the data

  • Productively Navigate SQL Server Data Tools

  • Effectively Navigate SQL Server Management Studio

  • Run the bring in Export Wizard

  • Build a Project

  • Insert and construct Connections to the Control Flow

  • Insert and construct implement SQL Tasks

  • join and construct primacy Constraints

  • Insert and construct Data Flow Tasks

  • Employ the Destination subordinate

  • Duplicate a Package and use again Project association Managers

  • Insert and construct a Data Conversion renovation

  • Insert and construct a Conditional Split conversion

  • Insert and construct a Multicast Transformation

  • Insert and organize an comprehensive Transformation

  • Insert and build up a Derived Column revolution

  • Insert and build up a Sort alteration

  • Insert and construct a Lookup renovation

  • Productively Deploy a Project

  • Build a model or Test Database

  • Productively Navigate and employ Key Objects

  • Construct a Server Side Time Dimension

  • Construct a Data Source

  • Construct a Data analysis

  • Effectively Navigate a Cube

  • Productively Navigate and Configure Partitions

  • Employ the Aggregation Design Wizard

  • Build and construct a Data Profiling assignment

  • Build up practical Cache

  • Organize and Process a Project

  • Construct a Cube

  • Comprehend the Functionality of MDX

  • Inscribe MDX

  • Comprehend How to employ MDX to Navigate Hierarchies

  • Inscribe MDX Navigating Hierarchies

  • Comprehend Working with Time in MDX

  • Inscribe MDX Working with Time

  • Constructing a Tabular Project

  • Import Data by means of the Table Import Wizard

  • Manually insert a Relationship

  • Construct procedures

  • Generate Calculated Columns

  • Build Hierarchies

  • Construct Perspectives.

  • Build KPIs

  • Process Data

  • Arrange a Solution

  • Join to a Tabular Model Using Excel

  • Establish, Access and make use of Report Manager

  • Employ Report Designer

  • Construct and organize Data Sources

  • Construct and build up Datasets

  • Construct and arrange a Basic Report

  • Construct and make up Graphics

  • Generate and constitute Maps

  • Construct and arrange Report Parts

  • Construct and put together a Model

  • Construct and organize Entities

  • Generate and arrange Members

  • Build and Configure Attributes

  • Construct a Business Rule

  • Set up a Model

  • Stack Data

  • Build a Subscribing View

  • Employ the Data Mining Add-in for Excel

  • Discover the options and settings accessible in the new SharePoint 2013 Central Administration

  • Generate a latest web application and business intelligence spot while exploring the features of both

  • Construct a SharePoint library to hold Excel workbooks and discover trusted file locations

  • Employ the Power View add-in for Excel

  • Build an Excel workbook with a parameter and keep it to a SharePoint document library

  • Insert Web Apps to a webpage

  • Discover the Dashboard Designer line and know how to craft and configure a data source

  • Build and organize a standard KPI and a scorecard

  • Generate and configure a leaf KPI and a scorecard

  • Generate two blank KPI’s and then turn them into an objective KPI

  • Generate and configure an analytic graph and an analytic network, insert them to a dashboard, set up them to SharePoint, and discover the options accessible

  • Generate and organize a filter, and bind the filter into both the analytic graph and analytic network created prior

  • Create and organize a cascading filter and then bind it into a latest analytic chart and gridiron

  • Build a Time Intelligence data connection, a Time Intelligence sort, and construct information using both

  • Construct four copies of the Objective Scorecard, organize settings in each of the four copies, and install them to SharePoint in a dashboard

  • Generate a new leaf KPI and employ that KPI in two latest scorecards, one with a filter constructed, and one without

  • Construct a new dashboard with two pages and analysis editing options

  • Construct a drawing, upload the file to the Student BI Site documents library, and analyze the drawing in a browser

  • Build a data-connected drawing and upload the document to the Student BI Site documents library

  • Construct an objective scorecard and matching plan map, put them in a dashboard, and then upload the dashboard to the Student BI Site

  • Employ Power Pivot within Excel to import a table from SQL Server

  • Analyze the relationships obtainable within the imported tables from SQL Server and then bring in a supplementary table and construct a relationship between it and the existing

  • Hide from view columns they don’t wish reflected in the resultant PivotTable

  • Construct a PivotTable in an presented worksheet

  • Allot administrators and permissions on the BDC Metadata Store

  • Discover the diverse content types obtainable in SharePoint 2013 and study how to place them and their subsequent settings

  • Construct a document library, organize it to accept precise content types, and then find out how to remove the document library

  • Build and organize a innovative external content type

  • Build an external list linked with the latest external content type created earlier

  • Navigate the Report Builder 3.0 interface

  • Construct an embedded data source linking into a database

  • Build an embedded data source linking into an OLAP database

  • Construct a shared data source via the Report Manager

  • Craft a shared dataset via the shared link they created in the prior exercise

  • Build a new dashboard and search three diverse ways to connect the Web Apps

Audience:

This course is specifically designed for:

  • Project Managers, Business Intelligence Developers, SQL Server Developers and IT Specialists that will be concerned with the plan, progress and continuance of SharePoint 2013 Business Intelligence solutions. The course introduces each of the services and reduces or eliminates several coding.

Prerequisite:

Prior to attending this course, students should have:

  • A considerable knowledge of the profit of business intelligence

Recommended prerequisite courses:

  • SharePoint 2013 Business Intelligence (MS-55042)

  • Power Pivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts (MS-55049)

    Course Outline

    Practice Certification Exam

    Coming Soon

    More Information

    More Information
    Brand Microsoft
    Subjects Business Productivity
    Lab Access Yes
    Technology Microsoft
    Learning Style Virtual Classroom
    Difficulty Intermediate
    Course Duration 5 Days
    Language English
    SATV Value 5 Days
    VPA Discount VPA Discount

    Reviews

    Write Your Own Review
    Only registered users can write reviews. Please Sign in or create an account

    Frequently Asked Questions

    FAQ's

    Frequently Asked Questions About Virtual Instructor-Led Courses

    I can't connect to my class, what are my options?

    The link to the class is available upon logging in to your dashboard. If you are unable to see it, please contact our support team at 1-855-800-8240 and they will be happy to provide you the direct link via email or the dial in number.


    I can't make it to attend to class. Can I reschedule?

    Yes, you can reschedule your class. Please contact your Sales representative and they will arrange this for you. If you forgot his/her name, feel free to contact our support team at support@quickstart.com or 1-855-800-8240.


    Will I get my certificate upon completion?

    Yes. Upon completion of the course, it will be available on your course as a Trophy Icon for you to download. If you do not see this, you will need to contact support@quickstart.com with the following details so they can email you the certificate: Class Name, Class Date, Account Rep, and Your Email.


    I cannot connect to my lab. Help!

    Your Lab is accessible on the bottom part of your course. You will see a button that says "LAB". Just click it to launch the lab. Please note that some classes don’t need/require a LAB. You can verify with our support team by calling them at 1-855-800-8240 or by email at support@quickstart.com. You can also check with your Instructor or the Associate Instructor if your class includes one.


    What is my access code for Skillpipe?

    A. Not all of the classes have or require Skillpipe. If your class includes one, please check your email as you should have received one from noreply@skillpipe.com. In case you do not find it in your inbox, please check the Spam / Junk folder. For any further assistance, you can call the support at 1-855-800-8240 or contact them via email at support@quickstart.com.


    I don't have audio. I can't hear the instructor.

    Make sure you are using a compatible headset for your laptop or computer. If you don’t have a headset, you can use the built-in speaker of your laptop. Otherwise, you can use the dial in option by calling the dial in number provided in the class joining email. You may also contact support team for the dial in numbers associated for your training at 1-855-800-8240 or contact them via email at support@quickstart.com.


    How can I reach student support?

    Support can be reach via phone at 1855-800-8240; via email at support@quickstart.com or via chat support through the chat button on our website. Please note that support office hours will be from 8am-5pm CST Monday to Friday. Any concerns after office hours will be attended the following business day.

    REQUEST MORE INFORMATION

    click here