Real Time Intelligence with Microsoft Fabric

Introduction:

In today’s world, quick access to Real-time information is crucial for businesses. Microsoft Fabric offers a simple yet effective solution for tapping into this vital resource. Let's explore the power of real-time intelligence with Microsoft Fabric and how it’s revolutionizing data-driven decision-making.

Step 1: Creating Eventstream

Creating an Eventstream to access the live streaming data.

I. Click on the “new+” in the workspace and select Eventstream.

fig 1.1.1 “new+” in workspace.

fig 1.1.2 Selecting Eventstream.

II. Create Eventstream with a name.

fig 1.2 Eventstream.

Step 2: Configuring The Source and Destination

After creating an Eventstream, establish an uninterrupted data flow by configuring the source and the destination. The source will be live data from Azure Event Hub and the destination will be the Microsoft Fabric Lakehouse.

I. Select Azure Event Hubs in the New source, specify the required connection detail for the Event Hubs and click add to connect.

fig 2.1.1 Eventstream Source.

fig 2.1.2 Connect azure event hub.

II. Select Lakehouse in the destination, specify the Required Lakehouse connection details and click add to connect the Lakehouse.

fig 2.2.1 Eventstream Destination.

fig 2.2.2 Connect lakehouse.

When the connection is established successfully, the data starts to stream.

fig 2.3 Streaming Eventstream.

Step 3: Create PowerBI Report with the Lakehouse Semantic Model

The PowerBI report can be created based on the specific tables or with all the available tables from the lakehouse

Create report with specific tables from the Lakehouse:

To import particular table in the PowerBI Report,

I. Click the Lakehouse in the right corner and select the “SQL analysis endpoint”

fig 3.1.1 SQL analytics endpoint.

II. Click more option of the particular table and Select “Add to default semantic model”

fig 3.1.2 Adding default semantic model.

III. Click new report in the SQL analysis endpoint.

fig 3.1.3 Creating new report.

Create report with all the tables from Lakehouse:

I. Click the Lakehouse in the right corner and select the “SQL analysis endpoint”

fig 3.2.1 SQL analytics endpoint.

II. Click new report in the SQL analysis endpoint to get the data from all the available tables from lakehouse.

fig 3.2.2 Creating new report

Step 4: Create your report

Visualize the report in a manner that aligns with the data provided.

fig 4.1 Visualize the report.

Step 5: Save the report

Save the report in the required workspace.

fig 5.1 Save the report.

Conclusion:

Based on the streaming data from Azure Event Hub the report dataset will be refreshed automatically. This dynamic approach enables us to visualize and understand the latest information, empowering better decision-making based on real-time insights and increases the business standards.

About Us:

Bi3 has been recognized for being one of the fastest-growing companies in Australia. Our team has delivered substantial and complex projects for some of the largest organizations around the globe, and we’re quickly building a brand that is well-known for superior delivery.

Website: https://bi3technologies.com/

Follow us on,
LinkedIn: https://www.linkedin.com/company/bi3technologies
Instagram: https://www.instagram.com/bi3technologies/
Twitter: https://twitter.com/Bi3Technologies