My experience using Power BI

As I mentioned in the previous entry, what data visualization tool to be used is depending on what kind of data you have, what is the purpose of your project and how you want to present it. My project does require me to demonstrate my ability to perform data exploration using Descriptive Statistics and apply techniques to clean data using Power BI.

I was given 3 sets of data. I was told that the data is messy because it used different external sources to compile it. I loaded the Power BI software tool on my machine, There is an option called “Get Data” found under the Home menu. It is able to load many types of data sources, from files to databases and online services and cloud.

Once the file is selected, in my case, I chose a .csv file. it will load into this dialog box to preview the source file. From here, it allows us to load or edit the data. We can edit the data anytime in the Power Query Editor. So, I chose to load the data first by clicking on the “Load” button.

I loaded all the 3 sets and under the “Fields” explorer on the right side of the tool, you can view the columns names for each of the datasets. Firstly, I noticed there is something wrong with the country code dataset. It did not read the first row as header, therefore my column name turned into “Column1”, “Column2”, “Column3”. Usually, Power BI able to identify the header in the excel file, just like the other 2 sets of data.

How to set first row as header?

I changed my view into “Model” view which I can select it from the side bar on the left side of the tool. The other 2 buttons on the left side bar are the “Report” view where we can do our visualization and the “Data” view where we can view our data. Again, there is a limitation on how many rows of data is able to be previewed. So, be aware of this point.

In the “Model” view, I changed the columns names by selecting the “countrycode” table and click on the “Edit Query” button under the Home menu. It opened the Power Query Editor which I mentioned earlier. There is a function called “Use First Row as Headers” in the Home menu.

This editor gives us the data profiling view, allows us to perform data cleaning and checking through the data quality through its summary statistics and column distribution. Also, I noticed the column names have been updated accordingly.

Data Profiling

It is a process of examine the data available from the data sources, either from flat files or databases. It collects and shows statistics summary such as count, min and max values, unique and distinct value, and other informative summaries about the data.

It allows us to understand the data before we can decide the data cleaning process. More often, it is a toolbox of business rules and analytical algorithms to discover, understand and potentially expose inconsistencies in your data. This helps to improve data quality or maintaining the health of the data.

Why do we need data profiling?

Data that is not formatted right, standardized or correctly integrated with the rest of the database can cause delays and problems that lead to missed opportunities, confused customers and bad decisions“.

Totally correct. Uncovering erroneous data within the dataset helps you ensure that your data is up to standard statistical measures, as well as business rules specific. Data quality check helps to identify incorrect or ambiguous data and provides ideas on what are the data to be cleaned.

You can check whether the data is consistent and formatted correctly through some pattern matching on the data types for example. Pattern matching helps you to understand whether the field is a text or number based field.

Lastly, relationship discovery. You want to know how each data sets are related or connected to one and another by starting with metadata analysis to determine key relationships.

End of the day, you will get a dataset diagram which looks similar to the screenshot once the data is cleaned, integrated and correctly formatted.

Data Visualization

The story did not end here, data visualization comes in when we have done some data crunching so that the data can be useful for analysis and visualization. Power BI data visualization covers a number of different charts, graphs and etc. It can be easily be located from its marketplace.


I added a histogram from the marketplace and pulled out some data from my dataset to see the age distribution and worth in billions distribution. It is quite interesting to look at data in this histogram and start asking questions from it.

Scatter Plot & Line Chart

Scatter plot is type of plot diagram which showing the pattern of the resulting points revealing any correlation present. A line chart or line plot or line graph is a type of chart which displays information as a series of data points called ‘markers’ connected by straight line segments. It is a basic type of chart common in many fields.

There are plenty of different charts and graphs can be used in Power BI. The important question here is knowing what kind of charts and graphs to be used in data visualization. It is important to choose the right one to draw the visual (chart) for data presentation.

Data Visualization Tool

Recently, I started using PowerBI for my study and I did a quick search on the comparison between tools used in data visualization. As many of us know, data visualization is the most initial and important steps of uncovering insights from data.

As it is getting more important, some of the top data visualization best practices include standardized methodologies, clear classification, data profiling and data presentation based on its audience.

What features are needed in Data Visualization Software?

One useful feature in many visualization software types is the ability to choose different visuals and graphs. Different types of charts or graphs represent different type of data. In other words, there is no single graphs or charts can be used to present all types of data.

Data visualization tools should have an accurate trend tracking capability. For example, you can see which are the products selling at each months and its demographics of buying those products.

Depending on what type of information you need, you might also requirehigh level of security. It is crucial to protect your data because you may have people who want to break into your account and steal important information and without proper security measurement, you are simply put your company and data at risk.

Lastly and most importantly, the software has to be ease to use. A simplified user interface and easy to understand tips to help users to work around on the software right away can avoid users from getting confused and trying to decode and interpret lots of data.

What are the top best data visualization tool in 2019?

Sometimes, I wonder whether I need to search for answers for this question when we always hear people just say they are using Tableau or QlikSense. However, I do notice there are a bunch of other data visualization tools out there and many of them serve different purposes in the business, come with different features and customization levels.

It depends on your data to decide which visualization tool is good to be used to give insight and present data. There are some which are desktop based, some are available by publishing the links to the audiences and some are just conveniently available in the cloud.

Let me just show you a table of some of the available data visualization tools in the market. I did not use all of them before.

If you are a Business Analyst or BI Developer, then you may have been seeing or using Tableau, Power BI, QlikView (QlikSense) or even the IBM Watson Analytics and SAP Analytics Cloud.

If you are a Developer or Data Engineer, you may want to have chart plugin or generator, then Plotly, Highcharts, D3.js or MATLAB.

And before I end my write-up, I want to share something which I found from the Internet and still related to visualization, it is the visualization on large screen. There is one called Ali DataV. It is a drag-and-drop visualization tool from Alibaba Cloud, which is mainly used for big data visualization of business data combined with geographic information.

Another one is Digital Hail, focuses on Data Imaging, 3D Processing, Data Analysis, and other related services. You can visualize and display data analysis results, which is more used in Smart Cities and Industrial Monitoring.

There are the two visualization tools which I find it so impressive and new to me.