Visualizing Data and Building Reports in Oracle Analytics Cloud Prepare Data Connect to Your Data Using Datasets 2 Connect to Your Data Using Datasets Learn how to use datasets to power your data visualization and analysis projects. Topics: What Are Datasets? About Opening Datasets View Available Connections Data Sources Available for Use in Datasets About the Dataset Editor Create a Dataset From a Connection Add Multiple Connections to a Dataset Add a File to a Dataset Created From a Connection Add a Table to a Dataset Using a SQL Statement Understand Dataset Table Joins Add Joins Between Dataset Tables Disable Auto Joins in Datasets Modify or Fix Joins in a Dataset Add Joins When Table Columns Don't Match Delete Joins from a Dataset Include a Dataset Table in Data Source Queries What is Preserve Grain? Specify Which Table Determines Grain Rearrange the Order of a Dataset's Tables What are Quality Insights? Enhance Your Data Using Quality Tiles About Removing or Restoring Dataset Columns Remove or Restore a Dataset Table's Columns Filter a Dataset Table Specify Whether a Dataset Table Is Cached or Live View a Dataset Table's Original Formatting Create Datasets from Files Create a Dataset from a Subject Area in Oracle Fusion Cloud Applications Suite Create a Dataset from an Analysis in Oracle Fusion Cloud Applications Suite Create a Dataset from a Local Subject Area Create a Dataset from a Local Analysis Create a Dataset from an Essbase Connection Create a Dataset from OCI Object Storage