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.
Class price: (include access to SSAS, SSRS material of MSBI2008 and 2 hours How to write Workable Resume Seminar).
$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
$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
Click this link register class use credit card.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) 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 industriesPart One:
1.Create report using expression function
2.How to switch one Parameter working with two database columns.
3.Create more datasets in one report with business requirement.
4.Data mapping between database data and business requirement
Part Two: Summary report drill down to detail report with report format in health care industry
5/3/2014 SSRS (4 Hours) Part 1. SSRS passing multi valued parameter to Stored Procedure
Part 2. SQL query tips
◦ 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
5/10/2014 SSRS (4 Hours) – Real Estate IndustryHow to transfer Crystal Report to SSRS Report;
Example of SSRS List report;
Grouping in SSRS Matrix report.
Some daily using SSRS expressions and tips
此部分新添内容会在课堂内休息时间穿插讲授
Create a tabular model is SSAS
Add Data/Create Relationships
Create Calculated columns/measures
SSAS tabular Role and row-level security
Build PowerView SSRS reports using tabular data model