[05/Deseado/05]

Creating virtual datasets using SQL queries

Security concerns

To join two separate virtual datasets

Combining data from multiple sources

Virtual dataset created using SQL queries

To create charts, dashboards, and reports

Always join inside the SQL query for a virtual dataset

False

True

False

True

False

False

True

Virtual datasets = Datasets created using SQL queries Cross-dataset joins = Currently not supported due to security concerns Separate virtual datasets = Created for each data source Third virtual dataset = Joins the two virtual datasets together

Create a virtual dataset for each data source = First step to combine data from multiple sources Create a third virtual dataset = Joins the two virtual datasets together Join the table data and the column data on the table name column = Example of joining in the third virtual dataset Use the third virtual dataset to create charts, dashboards, and reports = Final step after creating separate virtual datasets

Charts, dashboards, and reports can be created directly using the separate virtual datasets without the need for a third virtual dataset. = Advantage of using virtual datasets One of the workarounds to achieve similar results to cross-dataset joins in Flow.BI. = Using virtual datasets to combine data from multiple sources Virtual datasets in Flow.BI are created using SQL queries. = How virtual datasets are created Creating a third virtual dataset to join two virtual datasets together is the only workaround for achieving a cross-dataset join in Flow.BI. = Workaround for cross-dataset joins

It is recommended to join inside the SQL query for a virtual dataset in Flow.BI. = Recommended approach for joining datasets inside a SQL query Always join inside the SQL query for a virtual dataset. = Guideline for joining in a virtual dataset Physical datasets are recommended for achieving a cross-dataset join in Flow.BI. = Incorrect recommendation for cross-dataset joins Cross-dataset joins are currently not supported due to security concerns. = Reason why cross-dataset joins are not currently supported