1、微软 Power BI解决方案SolutionTradition DataBig DataThe above graphics were published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Microsoft. Gartner does not endorse any vendor, pro
2、duct or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartners research organization and should not be construed as statements of
3、 fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. $Microsoft TableauDATADATADatabase HDFS (Hadoop)SQL Server Powered by PolyBaseSQL统一查询,结构化和非结构化数据 查询关联 Hadoop表和关系型数据库表 采用标准 SQ
4、L语言 Select, From Where沿用现有SQL 技能无需 IT人员介入节省时间和成本分析多样 的数据类型DATA客户端工具多维分析 , 报表 , 记分卡 , 仪表板 , 自定义应用程序数据源数据库, LOB应用程序,数据订阅电子表格,文本文件BI Semantic Model数据建模业务逻辑和查询数据访问团队级 BIPowerPivot和PowerView管理层 BIPerformance Point Services组织级 BIAnalysis Services灵活的 丰富的 可扩展的统一语义模型DATAData sources Power BI serviceSaaS solu
5、tionse.g. Marketo, Salesforce, GitHub, Google analyticsOn-premises datae.g. Analysis ServicesOrganizational content packsCorporate data sources or external data servicesAzure servicesAzure SQL, Stream AnalyticsExcel filesWorkbook data / data modelsPower BI Desktop filesData from files, databases, Az
6、ure, and other sourcesData refreshVisualizationsLive dashboardsContent packs Sharing & collaborationNatural language queryReportsDatasets0100110101Power BI REST APIsPower BI DesktopPrepare Explore ShareReportPower BI 主要组件85+ 可视化对象 28 OOB visuals 60 Custom visuals交互式报表分析 & 数据表现工具格式化工具形状 /图片 /文本框Publish Power BI Desktop reports on-premisesPower BI Desktop 报表发布到本地服务器数据所处位置 ? 云端 本地如何进行连接 ? 导入数据 直接查询如何更新数据 ? 个人网关 本地数据网关