Forum Discussion

kdixon5490's avatar
kdixon5490
Icon for Helper III rankHelper III
6 years ago

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 r...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    kdixon5490
    Icon for Helper III rankHelper III
    6 years ago

    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.