好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: MSBI2012 SSAS SSRS 第六期 08/09 to 10/03  (Read 21792 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
MSBI2012 SSAS SSRS 第六期 08/09 to 10/03
« on: June 08, 2015, 07:07:46 AM »
MSBI2012 SSIS ETL 第六期 07/11 to 08/01
8:00 to 12:00 Noon (USA PST) Saturday


A perfect time for Core Package students who starting/finishing SQL Server 2012 online course.
Welcome student use their company employee training fund to take class.
Student will get access this online class video for one-year.
After register this class, old Core Package students will get one-year access for their old Core Package course video and one-year FREE joining Wednesday Class webibnar online.

美国老土 MSBI2012-1 SSIS ETL 第四期 第四节课 2015-01-31 视频预览   


MSBI2012 Part1 SSIS ETL

7/11, 7/12 Dr. Shelly  SSIS Labs and Real Work experience
7/18  Dr. Vivian  SSIS Real Work experience
7/25  Dr. Shin    SSIS Real Work experience
8/01   Dr. Shin    SSIS Real Work experience


MSBI2012 Part 1 SSIS ETL
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:

Coming soon.......

CLASS 4th 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 5th 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 第六期 08/09 to 10/03
8:00 to 12:00 Noon (USA PST) Saturday


8/09/2015  Sunday, Lina (Sunday, Yes, Sunday ONLY the first class)
8/15/2015  Saturday Lina    (All Saturday below)
8/22/2015  Catherine
8/29/2015  Catherine
9/05/2015  USA Labor Day, NO class
9/12/2015  Catherine/Shin
9/19/2015  Shelly
9/26/2015  Melody
10/03/2015 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


Water

How to use Report Builder 3.0 for SQLServer 2012 to create weekly, biweekly, monthly and quarterly reports
1.How to save them in Report Server
2.How to save them in the file system (Folders including Report Builder folder, Sql Query folder)
3.Will show how to create daily report  from writing query to create report by using report builder.
(How to quickly to create Ad hoc report under business requirements)
4.How to use report manager AP data source for all the reports And why?
5.Introduce 3 DBA queries to list all reports’ information.

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.

Shelly SSRS  (4 Hours):
 (SSRS real industry experiences)
Part 1. Introduction of Clinical Data analysis.
Part 2. Report life cycle in Health Care.
Part 3. How to build a detail and summary report.
Part 4. Advance programming in SSRS report.

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


MSBI2012-1 (SSIS ETL)    $1199    for general public
                                      $999      for MSBI 2008 student
                                      $949      for Core Package 2012 student
                                      $899      for Core Package 2013 student
                                     
MSBI2012-2 (SSAS, SSRS)
Class price:                   $1918      for general public
                                    $1818      for SQL Server 2012 student
                                    $1750      for MSBI2012-1 (SSIS) student
                                    $1598      for MSBI 2008 student
                                    $1549      for Core Package 2012 student
                                    $1449      for Core Package 2013 student
                                    $1399      for old Core Package student + MSBI 2008 student
                                    $1349      for Core 2012 + MSBI2012-1 student
                                    $1299      for Core 2013 + MSBI2012-1 student
                                 
Click this link register class.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
今天(07/11)开始的 美国老土MSBI2012课第六期第一堂 SSIS ETL 课, Dr.丽主讲.
四个小时的课,  Dr.丽结合她在工业界的不同公司的经验, 详细讲了三个Lab, 一步步由浅入深, 非常清楚.
新老同学们问了很多很有意思的问题. 收获很大.
转眼间, 一堂课上下来,  Dr.丽不停的把工作中的高招秀给大家, 同学们直到最后一刻还热烈讨论.

如果你想报MSBI2012课, 时间还不晚.
明天会接着讲第二堂.


 

Rainlily

  • Core Package
  • Sr. Member
  • *
  • Posts: 294
  • Karma: +0/-0
我是半新的同学 :P(5月上了SQL2012和SSRS部分的课--没赶上SSAS,所以不敢算新生了),今天头一次上SSIS ETL的课。这课上完了,绝对是热血沸腾的状态。Shelly老师讲得非常非常棒,条理清楚,言简意赅,重点部分反复强调,对同学们的问题非常细致耐心地回答,咱们老土学校有这样高水平的老师/前辈,真的是大家的福气!今天收获很大是不在话下的,虽然还没有很好的消化,更没到达到融会贯通的水平,但是我相信课下好好用功学习就一定能。课后我顺手把以后几堂课的ppt笔记打印了出来,结果这一打印,又被打了一剂鸡血,lol。敢情后面的Case更精彩! 许多在以前周三Webinar里不断听到的曾经陌生的关键词被反反复复,详详细细的讲解,加上老师们工作实例中的应用演绎,看得我是眼花缭乱,心潮澎湃啊!!同时也理解了为啥Shelly老师对咱们现在的同学会有“羡慕嫉妒恨” LOL。对于后面的课程笔记,虽然现在觉得像看天书,但是我对这门课将来学成之后的前景非常非常有信心。总之一句话,这门课太值了!同学们,咱们一起好好努力吧!
顺便贴一个lao9前辈曾经贴过的1.01法则的中文版及扩充,与各位同学共勉!


shofeller

  • Core Package
  • Full Member
  • *
  • Posts: 216
  • Karma: +0/-0
老师我打算报SSAS SSRS,请问第七期的SSIS会在什么时候开呢? 如果没有上过SSIS,会不会对MSBI-II有什么影响,会不会跟不上阿,谢谢!

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Student can start SSAS SSRS, then SSIS ETL.
Next SSIS ETL will start in the beginning of October.
It is no problem you start from SSAS SSRS.
It is a good start.

Vv90249

  • Core Package
  • Newbie
  • *
  • Posts: 39
  • Karma: +0/-0
Then will the next SSAS SSRS classes start right after the SSIS in October?
I'm a core-package student and just attended SSIS&ETL. I'll need more time to work on SQL/Oracle....as well as SSIS. It'll be too overwhelmed to start SSAS and SSRS right away.Sorry sorry I'm so very slow.   

Vivien

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Yes, the class plan is exactly as you said.
Yes, we deliver many useful skills in all of our courses.
Plan your study and follow your study plan.


USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: MSBI2012 SSAS SSRS 第六期 08/09 to 10/03
« Reply #7 on: August 06, 2015, 03:44:12 PM »
MSBI2012 SSAS SSRS 第六期 08/09 to 10/03
The first class: 8:00 to 12:00 Noon (USA PST) Sunday

8/09/2015  Sunday, Lina (Sunday, Yes, Sunday ONLY the first class)

8:00 to 12:00 Noon (USA PST) Saturday
8/15/2015  Saturday Lina    (All Saturday below)
8/22/2015  Catherine
8/29/2015  Catherine
9/05/2015  USA Labor Day, NO class
9/12/2015  Shelly/Na/Catherine
9/19/2015  Melody
9/26/2015  Shelly
10/03/2015 Catherine

Vv90249

  • Core Package
  • Newbie
  • *
  • Posts: 39
  • Karma: +0/-0
Re: MSBI2012 SSAS SSRS 第六期 08/09 to 10/03
« Reply #8 on: August 07, 2015, 08:10:52 AM »
Laoshi,

Could you confirm that the first SSAS class is this SUNDAY on 08/09? Because I think I saw yesterday somewhere on the web says Saturday on 8/8.

Just to make sure.
Thanks.

Vivien L

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
Re: MSBI2012 SSAS SSRS 第六期 08/09 to 10/03
« Reply #9 on: August 07, 2015, 08:21:06 AM »
Yes, SSAS will start at 8/9/2015, Sunday.