@tameemyousaf , as others have said, it depends what you're trying to test. If you're trying to test the user experience with the frontend, as @acbg is, then you would probably want to use tools like Selenium, Tosca, UFT, etc to interact with the UI.
If you're interested in testing that the visuals are configured with the correct filters and such, in other words, that they are displaying the data you expect them to display, then you could still use the tools above but you'd need to build something to query your database to get your expected result. This second scenario is what I've been doing for a client. It's not simple but it's definitely possible.
I found that this approach worked well but there were other challenges (like running thousands of tests in a reasonable timeframe, cost of maintenance, distinct skillset to the rest of the team) that eventually lead me to build my own tool. If you're interested, you can check it out here.