SQL BI
【SQL Server BI 实战班】
深入、全面、翔实、专业的数据库知识，可以助你在数据求职中脱颖而出、赢得offer！
5/5
课 程 特 色
【特别喜讯】：疫情期间成功拿到Offer的成功学员都上过这门课
- 为什么人人都要学《SQL Server BI 实战班》？刘老师每日工作都会用到！
- 老师：多年数据仓库及数据服务的实际工作经验 & 具有强大的理论基础和实战经验
- 介绍实际职场中的真实案例，助你轻松拿到offer
- 常年保持高就业率的课程
授 课 老 师：Jay Liu
维多利亚数据学院 – 刘杰院长：计算机软件专业毕业，MCITP-DBA 2005/2008，拥有多年大型信息系统设计开发经验。曾经在中国主持设计开发超过1000个用户的大型政府部门办公自动化系统，AT&T全美联机系统的Senior Consultant，加拿大著名金融公司、银行及政府部门的Senior SQL Server DBA Consultant。擅长大型系统的设计，复杂数据结构的应用，企业级数据库系统的维护和开发。对于数据库系统理论及应用有精辟及独到的见解，所教授的SQL Server DBA及Access VBA 课程一直受到众多学员的好评。
Course outline
- Business Intelligent Architecture
- Reporting Services (SSRS)
- What is SSRS, SSRS Architecture
- Design SSRS Solution
- Develop SSRS Solution
- Access Data
- Data Source
- Data Set
- Display Data
- Table
- Fields
- Aggregated expression
- Group
- Format
- Table
- Report Items
- Data Region
- Independent Item
- Parameters, Filters and Sort
- Create Parameters, filters and orders
- Create dynamic Parameters
- Navigation
- Dynamic Visibility
- Drill down report
- Document map
- Actions
- Hyperlink
- Drill-through Link
- Book Mark Line
- Implement Report Layout
- Implement Report Rendering Formats
- Subscriptions
- On demand
- Data driven subscriptions
- Report Model
- Report builder
- Access Data
- Test SSRS Solution
- Integrate SSRS with Customer Application
- Deploy And Configure SSRS Solution
- Build Report
- Publish Report
- Execute Report
- Configure Cached Instance
- Create Snapshot and Report History
- Administering Security
- Administering Reporting Services
- Configuration files
- Performance
- Database Storage
- Disk Space
- Backup Restore
- Manage SSRS Solution
- Integration Services (SSIS)
- What is Integration Services
- Integration Services Architecture
- SSIS Tools and Utilities
- Develop SSIS Solution
- Create SSIS Solution
- Project
- Connections and Connection Manager
- Control Flow
- Data Flow
- Implement Logging
- Implement Event Handler
- Implement Variable
- System Variable
- User Variable
- Debug SSIS package
- Build SSIS solution
- Running SSIS Solution
- Deploy SSIS Solution
- Manage SSIS Solution
- Analysis Services (SSAS)
- What is Analysis Services
- Analysis Services Architecture
- SSAS Tools and Utilities
- Develop SSAS Solution
- Create SSAS Solution
- Project
- Manage Connections
- Cube
- Dimensions, Attribute, Hierarchy
- Measures, Measure Group
- Introduction of MDX
- Implement KPI
- Implement Actions
- Implement Perspectives
- Implement Translations
- Introduction of Data Mining
- Deploy SSAS
- Manage SSAS
- Configuration
- Security
- Monitor
【学数据分析，就来维多利亚！实习就业有保障！】
