Connecting to Oracle database performance issues

Hi, I need to create a sales performance dashboard for one of my customers who uses Oracle as the transaction database. Normally, there are about 50 million sales transactions that I need to analyze...