好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: MSBI2014/2016 SSAS SSRS 第13期 8:00am to 12:00 Noon, Sat 11/03 to 12/22/18  (Read 5104 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
USALaoTu.com MSBI课,开创华人高薪转行捷径,把成千求变爱家人高薪送入大公司。

成千爱家男女高薪转行利器:在职北美大公司MSBI专家团队详细讲解市场热门微软商业智能报表软件MSBI  SSAS SSRS  Data Warehouse  基础知识和工作实际例子。
你将很快掌握全面系统的做各种Report的实际应用,使你在转行面试过程中脱颖而出,使你以后工作中如虎添翼。

凡有求变之心并愿意行动的同学,这是一个绝好的机会。
这门由北美在职MSBI业界专家团队教授的课把成批的爱家男女送进大公司挣高薪。别人行,你也行。

课程试听:MSBI 2012 第六期 SSRS_class4_20150919 课程视频剪集
USA LaoTu MSBI课,工作在北美业界的老师们充满爱心,把工作经验传授给学生。一批又一批的学生成功转行,进入大公司。

聪明华人求职转行都找美国老土,每天课每周两网会,别处都没有。
成千爱家男女很快高薪进大公司,家庭幸福生活更好,你也能做到。

课程内容:
MSBI2014/2016 SSAS SSRS  第13期

8:00am to 12:00 Noon (USA PST)  Sat 11/03/2018 to 12/22/2018

课程内容:

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

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

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

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


3. Catherine
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.

4. Catherine SSRS  (4 Hours)

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.

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

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

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
课程内容:
MSBI2014/2016 SSRS SSAS  第13期

Class web page: http://www.usalaotu.com/student/msbi2012_term13.php
Online class:
8:00am to 12:00 Noon (USA PST)  Sat 11/03/2018 to 02/05/2019

课程内容:

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

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


3. Catherine
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.

4. Catherine SSRS  (4 Hours)

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.

5. Melody  SSRS  (4 Hours  Video):
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

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

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

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