《powerbi功能全讲解》由会员分享,可在线阅读,更多相关《powerbi功能全讲解(23页珍藏版)》请在金锄头文库上搜索。
1、 Everyone Analyst to end user IT to end user BI 的发展趋势全员BI 2nd wave Self-service BI 1st wave Technical BI 3rd wave End user BI SaaS Data Sources Power BI web browser With natural language query, visual exploration etc. Azure-resident systems Azure Stream Analytics Azure SQL/DW HDInsight Power BI Mobi
2、le Apps with dashboards, alerting and visual exploration AS Tabular Corporate Data Sources PBI Desktop Power BI AS Connector Excel On-premise systems / other Real time Dashboards using Push API or ASA Power BI Gateway Power BI 技术架构 Bring your data to life 连接各种类型的数据源 File Database Azure Online Servic
3、es Other Excel CSV XML Text JSON SharePoint Folder SQL Server DirectQuery for SQL Server Access SQL Server Analysis Services SAP HANA SAP Business Warehouse Oracle IBM DB2 MySQL PostgreSQL Sybase Teradata IBM Informix Amazon Redshift Impala SQL Database DirectQuery for SQL Database SQL Data Warehous
4、e Marketplace HDInsight Blob Storage Table Storage HDInsight Spark DocumentDB Data Lake Store MailChimp Marketo QuickBooks Online Smartsheet SQL Sentry Stripe SweetIQ Twilio Zendesk Spark Dynamics CRM Online Facebook Google Analytics Salesforce appFigures GitHub SparkPost tyGraph Webtrends comScore
5、Digital Analytics Troux Planview Enterprise Azure Enterprise SharePoint Online Exchange Online Web SharePoint List OData Feed Hadoop File (HDFS) Active Directory Microsoft Exchange ODBC R Script Blank Query 使用数据查询功能连接到各种理性能类型的数据源以获取数据 查询导航帮助优化数据处 加载数据之前通过编辑查询整理数据,减轻数据负载量 连接关系型数据库时可以自动识别相关表的关系 通过 Power BI Desktop可查询的数据源类型 挑战挑战 Power BI 应用价值应用价值 挑战挑战 Power BI 应用价值应用价值