Dundas BI Tip 24 : How to Unpivot Your Excel Data for BI Consumption
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.
Join the conversation in our forum:
https://dundas.influitive.com/forum/t...
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-...