Forum Discussion
Data Load - Too Much!
Currently we have the following set up.
We do venue reporting so I have a venue(Arena) that has 12000 seats per show.
We do around 100 shows per year. That's 1.2 Million seats that I need to report on. That is way too much! But we have to report at the seat level because we need to show the status of each seat.
Is there a way to load maybe a list of the shows into a slicer or some other visual and then when that I selected we load the seats for that show?
Any other suggestions will be welcomed.
2 Replies
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.
