Forum Discussion
Data Load - Too Much!
hi kdixon5490 - that would be the best way to build you model so you can report at seat level.
If you do not have a show indicator in your data then a seat which was occupied for just 1 show would always show as occupied even though it was not occupied for the remainder of the 99 shows.
Unfortunately each show will need to show each of its' seats all 12000.
The reason being that we report on 3 things with regard to Seat.
Status is it SOLD, Open, Killed, Hold
Price Point: Is this a 4000 seat or a 4200 seat
Sold Price: What the seat actually sold for. Cause they can buy a 4000 seat but only pay 3500 if discounted.
Currently we have 3 concerts on sale Aha, Ricky Martian, Tini. I need to be able to select Aha and get back on Aha seats. I really don't think that Powerbi will handle bringing back all 1.2 million seats at a time.
So we have to bring back at 12000 at all times.