1-800-THE-TREE (1-800-843-8733)
 

Introduction to Microsoft Tools for Business Intelligence: Hands-On

Integrating SQL Server, Excel, SharePoint and PerformancePoint

 
Course: 146     Type: Hands-On Training     Duration: 3 Days

Quick Enroll    

You Will Learn How To
  • Achieve an end-to-end business intelligence solution using the Microsoft toolset
  • Consolidate enterprise data into SQL Server Analysis Services cubes
  • Perform data mining with Microsoft Office Excel
  • Build dashboards, scorecards and KPIs for easy visualization of business performance
  • Map business processes into a cycle of monitoring, analyzing and planning with PerformancePoint
  • Deliver and share reports throughout the enterprise with SharePoint Services

Course Benefits
Business Intelligence is not a software program, but 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 of software technologies. You learn how to build and integrate Microsoft tools into an end-to-end solution in order to achieve competitive business advantage.

Who Should Attend
Anyone who is involved or interested in planning, monitoring, analyzing or implementing business processes using Microsoft Business Intelligence tools. Knowledge of business fundamentals is assumed.

Hands-On Training
Throughout this course, extensive hands-on exercises provide practical experience working with Business Intelligence tools. Exercises include:
  • Reviewing a finished BI solution
  • Creating a KPI within a cube
  • Publishing an Excel workbook to SharePoint
  • Building a scorecard with Dashboard Designer
  • Forecasting trends with data mining techniques
  • Designing a dashboard in SharePoint
  • Visualizing data with PerformancePoint analytic grids and charts

Course 146 Content
Introducing Business Intelligence (BI)
Proposing an integrated solution
  • Identifying problems with current business practices as they relate to Business Intelligence
  • Aligning business objectives at all levels of the enterprise
  • Introducing the Microsoft BI vision and strategy
Identifying components of the Microsoft BI platform
  • SQL Server
  • Integration Services
  • Analysis Services
  • Reporting Services
  • Microsoft Excel
  • Microsoft Office SharePoint Server
  • Microsoft Office PerformancePoint Server
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
  • Automating package execution from the command line
Leveraging SQL Server Analysis Services
Defining and building a cube
  • Facts
  • Dimensions
  • Hierarchies
  • Measures
  • KPIs
  • Creating a cube with Analysis Services wizards
  • Denormalization
  • MOLAP
  • ROLAP
  • HOLAP
  • Introducing Multidimensional Expressions (MDX)
Extracting insight with data mining
  • Determining data mining algorithms for specific business data problems
  • Utilizing data mining to perform targeted marketing
Presenting Data with Reporting Services
Authoring a basic report
  • Building Tabular and Matrix reports with the Report Wizard
  • Creating a report based on an Analysis Services cube
Taking advantage of interactivity
  • Implementing drill down/up and expand/collapse
  • Exporting to other formats such as Excel
Exploiting Excel for Predictive Analysis
Creating models for data mining
  • Preparing and cleaning input data
  • Partitioning data into training and testing sets
  • Applying available models to solve business problems
Pivoting table data
  • Creating charts and pivot tables from different data sources
  • Connecting to Analysis Services with Excel
  • Drilling down to multiple levels of detail
Publishing reports and models
  • Saving a workbook to a SharePoint document library
  • Viewing an Excel workbook from a Web browser
Delivering BI through SharePoint
Identifying the components of SharePoint
  • Comparing WSS and MOSS
  • Benefits of the BI tools available in MOSS
Preparing to display BI data in SharePoint
  • Creating a Website using BI templates
  • Populating libraries
  • Uploading data sources and reports
Displaying dashboards
  • Building a SharePoint dashboard
  • Embedding KPIs and reports
  • Loading BI Web Parts
Smarter Decisions with PerformancePoint
Monitoring enterprise health
  • Creating dashboards for displaying company data
  • Building scorecards to provide an overall rating of the organization
  • Including specific KPIs to identify target areas
Analyzing organizational performance
  • Presenting Analysis Services queries in chart view
  • Visualizing analytic charts, grids and strategy maps
Planning for future competitive advantage
  • Leveraging the built-in dimensions and hierarchies to create models
  • Creating custom dimensions
  • Adding business rules with SQL or MDX
  • Designing data-entry forms for user input
  • What-if scenarios with writeback
Microsoft is a registered trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save as much as $2,350 on a Triple-Pack!

Introduction to Microsoft Tools for Business Intelligence: Hands-On
Upcoming Dates
Aug 27 - 29, 2008
 Washington, DC (Reston, VA)
Sep 24 - 26, 2008
 New York
Oct 1 - 3, 2008
 Washington, DC (Alexandria, VA)
Oct 8 - 10, 2008
 Ottawa
Oct 22 - 24, 2008
 Toronto
Oct 29 - 31, 2008
 Washington, DC (Rockville, MD)
Nov 5 - 7, 2008
 Los Angeles
Nov 12 - 14, 2008
 Chicago (Schaumburg)
Dec 3 - 5, 2008
 Washington, DC (Reston, VA)
Jan 7 - 9, 2009
 New York

Introduction to Microsoft Tools for Business Intelligence: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,250 Standard Tuition
Tuition with a Savings Plan
$ 1,245 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,025 Alumni Gold Discount
$ 2,000 Government Discount
 

 

Introduction to Microsoft Tools for Business Intelligence: Hands-On
Introduction to Microsoft Tools for Business Intelligence: Hands-On
Participants creating a dashboard with PerformancePoint.

CPE 17 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733