EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

Speedminer Data Warehouse And Business Intelligence Training

Course outline

5 days
Discuss this programme →

Duration

5 days

Objective

To provide core practical hands-on experience that helps MINDEF’s developers get acquainted with Data Warehouse and Business Intelligence Solution. The training will keep them actively engaged during the length of the course. It covers the basics of Speedminer System particularly in mapping operational data to a data warehouse and designing a BI solution for a business problem.

Target Audience

MINDEF developers

Syllabus

Day

Syllabus

Time : 9:00 a.m to 4:30 p.m

Setup & Installation

  • IRIS database installation & setup
  • Speedminer installation & configuration

Database Training

  • Speedminer Studio, technical walkthrough and training
  • Lessons on creating database, namespace, mapping & configuration. Trainees will learn how to set the namespace, database and then creating the relevant mapping to the databases.
  • Exercise

Time : 9:00 a.m to 4:30 p.m

ETL(Extract, Load and Transfer)

  • Extract Transfer Load(ETL)
  • Performing the ETL
  • Scheduler
  • Abstract Data Type
  • Business Terminology
  • Data Browser
  • Dimension Relationship
  • Exercise and Hand on continue to pull the tables, loading the data and testing for success.
  • the dimensions
  • Correction

Time : 9:00 a.m to 4:30 p.m

Creation of Dimension

  • Building and developing the dimensions for analysis.
  • Identifying the fields, conditions and rules to formulate the dimensions.
  • Exercise
  • Design And Build the dimensions
  • Correction

Creation of Analysis

  • Analysis
  • Analysing the data that has been rebuild and understanding the data for pivot, chart and reporting purpose
  • Exercise
  • Design And Build
  • Correction

Time : 9:00 a.m to 4:30 p.m

Creation of Pivot Table

  • Pivot table
  • Creation of the pivot table for the dashboard.
  • Exercise
  • Design And Build
  • Correction

Charting

  • Charting, creating chart and building them into dashboards.
  • Identifying the correct charts and suitable displays.
  • Exercise
  • Design And Build
  • Correction

Time : 9:00 a.m to 4:30 p.m

Creation of Dashboard

  • Dashboard design and the approach
  • Creating filters and triggers for the dashboards.
  • Exercise
  • Design And Build
  • Correction

Support and Maintenance

  • Administration
  • User Preferences
  • Performance Tuning (Adjacent Bit-Matrix Reorder)

Programme scope, delivery arrangements and suitability are confirmed during enquiry.