One approach to automatically test the data of monthly generated Tableau Certification Course reports is to use a tool that can extract the data from the reports and compare it to a set of expected results. This can be done using a script or a program that is run on a schedule, such as a cron job. Another approach is to use a tool that can interact with Tableau's API and programmatically verify that the data in the report is correct. This can be done using a language such as Python or R, or using test automation tools like Selenium. It's important to note that testing the data of the report will vary depending on the complexity and structure of the report and the data it contains, and it may require some expertise in SQL and data analysis.
Here is an example of how this might be done in Python using the TabPy library:
from tabpy.tabpy_tools.client import Client
# Connect to the TabPy server
client = Client('http://localhost:9004/')
# Extract the data from the report
data = client.query('SELECT * FROM report_name')
# Compare the extracted data to the expected results
expected_results = [1, 2, 3, 4, 5]
for i in range(len(data)):
assert data[i] == expected_results[i]
