I often run reports and export them to manipulate the data through other programs, like SQL. The way the data is organized in finished reports is not compatible (or more difficult) to manipulate with other data analytics tools that I am aware of.

For most of these tools, the data needs to be organized strictly as "Long Data" (One column per attribute).

For example, running a report for question responses by learner: I would expect column 1 to be learners names, the next column to be that learner's answer to question 1, the next column to be that learner's answer to question 2 etc. 

The way the report is organized now is a long column with answers to question 1 at the top of the column, the answers to the next question in that same column underneath the question 1 answers. 

This makes it difficult to query - I can pull all data from any given entire column, but I have to go in an manually look at how many rows are associated with each question, which is too labor-intensive for datasets that are thousands of rows long.