只要你有颗求变之心并愿意行动，到这里来， 必使你得改变！USALaotu 华人最大最久数据分析职业培训网校，十多年来北美业界专家授课， 培养学生能做会说，不用再修学位，不考证，很快高薪转行进大公司。
无论经济是好是坏，数据量一直都在增长，数据人才各个公司都缺。
微软的商业智能MSBI 数据分析应用软件系统收到数不清的大公司，大学，医院，政府单位的青睐， 会MSBI技术的人才可以轻松的拿到高薪Offer.
USALaoTu MSBI课程，有多位北美在职MSBI高级专家详细授课，已经开讲十多年了，是目前市面上内容质量，性价比最好的培训课，培养了大批学生成功高薪转行进大公司，生命生活得到改变，过上好日子。
课程内容：
MSBI2016/2019 SSAS SSRS 第14期
Class web page:
http://www.usalaotu.com/student/msbi2019_term14.phpOnline class:
8:00am to 12:00 Noon (USA PST) SUn 05/10/2020 to 06/28/2020
课程内容：
1.
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
2.
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 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
Topic: 大公司BI高级专家讲授MSBI2019 SSAS SSRS 第14期 8:00am to 12:00 Noon, Sun 05/10 to 06/28/2019 (Read 2961 times)