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

Author Topic: MSBI2012 第五期 Part1 & Part2 class schedule 04/11/15 to 06/27/15  (Read 10003 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
MSBI2012 第五期 Part1 & Part2 class schedule 04/11/15 to 06/27/15
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

4/11/2015  Dr. Shelly  SSIS Labs and Real Work experience
4/14,  4/16  Dr. Shelly  SSIS Labs and Real Work experience
4/18/2015  Dr. Shin    SSIS Real Work experience
4/25/2015  Dr. Vivian  SSIS Real Work experience
5/2/2015  Dr. Shin    SSIS Real Work experience


MSBI2012 Part2 SSAS SSRS


5/09/2015  Lina
5/16/2015  Lina
5/23/2015  Catherine
5/30/2015  Catherine
6/06/2015  Catherine/Water
6/13/2015  Shelly
6/20/2015  Melody
6/27/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

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
                                      $799      for Core Package 2012 + MSBI 2008 student
                                      $699      for Core Package 2013 and MSBI 2008 student
                                      50% of above price for old MSBI2012 Part1 student to re-take
                                     
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
                                    $1249      for Core 2012 + MSBI 2008 student
                                    $1199      for Core 2013 + MSBI 2008  student
                                    $1099      for Core 2013 + MSBI2008 + MSBI2012-1 student
                                    50% of above price for old MSBI2012 Part2 student to re-take online class (with video and document access.)
                                 
Click this link register class.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: MSBI2012 第五期 Part1 & Part2 class schedule 04/11/15 to 06/27/15
« Reply #1 on: April 10, 2015, 01:20:17 PM »
MSBI2012 第五期 Part1 SSIS ETL 04/11 Saturday 8:00 to 12:00 (USA PST)
A good start class if you want to change your life soon.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: MSBI2012 第五期 Part1 & Part2 class schedule 04/11/15 to 06/27/15
« Reply #2 on: April 11, 2015, 07:46:12 AM »
USA LaoTu MSBI 课, 从2011年开始, 把原来很玄呼的微软商业智能分析软件英文系统,用清清楚楚的中文教学展现在求变爱家男女面前. 自开课以来, 无数咱国家庭由此改变,过上更好生活.
USA LaoTu MSBI 课, 老师们是由多位充满爱心, 具有博士学位, 在北美大公司, 医院, 银行, 制造业等工作的MSBI专家组成.
在USA LaoTu MSBI 课上,学生们不仅学到了基础技能, 还看到了,拿到了各位老师们来自工作中的诸多实际BI项目的材料.
在这些BI技能和活生生的BI项目的武装下, 同学们会做,会说, 纷纷拿到大公司好工作! 同学们都把USA LaoTu MSBI 课誉为找工作的敲门砖.
新的一期MSBI课今天开始, 你若有求变的急迫感, 建议你来参加这次课.
一周只讲四小时, 你有足够时间复习.
课后的视频, 学生们可在一年之内看任意次.
Please email to customer service at inquiries@usalaotu.com if you have any questions.