USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on February 14, 2014, 11:39:39 AM
-
MSBI 2012 Part I: SSIS&ETL Start 19:00 to 21:00 USA PST, Tuesday Feb 25:
把原有的广受欢迎的MSBI 课的内容进一步扩展，充实，把 SSIS&ETL 单独开课，从基础到实战， 加进工业界的实际项目和二十年SSIS Consultant 的经验精华。成为找工作， 赢MSBI工作的利器。
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, 19:00 to 21:00 USA PST
Mar 1 (Sat), 4H, 08:00 to 12:00 USA PST
March 4(Tue）, 2H 19:00 to 21:00 USA PST
March 6(Thu) , 2H 19:00 to 21:00 USA PST
March 8 (Sat),4H 08:00 to 12:00 USA PST
March 11(Tue), 2H 19:00 to 21:00 USA PST
March 13(Thu), 2H 19:00 to 21:00 USA PST
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 join online live class listen only.
Click here: Register course and Webinar use Credit Card. (http://student.usalaotu.com/make_payment.php)
Click here: Register course and Webinar use Paypal. (http://student.usalaotu.com/courseschedule.php), click last Buy Now button, enter amount.
-
老师，这个为什么是PartI? PartI以后还会有PartII等吗?如果来不及赶2月底的课程，MSBI Live Class什么时候再开？
谢谢！
-
Yes, Part 2 will cover SSAS and SSRS.
Better join this class.
Next same class will open after three month.
-
This MSBI 2012, add more stuff than previous MSBI (2008).
Yes, MSBI 2012 Part 2 covers SSAS and SSRS, it will be charged separately.
Yes, Part 2 will cover SSAS and SSRS.
Better join this class.
Next same class will open after three month.
好谢谢。我再想问一下，这个跟老土老师网站里列的那个$1299 (for core package student) MSBI 课程有什么不一样呢？
PartII (SSRS)还要单收费是吗？
-
报这课的能access哪些以前相关课的 class material /video? Thanks
-
我现在的电脑装了SQL Server，用VM分了100G，请问如果学BI，还需要新硬盘/电脑吗？谢谢！
-
The first 8 hour of this class cover old MSBI SSIS chapter 1 to chapter 7 material.
You will access previous SSIS ETL Term 1 class video.
报这课的能access哪些以前相关课的 class material /video? Thanks
-
You will be OK.
我现在的电脑装了SQL Server，用VM分了100G，请问如果学BI，还需要新硬盘/电脑吗？谢谢！
-
MSBI 2012 is A different class with old MSBI 2008 CLASS.
Student registered SSIS ETL (MSBI 2012 part 1) will get access of previous SSIS ETL class material and video immediately for review.
They will not get MSBI 2008 class video. The old SSIS content OF MSBI 2008 COURSE and chapter is covered in SSIS ETL class video.
-
Which developing tool are we using in BI class VS2008, VS2012 or the special one for BI?
-
We will use the same edition as we used on SQL Server 2012 class.
-
We will use the same edition as we used on SQL Server 2012 class.
But which Visual Studio version are we using in coming BI class?
-
Visual Studio comes with SQL Server 2012
-
Get it. Thanks.
-
那MSBI partII 什么时候开？
-
Will start Msbi 2012 part 2 after part 1 finish.
Will publish schedule soon.
-
如果我把part2+part2的课都报了，是不是可以听以前的MSBI的录像啊？
-
The Content of MSBI 2008 (SSIS, SSAS, SSRS) and more advanced stuff will be covered in new MSBI 2012 class.
-
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. (http://youtu.be/1adN3fLqFHc)
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. (http://student.usalaotu.com/make_payment.php)
Click here: Register course and Webinar use Paypal. (http://student.usalaotu.com/courseschedule.php), click last Buy Now button, enter amount.
-
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
-
http://student.usalaotu.com/make_payment.php
modify the payment amount on that web page.
click next step.
-
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
-
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.
-
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.
-
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.
-
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!
-
heather,
Would you reference this link:
http://forum.usalaotu.com/index.php?topic=3185.0 (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.
-
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 (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.
-
Thank you all.
-
Click here: MSBI 2012 Part 1 SSIS ETL class preview. (http://youtu.be/1adN3fLqFHc)
-
视频： 坐家妈妈这样通过做 USA LaoTu MSBI 2012 课 Part 1 SSIS ETL 项目 一步一步走出家 (http://youtu.be/VXTRNj9CLeU)
-
这位在上面课程录像中发言的Ying 同学， 可不可以给我短信结识一下， 我和你有着相似的背景， 更巧合的是我们的first name 都一样， 如果能经常一起讨论学习工作， 一定获益匪浅。 谢谢。
-
sure, pm to me.
-
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