The MongoDB BI Connector allows users to create queries with SQL and visualize, graph, and report on their MongoDB data using existing relational business intelligence tools. The connector performs a transformation of data from MongoDB's flexible documents to SQL's rigid schema of tables, rows, and columns, enabling the use of standard SQL BI tools for building visual dashboards from a MongoDB flexible data store. In standalone mode, the connector maps collection document structures to a relational schema automatically by randomly sampling collection documents, while in custom mode, it relies on explicit mappings provided by the BI Connector administrator through the Document to Relational Definition Language (DRDL). The DRDL file can be used to customize the mapping of MongoDB documents to SQL columns, creating a single-table schema with desired fields. By using the BI Connector, users can build visual dashboards from their MongoDB data without performing complex ETL operations or manual intervention.