Analyze and organize sales data Power BI
Budget: €12 – €18 EUR
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.