Data Load - Too Much!

[kdixon5490]

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.

[Sumanth_23]

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.   

[kdixon5490]

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.