Analyzing Fabric Lakehouse Data Using Natural Language with PandasAI

In this guide, we demonstrate how to analyze your Microsoft Fabric Lakehouse or Warehouse data using natural language queries without requiring F64 capacity or a Copilot license. Leveraging PandasAI and BambooLLM, you can transform your data into actionable insights quickly and efficiently.

Step 1: Load Your Data into the Fabric Lakehouse or Warehouse

Ensure your data is uploaded to your Fabric Lakehouse or Warehouse. Once the data is ready, create a shortcut over the dataset to make it accessible in your Fabric Notebook.

Step 2: Connect and Load Data in a Fabric Notebook

1. Open a Fabric Notebook and select Python as your working language.

2. fabric will load your data automatically

Step 3: Install PandasAI Library

Install the PandasAI library within your Fabric Notebook

Once installed, import the necessary libraries and configure your BambooLLM API key:

Step 4: Convert DataFrame to SmartDataFrame

Transform your standard Pandas DataFrame into a SmartDataFrame to enable natural language queries:

Step 5: Analyze Your Data Using Natural Language

With the SmartDataFrame ready, you can now query your data using natural language. For example:

Step 6: Insights at Your Fingertips

PandasAI, powered by BambooLLM, processes your query and delivers results seamlessly. You can perform various analyses, such as:

• Aggregating data.

• Visualizing trends with charts and graphs.

• Translating headers or text into different languages.

Benefits of Using PandasAI with BambooLLM

1. No Additional Licenses Required: Operate without F64 capacity or a Copilot license.

2. Natural Language Interaction: Query your data intuitively without writing complex code.

3. Flexibility: Handle large datasets efficiently with DuckDB or other optimizations.

4. Seamless Integration: Works seamlessly within the Fabric ecosystem.

Conclusion

In this guide, we demonstrate how to analyze your Microsoft Fabric Lakehouse or Warehouse data using natural language queries without requiring F64 capacity or a Copilot license. With this approach, analyzing your Fabric Lakehouse or Warehouse data becomes straightforward and accessible. Using PandasAI and BambooLLM, you can harness the power of natural language processing to unlock insights from your data effortlessly. Say goodbye to complicated coding and hello to intuitive, efficient data analysis!