Analyze

Now that we have data integrated into the lakehouse and have prepared them for reporting, we’ll analyze these data to get insights. We will look at two methods: first, we will use Power BI to create visualizations (reports and dashboards), and then we will use SQL endpoint to connect the lakehouse for running analytical queries.

Power BI

Power BI is natively integrated within the whole Fabric experience; this native integration brings a unique mode of accessing the data (called Direct Lake, which we discussed in earlier chapters) from the lakehouse to provide the most performant query and reporting experience. Let’s create a report based on the data from the Gold zone:

1. Open the wwi_gold lakehouse and click on SQL endpoint under mode selection on the top right of the screen to switch to SQL endpoint mode for the selected lakehouse.

Figure 3.23 – Switching to SQL endpoint mode

2. Once you are in SQL endpoint...