{"id":14251,"date":"2015-10-29T11:38:00","date_gmt":"2015-10-29T18:38:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/10\/29\/microsoft-business-intelligence-our-reporting-roadmap\/"},"modified":"2024-01-22T22:50:18","modified_gmt":"2024-01-23T06:50:18","slug":"microsoft-business-intelligence-our-reporting-roadmap","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/10\/29\/microsoft-business-intelligence-our-reporting-roadmap\/","title":{"rendered":"Microsoft Business Intelligence – our reporting roadmap"},"content":{"rendered":"
While each year has seen advances across our product line, this past year\u2019s progress is truly unprecedented. We firmly believe Microsoft now offers the industry\u2019s most complete and modern business intelligence product family \u2013 with unmatched breadth and depth.<\/p>\n
At first approach, this depth can be overwhelming \u2013 how do all the components fit together? Where are things heading in the future? These are frequent questions from our customers and partners.<\/p>\n
As we approach the release of SQL Server 2016<\/a> it\u2019s a great time to tackle those questions in a definitive blog.<\/p>\n Our goal is simple \u2013 we want to put the power of data in the hands of every business and person on the planet. It is our objective to serve over a billion users with the Microsoft business intelligence (BI) platform.<\/p>\n <\/a><\/p>\n Data is coming at us from every direction. From traditional sources \u2013 on-premises enterprise applications and databases. From sources developed over the last decade \u2013 websites, mobile applications, social media and SaaS business applications. And from sources still emerging \u2013 data from the \u201cInternet of Things.\u201d<\/p>\n Maximizing the potential of one\u2019s data requires a platform that can work with data from on-premises systems and from the cloud \u2013 of any shape, size and arrival velocity, that can deliver insights wherever users may be, and in a form most convenient and accessible; and that offers deployment options that best fit the needs of an organization, at any point in its journey.<\/p>\n To achieve these requirements, we are aligning our cloud and on-premises solutions. It is our intent that your reporting technology investments and expertise will transfer across these deployment modalities so you can easily mix and match on-premises and cloud components, and benefit from our unique hybrid scenarios.<\/p>\n We intend to standardize reporting content types across Microsoft on-premises, cloud and hybrid systems. Our reporting path forward focuses on four report types:<\/a><\/p>\n SQL Server Reporting Services (SSRS) to date has focused on paginated reports and offers class-leading capabilities for that format. With SQL Server 2016 we are taking a leap forward by adding support for mobile reports. The addition of this new report type in SSRS is accompanied by an entirely new web experience for Reporting Services allowing users to access both paginated and mobile reports in one centralized location.<\/p>\n <\/a><\/p>\n This modernized SSRS web experience delivers the foundation for centralized report consumption, embedding and sharing of BI reports for those organizations that desire an on-premises option (versus using Power BI in the cloud).<\/p>\n Power BI Desktop is a data discovery and interactive reporting tool allowing business analysts to connect, prepare, and visually explore data across a freeform canvas. It combines the strengths of Power Query to connect to a vast spectrum of data sources and easily shape data, Power Pivot for rich data blending and modeling, and next generation Power View to intuitively perform visual analytics and author compelling reports.<\/p>\n <\/a><\/p>\n Based on the same technology as Power View, Power BI Desktop supports existing Power View reports and provides the future path to a HTML5 based interactive report experience on-premises.<\/p>\n Just as we\u2019ve added mobile report delivery to SSRS in SQL Server 2016, we intend to add governed Power BI Desktop report delivery in the future. Today Power BI Desktop supports publishing of reports to Power BI; Power BI Desktop is free to use, experience it yourself today<\/a>.<\/p>\n Whether using SQL Server Reporting Services on-premises, Power BI in the cloud, or both as your report delivery solution, we\u2019ll have a single mobile application (for each of Windows, iOS and Android) for consumption of all report types. At PASS Summit 2015 we demonstrated a single Power BI mobile application delivering a combination of report types from both SQL Server Reporting Services 2016 and the Power BI service. All of your BI content will be at your fingertips from within a single, unified mobile app to deliver insights any way, anywhere and from any device.<\/p>\n As we continue to harmonize our offerings across cloud and on-premises, we continue to align technologies and tools across all parts of our BI platform.<\/p>\n <\/a><\/p>\n Mirroring technologies across on-premises and the cloud enables one to easily switch between the two. Our approach also offers unique hybrid capabilities needed in a big data world where data lives in many locations.<\/p>\n For example, you can use your existing on-premises SSAS multi-dimensional models with enforced row-level security as a data source for Power BI without moving your data to the cloud; or directly connect to data in an on-premises SQL Server database without requiring SSAS, again without requiring your data move to the cloud.<\/p>\n You can choose, manage and monitor on-premises-to-Power BI data connections using our forthcoming enterprise gateway capability. Pin your favorite chart<\/a> from an operational SSRS report to a Power BI dashboard to leverage your existing reporting investments in SQL Server Reporting Services.<\/p>\n It\u2019s your data. We are here to empower you to drive your business based on insights gained from that data, whether your data is on-premises, in the cloud or a combination of the two.<\/p>\n Let us know what you think, share your comments about our future direction, and of course try out the latest SQL Server 2016 CTP<\/a>, and Power BI Desktop to experience the future of SQL Server BI today.<\/p>\n Lastly, if you are attending PASS Summit this week, join us for our on-premises BI sessions today and tomorrow:<\/p>\n Oct. 29, 2015 at 1:30\u00a0pm PST<\/strong>: What\u2019s New in SQL Server 2016 Reporting Services<\/a> [BIA-321-M] in TCC 304<\/strong> by Riccardo Muti While each year has seen advances across our product line, this past year\u2019s progress is truly unprecedented. We firmly believe Microsoft now offers the industry\u2019s most complete and modern business intelligence product family \u2013 with unmatched breadth and depth. At first approach, this depth can be overwhelming \u2013 how do all the components fit together?<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[2397],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-14251","post","type-post","status-publish","format-standard","hentry","product-power-bi","content-type-thought-leadership","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-3-1593580441-293","review-flag-anywh-1593580318-7","review-flag-bia-1593580706-773","review-flag-free-1593619513-128","review-flag-lever-1593580264-545","review-flag-new-1593580247-437"],"yoast_head":"\nWhere we are heading<\/h1>\n
Harmonizing report types<\/h1>\n
\n
\n<\/strong><\/li>\nReporting Services is our on-premises solution for BI report delivery<\/h1>\n
Publish Power BI Desktop Reports on-premises<\/h1>\n
Unified Mobile BI experience<\/a><\/h1>\n
Symmetry across on-premises and cloud<\/h1>\n
The future is bright<\/h1>\n
\nOct. 30, 2015 at 11:15\u00a0am PST<\/strong>: The Analysis Services Evolution<\/a> [BID-311-M] in TCC 303<\/strong> by Kasper de Jonge
\nOct. 30, 2015 at 3:30\u00a0pm PST<\/strong>: Datazen Technical Deep Dive<\/a> [BID-312-M] in TCC 304<\/strong> by Chris Finlan and Paul Turley<\/p>\n","protected":false},"excerpt":{"rendered":"