视频:2014-03-12 191 次周会 特邀嘉宾： 多位工作在北美大公司一线SSRS专业人士：琳女士等

[USA LaoTu Support Team]

美西周三晚上七点, 专家同学助你图变. 走出家门确有捷径, 会做会说工作不难!

7:00pm to 8:30pm Wednesday, 美西 时间,       
10:00pm to 11:30pm Wednesday, 美东时间
愿每一个想出来工作的咱国同胞都尽快拿到好工作!

每天学老土数据库课，每周同学都拿好工作！

Tue, Sat:  MSBI 2012 Par 1: SSIS ETL
Wed:        Class webinar, sharing interview and job hunting experience
Sat:          MSBI 2012,  Excel 2010 Expert

Anytime 24x7: Student Forum answering student's questions.  大家一起结成伙伴学都得好工作！

MSBI 2012   由多位充满爱心的从土校毕业，现在北美大公司任职的一线MSBI专业人士一起教，阵容强大，内容详实，带来工业界实际BI经验和例子。是你无论如何都不能错过的国语MSBI在线课。
Click here watch MSBI 2012 class video.

Click here watch USA LaoTu 必爱课 坐家妈妈这样通过做项目 一步一步走出家 .


Excel 2010 Expert started on 17:00  Saturday Mar. 8th.

Oracle 11g SQL (Core Package 2013 Course) online live class will start in April, it will be FREE for new Core Package students who registered after Jan 15, 2014.

关于听课的规则和经常问到的问题  Policy and Frequently Asked Questions: http://www.usalaotu.com/faq.html

视频: 2014-03-12 191 次周会，祝贺美国老土 MSBI 2012 Part 2: SSRS /SSAS 即将开课！
             特邀嘉宾： 多位工作在北美大公司一线SSRS专业人士：琳女士等

After Webinar, you can access webinar video from:
视频: http://www.youtube.com/user/USALaoTu

Webinar connection information is  published under Core Package Message Board.

------------------------------
MSBI 2012 Part 2 SSAS, SSRS
Sat   08:00 to 12:00  USA PST,  Saturday, 03/22 to 05/10
Total 32 hours of real industry experience sharing by SSAS/SSRS professional working in large companies.
Students register this class  will get access of MSBI 2008 SSAS/SSRS class video.

03/22    SSAS
03/29    SSAS
04/05    SSRS
04/12    SSRS
04/19    SSRS
04/26    SSRS
05/03    SSRS
05/10    SSRS

3/22/2014 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
 
3/29/2014  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

04/05/2014    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
 
04/12/2014    SSRS Second Class (4 Hours):
Real work project-Dashboard
Building product catalog by using list and image
Adventure Works Invoice
Employee Sales Summary
Deployment and Manage Reports
Access, Deliver, and Monitor Report
 
4/19/2014  SSRS (4 Hours) –Real Estate industry
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.
 
4/26/2014 SSRS (4 Hours)  --Health Care, Manufacture industries
Part One: Will update soon….
Part Two: Summary report drill down to detail report with report format in health care industry
 
5/3/2014 SSRS (4 Hours)  --Health Care
Will update soon….
 
5/10/2014  SSRS (4 Hours) – Real Estate Industry
How to transfer Crystal Report to SSRS Report;
Example of SSRS List report;
Grouping in SSRS Matrix report.
Some daily using SSRS expressions and tips
 
More information later.