Leipzig, 11/06/2018 – As organizations embrace a data culture to drive business decisions, they need an enterprise business intelligence platform that can meet their sophisticated needs – from self-service BI to full enterprise governance, from paginated reports to full interactive data exploration, and from small data sets to petabytes of data.
In July, Microsoft laid out the roadmap for Power BI to help organizations unify modern and traditional BI on one enterprise platform, and empower business analysts by expanding self-service data prep for big data. Since then, a number of capabilities were shipped that deliver on this roadmap: Premium multi-geo allows customers to address data residency requirements, aggregations enable data analysis over petabyte sized datasets with trillions of rows of data, and the new Power BI Home landing page and dashboard commenting make it easier to get to your most important content and collaborate across the enterprise.
Today, Microsoft is announcing the availability of several new capabilities that were laid out in the July roadmap.
Dataflows expand self-service data prep in Power BI
Power BI already includes robust self-service data preparation capabilities in Power BI Desktop through the familiar Power Query based experiences that are used by millions of users worldwide. Now the public preview of dataflows in Power BI, is taking self-service data preparation to the next level.
- Dataflows enable business analysts to create data preparation logic that can be reused across multiple Power BI reports and dashboards.
- Dataflows can be linked together to create sophisticated data transformation pipelines that enable business analysts to build on each other’s work. A new recalculation engine automatically tracks dependencies and recomputes data as new data is ingested.
- Dataflows can be configured to store the data in the customer’s Azure Data Lake Storage Gen2 instance, fueling collaboration across roles. Business analysts can seamlessly operate on data stored in Azure Data Lake Storage, taking advantage of its scale, performance, and security. Meanwhile, data engineers and data scientists can extend insights with advanced analytics and AI from complementary Azure Data Services like Azure Machine Learning, Azure Databricks, and Azure SQL Data Warehouse.
- Dataflows support the Microsoft Common Data Model, giving organizations the ability to leverage a standardized and extensible collection of data schemas (entities, attributes and relationships)
Power BI empowers a broad group of employees to self-discover, share and monitor insights across a diverse range of data sources in the cloud and on-premises. Dataflows unlocks new possibilities for analysts leveraging large datasets.
SQL Server Reporting Services technology now in Power BI
A modern, compliant and unified enterprise BI platform for business analytics is easier than ever with Microsoft latest enterprise operational reporting capabilities.
The popular SQL Server Reporting Services technology is now part of Power BI and available in public preview, providing a unified, secure, enterprise-wide reporting platform accessible to any user across devices. Pixel-perfect paginated reports can now be included alongside Power BI’s existing interactive reports.