Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
End to End Microsoft Business Intelligence
SharePoint Training Overview

This five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Re-porting Services, Report Builder 3.0, SharePoint 2010 Integration, Reporting Services Content Types, PerformancePoint Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining. The intention of this course is to allow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.

SharePoint Training Audience:

Project mangers, developers, I.T. Professionals, end-user ombudsman, analyst

SharePoint Training Prerequisites

Understanding Of Relational Database Concepts and goals of Business Intelligence.

SharePoint Training Course duration

5 days

SharePoint Training Course outline

1. The Business Intelligence Stack

  • SQL 2008R2 BI Platform
  • Enterprise Extract Transform Load with Integration Services
  • Analysis Server
  • DBMS Management System
  • Understanding Multidimensional Space Terminology
  • Reporting Services
  • Understanding Terminology
  • Data Mining
  • Dashboards/ Scorecards
  • SharePoint 2010 Services 2010
  • Web Server
  • Content Database
  • Web Application / Collection Tools
2. The Unified Data Module
  • Data Sources
  • Data Views
  • Proactive Caching
  • When It Is Inappropriate to Use UDM
3. SQL Server Integration Services
  • Data Import/ Export Wizard
  • Extract Transform Load Tool
  • Control Flow and Data Flow Engine
  • Application Platform
  • New or Changed Features
  • Script Task and When to Use It
  • MERGE operation in an SQL statement
  • Change Data Capture
  • Data Flow Improvements
  • Data Profiling Task and Viewer
  • Enhanced Performance and Cashing for the Lookup Transformation
  • New Debug Dump
  • New SSIS Connection Project Wizard
4. Extract Transform Load
  • ETL Life Cycle
  • Extract
  • ADO Net Source
  • Excel Source
  • Flat File Source
  • Raw File Source
  • XML Source
  • Transform
  • SSIS Logging
  • Best Practices for Design
5. SQL Server Analysis Services
  • Cubes
  • Multi Dimension Space
  • Measures / Groups / Dimensions
  • Granularity
  • Dimension Hierarchies
6. MDX
  • MDX Query Editor
  • Select Statement
  • Select Clause
  • From Clause/ Where Clause
  • Tuples
  • Cells
  • Partial Tuples
  • Sets
  • Functions
  • Limiting Sets
  • Time
7. SQL Server Reporting Services
  • Integration with SharePoint
  • Integrated Install
  • Report Processing and Rendering
  • Report Processing Options
  • Report Authoring Environments
  • Data Access
  • Datasets
  • Charts
  • Report Builder 3.0
  • Subscriptions
  • Integration with SharePoint 2010
  • SharePoint is the Repository
  • SharePoint Security
  • Storage Security
  • Decomposition Tree
  • Improved Scorecards
  • Improved Time Intelligence with Dynamic Filters
  • Linking of PerformancePoint Web Parts
  • KPI Details Report
  • Analytics Reports
  • Navigating Dashboard Designer
  • Visual Reports
  • Types of Visual Reports
  • PPS Filters
8. Excel Services
  • What Excel Services Is Not
  • Single Version of The Truth
  • Differences when in the Browser
  • Preparing and Publishing a Workbook
  • Excel Web Part
  • Visio Services
9. PowerPivot
  • PowerPivot and Excel
  • PowerPivot and SharePoint
  • Enterprise Business Intelligence & PowerPivot
  • VertiPaq Engine
  • Importing Data
  • Enriching Data
  • Refreshing Data
  • Formatting Data
  • Sorting and Filtering
  • Creating Relationships
  • Calculations
  • SharePoint Sharing
10. Data Mining
  • What is Data Mining
  • Why Data Mining
  • Problems Addressed
  • Notable Uses of Data Mining
  • Data Mining Tasks
  • Microsoft Algorithms
  • Microsoft Decision Trees
  • Microsoft Time Series
  • Microsoft Clustering
  • Microsoft Sequence Clustering
  • Microsoft Associations Rules
  • Microsoft Neural Network
  • Matching the Tasks to the Algorithm
  • SQL OLAP Mining
  • SSIS Data Mining
  • Excel and The BI Extensions
  • Forecast Table Analysis Tool
  • Prediction Calculator Tool
  • Shopping Basket Analysis Tool
  • Detect Categories Table
  • Analyze Key Influences

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy