normalize or not?

[#1]

Hi!

I have a excel file with a lot of sales data. Each row contains information of customer, date, referens and so on.

My question is if I should divide the table into several tables through the script so that I get a customer table, an order table, un order row table.

If I do it in SQL I would and then use JOIN

[rwunderlich · Accepted solution]

The quick answer is no. In general, QV works best with denormalized data. There are exceptions of course. But the typical reasons for normalization -- space savings, referential integrity, etc -- don't usually apply to QV. So leave it denormalized as is.

-Rob