高薪转行利器 USA LaoTu MSBI2012 SSIS ETL 第9期 6/18/2016 to 07/30/2016

[USA LaoTu Support Team]

誉满全球华人的USA LaoTu MSBI2012 SSIS ETL  第9期  6/18/2016 to 07/30/2016

USA LaoTu 独创高质量MSBI培训课程, 数年来, 始终牢牢坚持以找工作为目标, 业界一线在职数据分析师博士专家团队不懈努力把在北美诸多大公司多年积累的大量高招, 实例, 讲给一批又一批渴望求变并愿意行动的我中华儿女, 使他/她们在美国, 在海外找工作的路走的更顺, 能做会说, 信心满满, 有能力转行, 很快进入大公司高薪好工作, 成为公司BI骨干, 进入中产阶级, 家庭生活更幸福.  上课同学们都说:  USA LaoTu MSBI课是找工作的敲门砖, 是快速转行挣高薪的必修课. 别处都没有, 别处做不到.

Registration link. After register, student will get previous class material, access previous class video, and join this new online live class.

MSBI2012 Term9 SSIS ETL   6/18/2016 to 07/30/2016

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

Sat, Jun 18, 2016 8:00 AM - 12:00 PM PDT  Dr. Shelly SSIS Labs and Real Work experience
Sat, Jun 25, 2016 8:00 AM - 12:00 PM PDT  Dr. Shelly SSIS Labs and Real Work experience
Sat. Jul 02, 2016 No class
Sat, Jul 09, 2016 8:00 AM - 12:00 PM PDT  Dr. Diane  SSIS Real Work experience
Sat, Jul 16, 2016 8:00 AM - 12:00 PM PDT   Dr. Diane  SSIS Real Work experience
Sat, Jul 23, 2016 8:00 AM - 12:00 PM PDT  Dr. Shin SSIS Real Work experience
Sat, Jul 30, 2016 8:00 AM - 12:00 PM PDT  Dr. Shin SSIS Real Work experience

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课，诸多工作在北美业界的老师们充满爱心，把工作经验传授给学生。近千的学生成功转行，不用再读学位，不用考证，顺利高薪进入大公司。

只要你有颗求变的心，并愿意付出行动，USA Laotu 独创转行捷径体系必将你改变。
今天注册课，今天就可看讲课视频，开启你的高薪转行之路。
More questions?
Feel free call 408.707.3887.
Or, come join our Monday night Questions and Answers webinar:
请来参加 USA LaoTu 主持： 周一美西六点半，海外华人公益职场问答网会。

交流与求职，跳槽，在公司有关的任何问题，实实在在问，实实在在答。
海外华人任何有问题的人都能问，任何有经验的热心人都可答。
帮我华人求职, 助我华人工作.
咱参与， 咱奉献，咱健康， 咱高兴！

Monday: 06:30pm to 07:30pm USA PST,  California time
Monday: 09:30pm to 10:30pm USA EST,  New York time
Tuesday: 08:30am to 9:30am Beijing time 北京时间周二上午八点半

周一美西六点半，海外华人公益职场问答网会

This webinar give you the opportunity to ask Dr. LaoTu questions and learn from questions being asked by other people.

Please Plan to Participate on the 周一美西六点半，海外华人公益职场问答网会 Monday,  from 6:30 PM - 7:30 PM PST (9:30 PM – 10:30 PM EST).

Registration URL: https://attendee.gotowebinar.com/register/944962440628708610

[USA LaoTu Support Team]

MSBI2012 Term9 SSIS ETL   6/18/2016 to 07/30/2016

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

Sat, Jun 18, 2016 8:00 AM - 12:00 PM PDT  Dr. Shelly SSIS Labs and Real Work experience
Sat, Jun 25, 2016 8:00 AM - 12:00 PM PDT  Dr. Shelly SSIS Labs and Real Work experience
Sat. Jul 02, 2016 No class
Sat, Jul 09, 2016 8:00 AM - 12:00 PM PDT  Dr. Diane  SSIS Real Work experience
Sat, Jul 16, 2016 8:00 AM - 12:00 PM PDT   Dr. Diane  SSIS Real Work experience
Sat, Jul 23, 2016 8:00 AM - 12:00 PM PDT  Dr. Shin SSIS Real Work experience
Sat, Jul 30, 2016 8:00 AM - 12:00 PM PDT  Dr. Shin SSIS Real Work experience

[USA LaoTu Support Team]

MSBI2012 SSIS ETL 第九期 6/18/2016 to 7/30/2016
8:00 to 12:00 Noon (USA PST) Saturday

6/18, 6/25 　Dr. Shelly  SSIS Labs and Real Work experience
7/2, 　　　　 No Class
7/9, 7/23 　  Dr. Diane  SSIS Real Work experience
7/23, 7/30 　Dr. Shin    SSIS Real Work experience

课程内容：

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


MSBI2012 SSAS SSRS 第九期 8/6/2016 - 9/24/2016
8:00 to 12:00 Noon (USA PST) Saturday

8/6/2016    Lina (SSAS)
8/13/2016  Lina  (SSAS)
8/20/2016  Catherine
8/27/2016  Catherine
9/03/2016  USA Labor Day, NO class
9/10/2016  Regina
9/17/2016  Catherine
9/24/2016  Melody
10/1/2016 Catherine

课程内容：

Lina SSAS Class one (4 Hours):
0. SSAS Database Overview
1. Create the Data Source  connection and the data view
2. Create a cube by using the cube wizard
3. Create cube dimensions
4. Format settings in the cube editor
5. Add measures and dimensions

Lina SSAS  Class two(4 Hours):
6.1. Cube calculation and KPIs
6.2 MDX language
7. Data Mining
8. SSAS Reporting – Real Industry Experiences
9. SSAS Processing- Real Industry Experiences
10. SSAS Migration- Real Industry Experiences

Catherine SSRS First Class (4 Hours):
Original labs and demos
Lab1 Employee report(Table report)
Lab2 Product Report(Using Wizard)
Lab3 Sales by Region(Matrix Report using OLAP)
Lab4 Parameter Report
Lab5 Sales By Geography(use MDX Query Designer and pulling data from Cube)
Lab6 Dashboard
Cascading parameters report
Formatting grouping report
Dynamic columns report
Building report with custom code and page break control
building report contains looked up value field
building report template

Catherine SSRS Second Class(4 Hours)
(SSRS real industry experiences)
Part 1. SSRS passing multi valued parameter to Stored Procedure
Part 2. SQL query tip
  Date range
  Use parameter to control filter
Part 3. Sample report
   Start from business Report design
   Production report – use list to create free form report, control visibility, format group, add row number
   Open AR report – Use case when to age invoices, conditional shading, interactive sorting
 Part 4. Deploy report to different environment (Configuration manager)
 Part 5. Report performance – report and shared dataset caching

Regina
Coming soon…..

Catherine
How to configure the report server
Deployment and Manage Reports
Access, Deliver, and Monitor Report
Data-driven subscription
In this lesson, you use the data-driven subscription pages to connect to a subscription data source, build a query that retrieves subscription data, and map the result set to report and delivery options.

Melody  SSRS  (4 Hours):
Industry reporting life cycle
Data validation process in report development
Health Care Industry Sample Reports (Detail, Matrix, Charts)
Using SSRS expression to diagnose business challenges
MDX report from SSAS Cube

Catherine  SSRS  (4 Hours):
(SSRS real industry experiences)
Three new SSRS report in real work
Example of SSRS List report;
Grouping in SSRS Matrix report.
Some daily using SSRS expressions and tips

[USA LaoTu Support Team]

同学们都说： MSBI2012 技术是高薪转行数据分析师工作的敲门砖。
第九期MSBI2012课，是学习MSBI技术的最好机会。
SSIS ETL，公共讲六次课，每次四个小时。
学生不仅学到MSBI SSIS ETL 的基本技术，还看到很多工作中的实际例子。

注册MSBI2012课后，可以得到一年看原来核心课的录像，和参加周三的求职辅导周会。

[USA LaoTu Support Team]

MSBI2012 SSIS ETL Data Warehouse online live class starting this morning.

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

学完这门课后，紧接着就是 MSBI SSAS SSRS 课。
http://www.usalaotu.com/forum/index.php?topic=8377.0

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

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