itb-au logo
Story image

Microsoft Power BI to accelerate time to better data insights

13 Jul 2018

Microsoft’s Power BI now has extra capabilities for data analysis, and the company says the ultimate goal is for business analysts to gain data insights as quickly as possible.

Power BI was originally launched in 2015 to help companies embrace a data-centric culture for all employees, regardless of role and skillset.

Three years later, Power BI hosts more than 19 million data models and it processes more than 8 million dashboard queries every hour.

Microsoft Power BI Engineering general manager Arun Ulag now says that for that culture to thrive, everyone must work from the same data platform with intuitive tools that can sift through large datasets for quick insights.

“The Power BI updates we’re announcing today help organisations unify their enterprise BI needs on one platform and empower business analysts to leverage data more easily. Starting in July, these capabilities will begin to appear in Power BI in preview.”

He notes that data preparation and modelling are critical to customers’ data journeys – and they also take the most amount of time to work with.

This has prompted Microsoft to speed up data analysis time through the following features:

Self-service prep for big data

We’re expanding self-service data prep in Power BI by introducing new capabilities to help business analysts extract insights from big data.

Using the Power Query experience familiar to millions of Power BI Desktop and Excel users, business analysts can ingest, transform, integrate and enrich big data directly in the Power BI web service – including data from a large and growing set of supported on-premises and cloud-based data sources, such as Dynamics 365, Salesforce, Azure SQL Data Warehouse, Excel and SharePoint. The ingested data can now be shared across multiple Power BI models, reports and dashboards enabling easy data reuse.

Advanced analytics and AI with Azure

Additionally, it’s important that all of the users throughout an organisation operate on the same data. We’re fueling collaboration across roles by unifying access to data between Power BI and Azure Data Lake Storage Gen2. Business analysts can seamlessly operate on data stored in Azure Data Lake Storage taking advantage of its scale, performance, security and analytics with the self-service capabilities in Power BI, while data engineers, data scientists and other users can extend access to insights with advanced analytics and AI from complementary Azure Data Services like Azure Data Factory, Azure Databricks, and Azure Machine Learning.

Support for the common data model

Power BI will also support the common data model, which gives organisations the ability to leverage a standardised and extensible collection of data schemas (entities, attributes and relationships). Users can take advantage of a standard schema – or customise based on their unique needs – to simplify how they enrich their data with other sources from Microsoft and third parties to accelerate analysis across a broad, unified dataset.

Unifying self-service and enterprise BI Just as managing data from multiple sources can create challenges, managing multiple BI platforms within an organisation can limit centralised access to insights. Moving to one modern, compliant platform as the single destination for business analytics is easier than ever with key enterprise-facing updates on Power BI.

Enterprise-scale BI models & application lifecycle management (ALM)

We’re taking another step to bring advanced capabilities from SQL Server Analysis Services into Power BI, enabling larger data volumes, lifecycle management, and third-party BI tool connectivity. Incremental refresh, higher dataset size limits, and aggregates will allow customers to reach large dataset sizes, while maintaining fast and fluid reporting end users expect.

With new support for the XMLA protocol, existing Analysis Services tools for managing lifecycle—from deployment through operations can now work with Power BI datasets. Additionally, since many third-party BI tools support XMLA, Power BI can now fuel analytics for all users across your enterprise, regardless of which reporting tool they choose to use.

Enterprise reporting

Popular SQL Server Reporting Services technology is now part of Power BI, creating 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.

Multi-geo compliance 

New flexibility to deploy Power BI Premium in specific global regions so organisations can meet data residency requirements and improve performance of data loading by locating Power BI close to data sources.

Link image
Why TAPs are the building blocks of visibility
These hardworking devices provide the most effective way to copy actual traffic running across a system, so you can better monitor, secure and analyse your infrastructure.More
Story image
Interview: Hyland director talks CCM and why it's crucial in 2020
Techday spoke to Techday spoke to Hyland director of Asia Pacific Eugene Chng, who walks through the benefits of Customer Communication Management and its myriad benefits.More
Story image
Citrix partners with HPE to aid employees returning to offices
“Citrix is one of the partners that HPE is working very closely with to enhance existing solutions with components that are tailor made for COVID-19 response.”More
Story image
CenturyLink expands cloud alliance with Dell and VMware in Asia Pacific
The partnership is designed to offer a hybrid cloud solution to help digital businesses in Asia Pacific successfully modernise their application workloads and manage their cloud journey.More
Story image
Micro Focus launches solutions designed to aid modernisation
“Through new insight-driven tools, application program interface (API) development capabilities and robust deployment options, these Micro Focus solutions give developers new ways to work with complex COBOL and mainframe systems while delivering on a cloud strategy.”More
Download image
57% of IT professionals say their organisation uses NFV
Enterprise networks must support a growing number of distributed functions as well, which means there is more complexity and possibly skyrocketing Capex costs.More