刘杰SQL BI课程介绍LP

SQL BI

是提供
使你的技能
是各大企业

【SQL Server BI 实战班】

深入、全面、翔实、专业的数据库知识,可以助你在数据求职中脱颖而出、赢得offer!

5/5

课 程 特 色

【特别喜讯】:疫情期间成功拿到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
      • 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
    • 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

【学数据分析,就来维多利亚!实习就业有保障!】​


【维多利亚教育集团】Victoria Training Center

您的成功就业 从这里开始!

电话:416-665-1888

地址:250 Consumers Road, Suite 901, Toronto M2J 4V