If you’re working with an Excel file as a data source, there is an excellent chance that you’ve been provided with a pivoted file. I’ll show you how to use a Data Cube to unpivot this data and make it a much more valuable data source for BI and specifically Dundas BI. Pivoted information is just one of the many data issues that can be solved with Business Intelligent software that contains an ETL layer. Check it out.
If you’d like to learn more, I’d recommend you go to my learning channel - Off the Charts (with Jeff).
https://www.dundas.com/resources/off-the-charts-tips-from-an-expert