SQL Server Integration Services

Actual Training

Pelatihan Designing Data Warehouse and Data Visualization with SQL Server & Power BI (Pertamina Trans Kontinental)

Pada tanggal 30 Nov – 3 Des 2021 telah dilangsungkan pelatihan dengan topik Implementasi Data Warehouse and Data Visualization with SQL Server & MS Power BI. Pelatihan ini dilakukan secara offline di Actual Training Yogyakarta. Peserta pelatihan ini berasal dari Pertamina Trans Kontinental, Jakarta.

Adapun materi pada pelatihan ini adalah sebagai berikut:

Understanding the Fundamental Concepts of a Data Warehouse
o Goals of a Data Warehouse Solution
o Introduction to Dimensional Modeling
o Fact Tables and Facts
o Dimension Tables and Dimensions
o Star Schemas

Implementing Fact Tables
o Structure of a Fact Table
o Identifying the Facts
o Identifying the Keys
o Creating and Working with a Transaction Fact Table

Overview of an ETL System
o Types of Data Warehouse Loads
o Creating and Working with the Incremental Loads Table
o Populating a Dimension Table

Advantages of Using an ETL Tool
o Overview of SSIS
o Creating a New SSIS Project
o Creating Connection Managers
o Creating Control Flow Elements
o Creating and Working with Variables
o Adding Precedence Constraints
o Executing a SQL Task with Parameters

Loading a Data Warehouse with SSIS
o Designing Data Flow Elements
o Organizing Data in Containers
o Working with Package Parameters
o Adding Expressions to Tasks
o Deploying a Project in SQL Server

Power BI Fundamental
o Preparing data for Power BI (import, transform, filter)
o Creating data model in Power BI (data model, table relationship, calculation, measure)
o Creating Report (report development workflow, visualization, publication)

Visualizing Data from the Data Warehouse
o Creating a Semantic Layer
o The Multidimensional and Tabular Models
o Creating a Multidimensional Database in SSAS
o Analyzing Data from a SSAS Database
o Creating Interactive Reports
o Creating and Publishing a Report in Power BI
o Study Case from Client

35

Actual Training

Pelatihan Microsoft SQL Server Integration Services and Analysis Services

Pada tanggal 18-20 Maret 2020 telah dilangsungkan pelatihan inhouse dengan topik Microsoft SQL Server Integration Services and Analysis Services. Peserta dari pelatihan kali ini adalah pengembang aplikasi dari PT Focus Inti Solusi, Jakarta. PT Focus Inti Solusi merupakan salah satu perusahan pengembang software yang mempunyai spesialisasi di multifinance dan fintech.

Trainer pada pelatihan ini adalah Bapak Kiki Rizki Noviandi yang merupakan salah satu Microsoft MVP (Most Valuable Professional) di bidang SQL Server.

Adapun materi yang dibahas pada pelatihan ini adalah sebagai berikut:

  • Understand MSBI application development Life Cycle.
  • Understand basic Data Warehousing Concepts.
  • Understand the Concept of OLTP and OLAP.
  • Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • Learn SSIS Architecture, Components of SSIS.
  • Gain complete understanding of different control flow tasks, containers and precedence
    constraints.
  • Learn to work with variables, data types, functions, expressions and parameters and
    providing Dynamism in SSIS.
  • Learn working with event handler, Logging, Configuration Files.
  • Learn Error Handling and Debugging in SSIS.
  • Learn package deployment and project deployment.
  • Gain understanding of Security and Package management.
  • Understand need of OLAP.
  • Learn basic concepts related to OLAP like Cube, Dimension, Measures, Dimension Table,
  • Fact Table, Hierarchies etc
  • Understand Star and Snow Flake Schema.
  • Use SSDT (SQL Server Data Tools) to develop OLAP Database
  • Work with Data Source and data Source View.
  • Develop Cube using Cube Wizard.
  • Create Dimensions using Wizard and Designer.
  • Work with Regular, Snow Flake and Time Dimension
  • Configure Attribute properties, Understand Natural Hierarchies and Unnatural Hierarchies.
  • Work with attribute relationship, Role playing dimension.
  • Work with measure group, adding removing measures.
  • Understand relationships like Fact relationship, referenced relationship etc.
  • Work with Calculation, Named Query and Named Calculation.
  • Work with KPI, Perspective, Translation.
  • Work with Partition, Aggregation.
  • Understand different storage modes like ROLAP, MOLAP and HOLAP
  • Work with Security, Roles
  • Understand Processing and Deployment.
  • Learn MDX (Multidimensional Expressions Language).

1

Actual Training

Pelatihan Microsoft SQL Server Integration Services and Analysis Services (PT EPSON)

Pada tanggal 23-25 Oktober 2019 telah dilangsungkan pelatihan inhouse dengan topik Microsoft SQL Server Integration Services and Analysis Services. Peserta dari pelatihan kali ini adalah pengembang aplikasi dari divisi Sistem Informasi PT EPSON Batam.

Trainer pada pelatihan ini adalah Bapak Kiki Rizki Noviandi yang merupakan salah satu Microsoft MVP (Most Valuable Professional) di bidang SQL Server.

Adapun materi yang dibahas pada pelatihan ini adalah sebagai berikut:

  • Understand MSBI application development Life Cycle.
  • Understand basic Data Warehousing Concepts.
  • Understand the Concept of OLTP and OLAP.
  • Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • Learn SSIS Architecture, Components of SSIS.
  • Gain complete understanding of different control flow tasks, containers and precedence
    constraints.
  • Learn to work with variables, data types, functions, expressions and parameters and
    providing Dynamism in SSIS.
  • Learn working with event handler, Logging, Configuration Files.
  • Learn Error Handling and Debugging in SSIS.
  • Learn package deployment and project deployment.
  • Gain understanding of Security and Package management.
  • Understand need of OLAP.
  • Learn basic concepts related to OLAP like Cube, Dimension, Measures, Dimension Table,
  • Fact Table, Hierarchies etc
  • Understand Star and Snow Flake Schema.
  • Use SSDT (SQL Server Data Tools) to develop OLAP Database
  • Work with Data Source and data Source View.
  • Develop Cube using Cube Wizard.
  • Create Dimensions using Wizard and Designer.
  • Work with Regular, Snow Flake and Time Dimension
  • Configure Attribute properties, Understand Natural Hierarchies and Unnatural Hierarchies.
  • Work with attribute relationship, Role playing dimension.
  • Work with measure group, adding removing measures.
  • Understand relationships like Fact relationship, referenced relationship etc.
  • Work with Calculation, Named Query and Named Calculation.
  • Work with KPI, Perspective, Translation.
  • Work with Partition, Aggregation.
  • Understand different storage modes like ROLAP, MOLAP and HOLAP
  • Work with Security, Roles
  • Understand Processing and Deployment.
  • Learn MDX (Multidimensional Expressions Language).

epson_pak_Kiki_1_thumb[2]