BI Data Analytics

   Below are some finding while testing done for Tableau against IBM Db2 on cloud: Tableau seems to work better when using standard model instead of custom sql. Union is having performance issues. In some cases using cross join gives better performance results  Multi-language label changes solution is not extensive and need to create multiple worksheet and formatting compared to Cognos Analytics where you can assign query at Page level to place calculated columns anywhere.

Below are some of the tips/insights while working with Excel as data source in Cognos Analytics:- When you upload an excel, by default it's stored in My Content. You need to move it to Team Content for common use. When deploying excel from one environment to other, choose "Upload data option" in export options. That way data will be copied over as well. Once excel is uploaded, clicking on it opens Dashboard creation Interface by default. You will need to create a data module with excel as source and create a report out of it to access raw data for any future update. Excel Based reports doesn't show standard Report functions; however, you can copy variables created in other report to it and it will work. For example, ReportOutput() = 'HTML' to change layout based on html format output in excel based report is possible.  If any calculation is needed for cleaning, it can be done in data module. Hide original column and just expose calculated columns for re