sql server2014合作伙伴认证计划研讨会4v3cn

1、面向移动应用的BI仪表板解决方案Microsoft BI Platform + DatazenEva Zhao（）STU, EPG, Microsoft() Co.,微软企业与合作伙伴部 平台解决方案内容概览参考案例技术框架一览解决方案特色内容概览参考案例技术框架一览解决方案特色解决方案特色l 面向“移动”应用Ø 优先为移动场景而设计，进而扩展到大屏幕l 适用于全部移动平台Ø Windows 8, Windows PhoneØ iOSØ Androidl 基于“触摸”的仪表板设计器类型Ø 一次开发，发布到所有移动平台和类型l 集成微软所有的BI

2、数据源/数据类型Ø SQL Server, SSAS, SharePoint, Excel, Azure, Windows 8, Windows Phone证“模式”lØ 基于Excel创建，面向移动应用场景的绩效指标库敏捷、及时的洞察力 实时数据源连接 展现最新数值和趋势 通过相关仪表板提供详细的分析适应所有数据可视化和分析形式的仪表板 炫酷的视觉冲击 基于触摸的数据交互 适应任何屏幕机身的完美缩放 详细分析，下钻和钻透 脱机仪表板集成团队协作通过BI Hub实现团队协作 参与指标和仪表板的 当新的仪表板和kPI发布时，看到公告 从任何上参与协作全面的品牌定制化贯穿整个自

3、定义的用户界面定制化定制企业的仪表板样式，所有本地应用皮肤定制效果同步到windows 8、iOS、Android、Windows Phone以及浏览器内容概览参考案例技术框架一览解决方案特色架构一览要素 Viewer Apps* 在当前版本中仅支持Windows 8 操作系统Viewer Apps支持的操作系统关键功能Windows 8Windows 8.1+ 按照已设定的用户权限，连接到Datazen服务器； 已发布的仪表板； 已发布的KPIs； 在BI Hub窗口中，与其他团队成员； 在中保存KPI的数据以便离线 在中保存仪表板数据以便离线*iOS 7+Android 4.1+Windo

4、ws Phone7.1+ Windows Phone 8+要素 Publisher Apps / Datazen ServerDatazen Server支持的操作系统关键功能Windows Server 2008链接企业数据源； R2 （64-bit） 集成AD认证环境；Windows Server 2012R2 （64-bit）发布仪表板，以便任意可以随时； 面向终端用户个性化数据； 支持企业定制的仪表板样式Publisher Apps支持的操作系统关键功能Windows 8从本地Excel文件中创建和共享仪表板Windows 8.1+从企业或云端的数据源创建仪表板，然后发布到任意类型的要

5、素 数据源 / 部署环境数据源（SQL Server/SSAS）及其部属方式（On-Premise/Azure） SQL Server/SSAS用于数据SQL/SSAS的负载；，并处理实施请求；每增加部署一台Datazen服务器，则同时增加了 Server 如果用SQL Server数据和执行，该SQL Server既可以部署在企业内部（On-Premise），也可以部署在Azure VM（ 如果用SSAS），或者SQL Azure（PaaS）上；数据和执行，该SSAS既可以部署在企业内部（On-Premise），也可以部署在Azure VM（）上； “What about Power BI?

6、” Please refer to Appendix A at the end of this deck for fullsDatazen服务器部署方式（On-Premise/Azure） Datazen服务器既可以部署在企业内部（On-Premise），也可以部署在Azure上（ Datazen服务器/Viewer Apps/Publish Apps专为Azure而设计和优化； 典型的、支持1000用户的Azure部署需要 5 Azure XL VMs and 1GB of Azure cache）；Devices要求 Datazen Publisher 目前仅支持Windows 8+；技术

7、参数&扩展实例1 Instance = 8 CPU cores, 16GB RAMExample 1: Carlsberg Group, DenmarkExample 2: Fortescue Metals Group, AustraliaExample 3: Microsoft Customer InsightsDeployment Size20,000 usersDeployment TypeOn Premise (Physical Servers)Deployment EnvironmentDatazen Server Windows Servers (all machines

8、32 CPU Cores, 16GB RAM)§ 2 Server Core instances§ 8 Web instances5 Dedicated SQL Server instances§ 4 SSAS Multidimensional instances, 32 cores each production§ 1 SSAS Multidimensional instance, 32 cores developmentDeployment Size700 usersDeployment TypeAzureDeployment Environment

9、Datazen Server Windows Servers (all machines Azure XL VMs)§ 1 Server Core instance§ 2 Web + Render instances7 Dedicated SQL Server instances (total 84 CPU cores)§ SQL Server Enterprise Edition, 12 CPU Cores 16 GB RAMDeployment Size3,000 usersDeployment TypeOn Premise (Physical Servers

10、)Deployment EnvironmentDatazen Server Windows Servers (all machines 8 CPU Cores, 16GB RAM)§ 1 Server Core instance§ 3 Web + Render instances SQL Server instances§ 3 SSAS Tabular instances, 12 cores each§ 3 SSAS Multidimensional instances, 12 cores eachDatazen 3.0100 Users§ 1

11、 instance for Core, DAS, Web§ Total: 8 CPU cores, 16 GB RAM500 Users§ 1 instance for Core, DAS, Web§ Total: 8 CPU cores, 16GB RAM1,000 Users§ 1 instance for Core & DAS§ 2 Web instances§ Total: 24 CPU cores, 48GB RAM5,000 Users§ 2 instances for Core & DAS

12、67; 4 Web instances§ Total: 48 CPU cores, 96 GB RAM10,000 Users§ 3 instances for Core & DAS§ 5 Web instances§ Total: 64 CPU cores, 128 GB RAM100,000 Users§ 5 instances for Core§ 5 instances for DAS§ 10 Web instances§ Total: 160 CPU cores, 320 GB RAMMicroso

13、ft Analytics PlatformProvide total capability for General, Predictive and Big Data BI Platformü内容概览参考案例技术框架一览解决方案特色Datazen Case StudiesMicrosoft Customer Insights, GlobalCarlsberg Group, DenmarkDeployment size:DeploymentDeployment size:o 1,000 users in Phase 1o 20,000 users in long termMicrosof

14、t Customer Insights and Global Marketing Operations groups have one of the largest reporting audiences within Microsoft.Datazen was chosen because of its ability to target all device form-factors from a single publishing environment. As a part of the POC we had to demonstrate the ability to scale to

15、 a very large number of users.o 1,600 users in Phase 1o 1,400 additional users in Phase 2The customer had a need tiver reporting to3000 people in the field who use iPads.Datazens technology was appealing to the customer because of the speed of deployment, true mobile dashboard development, drill- th

16、rough capabilities, and the quality of end-user experience in iOS.Datazen Case StudiesSunbelt Rentals, United StatesDeployment size:o 1,000 users in Phase 1o 2,000 users in Phase 2Key requirement was to integrate with large data sets using advancedalization and load-on-demand features as well as support over 500 locations and over 1600 iPads.Datazen was chosen because of its ability to render dashboards in HTML5 format, and target all mobile devices.Vacheron Constn, SwitzerlandDeployment size:o 50 users in Phase 1o 100s of users i