How to use BI Reporting Tools

I have just now deployed a SpagoBI server / Studio and want to generate some reports with charts with MS SQL Server as my backend database.

I was told that we need to create an XML for our query in database. I am not sure how to do that as it is my very first time.

Kindly guide.