Using data profiling tools
You may deal with great amounts of data and need tools that allow you to quickly check data quality and distribution and get insights from columns' profiles.
Power Query offers an intuitive way of exploring data to identify bad data. Data profiling is especially convenient when you are working with large volumes of data and you want to quickly visualize the composition of that data.
Getting ready
For this recipe, you need to download the FactInternetSales2 CSV file into your local folder.
In this example, we will refer to the C:\Data folder.
How to do it…
Once you have opened your Power BI Desktop application, you are ready to perform the following steps:
- Click on Get Data and select the Text/CSV connector.
- Browse to your local folder where you downloaded the
FactInternetSales2CSV file and open it. A window with a preview of the data will pop up; click on Transform data. - Browse the query ribbon and click on...
