Training with Iverson classes

Training is not a commodity – all training centres are not the same. Iverson Associates Sdn Bhd is the most established, the most reputable, and the top professional IT training provider in Malaysia. With a large pool of experienced and certified trainers, state-of-the-art facilities, and well-designed courseware, Iverson offers superior training, a more impactful learning experience and highly effective results.

At Iverson, our focus is on providing high-quality IT training to corporate customers, meeting their learning needs and helping them to achieve their training objectives. Iverson has the flexibility to provide training solutions whether for a single individual or the largest corporation in a well-paced or accelerated training programme.

Our courses continue to evolve along with the fast-changing technological advances. Our instructor-led training services are available on a public and a private (in-company) basis. Some of our courses are also available as online, on demand, and hybrid training.

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.a

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.a

Additional Info

  • Certification Course & Certificate
  • Course Code MS20466
  • Price RM3983
  • Exam Price Exclude
  • Exam Code 70-466
  • Duration 4 Days
  • Principals Microsoft
  • Schedule

    1-4 Oct 2018

  • Audience

    This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:

    • Implementing analytical data models, such as OLAP cubes.
    • Implementing reports, and managing report delivery.
    • Creating business performance dashboards.
    • Supporting data mining and predictive analysis.
  • Prerequisities

    This course requires that you meet the following prerequisites:

    • At least 2 years’ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
    • Some exposure to basic programming constructs (such as looping and branching).
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • At Course Completion

    After completing this course, students will be able to:

    • Describe the components, architecture, and nature of a BI solution.
    • Create a multidimensional database with Analysis Services.
    • Implement dimensions in a cube.
    • Implement measures and measure groups in a cube.
    • Use MDX Syntax.
    • Customize a cube.
    • Implement a Tabular Data Model in SQL Server Analysis Services.
    • Use DAX to enhance a tabular model.
    • Create reports with Reporting Services.
    • Enhance reports with charts and parameters.
    • Manage report execution and delivery.
    • Implement a dashboard in SharePoint Server with PerformancePoint Services.
    • Use Data Mining for Predictive Analysis. 
  • Module 1 Title Introduction to Business Intelligence and Data Modeling
  • Module 1 Content

    As a SQL Server database professional, you may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that you have a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that you can use to implement the solution.


    • Introduction to Business Intelligence
    • The Microsoft Enterprise BI Platform

    Lab : Exploring a BI Solution

    After completing this module, you will be able to:

    • Describe the elements of a typical BI solution.
    • Select appropriate Microsoft technologies for a BI solution.
    • Describe key considerations for planning a BI project.
  • Module 2 Title Creating Multidimensional Databases
  • Module 2 Content

    This module provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube.


    • Introduction to Multidimensional Analysis
    • Creating Data Sources and Data Source Views
    • Creating a Cube
    • Overview of Cube Security

    Lab : Creating a Multidimensional Database

    After completing this module, you will be able to:

    • Describe the considerations for a multidimensional database.
    • Create data sources and data source views.
    • Create a cube.
    • Implement security in a multidimensional database.
  • Module 3 Title Working with Cubes and Dimensions
  • Module 3 Content

    This module describes how to create and configure dimensions and dimension hierarchies in an Analysis Services multidimensional data model.


    • Configuring Dimensions
    • Defining Attribute Hierarchies
    • Sorting and Grouping Hierarchies

    Lab : Working with Cubes and Dimensions

    After completing this module, you will be able to:

    • Configure dimensions.
    • Define attribute hierarchies.
    • Sort and group attributes.
  • Module 4 Title Working with Measures and Measure Groups
  • Module 4 Content

    This module describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures.


    • Working with Measures
    • Working with Measure Groups

    Lab : Configuring Measures and Measure Groups

    After completing this module, you will be able to:

    • Configure measures.
    • Configure measure groups.
  • Module 5 Title Introduction to MDX
  • Module 5 Content

    This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.


    • MDX Fundamentals
    • Adding Calculations to a Cube
    • Using MDX to Query a Cube

    Lab : Using MDX

    After completing this module, you will be able to:

    • Describe MDX.
    • Add calculations to a cube.
    • Describe how to use MDX in client applications.
  • Module 6 Title Customizing Cube Functionality
  • Module 6 Content

    This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations.


    • Implementing Key Performance Indicators
    • Implementing Actions
    • Implementing Perspectives
    • Implementing Translations

    Lab : Customizing a Cube

    After completing this module, you will be able to:

    • Implement Key Performance Indicators.
    • Implement Actions.
    • Implement Perspectives.
    • Implement Translations.
  • Module 7 Title Implementing an Analysis Services Tabular Data Model
  • Module 7 Content

    This module describes Analysis Services tabular data models and explains how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio.


    • Introduction to Tabular Data Models
    • Creating a Tabular Data Model
    • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

    Lab : Implementing an Analysis Services Tabular Data Model

    After completing this module, you will be able to:

    • Describe Analysis Services tabular data model projects.
    • Implement an Analysis Services tabular data model.
    • Use an Analysis Services tabular data model.
  • Module 8 Title Introduction to Data Analysis Expression (DAX)
  • Module 8 Content

    This module explains the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models.


    • DAX Fundamentals
    • Using DAX to Create calculated Columns and Measures in a Tabular Data Model

    Lab : Creating Calculated Columns and Measures by using DAX

    After completing this module, you will be able to:

    • Describe the fundamentals of DAX.
    • Use DAX to create calculated columns and measures.
  • Module 9 Title Implementing Reports with SQL Server Reporting Services
  • Module 9 Content

    This module introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports.


    • Introduction to Reporting Services
    • Creating a Report with Report Designer
    • Grouping and Aggregating Data in a Report
    • Showing Data Graphically
    • Filtering Reports Using Parameters

    Lab : Creating a Report with Report Designer

    After completing this module, you will be able to:

    • Describe the key features of Reporting Services.
    • Use Report Designer to create a report.
    • Group and aggregate data in a report.
    • Publish and view a report.
  • Module 10 Title Automating Report Execution and Delivery
  • Module 10 Content

    This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports.


    • Managing Report Security
    • Managing Report Execution
    • Delivering Reports with Subscriptions and Data Alerts
    • Troubleshooting Reporting Services

    Lab : Implementing Report Subscriptions

    After completing this module, you will be able to:

    • Configure security settings for a report server.
    • Configure report execution settings to optimize performance.
    • Use subscriptions and alerts to automate report and data delivery.
    • Troubleshoot reporting issues.
  • Module 11 Title Delivering BI with SharePoint PerformancePoint Services
  • Module 11 Content

    This module introduces Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services.


    • Introduction to SharePoint Server as a BI Platform
    • Planning Security for a SharePoint Server BI Solution
    • Planning for PerformancePoint Services

    Lab : Implementing PerformancePoint Services

    After completing this module, you will be able to:

    • Describe SharePoint Server as a BI platform.
    • Use PerformancePoint Services to deliver BI functionality.
    • Configure PerformancePoint Data Sources.
    • Create Reports, Scorecards, and Dashboards.
  • Module 12 Title Performing Predictive Analysis with Data Mining
  • Module 12 Content

    This module introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Microsoft Excel, and how to incorporate data mining results into Reporting Services reports.


    • Overview of Data Mining
    • Using the Data Mining Add-in for Excel
    • Creating a Custom Data Mining Solution
    • Validating a Data Mining Model
    • Connecting to and Consuming Data Mining Data

    Lab : Using Data Mining to Support a Marketing Campaign

    After completing this module, you will be able to:

    • Describe the key data mining concepts and use the Data Mining Add-ins for Excel.
    • Create a data mining solution.
    • Validate data mining models.
    • Use data mining data in a report.
* Training Dates:



Venue: Online | Duration: 30 minutes

Working in the IT industry is a true challenge
With the ever-growing IT complexity and integration of business processes, the continuous transformation of IT has reached levels never seen before and to keep up with all the changes is truly demanding.
This has led to a serious shortage of IT workers with relevant skills and updated knowledge on the changes in the industry who are able to select and implement the right technologies needed to ensure the sustainability of the business for the next 3 to 5 years. The high demand for these skilled IT workers is still growing and becoming more critical than ever before. It is imperative that IT professionals continue updating themselves and provide value to their organisations.
EPI IT Training Framework
EPI has developed the first and only vendor-neutral competency-based IT Training Framework in the world to address the need for IT competency training and certification for IT professionals to keep up-to-date and remain relevant. It is also the first and only IT Training Framework which is aligned with the European e-Competence Framework (e-CF) which links job roles to competence requirements.
(Certified IT Specialist)

CITS is the second course in the EPI IT Training Framework. It is a 3-day course designed to teach the skills, knowledge and competences required of the modern IT specialist working at the senior professional, team-leader, supervisor and management level in IT management.
Passing the CITS exam will earn you the globally recognised CITS certification from EXIN. This certificate proves that you have the competences required to provide leadership and take responsibility for team performances and development in unpredictable environments using innovative methods.  You will be able to place yourselves above your peers, delivering added value to your organisation. 
Target audience
- IT professionals/managers who have a need to understand the current IT requirements and core competences for managing IT in mission-critical environments
- IT professionals with 2-4 years working experience, who wants to take their career to the next level
- IT/HR/L&D Managers who are looking for a high-quality training for their IT managers/team leaders

Managing Director, EPI Malaysia
Being active in the IT and Data Centre industry for more than 25 years, Jan has in-depth knowledge and expertise on running mission critical operations. Jan is a Dutch national currently living in Malaysia. Before joining EPI, Jan has extensive work experience in the areas of service desk, system and network, audit and compliance, and security management. He has worked in sectors such as government, commercial and non-profit. Jan brings with him experience in various management positions, including working in large financial institutions where efficiency and effectiveness of IT operations are of the highest priority and failure/downtime was not an option.

Get a preview of the CITS course. Register now!
Date/Time: 4 October  2018; 16:00-16:30 Kuala Lumpur/ Singapore (View in your local time)

Systems Operations on AWS

Next training date available: 26-28 September 2018

In this course, you will create automatable and repeatable deployments of networks and systems on the AWS platform. We will explore the AWS features and tools related to configuration and deployment and common techniques for configuring and deploying systems.

This course is intended for:

  • System administrators
  • Software developers in a DevOps role

Course Objectives
In this course, you will learn how to:

  • Use standard AWS infrastructure features such as Amazon Virtual Private Cloud (Amazon VPC), Amazon Elastic Compute Cloud (Amazon EC2), Elastic Load Balancing (ELB), and AWS Auto Scaling from the command line
  • Use AWS CloudFormation to produce stacks of AWS resources that can be deployed in an automated, repeatable fashion
  • Build functioning virtual private networks (VPNs) with Amazon VPC using the AWS Management Console
  • Deploy Amazon EC2 instances using command line calls and troubleshoot common problems with instances
  • Monitor the health of Amazon EC2 instances and other AWS services
  • Manage user identity, AWS permissions, and security in the cloud
  • Manage resource consumption in an AWS account using Amazon CloudWatch, tagging, and AWS Trusted Advisor
  • Select and implement the best strategy for creating reusable Amazon EC2 instances
  • Configure a set of Amazon EC2 instances that launch behind a load balancer, with the system scaling up and down in response to demand
  • Edit and troubleshoot a basic AWS CloudFormation stack definition

We recommend that attendees of this course have the following prerequisites: 

  • AWS Technical Essentials
  • Background in software development or systems administration
  • Experience maintaining operating systems at the command line, such as PowerShell for Linux, cmd, or Windows PowerShell
  • Basic knowledge of networking protocols, such as TCP/IP and HTTP

For more information on the course outline, please click here.

Click This email address is being protected from spambots. You need JavaScript enabled to view request for quotation from salesperson.


Contains: PDF course guide, as well as a lab environment where students can work through demonstrations and exercises at their own pace.


This course provides training to new administrators on the fundamental tasks of installing and configuring IBM Cognos Analytics, and administering servers and content in the environment. In the course, participants will install and configure the IBM Cognos Analytics software, implement security, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.


If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

Additional Info

  • Certification Course only
  • Course Code J4055G
  • Price RM 6000
  • Exam Price Exclude
  • Duration Online
  • Principals IBM
  • Audience


  • Prerequisities

    * Knowledge of Web application server architectures

    * Security systems administration

    * Experience using basic Windows functionality

    * Experience using a Web browser

    * Knowledge of your business requirements

  • Module 1 Title Introduction to IBM Cognos Analytics administration
  • Module 1 Content

    Identify and explain the:

    * IBM Cognos Analytics enterprise components

    * role of the Administrator in relation to the IBM Cognos Analytics administration workflow process

    * role of IBM Cognos Administration and IBM Cognos Configuration

  • Module 2 Title Identify IBM Cognos Analytics architecture
  • Module 2 Content

    Identify and explain:

    * the features of the IBM Cognos Analytics architecture

    * the three architectural tiers

    * IBM Cognos Analytics servlets and services

    * the default servlet container and alternatives to its use

    * an example of IBM Cognos Analytics request processing

    * installation options

    * load balancing mechanisms

    * configuration options

    * the IBM Cognos Application Firewall

  • Module 3 Title Secure the IBM Cognos Analytics environment
  • Module 3 Content

    * Identify the IBM Cognos Analytics security model
    * Define authentication in IBM Cognos Analytics
    * Define authorization in IBM Cognos Analytics
    * Identify security policies
    * Secure the IBM Cognos Analytics environment


  • Module 4 Title Administer the IBM Cognos Analytics server environment
  • Module 4 Content

    * Describe the tasks required to administer the IBM Cognos Analytics server environment

    * Perform administrative tasks using IBM Cognos Administration

    * Manage dispatchers and services

    * Examine the log message facility

    * Tune performance of servers

    * Identify issues while troubleshooting the server environment

    * Identify the IBM Cognos Analytics backup strategy

    * Administer dynamic cubes


  • Module 5 Title Manage run activities
  • Module 5 Content

    * Manage current, upcoming, and past activities

    * Manage schedules

    * Enable and disable schedules

    * Set queue priority for schedules

    * Suspend a schedule until a later time

  • Module 6 Title Manage content in IBM Cognos Administration
  • Module 6 Content

    * Add a data source

    * Manage visualizations in the Library

    * Plan and perform a deployment

    * Identify how to maintain the IBM Cognos Analytics content store

    * Identify other content management considerations

  • Module 7 Title Additional configuration and customization
  • Module 7 Content

    * Manage user profiles

    * Identify how to manage packages through the IBM Cognos Analytics portal

  • Module 8 Title Overview of IBM Cognos Analytics (optional)
  • Module 8 Content

    * Describe IBM Cognos Analytics and its position within an Analytics solution

    * Describe IBM Cognos Analytics components

    * Describe IBM Cognos Analytics at a high level

    * Describe IBM Cognos Analytics security at a high level

    * Explain how to extend IBM Cognos Analytics

  • Module 9 Title IBM Cognos Analytics for consumers (optional)
  • Module 9 Content

    * Use published reports

    * Run reports with options

    * Personalize how content appears

    * Manage human tasks

    * Collaborate with IBM Connections

    * Access shared content

  • Module 10 Title Drill-through definitions (optional)
  • Module 10 Content

    * Discuss parameter-driven drill through

    * Discuss dynamic drill through

    * Set up package-based drill-through definitions

    * Set scope

    * Use the Drill Through Assistant

  • Module 11 Title End-to-end workshop (optional)
  • Module 11 Content

    * An exercise covering some of the major administrative functionality in the IBM Cognos Analytics 11.0 product.

* Training Dates:

We are using cookies to give you the best experience on our site. By continuing to use our website without changing the settings, you are agreeing to use of cookies.
Ok Decline