Course code: GOC341« Back

Get Your Data Under Control

The course deals with aspects of working with Business Intelligence solutions from the perspective of users. It outlines ways to effectively use Excel, retrieve data using preparer in the form of Gemini, succeeding in a shared environment with SharePoint. The course is intended for those who already using BI solutions and want to streamline their procedures. It is also suitable for introduction to the possibilities that the current platform SQL Server 2008/2008 R2 provides.

GOPAS Official Curriculum This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department ( or business department (

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 10 400 CZK included in course price 20
Brno2 10 400 CZK included in course price 20
Bratislava2 420,00 EUR included in course price 20

User intensity level


Printed presentation

Course Outline

Introduction to Business Inteligence

  • What is BI ?
  • Utilization data using BI
  • Tools used for BI

Data analysis in Excel using PivotTables

  • Use PivotTable
  • Analysis data cubes using pivot table
  • KPI in Excel

Uncovering hidden connections in Excel

  • What is datamining?
  • Datamining models
  • Datamining addin in MS Excel

Data presentation

  • Report creation in Report Builder 2.0/3.0
  • Use of geographic data in reports
  • Presentation of a report on the Web

Browsing data using PowerPivot

  • Import data from different sources
  • Data analysis using PowerPivotu
  • Sharing analysis with PowerPivot

BI on Sharepoint 2010

  • Reporting by Sharepoint
  • Powerpivot in Sharepoint
  • Create scorecards and dashboards with Web components

Previous courses

no preceding courses

Next courses

no following course
Tištěné nebo elektronické studijní materiály GOPAS

included in course price
The prices are without VAT.