Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.


SQL Server Training

Preferred method of contact?

Microsoft Tools for Business Intelligence



Course Number



4 Days


About This Course: Business Intelligence is the application of software technologies that enables business users to make better and faster decisions based on enterprise data. In this course, you are introduced to the Microsoft Business Intelligence suite. You learn how to build and integrate Microsoft tools into a comprehensive business solution in order to achieve competitive advantage.

You Will Learn How To

  • Deliver Business Intelligence solutions with SharePoint Services
  • Create KPIs and dashboards using PerformancePoint Services
  • Integrate data using SQL Server Integration Services
  • Easily consolidate data with SQL Server Analysis Services
  • Present business insights using SQL Server Reporting Services

Course Outline

  • Building Blocks of a SharePoint Business Intelligence Solution

Analyzing components of the Microsoft BI platform

  • SQL Server
  • Integration Services
  • Analysis Services
  • Reporting Services
  • Microsoft Excel
  • Microsoft SharePoint Server
  • Power Pivot
  • Power View
  • PerformancePoint Services
  • Delivering BI through SharePoint

Identifying the components of SharePoint

  • Leveraging the Power Pivot Gallery
  • Benefits of the BI tools available in SharePoint Server

Preparing to display BI data in SharePoint

  • Configuring Business Data Connectivity Services
  • Adding Reporting Services content types to a reports library
  • Deploying data sources to a data source library
  • Exploiting the Business Intelligence Center site template
  • Configuring SharePoint BI service applications

Assembling dashboards

  • Building a dashboard with SharePoint Web Part pages
  • Leveraging PerformancePoint Dashboard Designer
  • Importing Excel Services and Reporting Services reports
  • Adding KPIs and scorecards

Building additional dashboard components

  • Configuring KPIs and status lists
  • Creating analytic charts and grids
  • Setting up and applying filters
  • Implementing Time Intelligence (TI) with Simple Time Period Specification (STPS) expressions
  • Collecting BI Data with Integration Services

Integrating data from multiple sources

  • Connecting to external data sources
  • Creating a package for data imports

Working with Integration Services in a data warehouse

  • Populating a Star and Snowflake Schema in SQL Server with Integration Services
  • Leveraging SQL Server Analysis Services

Defining and building a cube

  • Dimensions
  • Hierarchies
  • Measures
  • Creating a cube with Analysis Services wizards
  • Denormalizing the database

Making BI pervasive with Self-Service Tools

  • Delivering analytics with Power Pivot for Excel add-ins
  • Performing sophisticated calculations with DAX expressions
  • Creating data visualization reports with Excel
  • Leveraging Time Intelligence DAX expressions

Shortening the Analysis Services life cycle with Tabular Model

  • Importing Excel workbooks into Analysis Services
  • Configuring Power Pivot Gallery
  • Presenting Data with Reporting Services

Authoring reports

  • Building Tabular and Matrix reports
  • Bringing ad hoc reporting to the masses with Power View
  • Creating a report based on Analysis Services models

Taking advantage of interactivity

  • Implementing drill down/up and expand/collapse
  • Exporting to other formats, such as Excel
  • Performing Analysis with Excel

Exploiting data mining with the table analysis tool

  • Analyzing key influencers of desired outcomes
  • Storing a prediction calculator on SharePoint

Pivoting table data

  • Creating charts and pivot tables from different data sources
  • Connecting to Analysis Services with Excel
  • Slicing and dicing to flexibly analyze data

Publishing reports and models

  • Saving to SharePoint Excel Services
  • Viewing an Excel workbook from a web browser
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Oct 4 - 7 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here






Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."



Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“This was an excellent course on Business Intelligence solutions. Even though I was an AnyWare remote, online participant, I heard everything clearly. Our instructor could not have been better; he knew the technology, and his interaction with me made me feel as if I was sitting right there in the classroom.”

- M. Mitchell, Database Administrator