Using Natural Language Processing Features of Power BI

By

A very useful feature of Power BI in creating reports is using its NLP using Ask a Question feature which helps you to directly question your data.

In order to use NLP, first, click on the Ask a Question in Power BI Desktop Home Menu Ribbon.


You will see greyed graph control with "Ask a question about your data" input box which can be used to interact directly with your data.


You can ask any question relevant to your data/dataset, the NLP in Power BI will interact with your data and show you relevant data to plot your chart/graph. 


You can select the relevant option as per requirement, Power BI will add the visualization to the report.

Happy Visualizing :)

Comments

Post a Comment

Popular posts from this blog

How to retrieve texts from Html SharePoint List source in Power BI

By
Image
Recently I have been put in to a scenario where I need data from SharePoint list to be published into Power BI Report. The columns used in SharePoint list where of type Multi Line Text and contained HTML tags. Up here I am going to show how to consume HTML in Power BI reports, Power BI itself offers way to clean your HTML text allowing you to use only text from it. Step 1: Connect to SharePoint List  using PowerBI Step 2: Select Transform Data Step 3: Find column FieldValueAsHtml, click to expand and select the column with Html data and click ok. This will extract the column data and create a new column with only texts extracted from Html. This new column will be called FieldValueAsHtml.YourColName. Enjoy.
Read more

Simplifying Data Migration: Debezium for Moving Data from Oracle to SQL Server

By
 Introduction In today's data-driven world, organizations rely on databases to store, manage, and analyze vast amounts of information. Over time, businesses may need to change database systems for various reasons, such as cost-efficiency, performance improvements, or compatibility with new applications. One common migration scenario is moving data from Oracle, a popular relational database, to SQL Server, another widely used database system. While data migration can be a complex task, tools like Debezium have emerged to simplify and streamline the process. What is Debezium? Debezium is an open-source, distributed platform for change data capture (CDC). It captures changes to database data in real-time, making it an excellent choice for scenarios like Oracle to SQL Server data migration. Debezium works by monitoring the database's transaction log and recording any changes made to the data, such as inserts, updates, and deletes. This captured data is then made available in a form...
Read more

Installing MariaDB on Ubuntu using SUDO

By
This article demonstrate steps to install MariaDB/MySQL on Ubuntu using sudo. This is part of our getting started journey to learn MariaDB/MySQL. I will be covering PostgreSQL in another article. Before we get started, very first step would be to install MariaDB/MySQL Server and client. You can install any of these RDBMS on Windows but this blog will mostly be following Ubuntu OS. There are various tools to access MariaDB/MySQL Server, we are going to use mysqlclient and Heidisql. Lets get started with installation of MariaDB. Step 1: Open your Ubuntu terminal window or bash and run following cmd. This step is going to check if mariadb-server is already installed and is going to remove it. You can either continue using the current setup or go to next step to do a fresh installation sudo apt-get remove mariadb-server Step 2: run sudo apt-get install software-properties-common Step 3: Check for Ubuntu updates sudo apt-get updates Step 4: Install Ubuntu updates sudo ...
Read more