Analyze and organize sales data Power BI
Budget: $30 – $250 USD
I need 2 years worth of sales data analyzed and organized into charts, graphs, tables etc for a ticket agency (concerts/sports/theater) - whatever is best for displaying the information.
I have all the information in excel format.
3) The columns are labeled:
Date of order | Event | Event Date | Ticket Section | Ticket Row | Venue | # of Tickets | Order Total | Price per Ticket |
Some examples of what I am looking for are:
Number of tickets by venue
Dollar amount by venue
Number of tickets by event
Dollar amount by event
Dollar amount by time of year
Number of tickets by time of year
Number of days before an event that the orders come in
Number of days before a venue that the orders come in
(broken down by 1D/1M/6M/Y)
Sales by section for each venue ( which sections have the most sales at each venue)
Sales by number of days listed
Average ticket sale price by venue
Average ticket sale price by event
Sales trends
And whatever else you can think of that would be useful information: any trend etc.
I have all the information in excel format.
3) The columns are labeled:
Date of order | Event | Event Date | Ticket Section | Ticket Row | Venue | # of Tickets | Order Total | Price per Ticket |
Some examples of what I am looking for are:
Number of tickets by venue
Dollar amount by venue
Number of tickets by event
Dollar amount by event
Dollar amount by time of year
Number of tickets by time of year
Number of days before an event that the orders come in
Number of days before a venue that the orders come in
(broken down by 1D/1M/6M/Y)
Sales by section for each venue ( which sections have the most sales at each venue)
Sales by number of days listed
Average ticket sale price by venue
Average ticket sale price by event
Sales trends
And whatever else you can think of that would be useful information: any trend etc.