avatarChristianlauer

Summary

Microsoft has introduced a new data exploration feature called Explore within Power BI, designed to facilitate quick and spontaneous data analysis without the need for creating full reports.

Abstract

Microsoft's new tool, Explore, integrated into Power BI, offers a straightforward and focused interface for users to analyze data swiftly. This feature is particularly beneficial for analysts needing to explore new datasets or business users seeking specific data insights for presentations, without the complexity of building complete reports. Explore is currently in public preview, allowing users to gain an initial overview of data from various sources such as Data Lakes, Data Warehouses, or large Excel/CSV sheets.

Opinions

  • The introduction of Explore in Power BI is seen as a significant advancement for data analysis, providing a solution to the challenge of initiating new reports from scratch for quick data insights.
  • The tool is considered useful for obtaining a first oversight over data from different sources, streamlining the process of data exploration.
  • The feature is expected to make data engineering and data science more accessible through AI, as indicated by Microsoft's announcement of the Public Preview of Copilot in Fabric.
  • The direct approach of Explore minimizes distractions and unnecessary complexities, which are commonly associated with the process of creating comprehensive reports.

Microsoft launches new Data Analysis Tool named Explore

How you can now easily explore Data with Power BI

Photo by Andrew Neel on Unsplash

Microsoft just launched a new Data Analysis tool called Explore, which is integrated into Power BI.

In Power BI, users often find themselves in need of spontaneous data exploration. This scenario might involve an analyst gaining access to a fresh dataset or source and wanting to delve into the data before constructing a comprehensive report.

Alternatively, it could be a business user seeking to address a specific query using data for inclusion in a PowerPoint presentation, but finding that the existing report doesn’t precisely address their question. In such cases, initiating a new report from scratch presents a significant obstacle, especially when a quick answer or a snapshot for a presentation is required[1].

Using the new Feature in Power BI — Screenshot by Author

This feature provides users with a streamlined and focused interface for data exploration. Much like exporting data or creating a PivotTable in Excel, Power BI now enables users to swiftly access Explore, allowing them to promptly generate a matrix or visualize data to obtain the required answers.

Explore within Power BI — Image Source: Microsoft[2]

This direct approach minimizes distractions and unnecessary complexities commonly associated with building complete reports[1][2]. Keep in mind that the feature is now in preview but for some PoC or testing, you surely can use it already now.

So this is clearly a new and very useful feature which Microsoft is providing its Power BI users. Often, you just want to explore data from a Data Lake, Data Warehouse or a (big) Excel or CSV Sheet. With this tool, it's now easier to get a first oversight over this kind of data. To dive deeper, please use the link down below.

Sources and Further Readings

[1] Microsoft, Empower Power BI users with Microsoft Fabric and Copilot (2023)

[2] Microsoft, Introducing Explore (Public Preview) (2023)

Data Science
Microsoft
Power Bi
Technology
Data Analysis
Recommended from ReadMedium