|
|
|
Frequently Asked Questions
What is this course about?The course gives attendees an introduction to Microsoft's business intelligence strategy and software tools. After taking this course, attendees will have a clear understanding of the use and purpose of each of the Microsoft business intelligence components, including SQL Server database, Integration Services, Reporting Services, Analysis Services, SharePoint, Data Mining add-ins for Excel, PowerPivot for Excel, PowerPivot for SharePoint and PerformancePoint Services for SharePoint.Who will benefit from this course?Anyone who needs an introduction to Microsoft Business Intelligence tools, including analysts, database administrators, enterprise architects, system designers and developers. What background do I need?This is a software tools course. This course is designed for the technical analyst. Basic database knowledge with any relational database and a background in IT are assumed.What is SQL Server?SQL Server is Microsoft's strategic data management server system. It has a full-featured relational database management system (RDBMS) with support for robust server-side development and data replication. It also has components for integrating data from heterogeneous data sources (SQL Server Integration Services), storing and managing multidimensional data (SQL Server Analysis Services) and enterprise reporting (SQL Server Reporting Services). What is SharePoint Server 2010?Microsoft SharePoint Server 2010 is the upgraded version of Microsoft SharePoint Services. SharePoint Server 2010 offers workflow functionality, extensive integration with Microsoft Office products, ASP.NET 3.5 compatibility and many other enhanced features. It allows an organization to organize data in a centralized, web-based application. What is SharePoint PerformancePoint Services?SharePoint PerformancePoint Services is a SharePoint performance management service that allows for monitoring progress, analyzing variances, and reporting on analysis using a variety of sophisticated reports. PerformancePoint uses metrics, key performance indicators (KPIs), and reports delivered to every desktop through intuitive scorecards, dashboards, and the easy-to-use Microsoft Office system environment.What is PowerPivot for Excel?PowerPivot for Excel is an add-in that Microsoft has released to facilitate self-service business intelligence analysis. With PowerPivot for Excel, ordinary users can integrate data from multiple sources, analyze, slice and dice the data without the need for the IT department to create Analysis Services cubes. The add-in allows millions or even hundreds of millions of rows of data to be imported for analysis, exceeding the Excel worksheet limit of one million rows. PowerPivot for Excel can be complemented with PowerPivot for SharePoint to enable sharing of business intelligence solutions.Do I need to have experience working with Business Intelligence solutions to be successful in this course?Some experience with the tools will help, but you do not need to have specific experience implementing Business Intelligence solutions to succeed in this course. A basic understanding of your business and the type of information you would like to glean from your systems is all the Business Intelligence experience that you need.How much time is spent on each topic?| Content | Hours | | Introducing Business Intelligence (BI) | 2.0 | | Collecting BI data with Integration Services | 2.5 | | Leveraging SQL Server Analysis Services | 2.5 | | Presenting data with Reporting Services | 2.5 | | Exploiting Excel for predictive analysis | 2.0 | | Delivering BI through SharePoint | 2.5 | | Smarter decisions with PerformancePoint | 3.0 |
Times, including the workshops, are estimates; exact times may vary according to the needs of each class.How much time is spent on the hands-on exercises?Approximately 40% of the course is devoted to hands-on exercises, allowing you to gain practical experience implementing Business Intelligence solutions with the Microsoft toolset. Exercises include: Reviewing a finished BI solutionCreating a KPI within a cubePublishing an Excel workbook to SharePointBuilding a scorecard with Dashboard DesignerForecasting trends with data mining techniquesDesigning a dashboard in SharePoint What platform is used for the hands-on exercises?This course uses Microsoft SQL Server 2008 R2 running on Windows Server 2008.How does this course relate to other Learning Tree courses?Learning Tree offers a number of courses that will help you expand upon the knowledge gained in this course and further your skills in several key areas. Those courses include: |
Microsoft is a registered trademark of Microsoft Corporation.
Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
|
|
Training Dates
 | Most events below can be taken in-class or live, online from your home or office with AnyWare. |
| Jan 16 - 18 | Toronto enrol | US Dates | | May 23 - 25 | Rockville, MD enrol | | Jul 25 - 27 | Alexandria, VA enrol | | Aug 8 - 10 | Reston, VA enrol | | Aug 29 - 31 | New York enrol | | Sep 19 - 21 | Rockville, MD enrol | | Oct 10 - 12 | Reston, VA enrol | | Nov 7 - 9 | Alexandria, VA enrol | | Dec 12 - 14 | New York enrol | | Jan 16 - 18 | Rockville, MD enrol | | Jan 30 - Feb 1 | Reston, VA enrol |
For AnyWare enrolments, please register at least 7 days prior to the start of the course.
More Dates and locations.
Bring this or any Learning Tree Course on-site to your location!
Your Course Tuition
EntitlesYou to...
- Class participation
- Team workshops
- Use of in-class hands-on equipment
- Comprehensive course materials
- Morning and afternoon refreshments
- Course Completion Certificate awarding Continuing Education Units
- FREE participation in Professional Certification
|
E-mail a Colleague
Course Details
Course Details PDF