1 Reply Latest reply on Oct 6, 2018 4:13 AM by Jim Dehner

    Data preparation steps

    jatin baveja

      Hi All

       

      I am new to tableau. I imported some data to play around in tableau and while validating the data i saw the totals not matching with me excel sheet.

      A colleague of mine simply just multiplied by 1 and the numbers stared tallying. I guess he forced tableau to do typecasting so all the measures were now being read as numeric and therefore totals started matching.

       

      That got me thinking as to what are the steps we should perform before importing excel into tableau?

       

      Thanks