MSBI 2012 Part 2 SSAS, SSRS
Sat 08:00 to 12:00 USA PST, Saturday, 07/26 to 09/13
Total 32 hours 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 class material and previous class video immediately.
MSBI 2012 part 2 is independent to MSBI Part 1. You can start MSBI Part 2 first, take MSBI part 1 later (start on 09/20)
Here is the schedule , contents may change ....
07/26/2014 村姑 (SSAS)
08/02/2014 村姑 (SSAS)
08/09/2014 Cindy (SSRS basics and lab 1-6 and more)
08/16/2014 Ruby (SSRS real industry experiences)
08/23/2014 Cindy (SSRS real industry experiences)
08/30/2014 Shelly (SSRS real industry experiences)
09/06/2014 Catherine (SSRS real industry experiences)
09/13/2014 Melody (SSRS real industry experiences)07/26/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
08/02/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
08/09/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
08/16/2014 Ruby SSRS (4 Hours):(SSRS real industry experiences)
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
08/23/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
08/30/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.
09/06/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
09/13/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
=====================================================
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.)
$150 for old MSBI2012 Part2 student to LISTEN ONLY of online class. (NO video, NO document.)
Click this link register class use credit card.Click this link register class use paypal.
Topic: MSBI 2012 第二期 Part 2 SSAS SSRS 07/26 to 09/13 8 x 4hr Sessions Saturday (Read 17197 times)