There could be several options you can deploy depending what you are looking in your final view. Here is some options you can try: Extract Your Data
- Filter, whichever info you don't' need, filter at extract level, like year or some dimensions.
- Aggregate data for visible dimension. Say, roll up to year level, instead of weekly, monthly lelvel
- Hide all unused fields. Definitely hide all unused fields otherwise it will be include in your extract. More columns/dimensions, more time to extract.
Depending on structure, going live good be a better option than extract. Tableau Online tips: Extracts, live connections, & cloud data | Tableau Software
Hop it helps.
Thanks for the information Sherzod.
There are scenarios even after necessary filters and rolling up the data, I have around 2.5 million records. Requirement is Users should be able to access and filter the data on the report. So, I have no option to filter the data at year wise. Hence, I am looking for faster ways to extract the data. I am using Oracle (data source).