MSBI 2012 Part I: SSIS&ETL 02/25/2014 to 03/13/2014

[USA LaoTu Support Team]

Will start Msbi 2012 part 2 after part 1 finish.
Will publish schedule soon.

[Louis]

 如果我把part2+part2的课都报了，是不是可以听以前的MSBI的录像啊？

[USA LaoTu Support Team]

The Content of MSBI 2008 (SSIS, SSAS, SSRS) and more advanced stuff will be covered in new MSBI 2012 class.

[USA LaoTu Support Team]

MSBI 2012  Part I:  SSIS&ETL   Start 19:00 to 21:00 USA PST, Tuesday Feb 25:

把原有的广受欢迎的MSBI 课的内容进一步扩展，充实，把 SSIS&ETL 单独开课，从基础到实战， 加进工业界的实际项目和二十年SSIS Consultant 的经验精华。成为找工作， 赢MSBI工作的利器。
Click here:  MSBI 2012 Part 1 SSIS ETL class preview.

Will be five 4 hour sessions, total 20 hours:
 
Mr. Wei will teach 18 hours.
Dr. Vivian will teach 2 hours.

Feb 25 (Tue）， 2H,  19:00 to 21:00 USA PST
Feb 27（Thu),  2H,   18:30 to 20:30 USA PST
Mar 1 (Sat), 4H,      08:00 to 12:00 USA PST
March 4(Tue）, 2H    18:30 to 20:30 USA PST
March 6(Thu) , 2H   18:30 to 20:30 USA PST
March 8 (Sat),4H     09:00 to 13:00 USA PST
March 11(Tue), 2H   18:30 to 20:30 USA PST
March 15(Sat), 4H   09:00 to 12:00 USA PST      Dr. Vivian
 
CLASS 1st 4 hour
    ETL Working Environment
    Original SSIS lab 1-4 Demo
    Data Modeling Project 1/5

CLASS 2nd  4 hour:

          Original SSIS lab 4-6 Demo
          Flat file Load—varying column width
           Data Modeling Project 2/5

CLASS 3rd 4 hour:

        Data warehouse: Dimension table ETL
        Truncate and delete in ETL
        How to apply Surrogate Key in Data Warehouse
        Data warehouse: Unique Constrain, migration from DEV to PRO
        Data Modeling Project 3/5

CLASS 4th 4 hour:

      Data warehouse: Fact table ETL
      Data warehouse: Audit table creation and ETL
      Incremental Loading
      Data Modeling Project 4/5

CLASS 5th 4 hour:

      Master Package Design---XML method
      How to parse XML data
      Data warehouse: Unique Constrain, migration from DEV to PRO
      How to deploy SSIS package to Production---Environment Variable Method
    Maintaining Production Server—process of fixing production issues
    Data Modeling Project 5/5

CLASS last 2 hour:
      Bio Ph.D, current BI expert Di. Vivian  will talk real SSIS experience.

SSIS&ETL                       $1199    for general public
                                      $999      for MSBI 2008 student
                                      $899      for Core Package 2013 student
                                      $699      for Core Package 2013 and MSBI 2008 student
                                      $100      for previous SSIS ETL student listen class again.

Click here: Register course and Webinar use Credit Card.

Click here: Register course and Webinar use Paypal., click last Buy Now button, enter amount.

[heather]

I am core package student. I would like to register MSBI, however, when I get in the payment, it showed original price without discount. Is there extra step or web link should I follow to register?  Thanks

[USA LaoTu Support Team]

http://student.usalaotu.com/make_payment.php

modify the payment amount on that web page.

click next step.

[USA LaoTu Support Team]

Student of MSBI 2012 part 1 SSIS ETL will get first 8 hours video of MSBI 2008 (SSIS part) class, and will get SSIS ETL class video.

Class schedule has changed:

Feb 25 (Tue）， 2H,  19:00 to 21:00 USA PST
Feb 27（Thu),  2H,   18:30 to 20:30 USA PST
Mar 1 (Sat), 4H,      08:00 to 12:00 USA PST
March 4(Tue）, 2H    18:30 to 20:30 USA PST
March 6(Thu) , 2H   18:30 to 20:30 USA PST
March 8 (Sat),4H     09:00 to 13:00 USA PST
March 11(Tue), 2H   18:30 to 20:30 USA PST
March 15(Sat), 4H   09:00 to 12:00 USA PST      Dr. Vivian

[fish]

The BI 2008 covers both part I and part II ( less content compared to BI 2012 part I and part II).
1.  If I would like to look for a job in BI field, do I have to study  both part I and part II for BI 2012?
2.  How much is for BI 2012 part II if I am a core package student and complete BI 2012 Part I?
3. I don't have time for online live class, will the class vedio be posted soon after the class?

Thank you very much.

[USA LaoTu Support Team]

MSBI 2012 Part 1 covers SSIS ETL  (Will get access of MSBI 2008 SSIS video).
MSBI 2012 Part 2 covers SSAS, MDX, SSRS, etc. (Will get access of MSBI 2008 SSAS, SSRS class video).


It depends on what BI job you are going to look, it may need different skills. More skills you have will open more chance for you to get a job.

Will publish Part 2 price and schedule soon.

Class video available for review in the night of each online class.  For example, last night's MSBI 2012  Part 1 SSIS ETL class 1 video is available for review last night.

[heather]

I attended last night SSIS class. Mr.Wei mentioned we need to install Adventureworks 2012. I searched and found out that there are couple different versions of this sample database and was warned that version has to match the function. Which one is the right one to install for SSIS&ETL class? Is dataware house version, RCO or RTM. Could you please give a detailed instruction on this. I am a new student, get confused easily. Thanks in advance.

[USA LaoTu Support Team]

You will be OK as long as you have a 2012 version of that database.
As said in last night's class, you learn the method of how to do SSIS and ETL,  teacher teach you a method for load data into a table A, after gain the skill, you should be able to do the same for a table B. Different company use different tables, however, all the basic methods are same.
As long as you have a 2012 version of that database, you are OK for the class.
Thanks!

[yingy]

heather,
Would you reference this link:
http://forum.usalaotu.com/index.php?topic=3185.0 of      Topic: 找同伴一起学MSBI 2012 part I (SSIS+ETL)  (Read 236 times) ?
in the Reply #10, zym listed AdventureWorks2012 download method. Hope can help.
 

[yuan]

Yes, I completed smoothly lab1 project w/ the newly attached AdventureWorks2012 database.

heather,
Would you reference this link:
http://forum.usalaotu.com/index.php?topic=3185.0 of      Topic: 找同伴一起学MSBI 2012 part I (SSIS+ETL)  (Read 236 times) ?
in the Reply #10, zym listed AdventureWorks2012 download method. Hope can help.

[heather]

Thank you all.

[USA LaoTu Support Team]

Click here:  MSBI 2012 Part 1 SSIS ETL class preview.