I need to load weekly excel files into tableau and look at enrollment numbers for courses. What is the best way to bring in this data? Should I load a new excel spreadsheet each week and join? Is it better to have the enrollment count column named with the date or just add the date in it's own column for each weekly file?
This is probably really simple, but I'm not having luck when I bring in two separate files from two different weeks with the same column names. I see the red links for the common fields but can't do a cross tab or graph showing enrollment count from week1 to week2. What am I doing wrong?