MSBI2012 SSIS ETL 第六期 07/11 to 08/01
8:00 to 12:00 Noon (USA PST) SaturdayA 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 7/11, 7/12 Dr. Shelly SSIS Labs and Real Work experience
7/18 Dr. Vivian SSIS Real Work experience
7/25 Dr. Shin SSIS Real Work experience
8/01 Dr. Shin SSIS Real Work experienceMSBI2012 Part 1 SSIS ETL
CLASS 1st 4 hour ETL Working Environment
SSIS lab 1-3 Demo
Lab1 Introduction the data flow.
Lab2 Introduction the work flow.
Lab3 Data transformation in Data flow.
CLASS 2nd 4 hour: SSIS lab 4-6 Demo
Lab4 Dynamically loading data.
Lab5 Loading Dimension table using SCD.
Lab6 Loading Fact table using Dimension Lookup.
CLASS 3Rd 4 hour:Coming soon.......
CLASS 4th 4 hour: MSBI and SSIS Historical Overview
ETL Environment
SSIS package design pattern
Advanced Topic--Data warehouse Loads:
Audit table creation and ETL
Dimension/Fact Table loads in DW
(Profiling task, ETL audit, master-child packages for data Extraction, Transformation and Loading)
Incremental Load (control table, CDC and Hash)
CLASS 5th 4 hour: Flat File Data analysis---Unstructured Data File Properties
Lab 1: Web Log project
1. Diana and lucky's SSIS Package
2. T-SQL
3. C# scripting
Text Mining skills:
Lab 2: Term Extraction
Lab 3: Term Lookup
How to Extend SSIS Package with C# . NET Scripting (Script Task and Script Component)
-- Brief Introduction to C# . NET Scripting in SSIS
-- SSIS Sample package designs for >10+ types of Flat files (ETL loads) in real work.
-- 10 Labs for different flat files loading
-- Summary: ETL design patterns:
Compare Web Log data loads with advanced Diana and lucky's SSIS Package, T-SQL, and C# methods
MSBI2012 SSAS SSRS 第六期 08/09 to 10/03
8:00 to 12:00 Noon (USA PST) Saturday8/09/2015 Sunday, Lina (Sunday, Yes, Sunday ONLY the first class)
8/15/2015 Saturday Lina (All Saturday below)
8/22/2015 Catherine
8/29/2015 Catherine
9/05/2015 USA Labor Day, NO class
9/12/2015 Catherine/Shin
9/19/2015 Shelly
9/26/2015 Melody
10/03/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.
CatherineHow to configure the report server
Deployment and Manage Reports
Access, Deliver, and Monitor Report
Data-driven subscription
In this lesson, you use the data-driven subscription pages to connect to a subscription data source, build a query that retrieves subscription data, and map the result set to report and delivery options.
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
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
Click this link register class.