PoÄŤĂ­taÄŤová škola GOPAS  

Gopas CZ 
Gopas SK 
   
     Site map · Advanced search 
Offer of courses » Databases » Microsoft SQL Server » Microsoft SQL Server 2005 » Microsoft SQL Server 2005/2008 – Business Intelligence – the Path to Success
Offer of courses » Databases » Microsoft SQL Server » Microsoft SQL Server 2008 » Microsoft SQL Server 2005/2008 – Business Intelligence – the Path to Success
Offer of courses » Databases » Microsoft SQL Server » Microsoft SQL Server 2008 R2 » Microsoft SQL Server 2005/2008 – Business Intelligence – the Path to Success


   print

GOC34 - Microsoft SQL Server 2005/2008 – Business Intelligence – the Path to Success

This two-day course is intended for everyone who wants to learn about the principles and use of Business Intelligence to support decision-making in the strategic management of an organisation. This is introductory course in the BI world on the Microsoft platform.

Who the course is for

For everyone who wants to learn how to sort data effectively and how to process it in order to mine essential information for a firm’s strategic decision–making.

What we teach you

  • We will familiarise you with the fundamental principles of Business Intelligence
  • You will learn about preparation, planning and analysis
  • You will learn about BI solutions design
  • You will learn about ETL implementation
  • You will learn about OLAP implementation
  • You will learn about client applications implementation
  • You will learn about other BI applications and uses

    Required skills

    Basic knowledge of T–SQL and relational databases

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    Books published by specialist publishers.

    Course syllabus

    Introduction to Business Intelligence

    • Why?
    • Basics of Data Warehousing.
    • What is what in the BI world.
    • Introduction to building BI projects on SQL Server 2005/2008

    Integration Services

    • Creating simple package
    • Implementing control flow
    • Implementing data flow

    Reporting Services

    • Authoring Reports
    • Publishing Reports
    • Reporting services capabilities

    Analysis Services

    • Building and deploying Analysis Services solution
    • Analysis services capabilities

    Data Mining

    • Why?
    • Terms in Data Mining

    Clients

    • Excel 2007
    • Performance Point Server 2007 demontration

    • Recommended prior courses

    MOC 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact–SQL

    Recommended subsequent courses

    MOC 2791 - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
    MOC 2792 - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
    MOC 2793 - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
    MOC 6234 - Microsoft SQL Server 2008 Analysis Services
    MOC 6235 - Microsoft SQL Server 2008 Integration Services
    MOC 6236 - Microsoft SQL Server 2008 Reporting Services

    Catalog price of course and handbook

    Locality Course price ex VAT Price of handbook ex VAT Number IT points
     Praha   7800 Kč  --   20 items
     Brno   7600 Kč  --   20 items

    Course dates

    Course date Course length Locality Price ex VAT Handbook ex VAT  Speaker language  
     21.10.2010   2   GOPAS Praha   7800 Kč included in course price Course Guaranteed course date
     03.02.2011   2   GOPAS Praha   7800 Kč included in course price Course
     26.04.2011   2   GOPAS Praha   7800 Kč included in course price Course Guaranteed course date
     22.12.2010   2   GOPAS Brno   7600 Kč included in course price Course
     08.12.2010   2   GOPAS Bratislava   260 EUR included in course price Course
     20.01.2011   2   GOPAS Bratislava   260 EUR included in course price Course
     29.03.2011   2   GOPAS Bratislava   260 EUR included in course price Course

    If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).