Diplomas
Certificates
Courses

MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Call our Sales
   Clients Testimonials
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Pro: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Admission

Candidates for this exam are IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. The qualified candidate for this exam typically has two to three years of experience in the following:

•Working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)

•Using the SQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS)

•Designing both relational and multidimensional database schemas

•Writing both relational and multidimensional queries

•Designing and building cubes

•Designing and creating reports

•Applying data mining algorithms to business problem domains

•Aggregating data from multiple sources into a data warehouse in a heterogeneous data environment

•Designing and managing enterprise-level solutions for multidimensional databases

•Collecting and interpreting business requirements


Pro: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
     Professional Group
  Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008   42
Exam # Duration Language Level Type Classroom Code Fees
70-452 45 English Professional Course Classroom Cs425 0 LE
Description :


Objectives :
  • Designing and Managing Reports
  • Designing Data Mining Models
  • Administering a BI Solution
  • Designing the BI Architecture
  • Designing and Deploying SSIS Packages
  • Designing an Analysis Services Database


Topics :




Recommended Knowledge :

• Knowledge of data warehousing, data marts, and industry-accepted Business Intelligence (BI) methodologies

• Conceptual understanding of SQL Server 2005 and SQL Server 2008 components, such as online analytical processing (OLAP), extract, transform, load (ETL), and reporting tools and technologies

• Experience in developing and implementing cubes at the physical level

• Experience in working with data transformations

• Experience in creating star and snowflake schemas at both conceptual and logical levels

• Experience in writing MDX for customization and querying

• Fundamental understanding of Microsoft Windows security, such as how groups, delegation of credentials, and impersonation function in a security context

• Fundamental understanding of Web-based architecture

• Experience in using the following tools: Microsoft SQL Server BI Development Studio - Microsoft SQL Server Management Studio - Report Builder and Report Manager - Source Code Control (SCC) product

• Possible experience in using the following tools: Microsoft Office Visio - System Monitor

Recommended Course(s) :

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance


Training Materials :

Microsoft Official Courseware (MOC)


Labs :

This Package includes several labs to ensure you will gain the targeted skills and experience


Credential :

Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008: counts as credit toward the following certification(s):

•Microsoft Certified IT Professional (MCITP): Business Intelligence Developer 2008

Category :
DataBase


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.