Author Topic: MSBI SSIS ETL Term11 8:00 - 12:00 Sat 5/13 - 6/24  (Read 5351 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
MSBI SSIS ETL Term11 8:00 - 12:00 Sat 5/13 - 6/24
« on: May 15, 2017, 03:20:25 PM »
USA Laotu 课,开创华人高薪转行捷径,把成千求变爱家人高薪送入大公司。

在职美国大公司MSBI SSIS ETL 博士专家团队详细讲解MSBI  SSIS ETL  Data Warehouse  基础知识和工作实际例子。

学完这门课后,紧接着就是 MSBI SSAS SSRS 课。



MSBI2012 Term11 SSIS ETL   5/13 - 6/24

8:00 to 12:00 Noon (USA PST) Saturday

Sat, May 13, 2017 8:00 AM - 12:00 PM PDT  Dr. Shelly SSIS Labs and Real Work experience
Sat, May 20, 2017 8:00 AM - 12:00 PM PDT  Dr. Shelly SSIS Labs and Real Work experience
Sat, Jun 03, 2017 8:00 AM - 12:00 PM PDT  Dr. Diane  SSIS Real Work experience
Sat, Jun 10, 2017 8:00 AM - 12:00 PM PDT   Dr. Diane  SSIS Real Work experience
Sat, Jun 17, 2017 8:00 AM - 12:00 PM PDT  Dr. Shin SSIS Real Work experience
Sat, Jun 24, 2017 8:00 AM - 12:00 PM PDT  Dr. Shin SSIS Real Work experience


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:
SSIS Expressions
     We will first introduce basic functions used in SSIS expressions, then give tips and tricks of common used SSIS expressions in ETL. We will demo how to leverge SSIS expressions to output files with special requirements for header/footer and to clean up files with special rows.
Through the demos, you will learn
to bring more dynamic powers to SSIS packages by SSIS expression and script tasks
to use as project/package parameters/variables
to debug and fix errors

CLASS 4th 4 hour:
SSIS Parent Child Design Pattern
SSIS Package/Project Deployment and SSIS Catalog
SSIS Logging and Monitoring

CLASS 5th 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 6th 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 第九期 8/6/2016 - 9/24/2016
8:00 to 12:00 Noon (USA PST) Saturday

8/6/2016    Lina (SSAS)
8/13/2016  Lina  (SSAS)
8/20/2016  Catherine
8/27/2016  Catherine
9/03/2016  USA Labor Day, NO class
9/10/2016  Regina
9/17/2016  Catherine
9/24/2016  Melody
10/1/2016 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

Coming soon…..

How 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.

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