
To share the results of your analysis, you can combine these visualizations into a simple dashboard. You can perform exploratory data analysis using familiar SQL query constructs, which you can then use as the basis for common types of visualizations that enable multiple perspectives of your data. Before looking at the integration with Power BI, let’s look at the capabilities of Databricks SQL.ĭatabricks SQL allows you to easily apply your existing SQL skills to big data analysis without learning a new language. For those organizations having a well-established Microsoft Power BI center of excellence, Databricks SQL also integrates with Power BI to support queries of the most complete and recent data in the data lake. On the other hand, Databricks SQL enables quick access to data insights by enabling BI/SQL workloads in the lakehouse.


This post was authored by Stacia Varga, business intelligence practitioner, author, mentor, and classroom instructor.Īs organizations adopt cloud data lakehouses to deliver the best of breed capabilities of data warehouses and data lakes, non-technical users such as data analysts don’t always have an easy way to access the data lakehouse for exploratory analysis.
