MSBI2012 第三期 Part2 SSRS SSAS 10/25/14 to 12/20/14

[USA LaoTu Support Team]

MSBI 2012 第三期 Part 2 SSRS, SSAS
Sat   08:00 to 12:00  USA PST,  Saturday, 10/25/14 to 12/20/14
Total eight sessions of real industry experience sharing by SSAS/SSRS professional working in large companies.

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.
After register, student can access previous class video immediately for review till end of this online 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 webinar online.


MSBI 2012 part 2 is independent to MSBI Part 1. You can start MSBI Part 2 first, take MSBI part 1 later (start on Jan 2015.)

Here is the schedule , contents may change ....

SSRS

10/25/2014  Cindy
11/1/2014   Cindy
11/8/2014   Catherine
11/15/2014  Shelly
11/22/2014  Melody
11/29/2014  No Class
12/6/2014   Catherine

SSAS
12/13/2014  Lina
12/20/2014  Lina

课程内容：

10/25/2014  Cindy 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

11/1/2014   Cindy 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

11/8/2014   Catherine  SSRS  (4 Hours):
(SSRS real industry experiences)
(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
Three new SSRS report in real work

11/15/2014  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.

11/22/2014 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

11/29/2014  No Class
12/6/2014   Water and Catherine
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
Deployment and Manage Reports
Access, Deliver, and Monitor Report

12/13/2014  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

12/20/2014  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



Class price: 
                                    $1918      for general public
                                    $1818      for SQL Server 2012 student
                                    $1750      for MSBI2012-1 (SSIS) student
                                    $1598      for MSBI 2008 student
                                    $1449      for Core Package 2013 student
                                    $1399      for old Core Package student + MSBI 2008 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 use credit card.
Click this link register class use paypal.