Author Topic: MSBI2016-1 SSIS ETL 第13期 Sat 9/22/2018 - 10/27/2018  (Read 1627 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
MSBI2016-1 SSIS ETL 第13期 Sat 9/22/2018 - 10/27/2018
« on: January 08, 2018, 06:54:46 PM »
MSBI2016-1 SSIS ETL 第13期  Sat 9/22/2018 - 10/27/2018

8:00 to 12:00 Noon (USA PST) Saturday

Sat, Sep 22, 2018 8:00 AM - 12:00 PM PDT

Sat, Sep 29, 2018 8:00 AM - 12:00 PM PDT

Sat, Oct 6, 2018 8:00 AM - 12:00 PM PDT

Sat, Oct 13, 2018 8:00 AM - 12:00 PM PDT

Sat, Oct 20, 2018 8:00 AM - 12:00 PM PDT

Sat, Oct 27, 2018 8:00 AM - 12:00 PM PDT

MSBI2012 Courses 课程试听:
昔日生物Lab生物夫妻,今日夫妻俩都是大公司BI专家。 Dr. Shelly 充满爱心向同学们传授业界BI技术,帮大家转行。
MSBI 2012 Term7  SSIS ETL class1 2015-10-10, Dr. Shelly 老师讲授 MSBI 入门课 视频剪集。


MSBI 2012 第六期 SSRS_class4_20150919 课程视频剪集。
Melody老师从文科背景转行为BI Developer, 又成为 BI Architect。


大家都知道: USA LaoTu MSBI课,诸多工作在北美业界的老师们充满爱心,把工作经验传授给学生。近千的学生成功转行,不用再读学位,不用考证,顺利高薪进入大公司。

USA Laotu 课,开创华人高薪转行捷径,把成千求变爱家人高薪送入大公司。

在职美国大公司MSBI SSIS ETL 博士专家团队详细讲解MSBI  SSIS ETL  Data Warehouse  基础知识和工作实际例子。
即使你感兴趣做Reporting,理解数据来源,数据采集,存储的过程,对你的面试和工作也非常重要。

学完这门课后,紧接着就可以学 MSBI SSAS SSRS 课。

凡有求变之心并愿意行动的同学,这是一个绝好的机会。
这门有多位北美在职MSBI业界专家团队教授的课把成批的爱家男女送进大公司挣高薪。别人行,你也行。

聪明华人求职转行都找美国老土,每天课每周两网会,别处都没有。
成千爱家男女很快高薪进大公司,家庭幸福生活更好,你也能做到。

课程内容:

CLASS 1st 4 hour
   ETL Working Environment
   SSIS lab 1-3 Demo
Lab1 Introduction the data flow.
Lab2 Introduction the work flow.
Lab3 Data transformation in Data flow.

CLASS 2nd  4 hour:
     SSIS lab 4-6 Demo
Lab4 Dynamically loading data.
Lab5 Loading Dimension table using SCD.
Lab6 Loading Fact table using Dimension Lookup.

CLASS 3Rd 4 hour:
SSIS Expressions
     We will first introduce basic functions used in SSIS expressions, then give tips and tricks of common used SSIS expressions in ETL. We will demo how to leverge SSIS expressions to output files with special requirements for header/footer and to clean up files with special rows.
Through the demos, you will learn
to bring more dynamic powers to SSIS packages by SSIS expression and script tasks
to use as project/package parameters/variables
to debug and fix errors

CLASS 4th 4 hour:
SSIS Parent Child Design Pattern
SSIS Package/Project Deployment and SSIS Catalog
SSIS Logging and Monitoring

CLASS 5th 4 hour:
         MSBI and SSIS Historical Overview
         ETL Environment
         SSIS package design pattern
         Advanced Topic--Data warehouse Loads:
          Audit table creation and ETL
          Dimension/Fact Table loads in DW
             (Profiling task, ETL audit, master-child packages for data Extraction, Transformation and Loading)
           Incremental Load (control table, CDC and Hash)         

CLASS 6th 4 hour:
    Flat File Data analysis---Unstructured Data File Properties
         Lab 1:  Web Log project
            1. Diana and lucky's SSIS Package
            2. T-SQL
            3. C# scripting
    Text Mining skills:
          Lab 2: Term Extraction
          Lab 3: Term Lookup

    How to Extend SSIS Package with C# . NET Scripting (Script Task and Script Component)
       -- Brief Introduction to C# . NET Scripting in SSIS
       -- SSIS Sample package designs for >10+ types of Flat files (ETL loads) in real work.
       -- 10 Labs for different flat files loading
       -- Summary: ETL design patterns:
           Compare Web Log data loads with advanced Diana and lucky's SSIS Package, T-SQL,  and C# methods



USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
Re: MSBI2016-1 SSIS ETL 第13期 Sat 9/22/2018 - 10/27/2018
« Reply #1 on: February 10, 2018, 04:17:58 PM »
To help the new Core Package students who also registered MSBI SSISETL (they are using SQL Server 2016 now), we added one session on Sunday Feb 11, 8:00 - 9:00, Dr. LaoTu explained step by step about how to install SSDT on SQL Server 2016.
The class video is available on student's class web page: ssisetl_term12_class2
Please watch class video.


USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
Re: MSBI2016-1 SSIS ETL 第13期 Sat 9/22/2018 - 10/27/2018
« Reply #2 on: September 18, 2018, 07:47:17 PM »
SSIS ETL 第13期 Sat 9/22/2018 - 10/27/2018
Tentative Course Schedule

CLASS 1st 4 hour:
SSIS lab Demo
Lab1: Introduction of the data flow and development environment.
Lab2: Introduction of the control flow and three types of containers in control flow.
Lab3: Introduction of common tools in data flow.
Lab4: Introduction of variables, parameters, and expressions with a demo of dynamically loading data files.

CLASS 2nd 4 hour:
SSIS lab Demo
Lab5: Loading Dimension tables using SCD and merge command in SQL. Introduction of data warehousing and different types of slowly change dimensions.
Lab6: Loading Fact tables using Dimension Lookup.
Lab7: Loading marketing mailing list by using Conditional Splits, Lookup transformations, Union all and Row Count auditing mechanism.
Lab8: Decoding error detailed information by using script components and new functions in SSIS 2016.

CLASS 3rd 4 hour:

SSIS Expressions and Design Pattern
     We will first introduce basic functions used in SSIS expressions, then give tips and tricks of common used SSIS expressions in ETL to make ETL package more dynamic.
Lab 9: Loading currency tables with deduping
Lab 10: Extracting data and generating output files with headers and footers
Lab 11: Importing files with data cleansing by removing error rows using script tasks
Lab 12: Design Pattern: Loading staging tables.

CLASS 4th 4 hour:
Lab 13: Design Pattern: Loading from staging tables to Data warehouse.
Lab 14: Design Pattern: Introduction of Package Part in SSIS 2016 to encourage reusability.
Lab 15: Design Pattern: Parent child design pattern to dynamically control loading orders and tables.
SSIS Package/Project Deployment and SSIS Catalog
SSIS Logging and Monitoring

CLASS 5th 4 hour:
         MSBI and SSIS Historical Overview
         ETL Environment
         SSIS package design pattern
         Advanced Topic--Data warehouse Loads:
          Audit table creation and ETL
          Dimension/Fact Table loads in DW
             (Profiling task, ETL audit, master-child packages for data Extraction, Transformation and Loading)
           Incremental Load (control table, CDC and Hash)       


CLASS 6th 4 hour:
    Flat File Data analysis---Unstructured Data File Properties
         Lab 1:  Web Log project
            1. Diana and lucky's SSIS Package
            2. T-SQL
            3. C# scripting
    Text Mining skills:
          Lab 2: Term Extraction
          Lab 3: Term Lookup

    How to Extend SSIS Package with C# . NET Scripting (Script Task and Script Component)
       -- Brief Introduction to C# . NET Scripting in SSIS
       -- SSIS Sample package designs for >10+ types of Flat files (ETL loads) in real work.
       -- 10 Labs for different flat files loading
       -- Summary: ETL design patterns:
           Compare Web Log data loads with advanced Diana and lucky's SSIS Package, T-SQL,  and C# methods