慧谷培训 >>> 特色技术课 >>> 实现 SQL Server数据模型和报表课程介绍   
    搜索课程
搜索:
选项:
 在线咨询    最新课表
    推荐课程
  优惠组合课程
思科官方授权CCNA班
思科官方授权CCNA+CCNP培训
思科+微软 CCNA+MCSE
网管课程CCNA+MCSE+RHCE
MCSE&全球IT认证金牌课程
  Cisco(思科)
思科官方授权CCNA培训
思科官方授权CCNP培训
思科官方授权CCIE培训系统
  政府补贴
政府补贴中高级计算机程序设计员Java
Office政府补贴
  微软/Linux
微软MCSE认证/server2016
红帽认证工程师(RHCE8)
微软官方MCITP 2008
  Office认证培训
Word课程
Excel基础入门应用
Excel中高级课程
Excel在企业管理上应用(专家级)
PPT(PowerPoint)商务应用
Access课程
Outlook课程
  平面广告设计
Adobe平面设计师班
美术创意设计班
Adobe Photoshop实战应用班.
高级平面广告创意设计师
  室内设计
AutoCAD 全能
3DMAX全能班(3DS MAX+VRA.
室内设计全能软件设计班
  网页设计
Flash/AS高级动画开发工程师班
资深网页设计美工定向班H5版
  影视动画制作课程
3DMAX影视动画全科班
  MAYA动漫游戏
Autodesk Maya认证班
  编程开发系列
Java初级入门SL-110
Jsp Web开发 SL314
Java模式设计OO-226
J2EE企业高级解决方案(SSM框架)
  特色技术课
VB.NET 开发编程
Visual Studio TFS
微软.net开发实战培训
C#技术基础课程
SharePoint Server 20.
MOSS 2013/2016(share.
Lotus Notes企业应用
Oracle OCP 数据库管理开发专家.
VM虚拟化技术 VCP6 培训
IOS精英直通车班
IOS核心速成班
Windows 10 桌面支持专家培训
互联网前端开发工程师(html5+JS)
安卓Android开发实训营
  小型机系统管理
HP-Unix系统及网络管理I
AIX 7 Basics AN10
大型机操作系统
Solaris 操作系统网络管理
  工业设计
CATIA V5/V6 造型设计实战应用
Pro/E 3/4/5/6 模具设计实战.
Pro/E 3/4/5/6 钣金设计实战
UG NX 5/6/7造型设计实战应用
UG NX 5/6/7模具设计实战
SolidWorks 造型设计实战应用
  软件测试专业培训
软件测试提高班
软件测试就业班
  企业管理课程
人力资源管理师二级
企业培训师二级
有效沟通技巧实战培训
  IT英语
IT英语,IT职业英语
it移民,IT就业
暂无小分类
  大数据
   
    广告课程
  >>> 实现 SQL Server数据模型和报表开班介绍
课程周期: 3天 培训费用: 4500 元
使用教材: 送培训讲义,教学光盘 教材费用: 不含教材费和考试费
学员收益: 微软认证
咨询电话: 021-64472947、13122257700  64470100   
  >>> 实现 SQL Server数据模型和报表最近开班
编 号 上课地点 学习时段 开课时间 在线报名


现在报名预约此课程

  >>>  实现 SQL Server数据模型和报表详细介绍

Course: Implementing Data Models and Reports with Microsoft SQL Server 2012
Duration: 3.00 Day(s)
Fees:4500RMB

Overview:
Students will learn how to implement self-service analytics and reporting, to implement multidimensional analysis solutions, create PowerPivot and tabular data models, and deliver rich data visualizations with PowerView and SQL Server Reporting Services.

Who Should Attend:
This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions.

Primary responsibilities include:
 Implementing reporting solutions by using SQL Server Reporting Services.
 Implementing multidimensional databases by using SQL Server Analysis Services.
 Creating tabular semantic data models for analysis by using SQL Server Analysis Services. - Create visualizations of data by using PowerView.
 Create data mining solutions by using SQL Server Analysis Services.

At Course Completion:
After completing this course, students will be able to:
 Describe the components, architecture, and nature of a BI solution.
 Create reports with Reporting Services.
 Create reusable report items that simplify self-service reporting.
 Manage report execution and delivery.
 Create a multidimensional database with Analysis Services.
 Implement dimensions in a cube.
 Implement measures and measure groups in a cube.
 Use MDX Syntax.
 Customize a cube.
 Implement a Tabular Data Model in PowerPivot.
 Use DAX to query a tabular model.
 Implement a Tabular Database.
 Use PowerView to create interactive data visualizations.
 Use Data Mining for Predictive Analysis. 
 Prerequisite(s) or equivalent knowledge:
    10774 Querying Microsoft SQL Server 2012

Prerequisite Comments:
Before attending this course, the student should have:
 At least 2 years’ experience of working with relational databases, including: Designing a normalized database.
 Creating tables and relationships.
 Querying with Transact-SQL.
 Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
 Some exposure to basic programming constructs (such as looping and branching).
 An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Outline: 

Lesson 1: Introduction to Business Intelligence and Data Modeling
 Introduction to Business Intelligence
 The Microsoft Business Intelligence Platform

Lesson 2: Implementing Reports with SQL Server Reporting Services 
 Introduction to Reporting Services
 Creating a Report with Report Designer
 Grouping and Aggregating Data in a Report
 Showing Data Graphically
 Filtering Reports by Using Parameters
 Publishing and Viewing a Report

Lesson 3: Supporting Self Service Reporting 
 Introduction to Self Service Reporting
 Shared Data Sources and Datasets
 Report Parts

Lesson 4: Managing Report Execution and Delivery 
 Managing Report Security
 Managing Report Execution
 Subscriptions and Data Alert
 Troubleshooting Reporting Services

Lesson 5: Creating Multidimensional Databases 
 Introduction to Multidimensional Analysis
 Creating Data Sources and Data Source Views
 Creating a Cube
 Overview of Cube Security

Lesson 6: Working with Dimensions 
 Configuring Dimensions
 Defining Attribute Hierarchies
 Sorting and Grouping Attributes

Lesson 7: Working with Measures and Measure Groups 
 Working with Measures
 Working with Measure Groups

Lesson 8: Introduction to MDX 
 MDX Fundamentals
 Adding Calculations to a Cube
 Using MDX to Query a Cube

Lesson 9: Customizing Cube Functionality
 Working with Key Performance Indicators
 Working with Actions
 Working with Perspectives
 Working with Translations

Lesson 10: Implementing a Tabular Data Model with Microsoft PowerPivot
 Introduction to Tabular Data Models and PowerPivot Technologies
 Creating a Tabular Data Model by Using PowerPivot for Excel
 Sharing a PowerPivot Workbook and Using PowerPivot Gallery

Lesson 11: Introduction to DAX
 DAX Fundamentals
 Using DAX to Create Calculated Column and Measures in a Tabular Data Model

Lesson 12: Implementing an Analysis Services Tabular Data Model
 Introduction to Analysis Services Tabular Data Model Projects
 Developing an Analysis Services Tabular Data Model in SQL Server Data Tools

Lesson 13: Creating Data Visualizations with Power View
 Introduction to Power View
 Visualizing Data with Power View

Lesson 14: Performing Predictive Analysis with Data Mining
 Overview of Data Mining
 Creating a Data Mining Solution
 Validating a Data Mining Solution
 Consuming a Data Mining Solution

 

  >>> 这个课程我有问题向老师咨询
姓 名: 慧谷联络,不对外公布
电 话: 慧谷联络,不对外公布
邮 件: 慧谷回复提问,不对外公布
问 题:
验 证:  
 
 
查看实现 SQL Server数据模型和报表最新开班时间    

上海慧谷职业技能培训中心  徐汇区乐山路33号2号楼4楼  
报名热线:021-64482972   64478100   64470100
Q Q:1335162497   Email:withub@vip.sina.com
Copyright© 1999—2019 All Right Reserved  IP/ICP备案:沪ICP备11020735号-5
劳动局认证批准文号:沪劳保技(2003)34号    教育局认证批准文号:徐教社(2005)310号