1 2 Previous Next 27 Replies Latest reply on Oct 4, 2014 12:03 AM by Cristian Vasile

    Preparing data for Tableau makes it too large to fit in Excel

    Siebe Bosch

      Hi everybody,

       

      I'm struggling with a dataset that, after preparing it for Tableau, gets too large to fit in Excel.

       

      I have two years of hourly precipitation data for 900 areas. This means 17544 datetime values.

      In a normal Excel-table this would be no problem. I simply place the dates in column A and the Area Names in row 1.

      Schermafbeelding 2013-05-21 om 20.20.55.png

       

      However: to prepare for Tableau I'll need to rearrange the data first (unPivot if you will).

       

      Schermafbeelding 2013-05-21 om 20.23.37.png


      This leads to a lot (and I mean a lot!) of redundant data. UnPivoting like this will require 900 * 17544 rows in Excel; more than 15 million rows!

      Needless to say that Excel does not support this huge number of rows.

       

      My question is: is there a way of using the first lay-out in Excel for input in Tableau while still having Tableau recognizing the Area Names?

      Or else: what is the best way to store this data. Can I put it in a CSV or do I have to switch to an SQL-database?

       

      Thanks in advance for your response.

      Kind regards,

      Siebe Bosch

        1 2 Previous Next