Data visualization takes a very important part in the business intelligence / data analytics since this is the part where the customer will view their required outputs / results. Data visualization is usually called as the pictorial / graphical representation of any data. In Big Data, the data visualization tools are used to research and analyze the huge or massive data / information and make it as pictorial representation for end user to access them for their further research or to get their desired output through drill-downs.
Want to have your software and application work well? Get in touch with our digital assurance experts
Here are a few main items / elements present in the Data visualization:
Here are some techniques in Data Visualization:
Before getting these items / elements, we have a process called ETL to get the required table to visualize. We have three stages in the ETL process. They are:
We get the target database to visualize the required outputs / results using the BI tools like Tableau, Power BI, etc.. We can call the output / results as “Dashboard” / “View” in the BI tools.
The main aim of any validation is to meet the requirement and we can follow the same testing process which we are following for the web testing, but the testing methodology differs here. Frankly speaking, it is very hard to validate the data and analytics when the respective persons who are going to validate are not subject matter expects on how the dashboards / views / data are developed and most of the time, the data by itself is incorrect. Usually, this can be overcome by understanding the proper requirements from the respective experts like business analyst, business economist, data scientist, etc..
There are many approaches to validate the dashboards / views. In general, we have two parts to validate the dashboards are UI and Data.
Here are a few common scenarios to validate the UI part:
Here are a few common scenarios to validate the Data part:
In the Data part, for validating / comparing the values between the source and the output, we have multiple approaches which we can choose based on the project need:
We must build the output / source table from the Raw data using SQL (we have to replicate whatever logics are used by the ETL team to get the Aggregated / Output table) to validate the dashboard. Once we have the source table for the dashboard, we need to build the further logic / calculation to validate the specific charts / tables in the dashboard using Excel Pivots or SQL.
We just need to build the output / source table from the Aggregated / Results table (no need for creating the logics since it is already done by the ETL team) to validate the dashboard. Once we have the source table for the dashboard, we need to build the further logic / calculation to validate the specific charts / tables in the dashboard using Excel Pivots or SQL.
In some projects, they are planning to improve the performance or upgrade the BI tool version. In this case, we should validate the data between the versions. Just downloading the values from both the versions for the same combinations and compare the values between them using Excel (usually it is called as Test Harness – it has source table in the left and latest table in the right and using the formula (source – latest = 0) to get the output.) Etc.
Note: The above methodologies are used commonly but we might have more methodologies than these.
• Mis-order of legends
• Irrelevant color
• Missing data in tooltip
• Missing data labels
• Mistakes in calculation / logic
• Issues in Decimal / rounding
• Backend filter is not applied
The World is already transforming to digitalization and the data is already taking a vital role in any businesses and making the data as pictorial / graphical (i.e. Data Visualization) which makes the digitization faster than before. If we need to create the quality product to make the brand, there should be quality check before handing over the product to the respective client or customer. Welcome to our digitized world and eagerly waiting for the upcoming features in digitization / visualization.
By Uma Raj
By Uma Raj
By Abishek Balakumar